We are going to use the spreadsheet to interpret the information you created from your M&M data. By using the spreadsheet, you will be able to make a graph of your information. You also will be able to calculate the color percentages with the spreadsheet.

2) We want to open up the spreadsheet. If you look at your diamond, you will see a smaller diamond on the far left of the big diamond - this diamond has the appearance of a big rectangle with little rectangles inside. Click on that diamond and select

3) You should see a spreadsheet on the screen at this point. Try clicking on one of the boxes with your mouse. Look in the upper left hand corner. You should see a letter and a number. Click on different boxes with your mouse and watch how the letters and numbers change. Why are they changing? Describe below what is happening.

4) The letter and number tell the location of the box, or

5) In cells B1 - B6, you are going to enter the number of M&M's that you had in your pack for each category. For example, if you had 3 brown M&M's, then you will enter the number 3 in cell B1 and press enter. Do this for the remaining colors.

We are now going to use the information from the spreadsheet to create a graph of our data.

6) We want to take the information and tell the computer to graph it. We first have to highlight all of the information that you have entered. Do this by clicking on cell A1 and dragging down and across to cell B6.

7) We are going to have to go back to the

8) Wait a minute. Look at what kind of graph you have on the screen. What is it telling you? Compare your screen with your neighbors. Is it different? The same? Explain why or why not.

9) Now see what happens when we look at other graphs. Go to

10) Now see what happens when you try another graph. Go to

11) Try looking at some other graphs using the commands above. Which did you like the most?

12) Go back to the spreadsheet by clicking on

13) In cells, C1 - C6, we are going to enter the information that will give us the percents. However, we need to create a total number of M&M's by having the computer add up the totals of colors for us. We do this by going to cell B7 and entering:

14) Now, we are going to let the computer do most of the work for us. In cell C1, you will enter B1/B7, the ratio of that color to the total number of M&M's. Repeat the same in cell C2, but use B2/B7. Repeat this for all changing only the numerator of your ratio. You will do this and stop after you enter the information into cell C6.

15) You should see the decimal equivalents for the ratios you entered. We can use the computer to convert those decimals to percents. To do this you will need to highlight cells C1 - C6. Next you will go to

RED

YELLOW

ORANGE

16) Are these the same percentages you calculated earlier? If not, what happened? Check for errors on your original worksheet and also check for errors on the spreadsheet.

17) What are some other applications for the spreadsheet? List about three or four. How could you use the spreadsheet to make some aspect of your life a little easier? Explain below.