Lesson Plan
Curated OER

Microsoft Excel Lesson Plan

For Teachers 5th
Fifth graders collect, organize, interpret data. In addition, they compare different textures, color including graphical representations such as bar graph, line graph .Students also describe the uses of rocks and how to use that to...
Lesson Plan
Curated OER

Over and Under Estimation

For Teachers 1st
First graders distinguish between an over-estimate and an under-estimate. They estimate the number of beans that can be held in a hand, organize data and actual findings.
Lesson Plan
Curated OER

Thinking Systematically

For Teachers 6th
Sixth graders solve real life mathematics problems. After reading a given problem, 6th graders gather and organize data into a table. They explore a pattern, and from this, derive a formula. Students solve the problems multiple ways...
Lesson Plan
Curated OER

Making A Table

For Teachers 6th
Sixth graders explore creating tables as a way to organize data. Students read story problems and discuss methods and strategies to solve them. They practice drawing tables, spotting patterns, and identifying missing information.
Lesson Plan
1
1
Cheetah Outreach

Population Change

For Teachers 3rd - 6th
Your youngsters become cheetahs in search of food, water, shelter, and space in a fun physical game that does a fantastic job of representing fluctuating species population based on resources available over years. 
Lesson Plan
Curated OER

Graph and Compare the Adventure's Temperature Vs. Local Temperature

For Teachers 7th - 9th
Students explore the concept graphing data. In this graphing data lesson, students use weather data from their local weather and some other city and graph them. Students plot the local weather vs. another city. Students record...
Lesson Plan
Curated OER

Speed + Graphing = Winners!

For Teachers 5th
Fifth graders take addition timed tests every day for a two week period. Using the data from the timed tests, they create a bar graph using Microsoft Excel computer software, a personal bar graph using graph paper and colored pencils,...
Lesson Plan
Curated OER

World Statistic Day

For Teachers 11th
Eleventh graders collect data about the state they live in. In this statistics lesson, 11th graders collect and analyze data as they compare themselves to students in other states. They analyze data about a person's education level, and...
Lesson Plan
Curated OER

Tall Tale Rollers

For Teachers 4th - 6th
Students explore American tall tales. In this tall tale lesson, students discover the six characteristics that are included in tall tales. Students survey their class to find each student's favorite tall tale character and organize the...
Lesson Plan
Curated OER

Hi, Deer!

For Teachers 5th - 6th
Students collect, organize by table, and examine census data in a simulation, estimate the size of the population in the simulation and make predictions based on the collection of census simulation data.
Lesson Plan
Curated OER

Geoboard Area

For Teachers 3rd - 6th
Young scholars 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

Pika Chew

For Teachers 6th - 8th
Learners work in collaborative teams with specific roles, use the Internet to research the behavior and ecology of pikas, make predictions about survival rates of pikas in different habitats and organize their data in graphs.
Lesson Plan
Curated OER

SUNSPOTS SPOTTED

For Teachers 11th - 12th
Students study sunspots and their motion, from data gathered, they determine the significance of the sunspot data. The data be used to calculate the rotational period of the sun. They draw conclusions as to the sunspot's impact on the...
Lesson Plan
Curated OER

Let's Get Organized

For Teachers 6th
Sixth graders identify table and each of its parts, including cell, column, row, header, and formula bar. Students then explain how tables are used to store and organize information in database, organize and categorize information...
Lesson Plan
Curated OER

Use It or Lose It

For Teachers 4th - 6th
Students explore the effects of resistance training on the muscles. Data on the muscle mass of rats is examined is graphed to determine any increase in mass due to training.
Lesson Plan
Curated OER

Fruit Loop Graphing

For Teachers 5th
Fifth graders interpret data and create graphs. Given Fruit Loops, they sort and classify according to color. Using spreadsheet technology, 5th graders record their data and create bar and circle graphs. Students analyze data and...
Lesson Plan
Curated OER

Discovering the Magical Pi

For Teachers 6th - 8th
Students calculate pi using data on the circumference and diameter of various objects. They define key vocabulary terms, measure the circumference and diameter of various circular objects, organize the data on a table or chart, and...
Lesson Plan
Curated OER

School Lighting Audit

For Teachers 9th - 12th
Students identify the data included in an energy audit. They perform an audit on the lighting in their school building. They complete a worksheet and discuss lighting issues with school staff.
Lesson Plan
Curated OER

Count The Letters

For Teachers 6th - 9th
Students perform activities involving ratios, proportions and percents. Given a newspaper article, groups of students count the number of letters in a given area. They use calculators and data collected to construct a pie chart and bar...
Lesson Plan
Curated OER

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

For Teachers 5th - 6th
Learners 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 Plan
Curated OER

Fast Food Survey Using Bar Graphs

For Teachers 2nd
Second graders create a bar graph to pictorically represent the data collected from a survey of students. They use Excel to electronically create the graphs and data tallies. They then interpret their data using sentences to explain.
Lesson Plan
Curated OER

Science: How's the Weather?

For Teachers 5th
Fifth graders brainstorm meteorological terms to create a semantic web using SuperPrint. For each topic, they create instruments, such as barometers or psychomotors, that they use to make scientific predictions about the weather. After...
Lesson Plan
Curated OER

Mean, Median, and Mode

For Teachers 9th - 12th
Students find the mean, median, and mode for a set of data. They define terms and find examples, as well as complete practice exercises. They work cooperatively to analyze real data from a variety of websites provided. To...
Lesson Plan
Curated OER

Paper Airplane Science

For Teachers 5th
Fifth graders recognize the need to follow the scientific method carefully and be aware of variables in experiments.  In this airplane instructional activity, 5th graders design and test an airplane, and complete a data sheet....