Lesson Plan
Curated OER

Microsoft Excel Lesson Plan

For Teachers 5th
Fifth graders collect, organize, interpret data. In addition, they compare different textures, color including graphical representations such as bar graph, line graph .Students also describe the uses of rocks and how to use that to...
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

What's Playing Tonight?

For Teachers 5th - 9th
Students collect data and visually represent it. They conduct a survey of favorite movies. Using a spreadsheet, students organize the data and create bar and circle graphs. Students answer statistical questions regarding the data.
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
Alabama Learning Exchange

The State Capital of Stem and Leaf

For Teachers 5th - 10th Standards
Students explore the concept of stem and leaf plots.  In this stem and leaf plots lesson, students plot the 50 US states' capitals on a stem and leaf plot according to the first letter of each state.  Students compare...
Unit Plan
Curated OER

GSE Foundations of Algebra: Equations and Inequalities

For Students 7th - 9th
Need lessons on writing and solving one- and two-step linear equations and inequalities, as well as systems of equations? This comprehensive 106-page module from the Georgia Department of Education contains many different lessons for a...
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...
Lesson Plan
Curated OER

Book: Latinos Today: Facts and Figures

For Teachers 8th - 10th
Students, after reading Chapter 1 in the book, "Latinos Today: Facts and Figures," identify and characterize the four main ethnic/racial groups in America. They calculate and design a bar graph showing their populations by their...
Lesson Plan
Curated OER

Labeling the World

For Teachers 6th
Sixth graders conduct research on the countries found on the labels on their clothing. They locate the countries on a map, research the labor practices on countries that export clothing to the U.S., and create a graph using the information.
Interactive
Curated OER

Among the Hidden - Population Math Activity

For Students 6th - 10th
In this population worksheet, students collect data on population by researching the Census Bureau and then make online graphs and answer short answer questions about the data. Students complete 5 problems total.
Lesson Plan
Curated OER

Meats Make Muscles

For Teachers 2nd
Second graders explore the meat group of the food pyramid. In this nutrition and diet lesson, 2nd graders study the benefits of eating foods in the meat group, collect data regarding their classmates' favorite foods, and create a graph...
Lesson Plan
Curated OER

5th Grade Health Newsletter

For Teachers 5th
Fifth graders choose health related topics of interest to them, research the topics employing a variety of resources, and then produce a newsletter using the technology available to them. The topics selected are also part of the 5th...
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

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

The Write Stuff

For Teachers 4th
Fourth graders share a previously written portfolio piece and the class guesses the genre. Students use tally marks to keep track of how many of each piece there are in class. Once the data collection is complete, 4th graders create a...
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

The Election Connection

For Teachers 3rd - 5th
Students participate in a mock election. In this election lesson plan, students vote online in a mock election, graph the results, and compare their results to the nationwide results.
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

Eerie Indiana!

For Teachers 11th
Eleventh graders research the population for ten cities in their state, in this example, Indiana, using census information. They design a spreadsheet using the data and create a bar graph with the data. They complete follow up questions.
Lesson Plan
Curated OER

The Great Chile Challenge

For Teachers 5th
Fifth graders gather data, create a graph, and interpret information. They build vocabulary by negotiating the ideas that go into the graphs which they create. They use Excel to print a variety of graphs based on how much they like Chile...