Lesson Plan
Curated OER

It's In The Chocolate Chips

For Teachers 6th - 8th
Students investigate which brand of chocolate chip cookies contains the most chocolate. They analyze and compare data using Microsoft Word and Microsoft Excel. They communicate the results with Microsoft PowerPoint.
Lesson Plan
Curated OER

There's No Accountin with Ledgers

For Teachers 10th
Tenth graders create and maintain a ledger, write an essay for the process, and learn to keep financial accounts through the ledger. In this ledger lesson, 10th graders define an accounting ledger and create one for the money they've...
Lesson Plan
Curated OER

Teaching about Data Interpretation

For Teachers 9th - 12th
High schoolers explore a variety of relevant lake water chemistry questions, compose responses, and present their results in a poster format. They, in pairs, answer questions about lake chemistry which are imbedded in this plan.
Lesson Plan
Curated OER

My Community

For Teachers 1st
First graders design a Powerpoint presentation to reflect information about their community.  In this community lesson, 1st graders create slides to explain the weather, geography and other information about the city.
Lesson Plan
Curated OER

Weather Or Not

For Teachers 3rd - 5th
Students use the internet to find pen pals to share in their weather experiment. Individually, they research the high and low temperatures for cities within the United States and email the results to their pen pal. They also develop a...
Lesson Plan
Curated OER

Cell Size Changes

For Teachers 9th - 12th
High schoolers examine the behavior of living cells treated with different types of stimuli. They watch an online movie, examine wet mount slides under a microscope, take an online quiz, and analyze data.
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 plan, students conduct a water vapor experiment in a soda bottle. Students utilize graphs and charts to analyze the results of the experiment and...
Lesson Plan
Curated OER

Reaching the Solar System

For Teachers 3rd - 5th
Students sing the Rap of the Solar System, view pictures of the planets, and calculate their weights and ages on all the planets and the sun. They create a presentation comparing themselves with a planet or object in the solar system.
Lesson Plan
Curated OER

Phenomenal Weather-Related Statistics

For Teachers 8th
Eighth graders research, collect and interpret data about weather statistics. They record that data on spreadsheets. they create Powerpoint presentations on their individual or group research.
Lesson Plan
Curated OER

Slopes, Hopes, & Speed

For Teachers 4th - 6th
Students investigate the sport of skiing through Internet research in this multi-task lesson. They compare and generalize the results of five individuals by using mean, median, and mode.
Lesson Plan
Curated OER

Solving Polynomial Equations

For Teachers 9th - 12th
High schoolers demonstrate how to use spreadsheets as a tool for analyzing, visualizing and solving mathematical problems. Students obtain fundamental grasp of cubic equations and other polynomial equations.
Lesson Plan
Curated OER

Menu Math

For Teachers 5th - 6th
Students follow the food pyramid to create a daily food budget. They research food prices online or in newspapers. They graph the amount of each food group included in their menus. They can also create a weekly food menu based on a fixed...
Lesson Plan
Curated OER

Compare 2-D Shapes

For Teachers 2nd
Second graders examine the attributes of two-dimensional shapes. In this geometry lesson, 2nd graders play a game in order to identify two-dimensional shapes and to name them.
Lesson Plan
Curated OER

Compare 2-D Shapes

For Teachers 2nd
Second graders explore and analyze plane shapes. In this plane shapes lesson, 2nd graders evaluate shape attributes to classify shapes correctly. Students work in groups to create different shapes.
Lesson Plan
Curated OER

State Economy Chart

For Teachers 5th
Fifth graders create a 3D Pie graph using the Chart Wizard in Excel to represent their assigned states' data. They discuss the similarities and differences between states, and form a hypothesis on the relationship between location and...
Lesson Plan
Curated OER

You want me to do what with this Dirt?

For Teachers 8th
Eighth graders explore how to take soil samples and use GPS to determine the location of the site they have chosen to take the samples.
Lesson Plan
Curated OER

Wings and Othe Things

For Teachers 3rd - 6th
Students work in groups that are engaged in different activities at different times. They watch the video "Madagascar" and collect data pertaining to the Fish Eagle's arm spam. They work together to perform mathematical computations...
Lesson Plan
Curated OER

Asthma "Outbreak" Exercise

For Teachers 8th - 12th
Students investigate numerical data on a possible asthma epidemic. Using statistical information, students graph and figure ratios of the epidemic. They evaluate the mortality rate from severe smog in the 1950's in London.
Lesson Plan
Curated OER

Graphing Weights and Measures

For Teachers 4th - 6th
Learners practice gathering, averaging, and graphing data. They practice converting measurements to the metric system. Students graph their results and present them to the class.
Lesson Plan
Curated OER

Dream Vacation

For Teachers 9th - 12th
Students research cities, states, or countries using the internet and other resources to learn about a vacation spot. They make a final presentation of their findings in forms other than a written report.
Lesson Plan
Curated OER

Code Crackers

For Teachers 6th - 8th
Students work in teams creating and posing math rules and trying to guess them using a formula controlled worksheet they create with Excel. Student pairs take turns to see who can crack the other's code the fastest.
Lesson Plan
Alabama Learning Exchange

Alex: The Elephants Truncate Roots

For Teachers 6th - 8th Standards
Learners will learn the process of finding where the square root of 2 is on the number line by truncating the square of a number between 1 and 2. They will also work with other square roots to learn how to order them on the number line....
Lesson Plan
Google

Google for Education: Data Aggregation and Decomposition (Excel)

For Teachers 9th - 10th
By using Microsoft Excel, students collect, decompose, and re-aggregate class data. Students use computational thinking skills by decomposing long lists of information and writing basic algorithms to help analyze data.
Lesson Plan
Alabama Learning Exchange

Alex: Scale Drawings

For Teachers 9th - 10th
During this instructional activity students practice measuring and converting to scaled measurements. Students measure various places on campus, such as a classroom or the gym. They place their findings on a spreadsheet. After converting...