Curated OER
Data and Scientific Graphs
Learners conduct experiments and graph their data. In this statistics instructional activity, students collect data and graph it on a coordinate plane. They analyze the data looking for patterns and they discuss their findings with the...
Curated OER
Teaching about Data Interpretation
Students explore a variety of relevant lake water chemistry questions, compose responses, and present their results in a poster format. They, in pairs, answer questions about lake chemistry which are imbedded in this plan.
Curated OER
Spreadsheet formulas
Students, while in the computer lab, practice using formulas, print options, functions and adjusting column widths while interacting with a spreadsheet program. They modify and use spreadsheets, after being given a scenario, to solve...
Code.org
Creating Summary Tables
Let the computer summarize all that data. Pairs work together to learn how to create pivot tables by following directions in the online module. They then utilize the data collected from the beginning of the unit to create their own...
Howard Hughes Medical Institute
Scientific Inquiry Using WildCam Gorongosa
How do scientists determine what questions to ask to meet their research goals? Help your class develop an inquiry mindset with a lesson based on studies in the Gorongosa National Park. Partners create their own research questions by...
Howard Hughes Medical Institute
Human Impacts on Biodiversity
Have you always wanted to take your science class on an amazing field trip they will never forget? Now you can! Observe the wildlife in an African savanna through trail cameras with a five-part data analysis activity. Learners analyze...
EngageNY
Sampling Variability in the Sample Mean (part 2)
Reduce variability for more accurate statistics. Through simulation, learners examine sample data and calculate a sample mean. They understand that increasing the number of samples creates results that are more representative of the...
Curated OER
Mythology Spreadsheet
Students read a large variety of myths and discuss the characters and their attributes found in mythology. Then they identify and learn to set up an appropriate spreadsheet program. Students also enter the data to the class spreadsheet...
Curated OER
Data Handling
In this data handling worksheet, 6th graders solve and complete 4 various types of problems. First, they draw a bar chart to represent the information provided in the table shown. Then, students show beneath the table how to work out the...
Curated OER
Graphing Our Marbles
Students collect information pertaining to marble colors found in their bag; then creating a spreadsheet in order to make a chart representing their findings using Microsoft Excel. Students will present their results to small groups.
Curated OER
Credit Cards: The Good, the Bad, and the ugly
Pupils study how dangerous credit cards can be. They see why it is important to pay off credit card bills as soon as they can. They use MS Excel to display and understand the data. They fill out questions using the data from their...
Curated OER
What's Your Shoe Size? Linear Regression with MS Excel
Learners collect and analyze data. In this statistics lesson, pupils create a liner model of their data and analyze it using central tendencies. They find the linear regression using a spreadsheet.
Curated OER
What's Up With My Class
Students collect data about their class and they use Excel spreadsheet to display their tables and graphs about the class. They answer survey questions and collect their data. Students create a graph of their choice to display the...
Curated OER
First Grade Shoe Sizes
Third graders collect shoe size data from classmates in their room and another third grade. They predict what the most common shoe size will be. They place the data in an spreadsheet on the computer. They design a graph using the...
Curated OER
What's Playing Tonight?
Pupils collect data and visually represent it. They conduct a survey of favorite movies. Using a spreadsheet, students organize the data and create bar and circle graphs. Pupils answer statistical questions regarding the data.
Curated OER
The Hot Dog Stand - An Annual Report
Students run a computer simulation and collect data as they work and use the data to create an annual report for their business. It is desirable for students to do this project individually, but it could be done as a class using a large...
Curated OER
Look Into My Eyes!
Students explore collecting, analyzing, and graphing information. They collect data on the various eye colors of their classmates. Students tally the results and create a graph.
Curated OER
Class Birthday Graph
Students analyze the basics of an Excel spreadsheet. They highlight cells in a spreadsheet. They make a column graph. Students are introduced to X-axis and Y-axis. They play various address games on the spreadsheet.
Balanced Assessment
Solar Elements
Let your brilliance shine like the sun. Future mathematicians and scientists consider given data on the abundance of different elements in the sun. The assessment task requires consideration of how these different abundances relate to...
Concord Consortium
Flying High
Some planes are just more efficient than others. Young mathematicians use data on the number of seats, airborne speed, flight length, fuel consumption, and operating cost for airplanes to analyze their efficiency. They select and use...
Curated OER
Hopes and Dreams: A Spreadsheet Lesson Using Excel
Fourth graders read "The Far Away Drawer" by Harriet Diller and discuss the story as a class. After discussion, 4th graders create a t-shirt GLYPH about their hopes and dreams,share their information with the class and create spreadsheets.
Curated OER
Analyzing Discrete and Continuous Data in a Spreadsheet
You are what you eat! Your statisticians keep a log of what they eat from anywhere between a day to more than a week, keeping track of a variety of nutritional information using a spreadsheet. After analyzing their own data, individuals...
Curated OER
Graphing Iron Data
Students apply a data set to create a graph show how iron ore impacts an ecosystem. They explain how the iron effects the distribution and abundance of phytoplankton in coastal ecosystems using spreadsheet software.
Curated OER
Graph Frenzy!!
Students brainstorm for a survey question to ask classmates. They survey their classmates. They enter the results into a spreadsheet and create the best graph for the information. They share their graphs with the class.