Lesson Plan
Curated OER

Multiplication Tables Using Microsoft Excel

For Teachers 8th
Eighth graders are introduced to Microsoft Excel as a computer application software program. They create multiplication tables in Microsoft Excel. Students work in small groups. They discuss the $ (anchor) function in Microsoft Excel.
Lesson Plan
Curated OER

Drawing One and Two Playing Cards With Replacement

For Teachers 6th - 9th
Math whizzes use data from simulations to make theoretical generalizations and discuss possible relationships between several given events. They use a simple card game to generate data to be analyzed.
Lesson Plan
Curated OER

A Fishy Tale

For Teachers 8th
Eighth graders do a research project on a particular species of Atlantic seafood and record and graph information pertaining to commercial landings of that species of seafood. They use a website and an Appleworks spreadsheet.
Lesson Plan
Curated OER

ExplorA-Pond: 6th Grade Area and Random Number Tables

For Teachers 6th
Sixth graders estimate surface area of a pond using a random number table.
Lesson Plan
Curated OER

The Hot Dog Stand

For Teachers 6th - 8th
Pupils run a computer simulation. They collect data as they work and use the data to create an annual report for their business. Several different simulations could be used for this project. It is desirable for students to do this...
Lesson Plan
Curated OER

American Colonies

For Teachers 6th - 8th
Students record information in a database about the three American colonies. They are comparing and contrasting them. They are to log into a given database and fill in the corresponding sections. Once it is filled in the similiarities...
Lesson Plan
Curated OER

Shoe Showdown

For Teachers 3rd
Third graders use rulers to measure their shoe size in inches and centimeters. They then enter the class shoe measurements into an excel data base and graph the results of both to make the comparison.
Lesson Plan
Curated OER

Excel Lesson

For Teachers 5th
Fifth graders will perform exercises and write the number of each exercise performed on the collection data sheet. They survey eight of their classmates for their exercise data and write that data on the collection data sheet. They then...
Lesson Plan
Curated OER

Nascar Unit Activity 2

For Teachers 8th
Eighth graders divide into groups of 4 or 5. They go to the track and have every student run/walk one lap around the school track. Call out their times as they cross the finish line. In the computer lab, have the students create a table...
Lesson Plan
Curated OER

What's Playing Tonight?

For Teachers 5th - 9th
Pupils collect data and visually represent it. They conduct a survey of favorite movies. Using a spreadsheet, students organize the data and create bar and circle graphs. Pupils answer statistical questions regarding the data.
Lesson Plan
Curated OER

All About Me: Measuring Height and Weight

For Teachers 2nd - 4th
Students take personal fitness inventories. In this personal health instructional activity, students take measurements of their heights and weights. Students record the data, calculate their BMI, and then chart their physical activity.
Lesson Plan
Curated OER

Two-Variable Linear Inequalities

For Teachers 9th - 11th
Here is an engaging lesson on solving equations with two variables. Have the class rewrite linear equations in the slope intercept form, y=mx + b. They graph the lines using the slope and y-intercepts.
Lesson Plan
Curated OER

Geoboard Area

For Teachers 3rd - 6th
Students explore the basic geometric shapes and geometric shape vocabulary through the use of geoboards and virtual geoboards. They create a variety of shapes with a partner, build ten different rectangles on their geoboards, and...
Lesson Plan
Curated OER

Lobster Roll!

For Teachers 9th - 12th
High schoolers collect data by playing a game that illustrates the delicate ecological balance between fishing, fishing regulations and fish populations. They graph and analyze the data and explain how economic decisions can affect the...
Lesson Plan
Curated OER

Great Graphing

For Teachers 7th - 8th
Students collect data, use a computer spreadsheet program to create various graphs, and compare the graphs. They state the findings of each graph in writing and decide which graph type best represents the data.
Lesson Plan
Curated OER

Find Yourself with Global Positioning

For Teachers 9th - 12th
Students examine different types of new mapping technologies. They use the internet to gather information about mapping and navigation. They create their own global positioning tool and defend it to the class.
Lesson Plan
Curated OER

Using a Spreadsheet to Understand Density

For Teachers 8th - 12th
Learners use density to identify what metal a gold colored weight is made of. They use a spreadsheet to graph the experimental density of common metals and compare the know densities to their calculated density of the known metal.
Lesson Plan
Curated OER

Mean, Median, Mode and Range

For Teachers 4th
Fourth graders investigate when to find the mean, median, mode and range.  In this statistical concepts lesson, 4th graders collect data, make observations and graph the data. Students verify their work on the computer.
Lesson Plan
Curated OER

First Class First? Using Data to Explore the Tragedy of the Titanic

For Teachers 9th - 12th
Students analyze and interpret data related to the crew and passengers of the Titanic. They research information on a Titanic database to illustrate specific statistical conclusions, and whether or not social status affected the outcome.
Lesson Plan
Curated OER

It's Your Life

For Teachers 6th - 7th
Students make a multiple line graph showing income levels for each education level for the past 8 years and the number of people for each ethnic group and gender is compared within each education level.
Lesson Plan
Curated OER

Rise Over Run

For Teachers 9th - 12th
Students define the slope of the line, find the slope between any two points on the line, and allow them to name other areas where the slope is used. They explain why the slope is defined as the rise over the run.
Lesson Plan
Curated OER

State Economy Chart

For Teachers 5th
Fifth graders research and record statistics on the economy of an assigned state. They create a spreadsheet in Excel to report the data and a 3D Pie graph using the Chart Wizard in Excel to represent their states' data.
Lesson Plan
Curated OER

Heat of an Unknown Metal

For Teachers 8th
Eighth graders complete labs to find the specific heat of many different types of substances, and use characteristic property to identify an unknown metal. CBL be used to determine energy lost or gained, and students complete a...
Lesson Plan
Curated OER

Baseball Relationships - Using Scatter Plots

For Teachers 6th - 10th
Students use graphing calculators to create scatter plots of given baseball data. They also determine percentages and ratios, slope, y-intercepts, etc. all using baseball data and statistics.

Other popular searches