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...
Activity
Howard Hughes Medical Institute

Spreadsheet Tutorial 1: Formulae, Functions, and Averages

For Students 9th - 12th
Spread your knowledge of spreadsheets. The first of five tutorials in the Spreadsheet Data Analysis unit introduces the basics of spreadsheets. It shows future data analysts how to organize and format tables, and how to use functions to...
Activity
Howard Hughes Medical Institute

Gorongosa: Scientific Inquiry and Data Analysis

For Teachers 9th - 12th Standards
How does the scientific process begin? Introduce ecology scholars to scientific inquiry through an insightful, data-driven lesson. Partners examine data from an ongoing research study to determine the questions it answers. The resource...
Activity
Howard Hughes Medical Institute

Measuring Biodiversity in Gorongosa

For Teachers 9th - 12th
Take your biology class' understanding of biodiversity to a whole new level! Ecology scholars use data to calculate three different diversity indices based on the organisms in the Gorongosa National Park. The four-part activity uses an...
Activity
Teach Engineering

Energy Perspectives

For Teachers 8th - 10th Standards
The data says ... the resource is great to use. Using Microsoft Excel, pupils analyze data from the US Department of Energy in the fifth lesson of a 25-part Energy Systems and Solutions unit. Each group looks at a different data set and...
Lesson Plan
Curated OER

Electronic Hydrology Lesson Plan - Revised

For Teachers 8th - 12th
Students use Excel spreadsheets. They predict time and height of peak flow on river
Lab Resource
Pingry School

The Water Lab – Spreadsheet Simulation

For Students 9th - 12th Standards
More than 70 percent of people and 90 percent of businesses use spreadsheets regularly. While many courses overlook the important skill, the simple water lab focuses on entering spreadsheet data, formatting it, and printing plots based...
Lesson Plan
Curated OER

A Comparison Study of Water Vapor Data to Precipitation over North America

For Teachers 10th - 12th
Students use NASA satellite data to compare water vapor over the United States.  In this data analysis instructional activity students use an Excel spreadsheet to map their data. 
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
1
1
Curated OER

The Solstices

For Teachers 6th - 9th
Compare surface temperatures when the solstice occurs in the different hemispheres. Young scientists draw conclusions from their investigation of data collected using spreadsheets and a globe.
Activity
Howard Hughes Medical Institute

Spreadsheet Tutorial 2: Autofill Data, Cell References, and Standard Deviation

For Students 9th - 12th
If you've always wanted to know more about spreadsheets, here's a perfect resource for you. A self-paced tutorial introduces how to autofill and copy formulas in a Google sheet or Excel spreadsheet. It also shows users how to find range,...
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

Dough Lake Topology

For Teachers 9th - 12th
Young scholars practice coordinates and measurements, develop 2D, 3D topological map, construct grid with string on real surface, establish "level" fixed point for measurements, take and record data points of elevation, and enter data on...
Lesson Plan
Curated OER

Plants Under Attack

For Teachers 3rd
Third graders will identify the four needs for plant survival and gain skills and confidence in using scientific measurement tools, probes as well as the spreadsheets and graphing capacity of a computer to represent and analyze data.They...
Lesson Plan
Curated OER

Creating Climographs

For Teachers 6th - 8th
Students use satellite data to compare precipitation and surface temperatures on different islands.  In this satellite lesson students create graphs and explain the differences between weather and climate. 
Lesson Plan
Curated OER

Lesson 14: Genetic Disorders

For Teachers 9th - 10th
Students create PowerPoint presentation on the topic they researched. In this biology lesson, students fill out a storyboard about their topic. They share their project in class.
Lesson Plan
Curated OER

DNA Technology

For Teachers 9th - 10th
Students prepare PowerPoint presentation on DNA and cells. In this biology lesson, students create a storyboard of their presentation. They share the finished project in class. 
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....
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
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

Earth Energy Budget Pre Lab

For Teachers 4th - 7th
Students explore energy by conducting an in class experiment. In this climate change lesson, students conduct a water vapor experiment in a soda bottle. Students utilize graphs and charts to analyze the results of the experiment and help...
Lesson Plan
Curated OER

SolidWorks for Sheet metal

For Teachers Higher Ed
Students practice using the different tools on the Sheet Metal toolbar. In this engineering lesson, students create a sketch given a set of procedures to follow.
Lesson Plan
Curated OER

GeoHunt

For Teachers 7th - 8th
Students describe the difference between geological resources and othe natural resources. They list the rocks, minerals, and fossil fuels that are found in Illinois and their uses. They identify ways to conserve natural resources.
Lesson Plan
Curated OER

What Do Plants Need to Grow?

For Teachers 4th
Fourth graders control variables to determine the effect on plant growth. They collect information by observing and measuring and construct simple graphs, tables, maps and charts to organize, examine and evaluate information.

Other popular searches