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.
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.
Primary Learning Objective(s):
Students will learn how to:
Additional Learning Objective(s):
This assignment is to elicit students to begin thinking about:
Greater than 120 Minutes
Materials and Resources:
Student/Teacher Handouts (Attached)
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.
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:
IV. Create a bar chart to compare the cost of all (3) colleges on a separate sheet
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.
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.