Lesson Plan
Curated OER

Pumped Up Gas Prices

For Teachers 3rd - 6th
Students calculate gas prices. In this transportation lesson, 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 over time. 
Lesson Plan
Curated OER

Stock Market Game

For Teachers 4th
Fourth graders are introduced to how the stock market operates. In groups, they practice reading and analyzing the Standard and Poor's 500 index. They participate in a simulation of buying and selling stocks on the market trying to...
Lesson Plan
Curated OER

Cook Me Up Some Equations

For Teachers 7th - 12th
Students study a variety of math concepts in the context of cooking up a meal. In this math lesson, students calculate surface area and volume. They draw and interpret different types of graphs.
Lesson Plan
Curated OER

Using R&R to Teach Mathematics

For Teachers 2nd
Second graders create a shape garden. In this polygons lesson plan, 2nd graders practice making shapes using a geoboard and read the book The Greedy Triangle by Marilyn Burns.  Students also design a shape garden using...
Lesson Plan
Curated OER

Mapping West Virginia

For Teachers 4th
Fourth graders explore West Virginia. In this Unites States geography lesson plan, 4th graders discuss the type of land and the cities in West Virginia. Students create two overlays, with transparencies, that show the natural land and...
Lesson Plan
Curated OER

How to Change the World

For Teachers 10th - 12th
Biology or health classmates read a case study about a family who is dealing with fetal alcohol syndrome. The PowerPoint that is supposed to be shown is not included, but there are a plethora of web resources that can be used to help you...
Lesson Plan
Curated OER

Introduction to Scatter Plots and Correlation

For Teachers 9th - 12th
Students examine the concept of scatter plots. They compare baseball statistics to locate the ones that correlate with winning, and identify the positive, negative, and no correlation in sets of data using MS Excel.
Lesson Plan
Cornell University

The Physics of Bridges

For Students 9th - 12th
Stability is key when building a bridge. Scholars explore the forces acting upon bridges through an analysis of Newton's Laws and Hooke's Law. The activity asks individuals to apply their learning by building a bridge of their own.
Lesson Plan
Cornell University

Sound Off!

For Students 10th - 12th
Time to witness the effects of sound. Learners analyze different materials to determine their abilities to absorb sound waves. They use free software to monitor the amplitude of the waves to verify results.
Lesson Plan
Curated OER

M & Ms in a Bag

For Teachers 3rd - 5th
Students make predictions about the number and colors of M&M's in a snack size package. They create an Excel spreadsheet to record the data from their small group's bag, create a graph of the data, and discuss the variations of data...
Lesson Plan
Curated OER

Sea Floor Spreading I

For Teachers 12th - Higher Ed
Students use Excel to explore the geodynamics Model equation for ocean depth around a sea-floor spreading center. They complete an introductory tutorial on Excel for students with no prior Excel experience.
Lesson Plan
Curated OER

Comparing Temperature, Pressure, and Humidity

For Teachers 6th - 9th
Students investigate data on temperature, pressure, and humidity by downloading information from the ARM Website. Working in groups, they discover how weather impacts life in each of the ARM sites. They record weather data in their...
Lesson Plan
Curated OER

Running On Empty

For Teachers 11th - 12th
Students research causes of rising gasoline prices. They collect data on fluctuating gasoline prices and analyze the data using Excel. They write comparative essays supporting their results and create PowerPoint presentations to present...
Lesson Plan
Curated OER

Pumpkin Properties are a Smash!

For Teachers 4th - 8th
Students receive a miniature pumpkin and proceed through several stations to measure a variety of physical properties. The data is entered into a data sheet and the mass and volume measurements are used to calculate density. They also...
Lesson Plan
Curated OER

The Big Apple

For Teachers 8th - 9th
Students study the buying and selling market and how prices are determined for an agricultural product. In this competitive market lesson, students study how prices are determined in a market by studying the forces of supply and demand....
Lesson Plan
Curated OER

Tech Smart

For Teachers 6th
Sixth graders practice computer skills. In this technology lesson, 6th graders use programs such as Microsoft Word, Excel, Print Shop, and PowerPoint. They use the Internet for research and data collection to be incorporated in their...
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

Archaeology Vocabulary Sampling

For Teachers 4th - 8th
Students predict how many words out of ten they accurately define. They match the definitions to the correct vocabulary words and make a bar graph showing how many definitions were matched to the correct words. The write their group...
Lesson Plan
Curated OER

Create and Analyze Rectangular Patterns

For Teachers 6th - 8th
Learners explore the concept of geometric patterns. For this geometric pattern lesson, students use Microsoft Excel to explore geometric patterns. Learners analyze growth rates of pattern growth. Students create their own patterns...
Lesson Plan
Curated OER

Who is Being Left Behind?

For Teachers 7th - 9th
Students investigate scores as they relate to race. In this algebra lesson, students analyze standardized scores and how race can affect these scores. They plot their findings on a graph and draw conclusions.
Lesson Plan
Curated OER

The Sun's habitable Zone

For Teachers 9th - 12th
Students explore the average surface temperature of planets. They use the Planet Temperature Calculator to find the average temperature. Students explore how the distance from the sun affects the Earth's average surface temperature. They...
Lesson Plan
Curated OER

Food Groups in our Lunch

For Teachers 3rd - 5th
Young scholars make a graph. In this food groups and graphing lesson, students pack a sack lunch and then work in groups to tally the number of foods from each food group that they have. Young scholars use the data collected to create a...
Lesson Plan
Curated OER

Survey Project

For Teachers 8th
Eighth graders create a website using FrontPage. They use inserted forms to collect survey information and use Microsoft Excel and MS Word to create a presentation of the survey and the results.
Lesson Plan
Curated OER

The Distributive Property

For Teachers 5th - 8th
Students review how to solve problems using the Distributive Property of Mathematics. They solve problems using the paper and pencil method and then use the graphing calculator to discover the property over addition while making a visual...