Yorkville High School Computer Science

Computer Applications I :: Projects :: Class Data

Problem

This project will combine spreadsheets and word processing with a presentation. You will analyze the data we compiled about our class and find an interesting trend to present. You can do this in groups of up to three people, but all three must speak during the presentation.

Instructions

1. Download a copy of our class data spreadsheet as an Excel document.
2. Find the average, max, and min of each column.
3. Come up with a new column using the choose function or vlookup function. You may need to create a table array before creating your new column.
4. Create a chart of your choice. Make sure the chart is appropriately labeled.
5. Find an interesting fact or trend from the spreadsheet that you want to present. You must approve it with your teacher so no two groups are presenting on the same trend.
6. Create an announcement highlighting the trend you found. Each group member must turn in their own announcement.
7. Create a presentation about the trend you found. You should have at least 5 slides, including a title slide with the names of your group members.