Ben+and+Jerry


 * Human Bar Graph**


 * Which flavor do you prefer?
 * Choose your flavor of Ben and Jerry's.
 * Stand with those who have chosen the same flavor.
 * Create a human bar graph.
 * Put your "lid" on the class chart.

Excel can be used for a variety of tasks. Excel, a versatile tool, can increase productivity for management and computational tasks. Teachers, secretaries, principals and students can collect and analyze data for making decisions, solving problems, drawing conclusions and making generalizations.
 * Ben and Jerry's Ice Cream Project**

1. Predict how many sugar cubes each type of ice cream contains per serving. 2. Go to [] Choose four flavors and save the nutritional information for each on a sheet of paper. 2. Look at the number of grams of sugar from the nutritional information on the container. Were you close? 3. Open Excel and record the ice cream names. 4. Enter the basic nutritional formation listed below for each of your flavors: 5. Create the following formulas: 6. What does your information show?
 * Total Calories
 * Total Fat Grams
 * Total Carbohydrate Grams
 * Fiber Grams
 * Sugar Grams
 * Protein Grams
 * Convert your grams of sugar to total calories and total number of sugar cubes. (3 per cube)
 * Convert your fat grams to total calories
 * Averages for each by flavor
 * Percentages of total calories?
 * Can you believe there is all that sugar in your ice cream?
 * Which ice cream flavor had the most?
 * Which ice cream had the least?
 * What you predict for a 1/2 gallon? A gallon?


 * Ben and Jerry's Part II**

1. Figure out about how much ice cream you usually eat in a sitting. 2. Insert new columns and formulas to reflect the information for each of your four ice cream flavors. 3. Format your chart to be more pleasing to the eye by including the following:
 * Cell formatting
 * Conditional formatting
 * Merge and center of your title
 * Lines formats
 * Styles
 * Background images?


 * Ben and Jerry's Part III**

Create a graph to easily analyze this information.


 * Pie chart for each flavor
 * Serving size bar chart
 * Flavor comparison chart

How to make a pictograph []

[] login: (email address) password:
 * Tech4Learning - Recipes for Success (Stephanie)**