INVESTIGATING A REAL INVESTIGATING A REAL LIFE APPLICATION LIFE APPLICATION

USING EXCELUSING EXCEL

BY: CYNTHIA FRANQUIBY: CYNTHIA FRANQUIAND AND

AMBER RAMIREZAMBER RAMIREZ

Task 1: Compare the old and Task 1: Compare the old and new food pyramid. new food pyramid.

Task 2: To hand out a survey Task 2: To hand out a survey and see how many and see how many

people meet the people meet the requirements of the requirements of the

new new food pyramid. food pyramid.

THE “OLD” FOOD PYRAMIDTHE “OLD” FOOD PYRAMID

THE “NEW” FOOD PYRAMIDTHE “NEW” FOOD PYRAMID

DIFFERENT FOOD PYRAMIDSDIFFERENT FOOD PYRAMIDS

Healthy Eating Based on the Food Guide Healthy Eating Based on the Food Guide

PyramidPyramid Bread, Cereal, Rice, and PastaBread, Cereal, Rice, and Pasta6-11 servings a day 6-11 servings a day These complex carbohydrates make up the base of the pyramid. They provide B-vitamins, minerals, and These complex carbohydrates make up the base of the pyramid. They provide B-vitamins, minerals, and fiber. Try to steer clear of the more highly processed carbohydrates such as white bread and sugary fiber. Try to steer clear of the more highly processed carbohydrates such as white bread and sugary cereals. Choose whole grain products whenever possible. They have more vitamins, minerals, and fiber cereals. Choose whole grain products whenever possible. They have more vitamins, minerals, and fiber than products made from processed white flour. They also hit your bloodstream more slowly, giving you a than products made from processed white flour. They also hit your bloodstream more slowly, giving you a longer lasting source of fuel.longer lasting source of fuel.

1 serving = 1 slice of bread, 1/2 bagel or bun, 1 ounce dry cereal, 1/2 cup cooked cereal, 1/2 cup cooked 1 serving = 1 slice of bread, 1/2 bagel or bun, 1 ounce dry cereal, 1/2 cup cooked cereal, 1/2 cup cooked rice, 1/2 cup cooked pasta.rice, 1/2 cup cooked pasta.

VegetablesVegetables3-5 servings a day3-5 servings a dayVegetables are a fantastic source of vitamins and fiber. They're also naturally low in fat and calories. Deep-Vegetables are a fantastic source of vitamins and fiber. They're also naturally low in fat and calories. Deep-yellow, or orange vegetables, like carrots and squash, are a great source of vitamin A. Veggies from the yellow, or orange vegetables, like carrots and squash, are a great source of vitamin A. Veggies from the cabbage and pepper families (broccoli, Brussels sprouts, cabbage, bell peppers) are surprisingly rich in cabbage and pepper families (broccoli, Brussels sprouts, cabbage, bell peppers) are surprisingly rich in vitamin C. vitamin C.

1 serving = 1 cup raw leafy greens, 1/2 cup any other chopped vegetable, 3/4 cup vegetable juice1 serving = 1 cup raw leafy greens, 1/2 cup any other chopped vegetable, 3/4 cup vegetable juice

FruitsFruits2-4 servings a day2-4 servings a dayFruit makes a great snack or healthy dessert. It's high in carbohydrate energy and potassium, low in Fruit makes a great snack or healthy dessert. It's high in carbohydrate energy and potassium, low in sodium, and full of vitamins. Strawberries, watermelon, and citrus fruits (like oranges and grapefruit) are full sodium, and full of vitamins. Strawberries, watermelon, and citrus fruits (like oranges and grapefruit) are full of vitamin C; apricots and other orange-colored fruits have lots of vitamin A; and cantaloupe, mangos and of vitamin C; apricots and other orange-colored fruits have lots of vitamin A; and cantaloupe, mangos and papayas have both vitamins A and C. Try to avoid juices sweetened with sugar or canned fruit in heavy papayas have both vitamins A and C. Try to avoid juices sweetened with sugar or canned fruit in heavy syrup.syrup.

1 serving = 1 medium apple, banana, or orange; 1/2 cup chopped fruit or berries; 3/4 cup fruit juice.1 serving = 1 medium apple, banana, or orange; 1/2 cup chopped fruit or berries; 3/4 cup fruit juice.

Milk, Yogurt, and CheeseMilk, Yogurt, and Cheese2-4 servings a day2-4 servings a dayWe've all heard that milk products are rich sources of calcium, but did you know that they're also We've all heard that milk products are rich sources of calcium, but did you know that they're also loaded with protein? A glass of milk or a cup of yogurt has high-quality protein equal to an ounce of loaded with protein? A glass of milk or a cup of yogurt has high-quality protein equal to an ounce of meat or cheese or to one egg. Try to choose reduced fat dairy products whenever possible. A glass meat or cheese or to one egg. Try to choose reduced fat dairy products whenever possible. A glass of whole milk has the equivalent of two teaspoons of butter or three tablespoons of sour cream. That of whole milk has the equivalent of two teaspoons of butter or three tablespoons of sour cream. That bit of added fat would probably be more enjoyable on a baked potato rather than hidden in your milk!bit of added fat would probably be more enjoyable on a baked potato rather than hidden in your milk!

1 serving = 1 cup milk or yogurt, 1-1/2 ounces of natural cheese, 2 ounces of processed cheese.1 serving = 1 cup milk or yogurt, 1-1/2 ounces of natural cheese, 2 ounces of processed cheese.

Meat, Poultry, Fish, Dry Beans, Eggs, and NutsMeat, Poultry, Fish, Dry Beans, Eggs, and Nuts2-3 servings a day2-3 servings a dayThis group is a major source of protein. Cooked beans are high in protein and fiber and low in fat. This group is a major source of protein. Cooked beans are high in protein and fiber and low in fat. Tofu and white beans provide calcium. Almonds are good sources of vitamin E. Beef contains highly Tofu and white beans provide calcium. Almonds are good sources of vitamin E. Beef contains highly absorbable trace minerals like iron, zinc, and magnese. Poultry and seafood contribute vitamin B6, absorbable trace minerals like iron, zinc, and magnese. Poultry and seafood contribute vitamin B6, and pork is a rich source of thiamine.and pork is a rich source of thiamine.

1 serving = 2-3 ounces of cooked lean meat, poultry, or fish; 1 egg; 1/2 cup cooked beans, 2 1 serving = 2-3 ounces of cooked lean meat, poultry, or fish; 1 egg; 1/2 cup cooked beans, 2 tablespoons peanut butter, nuts, or seeds.tablespoons peanut butter, nuts, or seeds.

Fats, Oils, and SweetsFats, Oils, and SweetsUse sparinglyUse sparinglyThis group represents the tip of the pyramid. It includes butter, oils, margarine, sour cream, soda This group represents the tip of the pyramid. It includes butter, oils, margarine, sour cream, soda pop, candy, and sweet desserts. Remember, not all fats are created equal. You want to minimize pop, candy, and sweet desserts. Remember, not all fats are created equal. You want to minimize saturated fats found in animal products like meat and dairy, and trans-fats found in margarine or saturated fats found in animal products like meat and dairy, and trans-fats found in margarine or fried snack foods (look out for "partially hydrogenated" anything). Focus instead heart-healthy fried snack foods (look out for "partially hydrogenated" anything). Focus instead heart-healthy unsaturated fats such as those found in olive oil, nuts, seeds, and avocado. Sweets should be unsaturated fats such as those found in olive oil, nuts, seeds, and avocado. Sweets should be minimized as well. It’s generally better to enjoy a really extravagant dessert once in a while than to minimized as well. It’s generally better to enjoy a really extravagant dessert once in a while than to fill your daily menu with "fat-free" sugary treats. These sweets still tend to be high in calories and fill your daily menu with "fat-free" sugary treats. These sweets still tend to be high in calories and pretty much devoid of nutritional benefits. One possible exception may be molasses, which provides pretty much devoid of nutritional benefits. One possible exception may be molasses, which provides a rich source of iron.a rich source of iron.

1. What resources are you going to 1. What resources are you going to use? use?

a. We are going to be using a. We are going to be using the the internet, library, results that internet, library, results that

we get back from the we get back from the survey’s and our own survey’s and our own knowledge. knowledge.

SURVEY QUESTIONSSURVEY QUESTIONS

How many meals do you eat daily?How many meals do you eat daily?Daily exercise?Daily exercise?How often do you eat out?How often do you eat out?How often do you eat fast foods?How often do you eat fast foods?How often do you pay attention to what you How often do you pay attention to what you consume based on fats, sugar, and protein?consume based on fats, sugar, and protein?How often do you use the food pyramid as a How often do you use the food pyramid as a reference for your daily consumption?reference for your daily consumption?How often are you concerned with the calories How often are you concerned with the calories you take in?you take in?

MORE QUESTIONSMORE QUESTIONS

Are you concerned with your weight?Are you concerned with your weight?

Do you eat enough veggies and fruits?Do you eat enough veggies and fruits?

Do you try to improve your intake for a Do you try to improve your intake for a healthy one?healthy one?

Have you heard about the new & improved Have you heard about the new & improved food pyramid?food pyramid?

Has you eating habits changed in the last Has you eating habits changed in the last 2 years?2 years?

SURVEY RESULTSSURVEY RESULTS

Responses A B C D E F G H I J K L

1 4 1 2 1 1 1 1 1 3 Y Y N

2 3 2 3 2 1 1 1 1 4 Y N Y

3 3 2 3 2 3 2 3 3 3 Y N Y

4 3 2 4 3 1 1 1 3 5 Y N Y

5 3 5 1 1 2 3 3 5 5 Y N Y

6 2 3 4 4 3 1 3 5 3 Y N Y

7 3 2 2 2 5 1 5 5 5 Y N Y

8 4 2 3 2 2 1 2 3 4 Y Y Y

9 3 1 3 4 1 1 4 5 4 Y N Y

10 3 5 4 2 3 1 5 3 4 Y Y Y

11 2 2 2 3 1 1 1 1 2 Y N N

12 3 3 2 2 4 1 3 4 2 Y Y Y

13 2 2 3 2 1 1 1 3 4 Y N Y

14 4 5 4 2 4 1 1 3 4 Y N Y

15 3 2 4 1 3 3 3 3 3 Y Y Y

16 3 3 2 2 1 2 1 3 3 Y Y N

17 3 4 3 2 4 1 2 5 4 Y Y Y

18 3 1 4 2 1 1 1 2 2 Y Y Y

19 3 3 2 1 2 3 3 1 4 Y Y N

20 4 1 3 3 1 1 1 1 2 Y N N

How much meat should be consumed

0 2 4 6 8

Women

Children & teens

Teen boys and activemen/women

Age

Gro

ups

Ounces(oz.)

Meat

Three Different Calorie Levels

0

2

4

6

8

10

12

Bread groupservings

Vegetable Fruit Milk

Foods

Serv

ings

Women

Children & teens

Teen boys and activemen/women

Survey Comparsions

0

2

4

6

8

10

1 2 3 4 5

Ratings

Am

ount

of P

eopl

e (2

0 Su

mm

erm

ath

Girl

s)

Quest.

Quest.

Quest.

N ew P yramid vs. Old P yramid

02468

1012W

hole

Gra

ins

Fru

its

Fis

h, P

oultr

y,E

ggs

Hig

hC

arbs

(bre

ad,p

Foods

Ser

vin

gs Servings of Old

Pyramid

Servings of NewPyramid

INFORMATIONINFORMATION

The grain category, is made up of breads, cereal, rice, and pasta. The grain category, is made up of breads, cereal, rice, and pasta. The vegetables are made up of tomatoes, potatoes, lettuce, carrots, The vegetables are made up of tomatoes, potatoes, lettuce, carrots, mainly ground foods. The fruit category is made up of plant mainly ground foods. The fruit category is made up of plant products, usually sweet and having a pit. The meats and beans products, usually sweet and having a pit. The meats and beans category is made up of your meats, of course, but also fish poultry, category is made up of your meats, of course, but also fish poultry, eggs, nuts and beans or dry beans. eggs, nuts and beans or dry beans. If you are between the ages of 14 and 17 and only work out about If you are between the ages of 14 and 17 and only work out about 30 minutes or less each day, then you should be eating 6 ounces of 30 minutes or less each day, then you should be eating 6 ounces of grains, 2.5 cups of vegetables, 1.5 cups of fruits, 3 cups of milk and grains, 2.5 cups of vegetables, 1.5 cups of fruits, 3 cups of milk and about 5 ounces of meats & beans, each day. about 5 ounces of meats & beans, each day. If you are between the ages of 14 and 17 and work out about 30 If you are between the ages of 14 and 17 and work out about 30 minutes to and hour a day then you should be eating about 6 minutes to and hour a day then you should be eating about 6 ounces of grains, 2.5 cups of vegetables, 2 cups of fruits, 3 cups of ounces of grains, 2.5 cups of vegetables, 2 cups of fruits, 3 cups of milk and 5.5 ounces of meats and beans. milk and 5.5 ounces of meats and beans.

CONTINUEDCONTINUEDIf you are between the ages of 14 and 17 and work out for and hour If you are between the ages of 14 and 17 and work out for and hour or more each day then you should eat about 8 ounces of grains, 3 or more each day then you should eat about 8 ounces of grains, 3 cups of vegetables, 2 cups of fruit, 3 cups of milk, and 6.5 ounces of cups of vegetables, 2 cups of fruit, 3 cups of milk, and 6.5 ounces of meat and beans. meat and beans. Obesity: Obesity refers specifically to having an abnormally high Obesity: Obesity refers specifically to having an abnormally high proportion of body fat. Individuals with a BMI of 30 or more are proportion of body fat. Individuals with a BMI of 30 or more are considered obese.considered obese.BMI-A measurement of the relative percentages of fat and muscle BMI-A measurement of the relative percentages of fat and muscle mass in the human body, in which weight in kilograms is divided by mass in the human body, in which weight in kilograms is divided by height in meters and the result used as an index of obesity.height in meters and the result used as an index of obesity.About 15.5 percent of children between the ages of 12 and 19 were About 15.5 percent of children between the ages of 12 and 19 were overweight in 2000.overweight in 2000.About 63% teen girls have NEVER been on a diet.About 63% teen girls have NEVER been on a diet.About 28% of men and 27% of women ages 16-24 are overweight About 28% of men and 27% of women ages 16-24 are overweight or obese. or obese. If your calorie intake is too low, then you could actually be sending If your calorie intake is too low, then you could actually be sending your body into “starvation mode” which could slow down your your body into “starvation mode” which could slow down your metabolism and you may not lose weight at all.metabolism and you may not lose weight at all.

DATA COLLECTED BY THE NATIONAL CENTER FOR HEALTH DATA COLLECTED BY THE NATIONAL CENTER FOR HEALTH STATISTICSSTATISTICS

STATISTICSSTATISTICS

Condition Number of People (Millions) Percentage

Overweight 57.3 32.6

Obese 39.8 22.3

Healthy weight 73.2 41.2

Adult Statistics of Healthy and Overweight (millions)

Overweight

Obese

Healthy weight

REFERENCESREFERENCES

www.peanut-institute.org/obestiy-stuats-pr.www.peanut-institute.org/obestiy-stuats-pr.htmlhtml

www.mypyramid.govwww.mypyramid.gov

www.google.comwww.google.com

www.facts.comwww.facts.com

http://kidshealth.org/teen/food_fitness/http://kidshealth.org/teen/food_fitness/nutrition/fat_calories.htmlnutrition/fat_calories.html