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

2. Type in the column labels.
1. For cell B2, type in the text (Counts for Favorite Flavors).  Right mouse click on the cell.  Click on Format Cells, Alignment, and Wrap text.  Repeat for cell C2.  You'll have to get between the columns and stretch them out.  Get the +  between the column letters to widen the columns.
2. Highlight Cells A1,B1, and C1.  Go up to Format/Row/Height.  Change the Height to 45.
3. Keeping these cells highlighted, right mouse click.  Format Cells/Alignment/Horizontal & Vertical Alignment/Center
4. Bold the text in these three cells
3. Type in the Favorite Flavors from your class, Column A, Row 3
4. Shade Cells B2 through the Total column any color.  Format/Cells/Patterns
5. Shade Cells C2 through the Total column any other color.
6. Turn on the borders as in the example.  Format/Cells/Border

 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 Icon, å  to confirm that they equal 100%
4. Count the number of flavors.  Insert your formula in cell B15.  =count(high light the cells that you want to count).  Remember Excel can only count cells with numbers.

  Create the Pie Chart:

 Chart 1

1. Highlight the Ice Cream Flavor Names (do not include the Title, Ice Cream Flavors), Column A, and the actual percentages from the column, Percentage of Class, Column C (do not include the Title, Percentage of Class).  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,, keep clicking Next, look at the tabs at the top
2. Type in a title for your graph.
3. On this same screen,Click on Data Labels, and Category Name.  Each section should now be labeled with the kind of ice creams chosen by your classmates.Click on the Data Label tab.  Click on the Value box.  
4. Save this as a New Sheet. Chart 1.
5. Rename Chart 1 with a new name of your choice.  Right mouse click on Chart 1, select rename, start typing your new chart name
2. Right mouse click on the areas of the chart that you want to edit and change.

Chart 2

1. Highlight the Ice Cream Flavors. Column A, and the Number of Students, Column B, who chose that Flavor.   Now Create a Column Graph and place it on another New Sheet. Chart 2.  Rename Chart 2 with a new name.
1. Type in a title for your graph.
2. On this same screen, click on the Data Label tab.  Click on the Value box.
3. Click on one of the bars on the graph.  Go up to Insert Picture/Clipart/Click on the clipart picture and insert it into your bar.
4. Save this as a New Sheet. 
5. 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