Lesson Plan
Curated OER

Nutrition and the Media: Cereal Box Consumerism

For Teachers 2nd - 5th
How many treats do you buy each week? Learners investigate diets and how the media tricks consumers into purchasing unhealthy snacks. They will investigate the designs and logos affiliated with cereal boxes and identify specific phrases...
Lesson Plan
Curated OER

World of Work

For Teachers 12th
Twelfth graders research want ads on the Internet or in the newspaper. They calculate the estimated weekly, monthly, and yearly pay for an hourly, salary and commission positions. They calculate a paycheck including state tax, federal...
Lesson Plan
Curated OER

I Can Build It.....Yes I Can!

For Teachers K
Kindergartners listen to a story read by their teacher, then use magnetic shape pieces to construct simple designes. They "build" their own house using pre-cut paper shapes. This age-appropriate lesson would be an excellent choice for...
Lesson Plan
Curated OER

Thinking Outside the Box

For Teachers 9th - 12th
Now this lesson sounds fun! Students throw a ball, film it as it soars through the air, and use a spreadsheet to collect data. A scatterplot is created to produce a quadratic regression equation, an equation in vertex form, and an...
Lesson Plan
Curated OER

Our Favorite Season Lesson Plan

For Teachers 5th
Fifth graders complete a survey about their favorite season of the year. Using Excel, they create a graph using the chart wizard and copy it into Microsoft Word. They explore the relationship between the survey and the bar graph.
Lesson Plan
Curated OER

Graphing Speed

For Teachers 9th - 12th
Students use LOGAL motion detector probe and observe a generated graph as a student performs various standard motions, and make measurements of time and distance. They suggest various time and distance measurements which a student can...
Lesson Plan
Curated OER

Graphing and Analysis of Water Quality Reports

For Teachers 9th - 11th
Students practice making graphs and interpreting them. They compare and contrast different sets of data. They use Microsoft Excel to create different types of graphs.
Lesson Plan
Curated OER

Your Just Desserts

For Teachers 6th - 8th
Middle schoolers write letters to town officials and local businesses asking for favorite dessert recipes. They tabulate their responses in a spreadsheet. Students turn their survey results into colorful graphs.
Lesson Plan
Curated OER

Topic 6: Evaluating and Presenting Results

For Teachers 8th - 9th
Students construct spreadsheets from raw data. In this spreadsheet construction instructional activity, students compile data into Microsoft Excel. Students familiarize themselves with entering and presenting data in a spreadsheet.
Lesson Plan
Curated OER

Skyscraper Capers

For Teachers 5th - 8th
Pupils discuss skyscrapers and listen as the teacher introduces the project. They use the Internet to perform research on one skyscraper. Students use information they gather to create a brochure of their building . They create an Excel...
Lesson Plan
Curated OER

Virtual Field Trip

For Teachers 4th - 6th
Students calculate gasoline cost per mile on a virtual field trip. They calculate the gasoline costs and travel time for each of the 2 routes, and record on a data sheet. They use Excel to create data tables for mileage, gasoline...
Lesson Plan
Curated OER

Using My Nasa Data To Determine Volcanic Activity

For Teachers 8th - 12th
Students use NASA satellite data of optical depth as a tool to determine volcanic activity on Reunion Island during 2000-2001. They access the data and utilize Excel to create a graph that has optical depth as a function of time for the...
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

Pedestrian Safety for Students

For Teachers 3rd - 4th
Students create a spreadsheet. In this spreadsheet lesson, students take the responses they received from a pedestrian safety survey to create their spreadsheet. Then they turn this information into a graph.
Worksheet
Curated OER

Math Vocabulary Words

For Students 4th - 5th
In this math vocabulary learning exercise, students read 14 math vocabulary words relating to statistics and graphs.  This would be an excellent tool for teachers to create a math vocabulary word wall.  Teachers could use these...
Lesson Plan
Curated OER

Penny Pushing

For Teachers 5th
Fifth graders use an Excel spreadsheet to show them how to enter the amount of pennies they bring each week to school for a fundraising project. They count their pennies each Friday and enter the total amount in the correct columns. In...
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

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

Trends in Precipitation

For Teachers 8th
Eighth graders study about precipitation and graph the information. They look for patterns in a scatter graph and make inferences based on what they see. They need to see a relationship between location and the amount of precipitation.
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

Virtual Field Trip / Route, Mileage and Gasoline Cost Graphs

For Teachers 4th - 6th
Students use a spreadsheet program to graph and compare milage, gasoline costs and travel time for two travel routes in their virtual field trip in Michigan. They determine the most economical route based on the graphs and calculations.
Lesson Plan
Curated OER

A FOREST'S PLACE IN OREGON

For Teachers 3rd - 4th
Students engage in a activity to find the purpose for the forests of Oregon. The role of the forest is researched according to different geographic perspectives. The information is portrayed in graphs and presented by group members 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

Halloween Graphitti

For Teachers 5th - 7th
Students complete multi-curricular activities in a Halloween themed instructional activity. In this Halloween instructional activity, students examine newspaper ads to find prices of pumpkins and use them to complete a stem and leaf...