Lesson Plan
Curated OER

The Wonders of Bacteria

For Teachers 9th - 10th
Young scholars explore the evolution and features of bacteria through a series of activities. In this biology lesson, students collect data and graph bacterial growth. They design a brochure about bacteria's role in society.
Lesson Plan
Curated OER

Means of Growth

For Teachers 9th - 12th
Students collect and graph data. In this statistics lesson, students analyze their plotted data using a scatter plot. They identify lines as having positive, negative or no correlation.
Lesson Plan
Curated OER

Review of the Scientific Method

For Teachers 9th - 10th
Students review the Scientific Method with a hands-on activity. Working with a partner, they hypothesize the number of water drops that fit on the heads side of a penny. They collect data and share their results with the remainder of...
Lesson Plan
Curated OER

Creating Circle Graphs with Microsoft Excel

For Teachers 7th
Seventh graders will learn how to construct circle graphs using paper and pencil. Then they will learn how to construct circle graphs using Microsoft Excel. This lesson uses technology and shows learners how to cross skills into the...
Lesson Plan
Curated OER

Music and Sports

For Teachers 7th - 9th Standards
With so much talent in the classroom, do your musicians and athletes have related interests? This problem has your learners taking data from their classmates to decide whether there is an association between the two activities. The...
Lesson Plan
Curated OER

Historical Pollution in the Hudson: Part 2

For Teachers 9th
Ninth graders practice how to format and enter data into an Excel spreadsheet, make a graph, and interpret graphed data. They recognize how the pollution in the Hudson River has changed over time, and explain the consequences of these...
Lesson Plan
Science 4 Inquiry

Snakes in the Everglades

For Teachers 6th - 8th Standards
The Burmese python is on the loose ... and he's hungry! Illustrate the differences between causative and correlative relationships through an inquiry instructional activity. Pupils examine several sources of information to determine if...
Lesson Plan
Curated OER

Mathematics Module

For Teachers 9th
Delve into graphing! The concepts covered begin with basic graphing basic coordinates and algebraic expressions on coordinate planes, and build up to graphing linear inequalities and equations. Learners solve and simplify various...
Lesson Plan
Curated OER

One, Two, Three...and They're Off

For Teachers 5th - 6th
Students make origami frogs to race. After the race they measure the distance raced, collect the data, enter it into a chart. They then find the mean, median, and mode of the data. Next, students enter this data into Excel at which time...
Lesson Planet Article
Curated OER

Calculator-Based Lessons Help Examine Real-World Data

For Teachers 6th - 9th
Students may determine equations based on graphs and regression models.
Lesson Plan
Curated OER

A Plop and Fizz

For Teachers 7th
Seventh graders perform an experiment to determine the effect of temperature on reaction rates. In this chemistry lesson, 7th graders take measurements and record data. They create a graph and analyze results.
Lesson Plan
Curated OER

Quadratic Equations with the CBL 2

For Teachers 9th - 12th Standards
Learners practice generating parabolas with a motion sensor while determining the vertex form of the equation. They compare it to the regression equation from the calculator onto a data mate software. Each student completes several...
Lesson Plan
Curated OER

Graphing With a Spreadsheet

For Teachers 4th
Fourth graders review how to create bar, line and circle graphs. Using jelly beans, they collect data and present it in a bar graph form. They enter the same data into a spreadsheet and watch as the program creates the same graph. They...
Lesson Plan
Curated OER

Probability and Statistics

For Teachers 9th - 11th
Students are taught to search the internet for statistics concepts on sports. In this probability activity, students collect data and use the calculator to graph and analyze their data. They graph and make predictions about sports using...
Lesson Plan
Alabama Learning Exchange

What do Plants Need?

For Teachers 3rd - 4th
Students plant seeds and watch them sprout. Once growing plants are placed in different conditions and students record data about their growth. They graph the data.
Lesson Plan
Curated OER

EXCEL It!

For Teachers 5th - 8th
Students surf the Web gathering information about graphs. The data collected is incorporated into an Excel spreadsheet and graphs of varying nature generated to further enhance student understanding.
Lesson Plan
Curated OER

M & M Madness

For Teachers K
Students work with the mathematics unit of collection, organization, and presentation of data. In this math and technology lesson plan, students use Valentine M & M’s and The Graph Club to sort and graph the various colored M & M’s.
Lesson Plan
Curated OER

Graphing Favorite Fruit

For Teachers 3rd
Third graders take poll and sort data, enter the data to create a spreadsheet and create bar and pie graphs.
Lesson Plan
Curated OER

The Solar Cycle

For Teachers 7th - 12th
Students research the solar cycle. In this Science lesson, students use the internet to investigate the solar cycle. Students produce a spreadsheet and graph from the information collected.
Lesson Plan
Curated OER

Graphing

For Teachers 5th - 12th
Students gather statistical information on a chosen topic and place it into a spreadsheet. Using th Excel chart wizard, students create tables, graphs and charts of their information. They interpret the data and share it with the class.
Lesson Plan
Curated OER

Jellybean Graphs

For Teachers 2nd
Second graders predict and graph data based on the color of jelly beans they think are in a handful. In this prediction lesson plan, 2nd graders will predict how many of each color jellybean are in a handful. Then they graph these...
Lesson Plan
Curated OER

Graphing Regions: Lesson 2

For Teachers 3rd - 5th
Young scholars identify and analyze geographical locations of inventors. They each identify where their inventor is from on a U.S. map, discuss geographic patterns, and create a t-chart and graph using the Graph Club 2.0 Software.
Worksheet
Curated OER

Interpreting Data

For Students 7th - 8th
In this interpreting data worksheet, students solve and complete 4 different types of problems using different data types. First, they collect raw data from a paragraph shown. Then, students identify the examples of two different types...
Lesson Plan
Curated OER

Student Costs Graph

For Teachers 5th - 7th
Students calculate the mileage, gasoline costs, and travel time and costs for a vacation. They conduct a virtual field trip, and create a comparison graph of costs using Microsoft Excel software.