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...
Earth Watch Institute
Entering Local Groundhog Data in an Excel Spreadsheet
Here is a cross-curricular ecology and technology lesson plan; 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
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....
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 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...
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,...
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...
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....
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...
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...
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...
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
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 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...
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.
Concord Consortium
Broken Spreadsheet II
Work in reverse with the product becoming the given. Using a spreadsheet image of the graph of a trigonometric function, young scholars investigate methods of creating spreadsheet data that results in the given graph. The catch? The data...
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
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,...
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
Data Displays with Excel
Students collect and analyze data. In this statistics lesson, students display their data using excel. They plot the data on a coordinate plane and draw conclusion from their data.
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.