Howard Hughes Medical Institute
Spreadsheet Tutorial 1: Formulae, Functions, and Averages
Spread your knowledge of spreadsheets. The first of five tutorials in the Spreadsheet Data Analysis unit introduces the basics of spreadsheets. It shows future data analysts how to organize and format tables, and how to use functions to...
Earth Watch Institute
Entering Local Groundhog Data in an Excel Spreadsheet
Here is a cross-curricular ecology and technology lesson; your learners create spreadsheets depicting the location and number of groundhog dens in a local park. They research groundhogs and analyze data about where the groundhog...
Curated OER
Creating a Spreadsheet and Graph
Young scholars create graphs in Excel. In this spreadsheet lesson, students input data into spreadsheet cells then use the graphing feature of the Excel program to produce colorful graphs of the data. The directions to create...
American Institutes for Research
Digital Smiles
Explore metric measurement, recording data, and creating an electronic spreadsheet displaying results with your math class. Scholars will measure the length of their smiles, record the measurements, and represent the results on an...
Curated OER
Cross Cultural Transportation and Resources Exchange
Students examine various modes of transportation. They explore regional transportation options and discover options available in their area. Students survey types of transportation people use in their area. Using spreadsheet data,...
Curated OER
Using Electronic Manipulatives in Multiplication
Factor polynomials using electronic manipulatives. Your class will create a spreadsheet in excel and use it to multiply and perform basic operations and solve problems correctly. They create a visual to go along with each multiplication...
Curated OER
Tasty Tech Activity With Excel
Students are introduce to basic Excel skills, rank their opinions of menu items from fast food restaurants, add their answers to the spreadsheet, and then create a simple graph of the results.
Bowland
Speed Cameras
Do speed cameras help reduce accidents? Scholars investigate this question using a series of spreadsheet activities. Along the way, they learn about randomness, probability, and statistical analysis.
Curated OER
Technobiz
Students examine candy preferences to create a plan in order to improve candy sales. In this technobiz activity, students build spreadsheet and organizational skills by graphing and calculating data. Students are introduced to...
Curated OER
Virtual Field Trip
Are we there yet? Young trip planners learn about their state and plan a trip. They will select sites to see in three cities in their state, and record associated costs in a spreadsheet. While this was originally designed as a...
Curated OER
Monitoring Math with a Statistical Spreadsheet
Learners use a spreadsheet to compute landmark statistics of a math
quiz. This lesson can be ongoing throughout the school year and it integrates mathematics curriculum and technology in a simple format for student use.
Curated OER
Creating a Bar Graph Using a Spreadsheet: Dice Rolling Probabilities
Tenth graders explore the concept of spreadsheets. They create a simple spreadsheet and chart from given data. Students perform basic formatting procedures on their chart. They use spreadsheet functions to perform calculations.
Curated OER
Using a spreadsheet and the Internet to learn about stock market performance
High schoolers record the progress weekly of a business of their choice on the stock market, graph those results, research and report on current news and how it pertains to the companies recent performance.
University of Missouri
Money Math
Young mathematicians put their skills to the test in the real world during this four-lesson consumer math unit. Whether they are learning how compound interest can make them millionaires, calculating the cost of remodeling...
Curated OER
Loan Amortization - Mortgage
Upper graders explore the connection between interest and principal. They use an amortization schedule to determine the amount of principal paid vs interest on a $100,000 home loan. Fourteen discussion questions and a research-based...
Curated OER
Chances Are......You're Right
Young mathematicians study probability. In this math lesson, learners calculate odds, and convert those into percentages of probability. Fractions are also used, making this lesson quite rich in some of the more difficult conversions...
Curated OER
Made Round To Go Round
In this lesson students investigate what it would cost to furnish one room of their choice by shopping on the Internet. Both Australian and American dollars are to be given for each item to demonstrate the difference between two...
Curated OER
Math: Football Fever Fun
Students compile statistics from high school or other football team and construct a spreadsheet on which to record their findings. Using Chart Wizard to analyze the data, they construct charts and graphs for a visual display of the...
Curated OER
Three Squirrels and a Pile of Nuts
Students solve story problems using a spreadsheet in combination with various problem-solving strategies. Working in teams of three, students create attempt to solve a story problem using three different methods; using manipulative,...
Curated OER
Simple Bar Graphs Using Excel
Students create original survey questions, and develop a bar graph of the data on paper. They input the survey data using two variables onto an Excel bar graph spreadsheet.
Curated OER
Integers in the Weather
Middle schoolers engage in a clever lesson that combines meteorology with mathematical thinking. They use integers in relation to high and low temperatures that they record. They use a spreadsheet of weather data, a computer, and gain...
Curated OER
Managing a Checkbook
How do grown ups do it? Teach your upper graders the ins and outs of personal finance by having them use their algebra skills to balance a checkbook. They examine the financial side of math, set up a checking account, and balance their...
Curated OER
Application and Modeling of Standard Deviation
The first activity in this resource has learners computing the mean and standard deviation of two different data sets and drawing conclusions based on their results. The second activity has them using a dice-rolling simulation to...
Curated OER
Graphing Favorite Colors
Third graders collect data and insert it into ClarisWorks to create a spreadsheet/graph of their favorite color. They interpret the data together.