Lesson Plan
Curated OER

Dough Lake Topology

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

Taxes: Where Does Your Money Go?

For Teachers 9th - 12th
High schoolers explore the concept of taxes. In this tax activity, students investigate types of taxes and deductions taken out of a paycheck before they see it. High schoolers calculate the tax on a given dollar amount. Students...
Lesson Plan
Curated OER

It's Not Your Fault

For Teachers 9th - 12th
Students study the San Andreas Fault, calculate its movements, and compare the movements on both sides.  In this earthquake lesson students use the Internet to track movement, and calculate movement using a spreadsheet. 
Lesson Plan
Curated OER

Fencing Your Backyard

For Teachers 8th - 10th
Students use geosketch ro create a fence. For this geometry lesson, students identify the amount of material and area needed to create a fence. They calculate the perimeter and surface area of their fence.
Lesson Plan
Curated OER

The Water Detectives

For Teachers 9th - 12th
Learners collect water samples from designated sampling stations, and discuss water pollution. They analyze the water samples, record the data on a spreadsheet, and present the environmental water quality data to the class.
Lesson Plan
Curated OER

Break Even Analysis and Budgeting

For Teachers 11th - Higher Ed
Young scholars analyze the use of break even charts in business planning. They examine the purpose and nature of budgets. They explore price elasticity and how to use Excel spreadsheets to manipulate financial information.
Lesson Plan
Curated OER

All Shook Up

For Teachers 7th - 12th
Students calculate the amount of displacement after an earthquake.  In this seismic event instructional activity students research the Internet, and fill out a CORS data sheet.
Lesson Plan
Curated OER

Eyes on the Estuaries

For Teachers 9th - 12th
Students study estuaries and compare several ones in the U.S. In this estuary lesson students interpret data and compare the distribution of different species. 
Lesson Plan
Curated OER

Getting Physical with Estuaries

For Teachers 9th - 12th
Students study estuaries and how the physical factors change over time.  In this investigative lesson plan students use a website to gain knowledge of estuaries then in groups they create and present their charts.
Lesson Plan
Space Awareness

The Climate in Numbers and Graphs

For Teachers 6th - 10th Standards
Weather versus climate: weather relates to short time periods while climate averages the weather of a period of many years. Scholars learn about average temperature and precipitation in various climate zones and then apply statistics...
Lesson Plan
Curated OER

Getting to Know the Thirteen Colonies

For Teachers 5th
Fifth graders analyze information about the thirteen colonies. Using the information, they can manipulate and identify a region in which the colony is located. As a class, they make generalizations about the various regions and time...
Lesson Plan
Curated OER

There's No Accounting for Good Journals

For Teachers 10th
Tenth graders create journals on their spending habits. In this money-management lesson plan, 10th graders create and keep journals of their personal income and expenditures. Students learn to use Excel to create a spreadsheet for their...
Lesson Plan
Curated OER

Rock Creek Water Quality

For Teachers 9th
Ninth graders test water in a local creek using chemical kits and probes. They take GPS readings and digital photos. They calculate the Water Quality Index and create a spreadsheet of the test data.
Lesson Plan
Curated OER

Testing Battery Combinations

For Teachers 4th
Fourth graders examine the required combinations of plates and predict which combination will generate the most and least current and voltage. They use an ammeter and experiment with combinations of their own testing and record each...
Lesson Plan
Curated OER

Digestive System

For Teachers 6th - 8th
Middle schoolers explore the parts of the digestive system. Using interactive spreadsheet software, students observe, name and describe the function of each part of the digestive system. Middle schoolers may work individually or in pairs.
Lesson Plan
Curated OER

Halloween Graphitti

For Teachers 5th - 7th
Students complete multi-curricular activities in a Halloween themed lesson. In this Halloween lesson, students examine newspaper ads to find prices of pumpkins and use them to complete a stem and leaf plot. Students find the diameter,...
Lesson Plan
Curated OER

Marine Protected Areas

For Teachers 11th - 12th
Students design a research project about a Marine Protected Area they chose. In this marine biology lesson, students gather fish count and catch data then graph them. They create an information poster about their findings.
Lesson Plan
Curated OER

A Budget Can Help Young People Cut Their Spending

For Teachers 9th - 12th
Learners explore the concept of budgeting. For this budgeting lesson, students read an article about how a budget helps young adults keep track of their spending. Learners discuss financial issues that young adults have to deal with as...
Lesson Plan
Curated OER

Electric Field Mapping / Equipotential Lines

For Teachers Higher Ed
Students determine the equipotential lines surrounding a charged object. In this physics lesson, students draw lines to identify areas. They relate the spacing of the field lines to the strength of the charge.
Lesson Plan
Curated OER

BRIDGING THE GENERATION GAP

For Teachers 9th - 12th
Learners create a hypothesis about the attitudinal differences between generations, test their hypothesis with a survey, chart their findings, and present their answers to the class.
Lesson Plan
Curated OER

Just Graph It!

For Teachers 4th
Fourth graders evaluate various graphs for the best way to reflect statistical data. They use a spreadsheet to organize data and generate varied graphic representations. They select the graph they feel best shows their results.
Lesson Plan
Curated OER

Virial Theorem Lesson

For Teachers 9th
Ninth graders describe how equilibrium can occur as the balance of two effects. They model the stability of elliptical galaxies based on how fast stars within the galaxy are moving.
Lesson Plan
Curated OER

Collisions Lesson

For Teachers 10th
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.
Lesson Plan
Curated OER

Interest Calculation and Spreadsheets

For Teachers 5th - 12th
Students, while in the computer lab working on a spreadsheet program, calculate interest and accumulated value of a savings plan. They follow specific directives on how to create their spreadsheets. At the end of the lesson they print...