Code.org
Cleaning Data
"Clean the data!" "I did not know it was dirty." Introduce your class to the process of cleaning data so that it can analyze it. Groups work through a guide that demonstrates the common ways to filter and sort data. Pairs then...
Curated OER
Using Data from Sensors
Beginning with a discussion about using technology to collect data, this resource includes a video about the next Mars rover as an example. Young scientists are taught that filtering is necessary before collected data can be analyzed....
Earth Watch Institute
Entering Local Groundhog Data in an Excel Spreadsheet
Here is a cross-curricular ecology and technology lesson; your learners create spreadsheets depicting the location and number of groundhog dens in a local park. They research groundhogs and analyze data about where the groundhog...
Code.org
Discover a Data Story
"Data is so boring, there's no way to find any patterns in them." Or is there? Pairs investigate data sets using different data visualization tools to discover a trend that may exist in a data set. Once they find a trend or pattern,...
Virginia Department of Education
Organizing Topic: Data Analysis
Learners engage in six activities to lead them through the process of conducting a thorough analysis of data. Pupils work with calculating standard deviations and z-scores, finding the area under a normal curve, and sampling techniques....
Curated OER
Data Analysis and Probability: Graphing Candy with Excel
Collect and graph data using Microsoft Excel with your math class. They will make predictions about the number of each colored candy in a bag of M&M's, then sort, classify, count, and record the actual data before using Excel to...
Howard Hughes Medical Institute
Gorongosa: Scientific Inquiry and Data Analysis
How does the scientific process begin? Introduce ecology scholars to scientific inquiry through an insightful, data-driven lesson. Partners examine data from an ongoing research study to determine the questions it answers. The resource...
Code.org
Making Data Visualizations
Relax ... now visualize the data. Introduce pupils to creating charts from a single data set. Using chart tools included in spreadsheet programs class members create data visualizations that display data. The activity encourages...
Curated OER
Sweet Data
Students input data about the colors of their serving of M&M candies onto a spreadsheet. They create charts and graphs based on this information.
Statistics Education Web
Are Female Hurricanes Deadlier than Male Hurricanes?
The battle of the sexes? Scholars first examine data on hurricane-related deaths and create graphical displays. They then use the data and displays to consider whether hurricanes with female names result in more deaths than hurricanes...
Howard Hughes Medical Institute
Lesson 8: WildCam Gorongosa Data Analysis
How do scientists analyze data to get a specific answer to a question? The final chapter in an eight-part series of activities centered around Gorongosa National Park encourages scholars to dig deeper into the scientific process. After...
Curated OER
"Data Dabble"
Students engage in a lesson which facilitates their use of web sites to find data, graph it, and interpret it, thus scaffolding graphing skills to prepare students for their 8th grade I-search exit project.
Curated OER
Using Computer for Statistical Analysis
Students use the computer and S'COOL data for statistical analysis.
Howard Hughes Medical Institute
Spreadsheet Tutorial 5: Histogram
A professional-looking histogram is just a few clicks away. The last installment of a five-part Spreadsheet Data Analysis series focuses on histograms. Learners work through a tutorial to see how spreadsheets can help make frequency...
Georgia Department of Education
Math Class
Young analysts use real (provided) data from a class's test scores to practice using statistical tools. Not only do learners calculate measures of center and spread (including mean, median, deviation, and IQ range), but also use this...
Teach Engineering
Understanding the Air through Data Analysis
Is there a correlation or causation relationship between air pollutants? Groups develop a hypothesis about the daily variation of air pollutants, specifically ozone and CO2. Using Excel to analyze the data, the groups evaluate their...
Curated OER
Data, Data, Everywhere... and What Am I To Think?
Students demonstrate good random sampling techniques for data collection, select and develop graphic presentations of data and analyze the data to solve a problem presented.
Howard Hughes Medical Institute
Spreadsheet Tutorial 2: Autofill Data, Cell References, and Standard Deviation
If you've always wanted to know more about spreadsheets, here's a perfect resource for you. A self-paced tutorial introduces how to autofill and copy formulas in a Google sheet or Excel spreadsheet. It also shows users how to find range,...
Howard Hughes Medical Institute
Spreadsheet Tutorial 3: Column Graphs, Error Bars, and Standard Error of the Mean
There's absolutely no error in using the tutorial! Learners use spreadsheets to create column or bar graphs with error bars. They also learn how to calculate the standard error of the mean in the tutorial. This is the third installment...
Curated OER
Cross Cultural Transportation and Resources Exchange
Students examine various modes of transportation. They explore regional transportation options and discover options available in their area. Students survey types of transportation people use in their area. Using spreadsheet data,...
Radford University
Real World Data
Make math class feel more real by using real-world data. Scholars research or collect data on several different topics, such as nutrition, the motion of moving objects, cooling curves, and daylight hours. They create scatter plots using...
Kenan Fellows
Applying Linear Regression to Marathon Data
It's not a sprint, it's a marathon! Statistic concepts take time to develop and understand. A guided activity provides an opportunity for individuals to practice their linear regression techniques in spreadsheet software. The activity...
Curated OER
States Of Matter
Delv into the states of Matter. Students engage in the scientific inquiry process to uncover the exciting world of Matter. They watch a series of videos, and conduct experiments in order to collect and analyze data on the various state...
Curated OER
Data! Data! Graph that Data!
Fifth graders create data graphs using Microsoft Excel. For this data collection lesson, 5th graders create and conduct a survey, then use Excel to organize and graph their data.