Professional Learning Podcast Treasury Lesson Plans Personal Workspace Site Search ALEXville Learning Assets Home Courses of Study
Home  |    Add Bookmark   |   Print Friendly   |   Rate This Lesson Plan   |   Suggest a Variation

You may save this lesson plan to your hard drive as an html file by selecting "File", then "Save As" from your browser's pull down menu. The file name extension must be .html.

This lesson provided by:
Author: Samantha Mayweather
System:Montgomery County
School:Montgomery County Board Of Education
Lesson Plan ID: 33104
Title:

On the Mark, Get Set, EXCEL!!! It’s Time to buy a New
Car!

Overview/Annotation:

Students will learn about loans and how to calculate the monthly payment on a major purchase such as a car loan, home loan, or school loan. In a spreadsheet students will learn how to calculate monthly payments using the PMT (Payment) function.

This is a College- and Career-Ready Standards showcase lesson plan.

Content Standard(s):
BMA(9-12) Business Technology Applications6. Utilize spreadsheet features, including formulas, functions, sorting, and filtering data, templates, charts, and graphs in creating, editing, and printing workbooks.
BMA(9-12) Business Technology Applications23. Critique various ways to become financially literate, including identifying credit card use and misuse; explaining ways to avoid identity theft; identifying reasons for budgeting, saving, and investing; comparing rates of interest as they relate to various time frames in the repayment of loans; and determining how debt influences future employment and purchases.
Local/National Standards:  
Primary Learning Objective(s):

Students will be able to:

  • Define the terminology associated with a loan
  • Calculate the monthly payment for a loan
  • Determine which factors adversely affect their monthly payment
  • Resolve how to pay less interest on a loan
Additional Learning Objective(s):  
Approximate Duration of the Lesson: 61 to 90 Minutes
Materials and Equipment:

Student/Teacher Handouts Attached

Technology Resources Needed:

Computer with Internet access, Spreadsheet Software, teacher demonstrations with interactive white board.

 

Background/Preparation:
 
Procedures/Activities:

This lesson should follow an in depth discussion about installment loans. Students should be able to define the vocabulary for this lesson and understand the determining factors to compute the monthly payment on an installment loan. Please see the (Student Teacher Installment Loan) attachment, (PMT Function) attachment, and (Performance Based Assessment Dream Car Instructions) attachment.


Attachments:**Some files will display in a new window. Others will prompt you to download. PerformanceBasedLessonDreamCarExample.pdf
PMTFunction.pdf
Student_TeacherInstallmentLoanVocabulary.pdf
PerformanceBasedLessonDreamCarRubric.pdf
PerformanceBasedAssessmentDreamCarInstructions.pdf
Assessment Strategies:

Formative assessment with the vocabulary while students are engaged in a discussion. Project based Assessment for students to purchase their “Dream Car”.

Extension:

Students can use this to purchase a new home that is $250,000 or less. Students can also finance a 4 year degree at a University of their choice and a 2 year degree at a community college and discuss the pros and cons of receiving a 4 year degree vs. a 2 year degree. They must include the cost of college in their discussion.

Remediation:

  • Students may need to review the vocabulary.
  • Students will need to find the principal of 4 different cars to get a concrete understanding.
  • Students will need to calculate the term for a 4 year, 5 year, 6 year, 8 year, and 12 year loan.      (4x12)  (5x12)  (6x12)       (8x12)  (12x12).
  • Explain to students good interest rates vs. bad interest rates. Students will need to know how people get good interest rates (good credit). A great analogy would be a student who gets an “A” vs. a student who receives an “F” Why is a student that receives an “A” vs. one that receives an “F” more credible.

 

 

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 short-term 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:
Alabama Virtual Library
Alabama Virtual Library

Hosted by Alabama Supercomputer Authority
The University of Alabama at Birmingham
The University of Alabama at Birmingham
The Malone Family Foundation
The Malone Family Foundation
Thinkfinity
Thinkfinity
Best of the Web

Web Design by: Digital Mason LLC