Design Your Own Spreadsheet
Design Your Own Spreadsheet Ideas
Important: Make sure you need to do MATH (calculations) in your spreadsheet idea choice. Remember that your spreadsheet must include at least 3 different formula types and must be a real-world example. Check your rubric to make sure your idea will allow you to meet all the requirements. Use your planning sheet to plan your spreadsheet and make sure you will be able to answer all of the necessary questions.
1. Store-Keep track of your items, their cost, total value, sales, profit.
2. Teacher-Keep track of student grades, averages, highest, lowest grades.
3. Party Budget-Plan a party for 10 people. Stay within a budget.
4. Sports Team Coach-Keep track of team statistics.
5. Tutor-Keep track of hours tutored, cost, supplies.
6. Comparing two products.
7. Music Teacher
8. Christmas Budget/Gift List/Prices
9. Household budget.
10. Survey Results
11. Winter Olympic Results
12. Scientific Experiment Results (use ideas and information from your science class)
13. Estimations versus Actual Results of a survey or experiment
14. Math Problem Quiz for younger students
15. Cook/Restaurant-converting recipes from small number of servings to large number of servings
16. Librarian-keep track of dates, due dates, overdues and fines
17. Video Store-videos, length, cost, # times rented, money made per video, best rentals, worst rentals.
18. Music Store-items in store, cost, markup, selling price, number sold, best sellers.
19. Movie Producer-cost to do movie, money made, necessary ticket sales to pay for cost.
20. Nutrition-keeping track of nutritional information and planning meals based on results and not going over recommended allowances of items.
21. Comparing College Costs
22. Fundraising Spreadsheet-calculate costs to do your fundraising-paper, envelopes, stamps, phone calls, etc. Then calculate how much you raised.
23. Cost to put on a race.
24. Track meet statistics.
25. Use to compile and graph real-world data. Get data from this site: http://www.lttechno.com/links/spreadsheets.html#Real%20World%20Data
26. More ideas: http://bes.belmar.k12.nj.us/public/everyday_spreadsheets/start.htm
27. Plan a trip for spring break-travel budget
28. Supply store inventory and sales.
29. Running a restaurant.
30. Compare 10 products at 3 online stores and see which store has the best prices. Explore the following sites and compare the price of ten items. Make a simple spreadsheet that lists the place, the item, and the price. An easy place to start is with the titles of three books, movies, or CDs. Start with these: