Curated OER
Student News And Weather Channel
Fabulous! Your 5th graders should love this project. As an ongoing lesson throughout the year students use temperature probes to record outside temperature and then document their data using spreadsheets. They use their weather data and...
Code.org
Making Data Visualizations
Relax ... now visualize the data. Introduce pupils to creating charts from a single data set. Using chart tools included in spreadsheet programs class members create data visualizations that display data. The activity encourages...
Curated OER
Basic Excel
Students explore basic Excel spreadsheets. In this spreadsheet lesson plan, students enter Alaska weather information and perform calculations. Students title the columns on the spreadsheet and format the cells. Students complete...
Curated OER
Escape Velocity
Sixth graders create/use spreadsheets to solve real-world problems, explore patterns, make predictions, select/explain most appropriate types of graph to display data, use information to create product, and have basic understanding of...
Curated OER
The Viewing Tube
Looking for an excellent instructional activity that incorporates math, science, and technology? Groups of three students use a viewing tube to perform an experiment, and discover how to organize their data into an Excel spreadsheet. ...
Council for Economic Education
Loan Amortization - Mortgage
When you buy a home for $100,000, you pay $100,000—right? On the list of important things for individuals to understand, the lesson plan presents the concept of interest rates and loan amortization using spreadsheets and online sources....
Curated OER
Temperature High and Lows
Young scholars gather high and low temperature readings through email. In this temperature graphing lesson, students use a spreadsheet to input data for a graph. young scholars interpret the graphs to compare and contrast the data from...
Curated OER
Baseball Relationships - Using Scatter Plots
Students use graphing calculators to create scatter plots of given baseball data. They also determine percentages and ratios, slope, y-intercepts, etc. all using baseball data and statistics.
Curated OER
Using a Spreadsheet to Understand Density
Students use density to identify what metal a gold colored weight is made of. They use a spreadsheet to graph the experimental density of common metals and compare the know densities to their calculated density of the known metal.
Curated OER
Basic Algebra and Computers: Spreadsheets, Charts, and Simple Line Graphs
Students, while in the computer lab, assess how to use Microsoft Excel as a "graphing calculator." They view visual representations of line graphs in a Cartesian plane while incorporating basic skills for using Excel productively.
EngageNY
Credit Cards
Teach adolescents to use credit responsibly. The 32nd installment of a 35-part module covers how to calculate credit card payments using a geometric series. It teaches terminology and concepts necessary to understand credit card debt.
Curated OER
Creating Climographs
Students use satellite data to compare precipitation and surface temperatures on different islands. For this satellite lesson students create graphs and explain the differences between weather and climate.
Curated OER
The Fabled Maine Winter
Students graph and analyze scientific data. In this research lesson students use the Internet to obtain data then draw conclusions about what they found.
Curated OER
A Comparison Study of Water Vapor Data to Precipitation over North America
Students use NASA satellite data to compare water vapor over the United States. In this data analysis lesson students use an Excel spreadsheet to map their data.
Curated OER
How Much Is It?
Students explore foreign currencies. In this foreign currencies lesson, students simulate travel to another country and determine the value of the US dollar compared to other countries. Students use a conversion table and search Internet...
Curated OER
Million Dollar House
Fourth graders use a combination of calculators and spread sheet software to furnish their own million dollar horse without going over the specified amount of a million. The goal being to create a house that came to the exact amount of...
Curated OER
First Class First? Using Data to Explore the Tragedy of the Titanic
Learners analyze and interpret data related to the crew and passengers of the Titanic. They research information on a Titanic database to illustrate specific statistical conclusions, and whether or not social status affected the outcome.
Curated OER
Using Excel, the Internet, And Word To Create a Spreadsheet, Chart, And Instructions
Learners improve data entry in a spreadsheet.
Curated OER
Fast Food Survey Using Bar Graphs
Second graders create a bar graph to pictorically represent the data collected from a survey of students. They use Excel to electronically create the graphs and data tallies. They then interpret their data using sentences to explain.
Curated OER
Using Excel to Reference and Graph Live Data from a Web Site
Students collect live buoy data about water temperatures in the Gulf of Mexico from the Internet and work individually to organize their data and create a line graph using Excel Spreadsheet. Students analyze their data and examine any...
Curated OER
Interpreting Data and Statistics using Graphs
Seventh graders interpret data. In this lesson on types of graphs, 7th graders construct, interpret, and analyze different graphs. This lesson includes worksheets and resources.
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
Money Math: Lessons for Life
Students develop a budget for a college student using all of the influences that the student would have. In this budgeting lesson plan, students use real life examples to create a budget spreadsheet. Students read and study sample...
Curated OER
The Solar Cycle
Learners research the solar cycle. In this Science lesson, students use the internet to investigate the solar cycle. Learners produce a spreadsheet and graph from the information collected.