Lesson Planet
Search educational resources
  • Sign In Try It Free
  • AI Teacher Tools
    • Discover Resources Search reviewed educational resources by keyword, subject, grade, type, and more
    • Curriculum Manager (My Content) Manage saved and uploaded resources and folders To Access the Curriculum Manager Sign In or Join Now
    • Browse Resource Directory Browse educational resources by subject and topic
    • Curriculum Calendar Explore curriculum resources by date
    • Lesson Planning Articles Timely and inspiring teaching ideas that you can apply in your classroom
    • Our Story
    • Frequently Asked Questions
    • Testimonials
    • Contact Us
  • Pricing
  • School Access
    • Your school or district can sign up for Lesson Planet — with no cost to teachers
      Learn More
  • Sign In
  • Try It Free

Hi, what do you want to do?

Create a lesson plan
Create a lesson plan
Generate resources with 80+ AI teacher tools
Generate resources with 80+ AI teacher tools
Search 200,000 instructional videos
Search 200,000 instructional videos
Find a teaching resource
Find a teaching resource
Data Analysis and Probability: Graphing Candy with Excel Lesson PlanData Analysis and Probability: Graphing Candy with Excel Lesson Plan
Publisher
Curated OER
Curator Rating
Educator Rating
Not yet Rated
Lesson Plan

Data Analysis and Probability: Graphing Candy with Excel

Curated and Reviewed by Lesson Planet
This Data Analysis and Probability: Graphing Candy with Excel lesson plan also includes:
  • Project
  • Join to access all included materials

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 create a graph of the data.

84 Views 205 Downloads
Concepts

microsoft excel, data analysis, graphing data, graphing

Additional Tags

creating a graph, data analysis, graphing data, m&m math, excel, math
Show More Show Less

Resource Details

Grade
5th - 8th
Subjects
Math
2 more...
Resource Type
Lesson Plans
Audience
For Teacher Use
Duration
1 hr
Technology
Database & Spreadsheet

See similar resources:

Lesson Plan

Data Analysis Using Technology

Curated OER
Analyze data using technology. Middle schoolers design data investigations, describe data, and draw their own conclusions. Then they select the best type of graph, graph and interpret the data, and look for patterns in trends. They also...
5th - 8th Math
Unit Plan

Module 8: Modeling Data

Mathematics Vision Project
Statistics come front and center in this unit all about analyzing discrete data. Real-world situations yield data sets that the class then uses to tease out connections and conclusions. Beginning with the basic histogram and...
8th - 10th Math
CCSS: Designed
Lesson Plan

Monster Data

Curated OER
An inventive lesson shows learners how to collect, organize, and present mathematical data. They access websites which lead them through a variety of ways to engage in data collection. They get to design and create graphs, and present...
3rd - 5th Math
Lesson Plan

Displaying a Data Distribution

EngageNY
Pupils analyze a display of data and review dot plots to make general observations about the highest, lowest, common, and the center of the data. To finish, learners match dot plots to scenarios. 
6th Math
CCSS: Designed
Lesson Plan

Estimate and Compare Data

Curated OER
Seventh graders explore the values that are used in order to describe data that is collected or given. They compare data using the statistical analysis provided by finding the mean, median, and range.
7th Math
Lesson Plan

Show Me The Data!

Curated OER
Pupils create a bar graph. They will collect and organize data to turn into bar graphs. They create graphs for the favorite sports of the class, color of M&M's, and types of cars passing by.
6th Math
Interactive

Graphs for Discrete and for Continuous Data: Discrete vs. Continuous Data

CK-12 Foundation
Not all data is the same. Using the interactive, pupils compare data represented in two different ways. The learners develop an understanding of the difference between discrete and continuous data and the different ways to represent each...
7th - 12th Math
Instructional Video

How Do You Find the Mean of a Data Set?

Curated OER
There are eight decimals numbers in this data set. Find the mean. So add all the terms together and then divide that total number by the number of terms in the data set. That's how you find the mean or average of a data set.
3 mins 4th - 8th Math
Instructional Video

How Do You Find the Median of a Data Set?

Curated OER
Mean, mode, median? What's the difference? How do you find them? The teacher focuses on explaining median in this video. She gives a good explanation and shows how to order a data set to find the median number. This given data set has an...
4 mins 6th - 8th Math
Instructional Video

What is Numerical, or Quantitative, Data?

Curated OER
The teacher gives a very thorough explanation of numerical or quantitative data being anything where the answer to a question would be a number. Whereas any other answer might be considered categorical. She shows several different ways...
5 mins 6th - 12th Math
Try It Free
© 1999-2026 Learning Explorer, Inc.
Teacher Lesson Plans, Worksheets and Resources

Sign up for the Lesson Planet Monthly Newsletter

Open Educational Resources (OER)

  • Health
  • Language Arts
  • Languages
  • Math
  • Physical Education
  • Science
  • Social Studies
  • Special Education
  • Visual and Performing Arts
View All Lesson Plans

Discover Resources

  • Our Review Process
  • How it Works
  • How to Search
  • Create a Collection

Manage Curriculum

  • Edit a Collection
  • Assign to Students
  • Manage My Content
Contact Us Site Map Privacy Policy Terms of Use