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...
Curated OER
Data
Students collect data from an experiment they perform. In this data lesson, students use multiple representations to solve practical problems; describe advantages and disadvantages of the use of each representation. Then, they evaluate...
Curated OER
Data Analysis and Froot Loops
Use this probability and graphing lesson to have your learners work with a partner to make a necklace out of Froot Loops. They record the cereal colors randomly chosen and strung, graph their data, then use a ratio formula to determine...
Curated OER
Using Computer for Statistical Analysis
Students use the computer and S'COOL data for statistical analysis.
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...
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,...
California Academy of Science
Using Empirical Data in the Classroom: Raptor Migrations!
Raptor flight patterns align with seasonal changes in net primary productivity. Here is a thought-provoking lesson that uses empirical data from a video to help scholars understand raptor migrations, producers/consumers, and ecosystems....
Curated OER
Cold, Clouds, and Snowflakes
Students explore satellite data and graphing. In this weather data analysis math and science lesson, students analyze NASA satellite data to draw conclusions about geographical areas where precipitation might have happened. Students...
Virginia Department of Education
Safety and the Material Safety Data Sheet
While many chemicals are used in biology class, many pupils don't understand the material safety data sheets. The lesson explains each part and the importance of understanding the forms. Young scientists use safety equipment to ensure...
EngageNY
Evaluating Reports Based on Data from a Sample
Statistics can be manipulated to say what you want them to say. Teach your classes to be wise consumers and sort through the bias in those reports. Young statisticians study different statistical reports and analyze them for misleading...
Curated OER
Relative Mass Formula, Atomic Formula, and Empirical Formula
After giving the definitions of the different compound terms and formulas, equations are provided to teach your chemists to calculate different values. Relative formula mass, atomic mass, and empirical mass are shown and explained with...
Curated OER
Measurement and Data Collecting using Image Processing
Students trace the route of the historical event and measure the distance over which the people involved journeyed. A data sheet be constructed outlining the location of events, and the speed with which the journey occurred.
Curated OER
Position Within a Set
Your students will have no problem relating to this word problem involving a toy car race: there are three cars, and they come in first, second, and third place in a race down the driveway. Learners analyze the data by writing the...
Beyond Benign
Can You Hear Me Now? Cell Phone Accounts
How sustainable are cell phones? Throughout the unit, learners explore the issues around cell phones concerning sustainability. Class members take a graphical look at the number of cell phones across the world using a box-and-whisker...
Virginia Department of Education
Properties of Compounds and Chemical Formulas
Young chemists have unknown compounds they need to sort. Performing three different tests on each, the chemical behaviors they observe become the basis for data analysis.
Chymist
Empirical Formula of a Compound
Because of the work of John Dalton, we are able to write formulas for compounds. The hands-on experiment has scholars prepare a compound from its elements. Using mass data, individuals write the empirical formula for the compound.
Curated OER
The Mathematics of Chemical Formulas
Wow! This is one of the most exhaustive presentations on finding chemical formulas that you will come across! Beginning with the basics, and leaving junior chemists with procedures and concrete examples, this PowerPoint certainly...
Virginia Department of Education
Linear Curve of Best Fit
Is foot length to forearm length a linear association? The class collects data of fellow scholars' foot length and the length of their forearms. They plot the data and find a line of best fit. Using that line, they make predictions of...
PBIS World
Daily Check In Check Out Data Summary
Compile data for a child's IEP with a helpful summary worksheet. With formulas for calculating the assessment information you need, it's a great addition to checking on your learners' progress.
Curated OER
Go Fish
Help learners discover methods to estimate animal population. They will participate in a simulation of catching and tagging fish in order to estimate the fish population. They scoop and count goldfish crackers, record data, and use...
Curated OER
Exploring Quadratic Data : Transformation Graphing
High schoolers analyze the vertex form of a parabola and find an approximate fit of a model. They explain the quadratic parabola function and its properties by developing quadratic models. They use translation and dilation to change the...
Curated OER
Data Analysis: Investing is an "Interesting" Experience
Students compute interest earned. For this data analysis lesson, students examine investments and interest rates. They compute the total interest earned and find the simple interest.
Curated OER
Credit Cards: The Good, the Bad, and the ugly
Students 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
Maps and Modes, Finding a Mean Home on the Range
Fifth graders investigate data from maps to solve problems. In this data lesson, 5th graders study maps and collect data from each map. Students present their data in a variety of ways and calculate the mode, mean, median, and range.