Click here to see graphs made by the students.
What Color are Your Skittles?
Open your package of Skittles. Tally the amounts of the different colors of
Skittles found in your package.
1. Open the program called Microsoft Excel.
2. Click the mouse in cell B1 and type “My Skittle Colors” in the entry bar.
3. Highlight “My Skittle Colors” in the entry bar and change the font size to 14
and BOLD.
4. Press the enter key to move the information from the entry bar to the active
cell.
5. Click the mouse in cell B3 and type in “Green.” Highlight the word Green and
change the font to size 12 and make it BOLD. Press the enter key to move the
information from the entry bar to the active cell.
6. Highlight cells B4 through B7; change the font to size 12 and BOLD.
7. Enter the names of the different colors of the Skittles into cells B4, B5,
B6, and B7. Place your mouse in cell B4 and type in the next color. Continue
until all the colors are entered.
8. After you have labeled all of your candy colors, you will need to enter the
data recorded for each color. Click the mouse in cell C3 and enter the number of
green Skittles found in your package. Repeat for all the colors, entering the
data down column C.
9. Once the data is entered, click on cell B3 and drag the mouse to the end of
where you entered information in Column C. From the Insert menu on the Task Bar
select Chart. Select Pie chart. Click Next and Next again. In the Title
Selection space type _____’s Skittles. (Put your name on the blank line.) Click
on the Data Option tab and select Show Percent and then Finish.
10. Move the Pie chart off the spreadsheet table by clicking on the pie chart
and dragging it to the side. To increase the size of the pie chart, drag down on
the bottom and side of the chart area, and the chart will grow in size.
11. Change the color of each piece of pie on the chart by double clicking on the
color square in the legend and selecting the appropriate color from the Pattern
tab color chart. The legend and the piece of pie will change to this new color
after you click OK.
12. When you have completed your pie chart, click on Print Preview to make sure
that the chart and the spreadsheet will be printed. Save your work on your disk
- call it Skittle Colors – and print 2 copies.