Curated OER
Are We Couch Potatoes or Busy Bees? Data Analysis of Physical Activity in School
Students study practical data analysis within the constraints of the scientific method. In this data instructional activity students collect and enter data into a computer spreadsheet then create graphs.
Curated OER
Data Analysis: Infiltration Rate and Composition of Concrete
Students collect and graph data. In this statistics instructional activity, students analyze data using a spreadsheet program. They display their data effectively and analyze it.
Curated OER
Data Displays with Excel
Students collect and analyze data. In this statistics instructional activity, students display their data using excel. They plot the data on a coordinate plane and draw conclusion from their data.
Pingry School
The Water Lab – Spreadsheet Simulation
More than 70 percent of people and 90 percent of businesses use spreadsheets regularly. While many courses overlook the important skill, the simple water lab focuses on entering spreadsheet data, formatting it, and printing plots based...
Bonneville
Making Observations and Recording Data for Solar Powered Water Pumping
Get pumped about an activity with water pumps. The fifth of seven installments in the Understanding Science and Engineering unit has pupils learn how to make observations, record data, and create data displays. Each group measures the...
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...
Howard Hughes Medical Institute
Spreadsheet Tutorial 4: t-Test
The t-test tutorial will fit your needs to a T. After calculating the mean, sum of squares, standard deviation, and variance of two data sets on a spreadsheet, scholars learn to calculate the t-values. They then learn to use the TTEST...
Kenan Fellows
Saving Those Who Save Us: Exploring the Use of Sensors with Data Visualization
Sensor technology is amazingly accurate and useful. Combining the sensor technology and mathematical knowledge, scholars design experiments to answer a question they have developed. Questions may focus on light sensing, temperature...
Concord Consortium
Broken Spreadsheet I
There is power in spreadsheet formulas and learners use this power to model quadratic data. Given a scatterplot of a parabola, pupils create formulas in a spreadsheet to populate the data. The formulas they use lead to an understanding...
Howard Hughes Medical Institute
Measuring Biodiversity in Gorongosa
Take your biology class' understanding of biodiversity to a whole new level! Ecology scholars use data to calculate three different diversity indices based on the organisms in the Gorongosa National Park. The four-part activity uses an...
Curated OER
It's Your Life - Safe or Sorry/Safety Issues
Young scholars examine and chart data about safety hazards and unsafe situations. In this safety hazard lesson, students examine newspapers and web sites to investigate injuries from safety hazards. They make a spreadsheet using the data...
Curated OER
Sampling Bias And the California Recall
Using a 2002 California Gray David recall vote as an example, young statisticians identify sources of bias in samples and find ways of reducing and eliminating sampling bias. They consider ways to select random samples from a...
Curated OER
Student News And Weather Channel
Fabulous! Your 5th graders should love this project. As an ongoing lesson throughout the year students use temperature probes to record outside temperature and then document their data using spreadsheets. They use their weather data and...
Curated OER
A Comparison Study of Water Vapor Data to Precipitation over North America
Students use NASA satellite data to compare water vapor over the United States. For this data analysis lesson students use an Excel spreadsheet to map their data.
Concord Consortium
Look High and Low
From the highest high to the lowest low here's a resource that won't fall flat. Given data on the area and the highest and lowest elevations of each of the 50 states, learners decide which states are the least flat and the most flat. Of...
Curated OER
Explore Surface Types on a Journey Around Earth
Students explore satellite data. In this technology cross-curriculum math and world geography lesson plan, students locate specific map areas using a microset of satellite data. Students use technology and math skills to determine...
Curated OER
Creating a Spreadsheet and Graph
Students 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 the graph are...
Curated OER
Using Excel to Reference and Graph Live Data from a Web Site
Students collect live buoy data about water temperatures in the Gulf of Mexico from the Internet and work individually to organize their data and create a line graph using Excel Spreadsheet. Students analyze their data and examine any...
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
Data and Scientific Graphs
Students 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
Back-To-School Shopping
Fifth graders estimate the prices of items to be bought for back to school. They use catalogs and/or advertisements to research the cost of each of the items. They use problem solving strategies and a spreadsheet template to determine...
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
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...