M'n'M+MB13

= M and M MB13 =

**Candy is Dandy Spreadsheet**
>> Count the number of each color. >> Enter the correct number in the correct row. > > **Evaluation of this lesson will be based on:**
 * Assignment Procedure**: -
 * 1) Each pair of students will receive 1 bag of M&Ms.
 * 2) Create a spreadsheet with a row for each color. Enter the label **Colors** in cell A1. Enter the label **Bag 1** in cell B1.
 * 3) Enter the color names in column A under the Colors label.
 * 4) Gently open the bag and sort the M&M pieces according to color.
 * 1) Record the number of each color on the chart of the board to share with the class.
 * 2) Add a column label for the data from the other pairs of students in the class. Label the columns: Bag 2, Bag 3, etc. Fill in the correct numbers for each of the colors for each of the bags.
 * 3) Insert a field in column A - (Total) and create the sum function to show the total number of M&M's in Bag 1 and for each of the other Bags.
 * 4) Insert a field - (Average) and create the average function to show the average number for each of the colors for all of the Bags. Format for 1 decimal point.
 * 5) View this tutorial on how to create and label a pie chart. Make a **pie chart** based on the average colors in the spreadsheet. Manipulate the colors to match the colors of the M&M's. Set the data labels to show number of M&M's. Title the graph "**M&M Average Number of Each Colors/Bag**"
 * 6) Make a new chart, a stacked column chart showing the total number of each color of M&Ms in each Bag. (Do not include the average data or the total data in the chart. In Data Range, The **Data Series in Rows** and use the **First Column as Label**. Title the graph M&Ms in each bag. The X Axis is Bags. The Y axis is Number of Each Color. Match the colors in the legend to the colors of the M&Ms.
 * 7) Add your name to the spreadsheet. Get permission to print document. Make sure it fits on a single page and only print page 1.
 * Quality and accuracy of data collected
 * Organization of spreadsheet data
 * Hard Copy documentation of results
 * Accuracy of calculations
 * Titles and accuracy of graphs.
 * Printing on a single piece of paper with your name.