Healthy Eating
Resources: MathPower, page 198, Healthy Eating
Open the spread sheet called Nutrition
Fat and Fibre
1. From the Format menu select Column Hide for each column in the spreadsheet that you don't want to display. You can select the columns individually or in a group.
2. Find the records for ice cream, vanilla. What is the mass of fat in a serving of each vanilla ice cream?
Ice cream, vanilla _____ Ice cream, vanilla, rich _____
3. a. Sort the spreadsheet using the amount of Fat. Sort in descending order. How many records display more fat per serving than one serving of high fat vanilla ice cream?
______
b. Are you surprised by any of the foods you found in a? Explain.
______
______
c. What do you notice about the fibre content of the foods you found in part a?
______
______
4. Sort all the records from greatest to least fibre content. What do you notice about the fat content of foods with high fibre content?
______
______
5. a. Find the record for potato chips. What are the masses of fat and fibre in a serving?
______
b. Compare the serving size with the amount that you think of as a "normal portion." What are the masses of fat and fibre in your idea of a "normal portion"?
______
______
6. Repeat question 5 for:
a. eclair______
b. strawberries, raw______
c. pizza, cheese ______
d. cookies, peanut butter ______
Energy from Fat
One gram of fat provides about 38kJ energy. For a food, the percent of energy from fat, p, is given by the formula p = 38f/e x 100, where f is the mass of fat, in grams, and e is the energy from the food in kJ.
1. Add a column called Energy from Fat, %, rounding the percents to 1 decimal place. In cell G2 enter the formula: =38*E2/D2*100 and select all of column G. Use the Edit Fill Down command.
2. Select cell G2 and go to the Data menu and select Sort and Sort by Energy from Fat. Click OK.
Find all the records where over 60% of the energy is from fat. What types of food are more than 100%?
______