Favorite Ice Cream

 

Step 1: Determine the classes’ favorite flavors of ice cream

 

Create a Spreadsheet as in the example

 

  1. Merge and Center the title of the spreadsheet through cell C.  Color the text red, and change the font size.  Yes, C is correct.  You will later re-size the columns and make them larger.  Do not wrap text for Column A.
    1. Right mouse click on cell A2 and vertically align the text.
    2. Bold the text for A2, B2, and C2

 

 

  1. Type in the column labels.
    1. For cell B2, type in the text (# OF Students Who Choose That Flavor As Their Favorite).  Right mouse click on the cell.  Click on Format Cells, Alignment, and Wrap text.  Repeat for cell C2.
  2. Type in the Favorite Flavors from your class
  3. Shade Cells B2 through the Total row any color
  4. Shade Cells C2 through the Total row any other color.
  5. Turn on the borders as in the example.

 

Favorite Ice Cream Flavors Class Poll

Ice Cream Flavors

# Of Students Who Choose That Flavor As Their Favorite

Percent Of Class Who Chose That Flavor

Chocolate

3

12%

Vanilla

2

8%

Rocky Road

1

4%

Cherry Garcia

1

4%

Cookies n' Cream

7

27%

Strawberry

4

15%

Coffee

3

12%

Cookie Dough

5

19%

 

 

 

 

 

 

Totals

26

100%

 

 

 

Flavor Count

8

 

 

 


Directions for Formulas

 

  1. Total the number of students who voted:  =sum(B3:B12) in  Cell B13
  2. Calculate the percentage of students who like a certain flavor:  =B3/B13 in Cell C 3 through C 10.  Right mouse click, Format Cells, Percentage, Decimal point 0.
  3. Total using AutoSum the percentages, to confirm that they equal 100%
  4. Count the number of flavors.  Insert your formula in cell B15.  If you forget how to count, see the GPA assignment.

 

Create the Pie Chart:

 

  1. Highlight the Ice Cream Flavors, Column A, and the Percentage of Class, Column C,  who chose that Flavor.  Hold down the CTRL key to highlight both columns.  Create a  3-D Pie Chart using the Chart Wizard. 
    1. As you create the chart, look at the tabs at the top.  Click on Data Labels, and Show Labels.  Each section should now be labeled with the kind of ice creams chosen by your classmates.
    2. Save this as a New Sheet. Chart 1.  Rename Chart 1 with a new name of your choice.
  2. Right mouse click on the areas of the chart that you want to edit and change.
  3. Highlight the Ice Cream Flavors. Column A, and the Number of Students, Column B, who chose that Flavor.   Now Create the Bar Graph and place it on another New Sheet. Chart 2.  Rename Chart 2 with a new name.
    1. Data label needs to Show Value.
    2. Save this as a New Sheet.  Rename the Sheet

 

Insert three pictures

 

1.  Insert three graphics or pictures  of ice cream cones onto your spreadsheet, and your two graphs.  (One picture on the Spreadsheet and one on each of the Charts.  Total of three

 

 

Original idea for project from: http://bes.belmar.k12.nj.us/public/everyday_spreadsheets/old_start/start_old.htm