ALEX Lesson Plan

Creating Line Charts: Lines over Time

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: 33255 Title: Creating Line Charts: Lines over Time Overview/Annotation: 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.
Associated Standards and Objectives
Content Standard(s):
 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.

Local/National Standards:

Primary Learning Objective(s):

Students will learn how to:

1. Utilize productivity software (Microsoft Excel) to create line charts
2. Compare and contrast data (College Weather) using charts and graphs
3. Research information using the Internet to make an informed decision
4. Gain a deeper understanding of charts and graphs by learning that line charts are used to illustrate data over a period of time

This assignment is to elicit students to begin thinking about:

1. Career choices
2. Colleges
3. How important does weather weigh in on their college decision?
4. The correlation between data, charts and graphs

The assignment was connected to other activities because it allowed students to:

1. Select a career field
2. Use the Internet and search engines to find information
3. Make a decision based on their research and findings
4. Explore colleges
Preparation Information
 Total Duration: 61 to 90 Minutes Materials and Resources: Student/Teacher Handouts (Attached)College Weather Report WorksheetCollege Weather Questionnaire WorksheetCollege Weather Highs ExampleCollege Weather Lows 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 three different chart types:Pie Chart-Represents parts of a WholeBar Chart- Compare two separate entitiesLine 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 spreadsheetHow to use search enginesHow to read a line chart
Procedures/Activities:
 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: Title 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. CollegeWeatherExcelHIGHSExample.pdf CollegeWeatherExcelLOWSExample.pdf CollegeWeatherQuestionnaireWorksheet.pdf CollegeWeatherReportWorksheet.pdf
Assessment
 Assessment Strategies Formative Assessment:College Weather Report Worksheet (Handout)College Weather Questionnaire Worksheet (Handout)Summative Assessment:Excel SpreadsheetLine Chart- Representing college weather LOWSLine Chart- Representing college weather HIGHS
 Acceleration: 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. Intervention: Re-teach the lessonDecrease the number of colleges to 1 or twoAllow student an extended amount of time

Each area below is a direct link to general teaching strategies/classroom accommodations 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 Environment Time Demands Materials Attention Using Groups and Peers Assisting the Reluctant Starter Dealing with Inappropriate Behavior
Be sure to check the student's IEP for specific accommodations.