Lesson Plan
Curated OER

Personal Budgeting Project

For Teachers 8th - 11th
Young scholars create an Excel spreadsheet of a personal budget by estimating their possible income and monthly expenses from a worksheet. They group together to create a family unit and use the personal budget sheets to plan a family...
Lesson Plan
Curated OER

Learning About Graphics

For Teachers 4th - 6th
Students practice using and filling in a spreadsheet. They also create graphs and charts that coorespond with the data. This is a unit comprised of four lesson plans.
Lesson Plan
Curated OER

Canadian Cities

For Teachers 5th
Fifth graders gather population data on twelve cities in Canada. They present the information on a spreadsheet and sort the data on two different types of graphs. They create a generalization for the data that they collected.
Lesson Plan
Curated OER

How Many M&M's

For Teachers 4th - 6th
Students explore sets and collections. Students find the colors of M&M's and the amount of M&M's each student has. They organize this information into an Excel spreadsheet. Students use the chart wizard to create a graph.
Lesson Plan
Curated OER

Statistics and Graphing with Accelerated Math

For Teachers 3rd - 7th
Students create charts and graphs, using a spreadsheet program, of their results from their accelerated math lessons. Students discover how graphs can be used to interpret data in our everyday lives as well as how several different...
Lesson Plan
Curated OER

Demographic Changes in 19th Century England and Wales

For Teachers 7th - 12th
Students examine population in England and Wales during the period of 1801-1911. They calculate the percentage of population and how it changed from one census to the next in various towns. They record data on a spreadsheet and create...
Lesson Plan
Curated OER

Job Distribution After 1945

For Teachers 7th - 10th
Students research job distribution in the U.S. after 1945. They study a spreadsheet of employment data and identify changes in the distribution of jobs in America since World War II. They create pie charts reflecting the data of jobs...
Lesson Plan
Curated OER

World Education Statistics

For Teachers 9th - 12th
Students use a spreadsheet from The Digest of Education Statistics and convert the statistics to percentages, and create a chart of their new data. Students discuss their findings about the disparities in educational spending among...
Lesson Plan
Curated OER

Pedestrian Safety for Students Lesson 4: A Walkable Survey

For Teachers 4th - 5th
Students create a survey. In this survey lesson, students use www.walktoschool.org to help them come up with questions to ask other students. They put the information in spreadsheet format. 
Lesson Plan
Curated OER

Light and Elements

For Teachers 9th - Higher Ed
Here is a full-fledged investigation of light waves, the electromagnetic spectrum, and element spectra. Physicists research a scientist that contributed to our understanding of the behavior of light. They take notes on your lecture, and...
Lesson Plan
Curated OER

The Election Connection

For Teachers 3rd - 5th
Learners participate in a mock election. In this election activity, students vote online in a mock election, graph the results, and compare their results to the nationwide results.
Lesson Plan
Curated OER

Where the Buffalo Roam

For Teachers 7th - Higher Ed
Students lear about energy, energy efficiency and consumption. They measure energy use, graph the date, write a letter then design and present a PowerPoint on the topic.
Interactive
Curated OER

Elbow Room - Exploring Population Density

For Students 6th - 12th
In this population worksheet, students click on the links and research the internet about population, land, and government. Students answer 16 short answer questions including making spreadsheets.
Lesson Plan
Curated OER

Amphibian Spawns

For Teachers K
Students observe tadpoles as they gradually change into adults.  In this amphibian biology lesson, students watch tadpoles in a tank in the classroom, keep a daily record of what they observe, and chart the growth development of the...
Lesson Plan
Curated OER

Identification of Different Compounds and Substances

For Teachers 9th - 12th
Students conduct a series of tests to identify unknown compounds. For this chemistry lesson, students compare the physical and chemical properties of substances. They collect data and formulate a conclusion.
Lesson Plan
Curated OER

States Of Matter

For Teachers 4th
Delv into the states of Matter. Students engage in the scientific inquiry process to uncover the exciting world of Matter. They watch a series of videos, and conduct experiments in order to collect and analyze data on the various state...
Lesson Plan
Curated OER

Yellow Pages Ad-dition

For Teachers 3rd - 12th
Learners determine the revenue generated by sample pages from the Yellow Pages. They discuss the value of advertising a business in this venue. They use the local telephone directory and some fictitious ad rates to lead their inquiry.
Unit Plan
University of Missouri

Money Math

For Teachers 5th - 8th Standards
Young mathematicians put their skills to the test in the real world during this four-lesson consumer math unit. Whether they are learning how compound interest can make them millionaires, calculating the cost of remodeling...
Lesson Plan
Alabama Learning Exchange

Bloodstain Pattern Doesn't Lie......

For Teachers 9th - Higher Ed Standards
An interesting instructional activity on hypothesizing about the diameter of a drop of blood that is splattered. To test their theories, learners work in groups to make blood droplets splatter from different heights. They use graphed...
Activity
Curated OER

Sunrise, Sunset

For Teachers 10th - 12th Standards
What locations on Earth get the longest number of hours of daylight in the summer? Hint: It's not the equator! Use real-world sunrise and sunset data to develop trigonometric models that can be used to estimate the number of hours of...
Lesson Plan
EngageNY

Federal Income Tax

For Students 9th - 10th Standards
Introduce your class to the federal tax system through an algebraic lens. This resource asks pupils to examine the variable structure of the tax system based on income. Young accountants use equations, expressions, and inequalities to...
Activity
Teach Engineering

Energy Perspectives

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

Measuring Speed With iMovie

For Teachers 6th - 12th
Students record each other running, walking, throwing a ball, or doing a similar activity for a set distance. They import the video clips into iMovie. They compute how long it took in miles per hour.
Lesson Plan
Curated OER

How Many?

For Teachers 6th - 8th
Middle schoolers explore and design ways to collect data through simulations and random samples. They perform two experiments to determine the answers to various probability problems, and present the data/graphs in the form of a...

Other popular searches