the Facts!

It is now time to get your real data!  Open your bag of candy and let's get started!

  1. Click on the "Sheet 2" tab in your Excel file and rename it "the Facts!".  Recolor the tab red.
  2. In cell A1, title the slide "[Your Name]'s Quality Control - the Facts!"  Change the font, color, and size of the text as desired.
  3. Put the contents of your candy package into the clear bag and count the contents.
  4. In cell A3, key "Actual Count:".  Widen column A so that this text remains in column A (does not extend into column B).
  5. Count the total number of candy pieces in your bag and record this number in cell B3.
  6. Beginning in cell A5 and working your way down the column, list the various colors of candy found in your bag.
  7. Count the number of each color of candy found in your bag, and record these numbers in the corresponding cell in column B.
  8. In cell A11, key "Total"
  9. In cell B11, create a formula to add the numbers above beginning with cell B5.  Ensure that the total equals the count you recorded in cell B3.  If it does not equal, begin counting again to verify your information before continuing.
  10. Insert a row above row 3 where you have the Actual Count recorded. 
  11. Save!
  12. Write a reply to this assignment in Edmodo indicating your color counts for the M&Ms or Skittles to share this data with others to use in the near future.

Using the data in "the Facts" worksheet, let's now create a bar chart to show our actual data.

  1. Select the colors and number data from "the Facts" worksheet (do not include the totals).
  2. Create a bar chart of your choice (not stacked).
  3. Change the colors of each bar to represent the corresponding candy color.
  4. Change the chart layout so that the actual candy count is shown just after the bars in the chart.
  5. Delete the Legend or data series if one is present.
  6. Add a chart title above the chart called "[first name]'s the Facts!"
  7. Save!

Click here to continue with the Comparison.