Curated OER
How Big Is Your Head?
Students explore measurement by measuring classmates' heads. They record their measurements and they put the measurements in order from smallest to largest. Students figure the mean, median, mode, maximum, minimum, and range of their...
Curated OER
Student Costs Data Table
Students compare and contrast two routes selected for a virtual field trip. They create a data table of educational activities, lodging, and meal costs using Microsoft Excel software.
Curated OER
Rockin' Data
Fifth graders are given the questions, "What type of music would you suggest the manager place in front of the store?". Students collect data by talking with 20 adults and create a bar graph on the computer to present the data.
Curated OER
Shoe Showdown
Third graders use rulers to measure their shoe size in inches and centimeters. They then enter the class shoe measurements into an excel data base and graph the results of both to make the comparison.
Curated OER
Generate Measurement Data Word Problems
Bar and line graphs are an excellent way to visually analyze data: give your scholars practice both analyzing graphs and creating their own! First, they examine five basic bar graphs, indicating the number of squares on specific days....
Curated OER
Precipitation in Michigan Cities
Third graders investigate the rainfall amounts in four Michigan cities to observe how cities near lakes are affected differently by precipitation than those that are inland. They record the rainfall for the cities over an eight day...
Curated OER
What Can I Afford?
Students explore the concept of cell phone plans. In this cell phone plan instructional activity, students research the cost of cell phones. Students compare various cell phone plans and decide on which phone plan is best for them.
Teach Engineering
The Energy Problem
Think you can solve the energy problem? You'll first need to know about current energy use. Analyzing a set of circle graphs lets scholars see where energy consumption is the greatest, both by sector and by household use. They develop a...
PBL Pathways
Medical Insurance
Design a plan for finding the best health insurance for your money. Learners compare two health plans by writing and graphing piecewise functions representing the plan rules. Using Excel software, they create a technical report...
West Contra Costa Unified School District
Correlation and Line of Best Fit
Computers are useful for more than just surfing the Internet. Pupils first investigate scatter plots and estimate correlation coefficients. Next, they use Microsoft Excel to create scatter plots and determine correlation...
Polar Trec
Playground Profiling—Topographic Profile Mapping
The Kuril islands stretch from Japan to Russia, and the ongoing dispute about their jurisdiction prevents many scientific research studies. Scholars learn to create a topographic profile of a specific area around their schools. Then they...
Mathematics Vision Project
Circles: A Geometric Perspective
Circles are the foundation of many geometric concepts and extensions - a point that is thoroughly driven home in this extensive unit. Fundamental properties of circles are investigated (including sector area, angle measure, and...
Technical Sketching
Introduction — Surfaces and Edges
How different can 3-D and 2-D really be? An engineering resource provides an explanation about the importance of two-dimensional technical drawings. Several samples show how to create multi-view drawings from pictorials and...
Curated OER
Graphing Galore!
Students practice sorting and counting different objects. Using this information, they create graphs on a worksheet given to them. They describe and analyze the results and discuss them as a class to end the lesson. They also complete...
Curated OER
Line Graphs
Seventh graders create a line graph and identify when to use line graphs. In this line graphs instructional activity, 7th graders analyze the average temperatures of various cities. Students graph the data they collected.
Curated OER
Shake, Rattle, and Roll: Mt. St. Helens - Lesson Plan 2
Students compile information on volcanic activity at Mount St. Helens. In this earth science instructional activity, students use the information they gathered on Mount St. Helens to answer questions and create charts in...
Curated OER
Graphing on the Computer
Students create a bar graph on the computer using given information from the teacher. They create a bar graph using their own information chart (they need to create one on separate paper first). They utilize Microsoft Excel for this...
Curated OER
Creating Circle Graphs with Microsoft Excel
Seventh graders will learn how to construct circle graphs using paper and pencil. Then they will learn how to construct circle graphs using Microsoft Excel. This lesson uses technology and shows learners how to cross skills into the...
Curated OER
Graphing Pendulum Results
Sixth graders set up a pendulum experiment deciding which variable to manipulate (length of string or weight on the string). They create a hypothesis, collect necessary equipment, and write out each step of their experiment. They then...
Curated OER
Graphing Iron Data
Students apply a data set to create a graph show how iron ore impacts an ecosystem. They explain how the iron effects the distribution and abundance of phytoplankton in coastal ecosystems using spreadsheet software.
Curated OER
Excel Lesson Plan Coin Statistics
Second graders determine the difference between making a prediction and determining actual information. They design a spreadsheet for a coin flipping activity on which they include their predictions and what actual happens when they flip...
Curated OER
Graphing Your Favorite Pizza Topping
Fifth graders can survey the students just in their classroom, the grade level, or other grade levels. Upon finishing the surveys and compiling the data, the students can input their results in an Excel template or create their own...
Curated OER
Graphing
Fifth graders create graphs based on climate in South Carolina. They read and interpret information in a chart and construct a graphy from the information in the chart. They create a spreadsheet using Excel and publish 2 graphs.
PLS 3rd Learning
Interpreting Heart Rates During Various Physical Activities
Learners review terminology: pulse, heart rate, target heart rate zone. They work in three groups, and assigned to one of three activity stations. At 5-minute intervals, 4th graders check their pulse and record it on their group...