Curated OER
The Price is Right
Students, through various activities, explore online databases. Using the internet, students explore the distributors websites. They collect specific information on selected products. An spreadsheet with price comparisons is developed....
Curated OER
Excel Lesson Plan Coin Statistics
Second graders determine the difference between making a prediction and determining actual information. They design a spreadsheet for a coin flipping activity on which they include their predictions and what actual happens when they flip...
Curated OER
And the Winner Is...
Third graders participate in an election project. They collect data to create a spreadsheet from which a graph is generated.
Curated OER
Spreadsheet Activity
Young scholars create a spreadsheet to match a given sample. This includes adjusting column width and row height, changing alignment, changing size and style of print, changing number format.
Curated OER
Sorting
Students examine how sorting is the process of putting things into an orderly sequence based on some key value. In this lesson students create a spreadsheet with 26 rows of data, then sort those rows by different values.
Curated OER
Graphing Data from the Chemistry Laboratory
Students graph and analyze data using a spreadsheet.
Curated OER
Loving Literature
First graders, after having "Are You My Mother?" by P.D. Eastman read to them, participate in group discussions or independentally work to analyze a spreadsheet to identify essential elements in the story and graph their data. In...
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
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
Weather Watchers
Students practice using objective and quantitative means to describe and compare the weather. They compile weather conditions and create a spreadsheet to record their findings.
Curated OER
Checking Test Comparability/Scattergrams
Students construct a scattergram graph. In this statistics lesson, students graph data by hand and using a spreadsheet program. They establish lines of best fit and draw conclusions using their graphs.
Curated OER
Snow Cover By Latitude
Students create graphs comparing the amount of snow cover along selected latitudes using data sets from a NASA website. They create a spreadsheet and a bar graph on the computer, and analyze the data.
Curated OER
The Dangers of Being Obese/Overweight
Third graders determine if they are eating healthy. In this healthy living lesson, 3rd graders watch a video titled Happy Health and review the food pyramid. Students create a spreadsheet where they list their food intake for the week...
Curated OER
Pumped Up Gas Prices
Students calculate gas prices. In this transportation lesson, 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
Heat of an Unknown Metal
Eighth graders complete labs to find the specific heat of many different types of substances, and use characteristic property to identify an unknown metal. CBL be used to determine energy lost or gained, and students complete a...
Curated OER
Technobiz
Students examine candy preferences to create a plan in order to improve candy sales. In this technobiz instructional activity, students build spreadsheet and organizational skills by graphing and calculating data. Students are introduced...
Curated OER
Acceleration, Drag, Gravity, Motion, Forces, and Friction
Eighth graders build and run mousetrap cars in order to measure distance, time, and mass for their cars. They use these measurements to calculate average speed and kinetic energy, then create a slide show to visually explain how the car...
Curated OER
Graphing the Past Using Today's Technology
Eighth graders research statistical data regarding their current social studies unit. They write questions about the measures of central tendency, collect and analyze the data, insert the data into a spreadsheet, and generate graphs.
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 activity, 6th graders determine what a miner's income was minus his expenses graphing findings in...
Curated OER
How Do Plants Grow?
Students investigate plant growth. In this plant growth lesson, students investigate what would happen to plants if they did not have water and sunlight. Students conduct experiments to determine what plants need. Students create a...
Curated OER
Lesson Plan Outline for Rainbow Science
Young scientists study light reflection and refraction as they determine the critical angle, the rainbow angle, and color separation in rainbows. Teams record the data they collect in a shared spreadsheet and discuss results with the class.
Museum of Tolerance
Why is This True?
Are wages based on race? On gender? Class members research wages for workers according to race and gender, create graphs and charts of their data, and compute differences by percentages. They then share their findings with adults and...
Curated OER
Doughnuts to $ Database
Fifth graders are selling Krispy Kreme doughnuts to raise money for their overnight camping trip. They use a database to set to keep track of and record additions to their daily sales. Students then follow the step by step directions to...