Lesson Plan ID: 
24803 
Title: 
What's The Real Cost of That Car? 
Overview/Annotation: 
This is a Commerce and Information Technology lesson plan. A project requiring research, critical thinking and complex decisionmaking about factoring all the costs of purchasing a large ticket item... a car. 
Content Standard(s): 
BMA(912) Business Technology Applications  Advanced  3. Design spreadsheets for personal and business use.  BMA(912) Business Technology Applications  Advanced  4. Apply mathematical, statistical, and logical functions to solve problems using spreadsheets.  MA2015(912) Algebra  10. Understand that polynomials form a system analogous to the integers; namely, they are closed under the operations of addition, subtraction, and multiplication; add, subtract, and multiply polynomials. [AAPR1]  MA2015(912) Algebra  41. Represent data with plots on the real number line (dot plots, histograms, and box plots). [SID1]  MA2015(912) Algebraic Connections  5. Determine approximate rates of change of nonlinear relationships from graphical and numerical data. (Alabama)  MA2015(912) Algebraic Connections  6. Use the extreme value of a given quadratic function to solve applied problems. (Alabama)  MA2015(912) Algebraic Connections  7. Use analytical, numerical, and graphical methods to make financial and economic decisions, including those involving banking and investments, insurance, personal budgets, credit purchases, recreation, and deceptive and fraudulent pricing and advertising. (Alabama)  MA2015(912) Discrete Mathematics  9. Determine a minimum project time using algorithms to schedule tasks in order, including critical path analysis, the listprocessing algorithm, and studentcreated algorithms. (Alabama) 

Local/National Standards: 
Jump Start Standard 1: Take responsibility for personal financial decisions. Jump Start Standard 4: Make financial decisions by systematically considering alternatives and consequences. 
Podcast(s): 

Primary Learning Objective(s): 
Students will: 1. Use the decisionmaking process in this simulated car purchasing activity. 
Additional Learning Objective(s): 
Students will: 1. Determine how much must be saved each month for the down payment (or the entire car if it is to be purchased with cash.) 2. Determine total cost of car  down payment, loan fees, loan repayment. 
Approximate Duration of the Lesson: 
Greater than 120 Minutes 
Materials and Equipment: 
"Real Cost of That Car" Spreadsheet (Attached Excel Template) Personal Finance for the Economics Classroom Unit 2, JumpStart Classified section of newspaper, Internet site for car sales, or auto magazine, Cars Direct, Drivers Way 
Technology Resources Needed: 
Computer Lab Digital Projector Spreadsheet Software Internet 
Background/Preparation: 
1. Students must know how to use basic functions in selected spreadsheet software. 2. Students must be able to demonstrate proficient Internet research skills. 
Procedures/Activities: 
1.)Give Lesson Pre Test to assess the range of knowledge students may already have. (see attachments) (Approx. 20 minutes)
2.)With the class, brainstorm "all the factors to consider" when buying a car. Divide the ideas into logical categories. For example, body styles, frequency of repair, safety rating, condition, and fuel efficiency. Also, demonstrate how to determine a down payment amount based on the vehicle cost (new vs used) and personal circumstance. Use The Simple Dollar as a guided resource. Assign individual students or teams to research each category. Internet sites to suggest: www.kbb.com www.edmunds.com www.consumereports.com Allow the groups time to share their information and enter data onto their student handout (see attachments). (Approx. 40 minutes)
3.)Once the students have collected their baseline data, they will use the information to select a car. In this stage students must complete the "Student Car Buying Guide"(see attachements). Internet sites to suggest: Drivers WayCars DirectGoogle.comASK.com(Approx 30 minutes)
4.)Use a digital projector and show the students how to retrieve "The Real Cost of That Car" template (see attachment) from shared network folder. Have the students save the file to their personal computers. Have the students click on sheet 1 and complete "Scenario 1" as a class. Students will determine the blank areas in the "The Real Cost of That Car" spreadsheet by entering correct formulas and financial functions. In the guided lesson monitor students to insure they are able to use selected spreadsheet software financial functions and formulas to calculate costs correctly. The answers will vary as it is based upon their chosen car.
(Approx. 40 minutes)
5.)Have the students complete the final two scenarios independently. Monitor student progress and assist as needed. They should be able to estimate a reasonable down payment and calculate all other formulas. When the students have completed the assignment have them print and answer the reflection questions on their "Student Car Buying Guide" and discuss as a class or as an online discussion EduBlog.
(Approx. 40 minutes)
6.)Give Lesson Post Test to assess retention. (see attachments)
(Approx. 20 minutes)

Attachments:**Some files will display in a new window. Others will prompt you to download. 
Pre&PostTest.rtf
StudentCarBuyingGuide.rtf
TheRealCostofThatCar.xlt
BuyingACarRubric.rtf

Assessment Strategies: 
Buying A Car Grading Rubric 
Extension: 
These students may be used as peer tutors. Allow these students to create a loan amortization based on the finished spreadsheet. 
Remediation: 
1. Preteach spreadsheet vocabulary and familiarize students with selected software. 2. Reteach the lesson as a class if the students display difficulty in demonstrating proficiency in completing the project. 

Each area below is a direct link to general teaching strategies/classroom
accommodations
for students with identified learning and/or behavior problems such as: reading
or math performance below grade level; test or classroom assignments/quizzes at
a failing level; failure to complete assignments independently; difficulty with
shortterm memory, abstract concepts, staying on task, or following directions;
poor peer interaction or temper tantrums, and other learning or behavior problems.

Presentation of Material

Environment 
Time Demands 
Materials 
Attention 
Using Groups and Peers 
Assisting the Reluctant Starter

Dealing with Inappropriate
Behavior 
Be sure to check the student's IEP for specific accommodations.

Variations Submitted by ALEX Users: 
