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 their bedroom,...
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
Graphing Data from the Chemistry Laboratory
Students graph and analyze data using a spreadsheet.
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
Young scholars 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
Bounce With Me
How many practice lay-ups do you think Michael Jordan has done in his lifetime? Too many to count, but he had to start somewhere! Practice is the key to getting better in any activity. Look through this basketball lesson as there are...
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
Fitness plan: number 3
Young scholars monitor their fitness levels for six weeks of their P.E. course through the use of an Excel spreadsheet. They also research the obesity epidemic among youth in the U.S. today, presenting their findings to the class. This...
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
All Aboard!
Pupils research the history and background of snowboarding as well as the two main types of competition; the Giant Slalom and the Halfpipe. They find the schedule of past and future events and plot the locations of as many of these events.
Curated OER
Measuring Rainfall and Relationships Between pH, Alkalinity and Suspended Solids in the Pago River
Eleventh graders test the pH and alkalinity of Pago River. In this ecology lesson, 11th graders collect data and use spreadsheet to graph results. They analyze and share their findings with the class.
California Academy of Science
Optimal and Sustainable: Renewable Energy Revamp
More than 100 cities around the world have shifted from fossil fuels to renewable energy sources. Scholars investigate a city wanting to make this switch, but needs help determining how to make the shift. Groups consider all options,...
Curated OER
Spreadsheets - WP9/Quattro Pro
Pupils discover spreadsheet applications using Quattro Pro. They demonstrate basic knowledge and application of hardware, software, and Internet use. They recognize and appreciate the value of recording keeping, data input and data...
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.
Curated OER
Bingo!
First graders practice and reinforce phonics and/or math skills by creating Bingo! game using computer spreadsheet. Students incorporate phonics or math skills class has been practicing onto Bingo! cards, which can be printed and made...
Curated OER
Great Graphing
Students collect data, use a computer spreadsheet program to create various graphs, and compare the graphs. They state the findings of each graph in writing and decide which graph type best represents the data.
Curated OER
Global Warming Statistics
Students research real-time and historic temperature data of U.S. and world locations, and analyze the data using mean, median, and mode averages. They graph the data and draw conclusions by analyzing the data. A spreadsheet is used to...
Curated OER
Why Would I Owe My Soul to the Company Store?
Sixth graders listen to "Sixteen Tons" by Tennessee Ernie Ford and discuss what it means to owe one's soul to a store. In this mathematics lesson, 6th graders determine what a miner's income was minus his expenses graphing findings in a...
Curated OER
Seeing What You Cannot See--RADAR
Student imitate mapping the ocean floor using the basic concepts of radar. Then they explain what radar is and how it workds. All of their measurements are recorded on a data sheet. Then the data is entered into a spreadsheet program. A...
Curated OER
Do They Agree?
Fifth graders review and practice subject-verb agreement by cutting and pasting, and by writing a simple paragraph in which the subjects and verbs agree. They utilize worksheets imbedded in this plan to practice subject-verb agreement.