Lesson Plan
Curated OER

Hopes and Dreams: A Spreadsheet Lesson Using Excel

For Teachers 4th
Fourth graders read "The Far Away Drawer" by Harriet Diller and discuss the story as a class. After discussion, 4th graders create a t-shirt GLYPH about their hopes and dreams,share their information with the class and create spreadsheets.
Lesson Plan
Curated OER

Data Shuffle

For Teachers 6th - 8th
Students find an advertisement or newspaper using charts or graphs. They create another graph using the same information in a different format. They write a comparison of the two graphs.
Lesson Plan
Curated OER

Color Tile Graphing

For Teachers 2nd - 5th
Students explore data. They gather data and generate questions about the data in pictographs, tallies, tables, and bar graphs. Students use color tiles pulled by random to create their own bar graph. They discuss the bar graphs they...
Lesson Plan
Curated OER

Catches and landed value of fish

For Teachers 9th - 12th
Students analyze data.  For this secondary mathematics lesson, students read and retrieve data from a statistical table on the Canadian fishing industry.  Students interpret and describe data in mathematical terms and make...
Lesson Plan
Curated OER

Discovering Pi

For Teachers 7th - 8th
Students develop a formula that describes the functional relationship of the circumference of a circle to its diameter. Working with a partner, they measure the diameter and circumference of circular objects in order to discover the...
Lesson Plan
Curated OER

Bar Graphs

For Teachers 7th
Seventh graders visually represent and analyze data using a frequency table. They recognize what values in a data set are bigger by looking at a bar graph and answer questions about certain bar graphs and what they represent. Students...
Lesson Plan
Curated OER

Canada's Climate: Temperature and Rainfall Variations

For Teachers 6th - 8th
Middle schoolers analyze data about various climates in Canada. In this data analysis and climate lesson, students use Canada Year Book 1999 to complete a worksheet and make connections between precipitation and temperature in different...
Lesson Plan
Curated OER

Graphing in the Information Age

For Teachers 6th - 8th
Students create a variety of graphs based on population data. In this statistics lesson plan, students use data that can be gathered on-line to make a bar chart, line graph, and circle graph.
Lesson Plan
Curated OER

Chinese Immigrants in British Columbia, 1870

For Teachers 9th - 12th
Young scholars interpret historical evidence presented in primary and secondary resources. In this British Columbia history lesson, students read and analyze data regarding 1870 Canadian census data. Young...
Lesson Plan
Curated OER

Role-Playing Jean Talon

For Teachers 7th - 12th
Students explore New France. In this New France lesson, students examine census data compiled by Jean Talon in 1665 and 1666. Students take on the role of Talon trying to convince the King of France to increase his investment in New...
Lesson Plan
Curated OER

The Fat and the Lean

For Teachers 8th - 11th
Students collect data on calorie intake. For this algebra lesson, students use the collection of data to make better eating decisions. They investigate the nutritional value in food using a graph and draw conclusion from their findings.
Lesson Plan
Curated OER

Misleading Graphs

For Teachers 3rd - 5th
Students explore number relationships by participating in a data collection activity. In this statistics instructional activity, students participate in a role-play activitiy in which they own a scrap material storefront that must...
Lesson Plan
Curated OER

Ocean Temperatures

For Teachers 8th - 11th
Students list data collected by marine buoys and the different kinds of moored buoys. They describe how data is transmitted worldwide. They explain the difference between near shore and offshore air and water temperatures.
Lesson Plan
Curated OER

Power Metering Project

For Teachers 9th - 12th
Students collect and analyze variable data and understand the concept of electrical power.  In this energy lesson plan students use a spreadsheet to manage their data and create box plots. 
Lesson Plan
Curated OER

Temperature Bar Graph

For Teachers 9th - Higher Ed
Students explore mean, median and mode. In this math lesson, students analyze temperature data and figure the mean, median, and mode of the data. Students graph the data in a bar graph.
Lesson Plan
Curated OER

Getting A Grip On Graphs

For Teachers 4th
Fourth graders investigate the concept of graphing and comparing different types of data using pictographs, line graphs, scatter plots, etc... They gather data and make interpretations while examining the medium of how it is displayed.
Lesson Plan
Curated OER

Patterns, Relations, and Functions

For Teachers 6th - 9th
Students investigate the patterns of different data sets of numbers. They use critical thinking skills in order to find the missing numbers in any given set. This lesson helps to develop the skill of number sense.
Lesson Plan
Curated OER

Bias in Statistics

For Teachers 7th - 8th
Students work to develop surveys and collect data. They display the data using circle graphs, histograms, box and whisker plots, and scatter plots. Students use multimedia tools to develop a visual presentation to display their data.
Lesson Plan
Curated OER

Graph It

For Teachers 1st - 2nd
Students create a spreadsheet and graph using Open House attendance data.
Lesson Plan
Curated OER

Paws in Jobland: Lesson Plan 35 - Catch of the Day

For Teachers 3rd - 5th
Young scholars study information for fish farm workers given in the form of a chart, in order to practice interpreting data while learning about the career of a fisherman. In this data interpretation lesson, students read the chart to...
Lesson Plan
Curated OER

Using GIS to Construct Water Table Maps and Flow Nets

For Teachers Higher Ed
Students examine how to use GIS software to analyze patterns of groundwater flow. Seepage lake elevation data from the Sand Hills of Nebraska is used to construct a water table map and flow net using Esri's Arc Map software.
Lesson Plan
Curated OER

Function Tables

For Teachers 8th - 9th
Students identify function using tables of data. In this algebra activity, students create a tale of point and plot on a coordinate plane. They analyze the graph as being a function or not.
Lesson Plan
Curated OER

Discovering Magnets and Graphs

For Teachers 6th
Sixth graders investigate averages and statistics by discovering magnet strengths.  In this magnet experiment lesson, 6th graders utilize different magnets and attempt to attract different materials to them.  Students record...
Lesson Plan
1
1
American Statistical Association

A Sweet Task

For Teachers 10th - 12th Standards
Candy is always an effective motivator! A fun math activity uses M&M's and Skittles to explore two-way frequency tables and conditional probability. The candy can serve a dual purpose as manipulatives and experimental data.