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

Using a Spreadsheet to Solve Gas Law Problems

For Teachers 9th - 12th
High schoolers use a spreadsheet to solve gas law problems. In this gas laws lesson plan, students use the Express Calc program to load a spreadsheet for the gas law problems. High schoolers compute volume, temperature, or pressure...
Lesson Plan
Curated OER

Using a Spreadsheet to Understand Density

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

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

A Line Graph of the Ocean Floor

For Teachers 4th - 5th
Learners develop a spreadsheet and import the information into a line graph. In this spreadsheet and line graph instructional activity, students develop a spreadsheet of ocean depths. They import the information into a word processed...
Lesson Plan
Curated OER

Weather

For Teachers 5th - 7th
Learners create a spreadsheet and chart using data collected.  In this weather lesson, students select five cities from their state, including the city they live in.  Learners take daily temperature readings from all five...
Lesson Plan
Curated OER

Haber's Process- A Computer Simulation

For Teachers 10th - Higher Ed
Learners use an on line simulation to produce ammonia using Haber's process. In this Haber's process lesson plan, students use a spreadsheet to manipulate the pressure, temperature and catalysts used in the production of ammonia. Their...
Lesson Plan
Alabama Learning Exchange

How Big Can a Bee Be?

For Teachers 7th - 10th Standards
Mathematicians analyze the relationships between surface area and volume. They conduct Internet research, conduct various experiments, record the data in a spreadsheet, and graph the results and compare the rate of increase of surface...
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
Curated OER

Forces of Flight - Lift

For Teachers 3rd - 8th
Students design and test paper airplanes to understand the concept of lift and how it affects flight. This technology-based Science lesson plan is excellent for use with upper-elementary and middle-level learners and uses spreadsheet...
Lesson Plan
Curated OER

Does Humidity Affect Cloud Formation?

For Teachers 6th - 8th
Students use S'COOL data to identify factors that affect cloud formation. They find a data set using the S'COOL database , and use Excel to manipulate the data. Student isolate relevant data, create meaningful graphs from a spreadsheet,...
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
Howard Hughes Medical Institute

Lesson 8: WildCam Gorongosa Data Analysis

For Teachers 9th - 12th
How do scientists analyze data to get a specific answer to a question? The final chapter in an eight-part series of activities centered around Gorongosa National Park encourages scholars to dig deeper into the scientific process. After...
Lesson Plan
Curated OER

Graphing Data from the Chemistry Laboratory

For Teachers 9th - 12th
High schoolers graph and analyze data using a spreadsheet.
Lesson Plan
Curated OER

Collect the Weather Lesson Plan

For Teachers 3rd - 8th
Students explore the weather. In this weather spreadsheet lesson, students keep track of weather patterns as they use instruments and resources to chart the data the collect in spreadsheet form.
Lesson Plan
Curated OER

Graphing Climate Information

For Teachers 7th
Seventh graders plot the data for the average monthly precipitation for three cities. They make a graph using a spreadsheet.
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

Spreadsheet Moon Comparison

For Teachers 4th - 6th
Students use the Internet to research characteristics of moons for other planets They use a spreadsheet to organize information for all of the moons researched. They use the spreadsheet data to make statements showing comparisons and...
Lesson Plan
Curated OER

Volcano Spreadsheet and Graph

For Teachers 4th
Fourth graders find the height of selected volcanoes and convert their measurements to feet. Students interpret information from a graph. They also write math questions that require the use of a class created graph. Students use a...
Lesson Plan
Curated OER

Historical Pollution in the Hudson: Part 2

For Teachers 9th
Ninth graders practice how to format and enter data into an Excel spreadsheet, make a graph, and interpret graphed data. They recognize how the pollution in the Hudson River has changed over time, and explain the consequences of these...
Lesson Plan
Curated OER

Atomic Emission Spectra and the Bohr Model of the Atom

For Teachers 9th - 12th
Students investigate the wavelengths of spectra lines for common atoms. In this atomic emission spectra lesson plan, students use a transformer and diffraction grating to observe the emission spectra of various atoms. They find the...
Lesson Plan
Virginia Department of Education

The Rate of Motion

For Teachers 9th - 12th
How much time does it take to jump over three balloons? Pupils calculate the speed of tasks that require different motions. They determine motions for tasks such as walking, skipping, hopping, and jumping before creating a...
Lesson Plan
Curated OER

Lesson Plan Outline for Rainbow Science

For Students 7th - 12th Standards
Young scientists study light reflection and refraction as they determine the critical angle, the rainbow angle, and color separation in rainbows. Teams record the data they collect in a shared spreadsheet and discuss results with the class.
Lesson Plan
NOAA

Biological Oceanographic Investigations – Signals from the Deep

For Teachers 9th - 12th Standards
The Deepwater Horizon oil spill directly impacted an area of the Gulf of Mexico the size of Oklahoma. A marine biology lesson looks at the impact of an oil spill on the deeper parts of the ocean. Scholars download actual data collected...

Other popular searches