CS105 WK8 ASSIGNMENT
Final Project
For this project, pretend you are an organizer for a charity in your local area. The charity can be a real or pretend charity. You will be creating a Flyer advertising a fundraising event, a spreadsheet showing donations for 3 events given in each of 3 cities and creating a presentation in which you are telling an audience about your charity and the great work it does. Read below for more detail.
Flyer Instructions:
Some ideas for charity events could be a Bizarre, Fair, Bake Sale, Cake Walk, Carnival, Book Fair, Car Wash, Craft Fair, Pancake breakfast, Dinner….
Spreadsheet Instructions:
Using Microsoft Excel, create a spreadsheet that will have three cities of your choice and three fundraising events for each city in which money was raised. Have the word Donations in bold and merged and centered above the spreadsheet. Also bold the Cities and Events. Best fit columns headings as needed so they are visible. The spreadsheet is to calculate the total donations for each city and event. It will also total all donations and provide percent of total donation for each city. Percent will be formatted with percent symbol and totals with $ symbol with no decimal places. The sum function must be used for the totals and a formula used for percent of total donations for city. Be sure to label columns and rows, so it is clear what is in your spreadsheet and bold all column and row headings. Include your lastname and GIDnumber as a comment in cell A2.
Presentation Instructions:
Using Microsoft PowerPoint, create a 5-8 slide presentation in which you tell us about the charity you are involved with. There must be a title slide with a title and your name as the presenter. There also has to a concluding slide as the last slide in which you include contact information. On other slides include charity mission, benefits or accomplishments and where donations are spent. Also create a table showing donations locally. The presentation should include at least one image and have at least 1 slide with bullets points. The presentation should have one design theme or a background that is the same for all slides. There should be one slide transition that is used throughout the presentation.
For your submission, zip together the three files, the spreadsheet, the flyer, and the presentation, into a file entitled YourLastNameWeek8.zip. Upload this file into the assignment area.