Curated OER
Your Just Desserts
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.
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
Graphing and Analysis of Water Quality Reports
Learners 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
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
Graphing and Demography: The Domestic Slave Trade
High schoolers create graphs or charts based on the data a narrative imbedded in this plan. They make them either by hand or by using Excel or a similar database program. This lesson plan utilizes technology in a meaningful way.
Curated OER
Virtual Field Trip / Route, Mileage and Gasoline Cost Graphs
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.
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.
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
Seasons and Cloud Cover, Are They Related?
Students use NASA satellite data to see cloud cover over Africa. In this seasons instructional activity 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
Stock It To Me
Students investigate the stock market using stock market tables, charts, and graphs. They participate in a simulation of stock market investment over time. They read about the history of Wall Street and the Stock Market.
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
Scientific Method and Graphing
Seventh graders use the scientific method to determine how many seeds are in a watermelon.
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
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
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
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
Pumped Up Gas Prices
Students calculate gas prices. In this transportation lesson plan, 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
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
Mapping West Virginia
Fourth graders explore West Virginia. For 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
Making a Spreadsheet
Learners explore spreadsheet software. In this personal finance and computer technology instructional activity, students develop a vacation spreadsheet on the computer. Learners represent hotel, food, transportation, and entertainment...