Two Final Spreadsheet Projects

(200 to 300 Points for each Spreadsheet: Depending On Quantity and Quality of Work)

by Dr. Data

Teaching Objective: design, create in Microsoft Excel and printout two different spreadsheets with formulas displayed with the following characteristics below. Note: must have formulas displayed or no grade!!!

• Addition of at least 10 or more cells

• Subtraction of at least 2 cells

• Division of at least 2 cells

• Multiple at least 10 cells

• Average of at least 10 cells

• Optional: square root formula!

Sample Projects:

You must use labels (words), raw data (numbers) and formulas in design your two spreadsheets. Sample projects might be:

1. Allowance of Friends: money plus how you are going to spend and/or save it.
   
   
2. Exotic Vacations (travel, hotels, food, entertainment, etc.)
   
   
3. Student Grades in a teacher's book



4. Sport’s Statistics of your favorite sport.



5. Bowling Tourament. For a breakdown of a bowling tournament, go to: Math Table Original



6. Baseball Team Averages. For a breakdown of batting averages, go to: Class_Party Original and Class_Party_Formula . For team statistics, go to: Colorado Rockies



7. Football Statistics (passing, running, points, receiving, etc.) Go to for a breakdown of football statistics: Denver Broncos Statistics



8. Basketball Statistics: For a a breakdown of a team basketball statistics, go to: Denver Nugget Statistics.
   
   
9. Super Bowl Party. You buy the food. For a breakdown of the kind of statistics you might consider, go to: Class Party: Printout Class_Party Original and Class_Party_Formula .