Teachers.Net
JoinLog in
Teachers.Net

Car Costs and Spreadsheet Formulas

By Susan Kresge

  • Computer
  • Middle
Activity Time
2-3 42minute class periods
Materials
Spreadsheet software, Internet connection
Concepts / Topics
Budgets, Internet searching, spreadsheets

Students research a car, loan, and insurance within a monthly budget, calculate the monthly cost with spreadsheet formulas, and write a reflection on their process and learning.

Car Budget Assignment

Give each student a monthly budget—say $300—to use for a car.

Students must use the Internet to search for a car, a loan, and insurance that fit their budget. They must use a spreadsheet and formulas to calculate the monthly cost of the car.

Written Reflection

Students must also give a written description of how they found the car, loan, and insurance, as well as what they learned or were surprised about while completing this assignment.

Teachers.Net · https://teachers.net/lessons/2293.html