|Lesson Plan ID:
College Cost: A MAJOR Expense!
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 Career-Ready Standards showcase lesson plan.
|BMA(7-8) Computer Essentials||5. Use spreadsheet software to create, save, open, edit, and print a workbook or worksheet. |
|BMA(7-8) Computer Essentials||8. Demonstrate use of the Internet in business. |
|BMA(7-8) Computer Essentials||9. Utilize research results to determine career and entrepreneurial opportunities, responsibilities, and educational and credentialing requirements in entry-level information technology professions. |
|BMA(9-12) 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(9-12) Business Technology Applications||12. Utilize research results to determine career and entrepreneurial opportunities, responsibilities, and educational and credentialing requirements in commerce and information technology. |
|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
|Approximate Duration of the Lesson:
|| Greater than 120 Minutes|
|Materials and Equipment:
Student/Teacher Handouts (Attached)
- Menu Worksheet
- Career Choice Worksheet
- 4-Year Out of State College Example
- 4-Year In state College Example
- 2-Year Technical College Example
- Total Comparison Example
|Technology Resources Needed:
Computer with Internet access, spreadsheet software, Teacher demonstrations with Interactive White Board.
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
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 in-state and out of state colleges as well as attending a technical college based on the students career choice. You can also discuss attending a two-year college and then transferring to a 4-year 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:
- 4-year out of State College (Must have student College Major)
- 4 year in-state College (Must have student College Major)
- Technical College (Must have student College Major)
- Course Fees—
- 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:
- Category Name
- Leader lines
IV. Create a bar chart to compare the cost of all (3) colleges on a separate sheet
- The bar chart should have the following:
- X-Axis Title (Colleges)
- Y-Axis Title (Annual Cost)
|Attachments:**Some files will display in a new window. Others will prompt you to download.
Menu Worksheet (Handout)
Career Choice Worksheet (Handout)
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.
- Re-teach the lesson
- Decrease the number of colleges to one or two
- Allow student an extended amount of time
Each area below is a direct link to general teaching strategies/classroom
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
||Using Groups and Peers
|Assisting the Reluctant Starter
||Dealing with Inappropriate
Be sure to check the student's IEP for specific accommodations.
|Variations Submitted by ALEX Users: