Microsoft in Education |
Contact us Contact us

Using graphs to investigate candy color distribution

/education/en-us/PublishingImages/Lessonplan/19_Hero_265x130.png

In this lesson, students learn the benefits of using different kinds of graphs to communicate information, answer questions, and solve problems as they investigate color distribution in bags of M&M's.

Objectives

Students will be introduced to the concept of graphing as a way to communicate information.

Learning outcomes

  • Students will work in pairs to record color distribution in a spreadsheet format.
  • Students will use formulas in an Office Excel spreadsheet.
  • Students will convert the spreadsheet information into several kinds of charts.
  • Students will utilize information obtained through hands-on research and analysis to predict distributions and write a research report.

Lesson procedure

Introduction

Not all information is the same. To communicate different kinds of information effectively you need to graph the information in different kinds of charts. Some data collections are better represented by bar charts, for example, while others may be easier to interpret as line charts or pie charts. It is important to select a chart type that gets the message across in the most effective way. There are no sure-fire rules that determine which chart type to select for a particular data set, but there are helpful guidelines. For example, bar charts allow for a comparison of values within a category, line charts emphasize a progression of change, and pie charts show the relationship of a part to the whole.

In this lesson, you will learn how to use charts to communicate information effectively by conducting market research about M&M's. First, you will sort and classify the contents of several bags of M&M's by color, using bags with different weights. What makes this especially challenging is the temptation to eat your inventory of candy. Next, you will record the number of candies for each color and summarize your findings on a worksheet created in a Office Excel. Then you will convert the numbers into several kinds of charts and make predictions about color distribution in other bags of candy. You will analyze your data and present your process and results in a written report.​

 

Student activity

Follow the steps below to guide your students through this lesson plan. See student guide links at right.

  • Step 1: "Color distribution"
  • Step 2: "Create a worksheet"
  • Step 3: "Add formulas"
  • Step 4: "Create graphs"
  • Step 5: "Writing the report"

Lesson extension activities

After the lesson, encourage students to use Internet Explorer to visit the M&M's website and take a virtual tour of the factory. They can send email to the company, indicating which colors they like best, which colors they would like to see more of, and which new colors they would like to see in future bags of candy.

Encourage older students to summarize their research findings in a letter to the Consumer Affairs Department, M&M/Mars, 800 High Street, Hackettstown, NJ 07840-1503. Students can use the Microsoft Word Letter Wizard to get started.

Conclusion

Assess students on the following:

  • The accuracy of their data collection
  • The successful completion of a spreadsheet that includes formulas
  • Their ability to work and solve problems collaboratively
  • Their demonstrated understanding of the uses of different charts
  • The thoroughness and effectiveness of their final report