Curated OER
Using Excel to Draw a Best Fit Line
Students create line graphs for given data in Microsoft Excel. Students follow step by step instructions on how to create their graph, including how to create a trend line. Students print graphs without trend lines and manually draw...
Curated OER
Graphing
Learners gather statistical information on a chosen topic and place it into a spreadsheet. Using th Excel chart wizard, students create tables, graphs and charts of their information. They interpret the data and share it with the class.
Curated OER
Bias in Statistics
Students work to develop surveys and collect data. They display the data using circle graphs, histograms, box and whisker plots, and scatter plots. Students use multimedia tools to develop a visual presentation to display their data.
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
Young scholars 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 lesson, 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 coefficients and...
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...
It's About Time
Petroleum and Your Community
I was going to write a joke about oil, but it seemed crude. This lesson starts with a comparison of where the US gets oil from and how that has changed over time. After analyzing the data, scholars create a graph and use the Internet to...
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 vice-versa....
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...
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 lesson, 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 Excel. Then...
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
Learners 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.