Lesson Plan
Curated OER

Creating a Spreadsheet and Graph

For Teachers 4th - 5th
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...
Lesson Plan
Curated OER

WHAT IS THE POPULAR COLOR?

For Teachers 4th
Fourth graders graph cars according to their colors. They complete the graph including a title, scale, x-axis, and y-axis. Students collect the data and choose the type of graph to be made.
Lesson Plan
Curated OER

Which Amusement Park Would You Choose?

For Teachers 5th - 10th
Students analyze data related to amusement parks and create a spreadsheet to display the data. They read the data and predict which amusement park they think is safer, create a spreadsheet and graph, and write a proposal based on their...
Lesson Plan
Curated OER

Creating a Data Table

For Teachers 7th
Seventh graders explore organizing data into a table. The teacher leads a handshaking activity among the class. They collect the information concerning the number of handshakes each person received. Students discover a pattern. They...
Lesson Plan
Curated OER

Grade 5: Alphabet Frequency

For Teachers 5th
Fifth graders collect and organize data from writing samples, use fractions and decimals to describe the experimental data, and use the experimental results to make predictions about the frequency of letter usage in the English language.
Lesson Plan
Curated OER

Wiggle Worms

For Teachers 1st
First graders investigate worms, collect and analyze data. In this worm and data lesson, 1st graders listen to Chick and Duckling from the Macmillan/McGraw-Hill reading series. They conduct experiments with worms, collect simple data,...
Lesson Plan
Curated OER

If Our Class Went to See the Prince

For Teachers 1st
First graders read the story One Monday Morning and create picture graphs based on the number of teachers, boys, and girls that would visit the prince. In this data lesson plan, 1st graders interpret tables and graphs with the help of...
Lesson Plan
Curated OER

Reading the Neighborhood

For Teachers 1st
First graders complete activities with the story One Monday Morning in the Macmillan/McGraw Hill Textbook. In this data lesson, 1st graders read the story and gather data to create a picture graph. They read the graph and answer...
Lesson Plan
Curated OER

Atlatl Lessons Grades 4-12: Lesson for Beginning Users of Atlatl

For Teachers 6th
Sixth graders determine the mean, range median and mode of a set of numbers and display them. In this data lesson students form a set of data and use computer spreadsheet to display the information. They extend of the process by...
Lesson Plan
Curated OER

Our Favourite Halloween Treat

For Teachers 1st - 2nd
Students conduct a survey about Halloween candy and create a bar graph illustrating the data. In this data analysis instructional activity, stud nets are introduced to the topic with a discussion and survey, then the class creates a...
Lesson Plan
American Statistical Association

How Long is 30 Seconds?

For Teachers 6th - 8th Standards
Is time on your side? Pupils come up with an experiment to test whether their classmates can guess how long it takes for 30 seconds to elapse. They divide the class data into two groups, create box-and-whisker plots, and analyze the...
Lesson Plan
University of Georgia

Using Freezing-Point Depression to Find Molecular Weight

For Teachers 9th - 12th Standards
Explore the mathematical relationship between a solvent and solute. Learners use technology to measure the cooling patterns of a solvent with varying concentrations of solute. Through an analysis of the data, pupils realize that the...
Lesson Plan
American Statistical Association

Scatter It! (Using Census Results to Help Predict Melissa’s Height)

For Teachers 6th - 8th Standards
Pupils use the provided census data to guess the future height of a child. They organize and plot the data, solve for the line of best fit, and determine the likely height and range for a specific age. 
Lesson Plan
Curated OER

Our Favorites

For Teachers 6th - 7th
Pupils participate in and conduct a survey to determine various class favorites. They collect, organize and display their data, interpret the results, and complete a packet of worksheets to display the information.
Lesson Plan
Curated OER

Data Analysis and Probability

For Teachers 7th - 10th
Students make their own puzzle grid that illustrates the number of sit-ups students in a gym class did in one minute, then they make a histogram for this same data. Then they title their graph and label the scales and axes and graph the...
Lesson Plan
Curated OER

Conducting and Analyzing Local Studies

For Teachers 7th - 10th
Young scholars carry out the class weather study: recording, organizing and discussing data daily and keeping track of this work in their journals. They look for patterns and relationships in data, link these with what they know and with...
Lesson Plan
Curated OER

Linear Regression and Correlation

For Teachers 8th - 10th
Learners explore scatter plots. In this linear regression lesson, groups of pupils graph scatter plots and then find the line of best fit. They identify outliers and explain the correlation. Each group summarizes and shares their...
Lesson Plan
Curated OER

Is Global Warming Happening?

For Teachers 6th - 8th
Students investigate the probability of global warming and the effects of global warming on the environment. They conduct Internet research and collect data, transfer the data onto an Excel spreadsheet, and create a presentation that...
Lesson Plan
Curated OER

Graphing Memories

For Teachers K - 2nd Standards
Mem Fox’s Wilfrid Gordon McDonald Partridge provides the labels for a graphing activity. Class members create an illustration of a memory item brought from home, and place their illustration in the proper column of a graph. When the...
Lesson Plan
Curated OER

Data Analysis and Data Explorer

For Teachers 7th - 8th
Students use the Data Explorer software to organize and display the test scores for the classes in stacked box-and-whisker plots, then analyze the results in paragraph form.
Lesson Plan
NASA

MASS, MASS – Who Has the MASS? Analyzing Tiny Samples

For Students 9th - 12th
What is it worth to you? A hands-on activity asks groups to collect weights of different combinations of coins and calculate weighted averages. They use the analysis to understand the concept of an isotope to finish the third activity in...
Lesson Plan
1
1
University of Colorado

The Moons of Jupiter

For Students 6th - 8th Standards
Middle schoolers analyze given data on density and diameter of objects in space by graphing the data and then discussing their findings. This ninth installment of a 22-part series emphasizes the Galilean moons as compared to other...
Lesson Plan
Curated OER

TE Activity: A Tornado in My State?

For Teachers 3rd - 5th
Students study data about tornadoes in the United States while completing a worksheet. They develop a bar graph showing the number of tornadoes for the top ten states in the US. They find the median and mode of the data set.
Lesson Plan
Curated OER

Operation Spaghetti

For Teachers 3rd - 5th
Find the math in recipes. Young chefs will follow a recipe and investigate the total cost for materials. They measure amounts of food necessary for the recipe and compute the per person cost.