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.
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...
Lesson Plan
Curated OER

What's your favorite physical fitness activity?

For Teachers 4th
Fourth graders engage in a class discussion where they create a list of their favorite physical fitness activities. They tally the numbers on the board and use Microsoft Excel to create a spreadsheet and graph of the activities.
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

The Nifty Fifty-What's Your Size?

For Teachers 3rd - 5th
Students explore state populations. In this state geography activity, students use a variety of technology tools to research and graph population and area of assigned states.
Lesson Plan
Curated OER

The Election Connection

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

Shared Birthdays

For Teachers 6th - 8th
Students gather information on their classmates birthdays and create a spreadsheet with the dates. Using the internet, they find a famous person who shares their own birthday. They research the life of the famous person and develop a...
Lesson Plan
Center Science Education

Weather and Climate Data Exploration

For Teachers 6th - 12th Standards
Access local temperature data online, graph averages, and critique it. Learners listen to a scenario where weather and climate are confused, and then answer questions to differentiate the two. The lesson itself is compact, but there is a...