Lesson Plan
Curated OER

Escape Velocity

For Teachers 6th
Sixth graders create/use spreadsheets to solve real-world problems, explore patterns, make predictions, select/explain most appropriate types of graph to display data, use information to create product, and have basic understanding of...
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

Dental Detectives

For Teachers 1st
First graders explore the theme of dental health and hygeine. They make tooth loss predictions, count lost teeth, and graph tooth loss. In addition, they listen to dental health stories, read online stories, create spreadsheets, and play...
Lesson Plan
Curated OER

Birds, Fractions and Percentages

For Teachers 6th - 12th
Students study fractions, percentages, spreadsheets, and computers by watching and recording the number of species of birdsseen. They create a spreadsheet to record the results of their one month study.
Lesson Plan
1
1
Earth Watch Institute

Entering Local Groundhog Data in an Excel Spreadsheet

For Teachers 4th
Here is a cross-curricular ecology and technology lesson; your learners create spreadsheets depicting the location and number of groundhog dens in a local park. They research groundhogs and analyze data about where the groundhog...
Lesson Plan
Curated OER

Temperature High and Lows

For Teachers 5th - 8th
Students gather high and low temperature readings through email. In this temperature graphing lesson, students use a spreadsheet to input data for a graph. students interpret the graphs to compare and contrast the data from different...
Lesson Plan
Curated OER

Bones and Math

For Teachers 5th - 12th
students identify and explore the connection between math and the bones of the human body. Students collect data about bones from their classmates and from adults, apply formulas that relate this data to a person's height, and organize...
Lesson Plan
Curated OER

Math: The Bone connection

For Teachers 5th - 12th
Young scholars examine the connection between bones of the human body and math. In groups, they locate bones and determine which instruments are used for measuring. Students organize their findings and create spreadsheets for calculating...
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

Spreadsheets in Science

For Teachers 4th
Fourth graders create spreadsheets, explore patterns and make predictions based on the information. They select the appropriate graph to display the spreadsheet data. They search and sort prepared data bases to gain knowledge for...
Lesson Plan
Curated OER

Calculating & Graphing Using a Spreadsheet

For Teachers 11th - 12th
Students use the lab apparatus to calculate the average velocity and average acceleration at several points and record the data. They use the spreadsheets to plot distance vs. time, velocity vs. time and acceleration vs. time graphs.
Lesson Plan
Curated OER

Pollution Assessment: Is Wood Lake a Good Lake?

For Teachers 7th - 8th
Students become aware of pollution in Richfield Minnesota's Wood Lake, identify sources of pollution in Wood Lake, learn to use variables, equations, spreadsheets and modeling software, and generate solutions for the problem.
Lesson Plan
Curated OER

Polluting the Environment

For Teachers 4th
Fourth graders construct mini-ecosystem, pollute the ecosystem, observe, collect, and record data on the effects of these pollutants on their ecosystem, organize data on spreadsheets, create graphs, and design presentations to share with...
Lesson Plan
Curated OER

Publisher Brochures

For Teachers 7th - 8th
Students create brochures on subjects they are studying in Publisher. In this nonfiction writing instructional activity, students use Publisher to create a brochure telling all the main ideas of a topic they are studying. Students use...
Lesson Plan
Alabama Learning Exchange

Watch That Plant Grow

For Teachers 6th - 8th
Middle schoolers examine the growth of marigolds in a greenhouse environment. They chart data in spreadsheets showing plant growth over time and under a number of conditions. They record measures of plant height and greenhouse temperature.
Lesson Plan
Curated OER

Putting Your Money to Work

For Teachers 9th - 11th
Students create a collect data on expenses. In this algebra lesson plan, students create a spreadsheet to solve scientific equations. They incorporate math, science and technology in this lesson plan.
Lesson Plan
Curated OER

Exploring the Beach

For Teachers 6th - 9th
Students explore the beach. In this marine habitat lesson, students inspect sand grains, design beach profiles, classify marine life, and examine natural beach habitats. Students use spreadsheets to record data from their activities at a...
Lesson Plan
Curated OER

Checking Test Comparability/Scattergrams

For Teachers 7th - 12th
Students construct a scattergram graph. In this statistics lesson plan, students graph data by hand and using a spreadsheet program. They establish lines of best fit and draw conclusions using their graphs.
Lesson Plan
Curated OER

Pumped Up Gas Prices

For Teachers 4th - 12th
Students spend one month keeping track of the mileage and gasoline amounts they or their family has used. Information is entered into a spreadsheet to help calculate the average gas prices over time.
Lesson Plan
Curated OER

Understanding Cloud Formation

For Teachers 3rd - 5th
Students read and relate the poem, "Clouds" by Aileen Fisher to a demonstration on cloud formation. They create clouds in jars using ice water and matches then discuss the ways clouds can be used to predict weather.
Lesson Plan
Curated OER

Graphing Heart Rates

For Teachers 4th - 5th
Students explore heart rates. They record pulse rates, predict which exercises cause a faster heart rate, make a chart, and graph the results. Students write an essay using the data to support their predictions. They write a hypothesis...
Lesson Plan
Curated OER

Lobster Roll!

For Teachers 9th - 12th
Students 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

Pumped Up Gas Prices

For Teachers 3rd - 6th
Learners calculate gas prices. In this transportation instructional activity, students tally the mileage and gas costs of their car for one months. They figure out how much was spent on gas and create a graph showing average gas prices...
Lesson Plan
Curated OER

Significant Science: Statistics for Planet Earth

For Teachers 9th
Ninth graders discover how statistics are used to interpret results of scientific experiments. Students write hypotheses and test the hypotheses by collecting data and organizing the data. Students graph their data to produce a visual....