Curated OER
Made Round To Go Round
For 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
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
Learners 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 lesson...
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!
Students 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...
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
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 instructional activity, 6th graders determine what a miner's income was minus his expenses...
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.
Curated OER
Quick Concept Demonstrations
Students research the nervous system. Demonstrations on how to pick up keyed information in text is shown daily and weekly. Reviewed for content is Nerve Impulse, Polarization and Depolarization and perception. A spreadsheet will graph...
Curated OER
Calculating & Graphing Using a Spreadsheet
Students use the lab apparatus to calculate the average velocity and average acceleration at several points and record the data. They use the spreadsheets to plot distance vs. time, velocity vs. time and acceleration vs. time graphs.
Curated OER
Fabulous Fossils
Seventh graders investigate how fossils are formed and discuss how scientists determine the appearance of ancient plants and animals. They make fossils of everyday objects for others to identify. They make spreadsheets to display fossil...
Curated OER
There's No Accounting for Good Journals
Tenth graders create journals on their spending habits. In this money-management lesson plan, 10th graders create and keep journals of their personal income and expenditures. Students learn to use Excel to create a spreadsheet for their...
Curated OER
What Would it Cost You Today?
Learners explore inflation and the role played by advertising and marketing over the years. In this financial literacy lesson, students complete worksheets, do Internet research, and create an excel spreadsheet comparing prices from...