Teachers.Net
JoinLog in
Teachers.Net

Cars

By Sara Clark

  • Computer
  • Senior
Activity Time
3-4 Days
Materials
Computers with database and spreadsheet software
Concepts / Topics
Databases and Spreadsheets

Students create a database of invented cars, search a shared class database for a matching car, then use the PMT function and a spreadsheet to build its loan amortization table.

Unit Description

The first big purchase a young person makes is usually a vehicle. In this unit, students will create a database of cars they make up using given criteria. They will then be given criteria and find a car that matches. Using a spreadsheet, they will create an amortization table with the information they have.

Objectives

  • Students will be able to create a database using given criteria, then search a larger database to find a particular record.
  • Students will use the PMT function to calculate their payment, then use that payment to create an amortization table for a car loan. They will see how much of each payment goes toward interest and how much goes toward principal.

Sequence of Events

Day 1

  1. Start a classroom discussion about cars and how we would go about finding a car we would want to purchase. Discuss what is involved and the responsibilities that go with ownership.
  2. Instruct students to make up five different cars, specifying the make, model, year, color, price, and whether each is used or new. Give students a list of colors they may use.
  3. Have students create a database for the five cars they have made up.
  4. Arrange the fields in this order: make, model, year, color, price, new/used, and source.
  5. After creating the database, have students enter the information for their five cars.
  6. Have students save the file as Cars.TheirName.
  7. Have students upload the file to the teacher.

Day 2

  1. Using a compiled database from all the students, select criteria that will match at least one car in the database.
  2. Have students draw their car criteria out of a “hat.”
  3. Have students open the class file, named Cars, in read-only format.
  4. Have students search the database for cars that meet their assigned criteria.
  5. Have students choose a car that meets their criteria and write down the information in the database about that vehicle. They will need to keep this information for the final assignments.

Day 3

  1. Show students how to calculate a loan payment using the PMT function.
  2. Create an example amortization table so students can see how to make one.
  3. Divide students into three sections and give each section an interest rate.
  4. Have students use their assigned interest rate and the information they recorded from the database, including the price, to calculate their payment. Each loan will have a five-year term.
  5. Have students use their payment to create an amortization table for the life of the loan.
  6. Remind students to use the copy and paste functions to create their amortization table.

Project Requirements

Students are required to complete the following:

  1. A database of five cars.
  2. A spreadsheet with the calculated loan payment for their selected car and an amortization table for that loan.

Evaluation

Evaluation will be based on completion of the assignment above. Each teacher can decide what level of accuracy to require.

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