Earth Watch Institute
Entering Local Groundhog Data in an Excel Spreadsheet
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...
Curated OER
Creating Climographs
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.
Teach Engineering
Energy Perspectives
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...
Curated OER
A Comparison Study of Water Vapor Data to Precipitation over North America
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.
Curated OER
Dental Detectives
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...
Howard Hughes Medical Institute
Spreadsheet Tutorial 2: Autofill Data, Cell References, and Standard Deviation
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,...
Curated OER
Fast Food Survey Using Bar Graphs
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.
Curated OER
Lesson 14: Genetic Disorders
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.
Curated OER
DNA Technology
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.
Curated OER
Publisher Brochures
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...
Curated OER
Pumped Up Gas Prices
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...
Curated OER
Dough Lake Topology
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...
Curated OER
SolidWorks for Sheet metal
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.
Curated OER
Texas Weather Report
Young scholars use provided links to observe selected weather sites and collect temperature and precipitation data for listed cities. They enter the information onto their spreadsheet. Students study maps of the Texas natural reagions,...
Curated OER
What Do Plants Need to Grow?
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.
Curated OER
Collisions Lesson
Tenth graders explore the role that collisions and near collisions of galaxies play in determining the shape of galaxies. They model the collision of disk shaped and spherically shaped galaxies.
TeachEngineering
Teach Engineering: Energy Perspectives
Students utilize data tables culled from the US DOE Energy Information Agency to create graphs that illustrate what types of energy we use and how we use it. An MS Excel workbook with several spreadsheets of data is provided. Students...