lesson plan 1- using digital spreadsheet

Lesson Title “My Monthly Budget”
Teacher’s Name – Shannon Bukikosa
Grade 10-12th
Content Area: Business/Clerical
Lesson Length: 2 weeks (Total Time)

Analyze Learners
1. 15-18 students
2. 4 girls:1 boy
3. 14-18 year olds
4. Students in the class are on the Career Path
5. Current Knowledge, Prerequisites, and Notes about Learner Attitudes
·1 Basic knowledge of Excel
·2 Internet search capabilities
6. Learning Styles o Visual – 60%
o Auditory (Aural) – 20%
o Kinesthetic (Hands On) - 20%

State Objectives
Students will be able to participate in groups of 2 to represent a family
Students will be able to create an Excel spreadsheet for a monthly budget
Students will be able to research websites to support salaries and expenses
Students will use the given factors that must be incorporated into calculations in spreadsheet:
Students must -
· Choose an occupation for self and spouse
· Determine how many children the family will have
· Choose to rent an apartment or buy a house
· Determine monthly rent or mortgage payment
· Determine monthly costs for power, water, gas for house or apartment
· Determine monthly cost for telephone and cell phones
· Determine monthly cable expense
· Determine monthly expenses for 1 or 2 cars which includes auto loan, insurance, maintenance, and gas
· Determine monthly expenses for family entertainment; must list at least 2 activities
· Determine monthly food and toiletry expenses
· Determine monthly childcare expenses
· Determine monthly clothing expenses
· Determine a monthly expense for special occasions such as birthdays or holidays
· Determine monthly amount to deposit into a savings account
Spreadsheet should contain formulas for future input of expenses
Students will be able to produce a graph to visually breakdown monthly expenses
Students will be able to present their graph to class

Select Media, Materials, and Methods
Internet/Search Engines
Computer/laptop
Excel software
Multi Media (projector)

Utilize Media, Materials, and Methods
Teacher will preview resources of search engines to be used by students to gather valuable information to determine expenses.
Teacher will preview students’ work before presenting to class
Teacher will prepare handouts and rubrics
Teacher will prepare necessary equipment and make available to students
Teacher will present objectives of the lesson and the handouts
Teacher will discuss guidelines and rubrics
Teacher will remind students of acknowledging sources, plagiarism and copyright penalties
Teacher will review proper use of equipment by students

Require Learner Participation
Students must present their budget to the class on a projector
Students must share experience on this lesson.

Evaluate & Revise
Teacher will evaluate participation in group activity and presentation
Teacher will check if students used each factor in spreadsheet
Students will cite resources used
Teacher will evaluate spreadsheet formulas
Teacher will evaluate graph and presentation
Students will provide feedback on lesson
Teacher will revise lesson plan based on student feedback