Car Costs and Spreadsheet Formulas
- Computer
- Middle

- Activity Time
- Materials
- Concepts / Topics
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