Curated OER
Virtual Field Trip
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...
Curated OER
Creation and Interpretation of Voter Participation Graph
Ninth graders research information about voter participation in the United States based on age. They develop generalizations about voting patterns in the U.S and use Microsoft Excel to analyze the information.
Curated OER
Using My Nasa Data To Determine Volcanic Activity
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...
Curated OER
The Racing Heart
Fifth graders locate their own pulse rate from their carotid or radial artery, and graph their pulse rates after completing various exercise activities. They graph their data on a pie graph using Microsoft Excel software.
Curated OER
Virtual Field Trip / Route, Mileage and Gasoline Cost Graphs
Pupils 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.
Curated OER
Graphing and Analysis of Water Quality Reports
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.
Curated OER
Delicious Graphing
Fourth graders sort trail mix by type and use that information to create different types of graphs for comparing.
Curated OER
Seasons and Cloud Cover, Are They Related?
Students use NASA satellite data to see cloud cover over Africa. In this seasons lesson students access data and import it into Excel.
Curated OER
Virtual Field Trip
This hands-on resource has future trip planners analyze graphs of mileage, gasoline costs, and travel time on different routes. While this was originally designed for a problem-solving exercise using a Michigan map, it could be used as a...
Curated OER
Learning About Graphics
Students practice using and filling in a spreadsheet. They also create graphs and charts that coorespond with the data. This is a unit comprised of four lesson plans.
Curated OER
Scientific Method and Graphing
Seventh graders use the scientific method to determine how many seeds are in a watermelon.
Radford University
Sleep and Teen Obesity: Is there a Correlation?
Does the number of calories you eat affect the total time you sleep? Young mathematicians tackle this question by collecting their own data and making comparisons between others in the class through building scatter plots and regression...
Curated OER
History of the Star Spangled Banner
We have all heard the "Star Spangled Banner" at many points in our lives, but how often do we take the time to truly understand what the words of the national anthem mean to Americans? Don't miss this opportunity to examine the lyrics...
Curated OER
What Color Are Your Skittles?
Students create spreadsheets and manipulate data. They collect data, create appropriate graphs and use percentages to describe quantities. Students compare and contrast data. They use spreadsheets to generate a pie chart.
Curated OER
Coin Count & Classification
Students make a prediction about how 100 pennies sort by decade or year and then test their predictions. They organize their data using a graph that is imbedded in this lesson.
Curated OER
Deer: Predation or Starvation
In this balance of nature instructional activity, students use a data chart to graph wolf and deer populations over a ten-year period. Students use this graph to complete 3 short answer questions.
Curated OER
Pumped Up Gas Prices
Students calculate gas prices. In this transportation lesson, students tally the mileage and gas costs of their car for one months. They figure out how much was spent on gas and create a graph showing average gas prices over time.
Curated OER
Don't Settle for a Byte... Get the Megabyte on Technology
Students use word processing, presentation, and spreadsheet software. In this multi-day computer software usage lesson, students complete a research project that requires the use of a word processor, Excel, FrontPage, and PowerPoint to...
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 lesson plan, students use the information they gathered on Mount St. Helens to answer questions and create charts in Excel. Then students...
Curated OER
Mapping West Virginia
Fourth graders explore West Virginia. In this Unites States geography lesson, 4th graders discuss the type of land and the cities in West Virginia. Students create two overlays, with transparencies, that show the natural land and the...
Curated OER
Introduction to Scatter Plots and Correlation
Students examine the concept of scatter plots. They compare baseball statistics to locate the ones that correlate with winning, and identify the positive, negative, and no correlation in sets of data using MS Excel.
Curated OER
Maryland’s Chesapeake Bay Landscape Long Ago and Today
Combine a fantastic review of primary source analysis with a study of Captain John Smith's influence on the Chesapeake Bay region in the seventeenth century. Your young historians will use images, a primary source excerpt, and maps...
Curated OER
Integration and the "Barrier Breakers": Black Baseball 1945-1960
High schoolers explore integration of Major League Baseball, identify important individual baseball players who played key roles in integration, and analyze historical information through charts, graphs, and statistics.
Curated OER
Positive Future Fair Project
Ninth graders view the film "Pay It Forward" and discuss what kind of public campaign is needed to move people to positive action. They consider different ways of presenting information (graphs, visual displays, etc.) as tools for...