1 / 21

INVESTIGATING A REAL LIFE APPLICATION USING EXCEL

INVESTIGATING A REAL LIFE APPLICATION USING EXCEL. BY: CYNTHIA FRANQUI AND AMBER RAMIREZ. Task 1: Compare the old and new food pyramid.

halee-mcdowell
Download Presentation

INVESTIGATING A REAL LIFE APPLICATION USING EXCEL

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. INVESTIGATING A REAL LIFE APPLICATION USING EXCEL BY: CYNTHIA FRANQUI AND AMBER RAMIREZ

  2. Task 1: Compare the old and new food pyramid. • Task 2: To hand out a survey and see how many people meet the requirements of the new food pyramid.

  3. THE “OLD” FOOD PYRAMID

  4. THE “NEW” FOOD PYRAMID

  5. DIFFERENT FOOD PYRAMIDS

  6. Healthy Eating Based on the Food Guide Pyramid • Bread, Cereal, Rice, and Pasta6-11 servings a day 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 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 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 rice, 1/2 cup cooked pasta.Vegetables3-5 servings a dayVegetables 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 cabbage and pepper families (broccoli, Brussels sprouts, cabbage, bell peppers) are surprisingly rich in vitamin C. 1 serving = 1 cup raw leafy greens, 1/2 cup any other chopped vegetable, 3/4 cup vegetable juiceFruits2-4 servings a dayFruit 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 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 syrup.1 serving = 1 medium apple, banana, or orange; 1/2 cup chopped fruit or berries; 3/4 cup fruit juice.

  7. Milk, Yogurt, and Cheese2-4 servings a dayWe'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 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 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.Meat, Poultry, Fish, Dry Beans, Eggs, and Nuts2-3 servings a dayThis 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 absorbable trace minerals like iron, zinc, and magnese. Poultry and seafood contribute vitamin B6, 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 tablespoons peanut butter, nuts, or seeds.Fats, Oils, and SweetsUse sparinglyThis 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 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 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 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 a rich source of iron.

  8. 1. What resources are you going to use? a. We are going to be using the internet, library, results that we get back from the survey’s and our own knowledge.

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

  10. MORE QUESTIONS • Are you concerned with your weight? • Do you eat enough veggies and fruits? • Do you try to improve your intake for a healthy one? • Have you heard about the new & improved food pyramid? • Has you eating habits changed in the last 2 years?

  11. SURVEY RESULTS

  12. INFORMATION • The grain category, is made up of breads, cereal, rice, and pasta. The vegetables are made up of tomatoes, potatoes, lettuce, carrots, mainly ground foods. The fruit category is made up of plant products, usually sweet and having a pit. The meats and beans category is made up of your meats, of course, but also fish poultry, eggs, nuts and beans or dry beans. • 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 grains, 2.5 cups of vegetables, 1.5 cups of fruits, 3 cups of milk and about 5 ounces of meats & beans, each day. • 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 ounces of grains, 2.5 cups of vegetables, 2 cups of fruits, 3 cups of milk and 5.5 ounces of meats and beans.

  13. CONTINUED • 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 cups of vegetables, 2 cups of fruit, 3 cups of milk, and 6.5 ounces of meat and beans. • Obesity: Obesity refers specifically to having an abnormally high proportion of body fat. Individuals with a BMI of 30 or more are considered obese. • BMI-A measurement of the relative percentages of fat and muscle 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. • About 15.5 percent of children between the ages of 12 and 19 were overweight in 2000. • About 63% teen girls have NEVER been on a diet. • About 28% of men and 27% of women ages 16-24 are overweight or obese. • If your calorie intake is too low, then you could actually be sending your body into “starvation mode” which could slow down your metabolism and you may not lose weight at all.

  14. DATA COLLECTED BY THE NATIONAL CENTER FOR HEALTH STATISTICS

  15. STATISTICS

  16. REFERENCES • www.peanut-institute.org/obestiy-stuats-pr.html • www.mypyramid.gov • www.google.com • www.facts.com • http://kidshealth.org/teen/food_fitness/nutrition/fat_calories.html

More Related