Lesson Plan
Curated OER

Rouge River Data

For Teachers 3rd - 5th
Young scholars participate in using Excel sofware in order to create graphs. They create the graphs using data that they gathered during the Rouge River Field Trip they attended. The produce bar graphs from the excel spreadsheets.
Lesson Plan
Curated OER

Candy is Dandy

For Teachers 6th - 9th
Students investigate color distribution in bags of M&Ms They sort and classify the contents of a bag of M&Ms and summarize their findings on a worksheet. Students convert the numbers into charts and make predictions about color...
Lesson Plan
Curated OER

Toy Dissection Graph

For Teachers 3rd - 6th
Students explore simple machines and how they are made. They examine the parts of the simple machine and collect information about its parts. Using Excel, students create circle and bar graphs from the collected data.
Lesson Plan
Curated OER

Quarter, Nickel, Dime....

For Teachers 4th - 6th
An engaging game called, "Quarter, Nickel, and Dime" is presented in this math lesson. Players are given an envelope with slips of paper that represent the three coins. In pairs, they play the game 18 times, and the whole class charts...
Lesson Plan
Curated OER

WebQuest: Thrills and Spills- Pick Your Park!

For Teachers 4th - 6th
Students participate in a WebQuest in which they must determine which amusement park is the "median priced" park. Students visit park websites to accumulate prices for parking, activities, restaurants, and gift shops.
Lesson Plan
Curated OER

Spreadsheet Graphs

For Teachers Higher Ed
Students create graphs using information from spreadsheets. They select a topic from the following choices: website use, digital cameras, spreadsheets, calculators or educational software. They tally the class results and create an...
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

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...
Worksheet
K12 Reader

Displaying Data

For Students 2nd - 3rd Standards
It's important to learn how to display data to make the information easier for people to understand. A reading activity prompts kids to use context clues to answer five comprehension questions after reading several paragraphs about...
Lesson Plan
Curated OER

Finding Caterpillars

For Teachers 4th - 6th
Students examine how animals protect themselves from predators and camouflage themselves. They participate in a simulation in which they locate red and green yarn "caterpillars," organize their data, and generate a bar graph using...
Lesson Plan
Curated OER

How Do You Get to School?

For Teachers 3rd
Third graders talk about all the various ways they get to school. They make a list of all the bus numbers that the students use. They also list all the other methods of transportation used and solidify a hypothesis.
Lesson Plan
Curated OER

Dental Detectives

For Teachers 1st
First graders explore the theme of dental health and hygeine. They make tooth loss predictions, count lost teeth, and graph tooth loss. In addition, they listen to dental health stories, read online stories, create spreadsheets, and play...
Lesson Plan
Curated OER

Polar Bears in Peril - Climate Change Culprit?

For Teachers 9th - 12th
High schoolers explore the changes in sea ice over several years. In this life science instructional activity, students review and examine 20 years of data. They use Excel to graph data and analyze trends.
Lesson Plan
Curated OER

Delicious Graphing

For Teachers 4th
Fourth graders sort trail mix by type and use that information to create different types of graphs for comparing.
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

Seasons and Cloud Cover, Are They Related?

For Teachers 6th - 12th
Students use NASA satellite data to see cloud cover over Africa.  In this seasons lesson students access data and import it into Excel. 
Lesson Plan
Curated OER

Weather, Weather, Everywhere!

For Teachers 6th
Sixth graders collect weather data to compare temperatures around the world. Using the Internet, learners collect data, put it into spreadsheets, and analyze and graph the results. An interesting way to cover the topic of weather.
Lesson Plan
Curated OER

Predicting Temperature: An Internet/Excel Learning Experience

For Teachers 3rd
Third graders use the Internet (www.weather.com) to find the high temperature for our locale and the high temperature for another city around the world. They keep track of the temperature in these two locations for 10 days.
Lesson Plan
Curated OER

The Great Turkey Walk

For Teachers 4th - 6th
Young scholars formulate questions that can be addressed with data and collect, organize, and display relevant data to answer them. They wcreate bar graphs and pie graphs
Lesson Plan
Curated OER

Technobiz

For Teachers 8th - 12th
Students examine candy preferences to create a plan in order to improve candy sales. In this technobiz lesson, students build spreadsheet and organizational skills by graphing and calculating data. Students are introduced to terminology...
Lesson Plan
Curated OER

HEART THROBS

For Teachers 6th - 8th
Students predict what might happen to their pulse rates after physical exertion and then make conclusions about the effects of physical activity on pulse rates.
Lesson Plan
PHET

Soda Bottle Magnetometer

For Teachers 6th - 8th Standards
Introduce learners to set of complete instructions that describe how to build a magnetometer that works just like the ones professional photographers use to predict auroras. The diagrams are wonderfully descriptive, and the written...
Lesson Plan
Curated OER

Back-To-School Shopping

For Teachers 5th
Fifth graders estimate the prices of items to be bought for back to school. They use catalogs and/or advertisements to research the cost of each of the items. They use problem solving strategies and a spreadsheet template to determine...
Lesson Plan
Curated OER

What Do Plants Need to Grow?

For Teachers 4th
Fourth graders control variables to determine the effect on plant growth. They collect information by observing and measuring and construct simple graphs, tables, maps and charts to organize, examine and evaluate information.