Home 
Add Bookmark 
Print Friendly

Rate This Lesson Plan 
Suggest a Variation
Lesson Plan
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
General Lesson Information
Lesson Plan ID:
33252
Title:
College Cost: A MAJOR Expense!
Overview/Annotation:
Students will choose a college based on their career goals and aspirations. In this lesson, students will select a career field, choose a field of study (major), and research college cost. Students will learn how to chart, graph, analyze and present the total cost of college in a spreadsheet.
This is a College and CareerReady Standards showcase lesson plan.
Associated Standards and Objectives
Content Standard(s):
BMA (78) Computer Essentials 5. Use spreadsheet software to create, save, open, edit, and print a workbook or worksheet.
Utilizing formulas for problem solving applicable to a spreadsheet
Creating charts to interpret spreadsheet data BMA (78) Computer Essentials 8. Demonstrate use of the Internet in business.
Examples: research, travel, correspondence, advertisement
Identifying misuses of the Internet in business Examples: slamming, spamming, flaming
BMA (78) Computer Essentials 9. Utilize research results to determine career and entrepreneurial opportunities, responsibilities, and educational and credentialing requirements in entrylevel information technology professions.
BMA (912) Business Technology Applications 6. Utilize spreadsheet features, including formulas, functions, sorting, and filtering data, templates, charts, and graphs in creating, editing, and printing workbooks.
BMA (912) Business Technology Applications 12. Utilize research results to determine career and entrepreneurial opportunities, responsibilities, and educational and credentialing requirements in commerce and information technology.
Determining factors to be considered in developing an effective career plan and procedures for obtaining employment
Using terminology commonly associated with commerce and information technology
Local/National Standards:
Primary Learning Objective(s):
Students will learn how to:
Utilize productivity software (Microsoft Excel) to compare and contrast data (the cost of colleges) using charts and graphs.
Calculate the total cost of college.
Gain a deeper understanding of percentages and fractions through pie charts.
Use charts and graphs to represent data.
Additional Learning Objective(s):
This assignment is to elicit students to begin thinking about:
Career choices
Colleges majors
College Expenses
The correlation between data, charts and graphs
Preparation Information
Total Duration:
Greater than 120 Minutes
Materials and Resources:
Student/Teacher Handouts (Attached)
Menu Worksheet
Career Choice Worksheet
4Year Out of State College Example
4Year In state College Example
2Year Technical College Example
Total Comparison Example
Technology Resources Needed:
Computer with Internet access, spreadsheet software, Teacher demonstrations with Interactive White Board.
Background/Preparation:
This lesson should follow a discussion about how students should choose a college based on their career field & college cost. Students should be cognizant of college choices and college majors. They should focus on high demand careers (primarily careers in STEM) and choose college majors and colleges accordingly.
In order to complete this assignment successfully students needed to know:
How to use a spreadsheet
About careers in STEM that might interest them
What is a college major
How to calculate total cost
How to calculate the percent of a number
How to use search engines
Procedures/Activities:
Step 1: Motivation & Introduction
Begin the lesson by discussing college majors and how to search for a college that has the students’ major. Discuss college cost in terms of instate and out of state colleges as well as attending a technical college based on the students career choice. You can also discuss attending a twoyear college and then transferring to a 4year university.
Step 2: Activity
I. Complete Career choice Worksheet (handout)
II. Format College Expense Data
III. Create a Pie Chart in Excel using the following data for each College. All charts should be on a separate sheet; name each sheet and color it. Students should choose one of each college:
4year out of State College (Must have student College Major)
4 year instate College (Must have student College Major)
Technical College (Must have student College Major)
Tuition
Course Fees—
Books—
Travel—
Room/Rent—
Meals— (Handout) Calculate for 1 week and then multiply by 36 to get an annual college cost
Entertainment— Calculate for 1 week and then multiply by 36 to get an annual college cost .
Parking Permit Type data into Microsoft Excel
All Pie Charts should have:
Title
Category Name
Value
Percentage
Leader lines
Legend
IV. Create a bar chart to compare the cost of all (3) colleges on a separate sheet
The bar chart should have the following:
Title
XAxis Title (Colleges)
YAxis Title (Annual Cost)
Attachments: **Some files will display in a new window. Others will prompt you to download.
Assessment
Assessment Strategies
Formative Assessment :
Menu Worksheet (Handout)
Career Choice Worksheet (Handout)
Summative Assessment :
Excel Spreadsheet
Acceleration:
Students can present the college of their choice to the class and use the charts and graphs to explain why they chose that particular college.
Intervention:
Reteach the lesson
Decrease the number of colleges to one or two
Allow student an extended amount of time