|Lesson Plan ID:
Creating Line Charts: Lines over Time
Students will select three colleges or universities that they would consider attending. Students will then conduct an online research on the average temperature Highs and Lows for each location over a 12 month period. Next, students will create a line chart illustrating the average temperature highs and lows for each university and then answer 10 questions based on their research (information in the chart).
This is a College- and Career-Ready Standards showcase lesson plan.
|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||10. Critique the Internet and digital information for validity, accuracy, bias, and current relevance. |
|Primary Learning Objective(s):
Students will learn how to:
- Utilize productivity software (Microsoft Excel) to create line charts
- Compare and contrast data (College Weather) using charts and graphs
- Research information using the Internet to make an informed decision
- Gain a deeper understanding of charts and graphs by learning that line charts are used to illustrate data over a period of time
|Additional Learning Objective(s):
This assignment is to elicit students to begin thinking about:
- Career choices
- How important does weather weigh in on their college decision?
- The correlation between data, charts and graphs
The assignment was connected to other activities because it allowed students to:
- Select a career field
- Use the Internet and search engines to find information
- Make a decision based on their research and findings
- Explore colleges
|Approximate Duration of the Lesson:
|| 61 to 90 Minutes|
|Materials and Equipment:
Student/Teacher Handouts (Attached)
- College Weather Report Worksheet
- College Weather Questionnaire Worksheet
- College Weather Highs Example
- College Weather Lows Example
|Technology Resources Needed:
Computer with Internet access, Spreadsheet Software, Teacher Demonstrations with Interactive White Board.
This lesson should follow a discussion about three different chart types:
- Pie Chart-Represents parts of a Whole
- Bar Chart- Compare two separate entities
- Line Chart- Compares data over time (12 months for this assignment)
The discussion should also include the importance of weather (activities students will be able to participate in) and if weather would factor into their college decision.
I. In order to complete this assignment successfully students needed to know:
- How to use a spreadsheet
- How to use search engines
- How to read a line chart
Step 1: Motivation & Introduction
Begin the lesson by discussing the pros and cons of living in a warm climate versus a cold climate and vice versa. For example, someone who attends UCLA can go surfing, water skiing and enjoy wearing shorts practically year round. On the other hand, someone who attends Boston College can go snow skiing, snowboarding and enjoy building a snowman.
Step 2 : Activity
I. Conduct an online research for each college average temperature Highs and Lows College Weather Report Worksheet(handout)
II. Use the handout to put the data into a Spreadsheet.
- Sheet 1- Create a line chart comparing each colleges average Low temperature for each month in Fahrenheit
- Sheet 2- Create a line chart comparing each colleges average High temperature for each month in Fahrenheit
- The Line chart should have the following:
- X-Axis Title (Months)
- Y-Axis Title (Temperature in Fahrenheit)
- Legend (College Name & City, State)
|Attachments:**Some files will display in a new window. Others will prompt you to download.
College Weather Report Worksheet (Handout)
College Weather Questionnaire Worksheet (Handout)
- Line Chart- Representing college weather LOWS
- Line Chart- Representing college weather HIGHS
Students can create a line chart of the college of their choice illustrating the college’s highs and lows. They could write one paragraph discussing the various extracurricular activities they can participate in, in relation to the weather.
- Re-teach the lesson
- Decrease the number of colleges to 1 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: