Auburn University-Montgomery Graph Nutrients Analysis With the two reports in hand (seen Spread sheet and bar graph report), take some time to analyze and

Auburn University-Montgomery Graph Nutrients Analysis With the two reports in hand (seen Spread sheet and bar graph report), take some time to analyze and appraise the nutritional merits of this meal, focusing exclusively on macronutrients and fiber. The Spreadsheet report lists the number of calories and grams of selected nutrients contained within each ingredient; the Bar Graph report summarizes the number of calories and grams of selected nutrients within a single serving. You are expected to extract the most relevant numerical data and present these in a table. Note, that your table should reflect the extent of your analysis of the reports and relevant concepts learned within the course. In addition to your table, you may also include one graph (i.e. this graph is not required). The data you select to present in your table (and graph) will form the basis of your write up.

Your written report must adhere to the following structure with section headings and title:

1. Introduction. Begin with a brief introduction to the topic of nutrition followed by clearly defining the diversity and importance of macronutrients. End your introduction by clearly articulating the objectives of your written report.

2. Main Body. The main body will contain your analysis of the data. Your table belongs in this section. In this section, you are not simply repeating in words the numbers listed in your table. The write up should focus on the overall composition of the meal – not how well it meets your recommended intake requirements. In other words, I don’t want your report to be about how you can’t tolerate some foods, or how much you exercise. In your write-up, you are analysing and appraising the diversity (different types) and richness (the amounts) of macronutrients in this meal; and will ultimately reflect the knowledge you’ve acquired in this course.

**Note that you may also choose to generate “Single Nutrient Reports”; this can offer additional data that can be used in your write-up**

Remember that your table (and graph) must include a descriptive title and units. Where applicable, labels and legend. Please peruse magazine articles, books, etc. to get familiar with what an appropriate descriptive title looks like.

3. Conclusion. This will be a brief synopsis (one paragraph) of your most relevant findings and can include suggestions of how to improve the meal.

(12 font Times New Roman with 1 inch margins) Bar Graph Report
The Bar Graph Report displays graphically the amount of the nutrient consumed and compares that to the
dietary intake recommendations.
Profile Info
Personal: assignment Female 24 yrs 160 cm
120 lb
Day(s): 2020 May 28 (Dinner)
Activity Level: Sedentary
(Strive for an Active activity level.)
BMI: 21.3
Normal is 18.5 to 25.
Weight Change: Lose 1 lb per week
Best not to exceed 2 lbs per week.
Nutrient
Value
Basic Components
Calories
Calories from Fat
Calories from SatFat
Protein (g)
Protein (% Calories)
Carbohydrates (g)
Carbohydrates (% Calories)
Total Sugars (g)
Dietary Fiber (g)
Soluble Fiber (g)
InSoluble Fiber (g)
Fat (g)
Fat (% Calories)
Saturated Fat (g)
Trans Fat (g)
Mono Fat (g)
Poly Fat (g)
Cholesterol (mg)
Water (g)
461.55
139.30
19.69
20.08
17.40
65.27
56.57
7.78 ^
17.49
5.98
8.75
15.48
30.18
2.19
0.00
10.91
1.98
0.00
391.83
Vitamins
Vitamin A – RAE (mcg)
Vitamin B1 – Thiamin (mg)
Vitamin B2 – Riboflavin (mg)
Vitamin B3 – Niacin (mg)
Vitamin B6 (mg)
Vitamin B12 (mcg)
Vitamin C (mg)
Vitamin D – mcg (mcg)
Vitamin E – a-Toco (mg)
Folate (mcg)
Minerals
DRI Goal
1,359.38
380.63
122.34
43.54 *
12.81 *
186.91
55.00
19.03
42.29
28.00
13.59 ~
Percent 0
34
37
16
46
136
35
103
%
%
%
%
%
%
%
92 %
37 %
108 %
16 %
15.10
13.59
300.00 ~
2,700.00
72
15
0
15
%
%
%
%
516.23
0.46
0.26
2.94
0.66
0.00
44.32
0.00
3.89
700.00
1.10
1.10
14.00
1.30
2.40
75.00
15.00
15.00
74
42
23
21
50
0
59
0
26
%
%
%
%
%
%
%
%
%
289.21
400.00
72 %
50
100
150
Calcium (mg)
Iron (mg)
Magnesium (mg)
Phosphorus (mg)
Potassium (mg)
Sodium (mg)
Zinc (mg)
Other
Omega-3 (g)
Omega-6 (g)
Alcohol (g)
Caffeine (mg)
182.63
6.56
158.53
342.51
1,623.63
257.15
2.53
1,000.00
18.00
310.00
700.00
2,600.00
2,300.00 ~
8.00
18
36
51
49
62
11
32
%
%
%
%
%
%
%
0.45 +
1.49 +
0.00
0.00
* Protein is not adjusted for endurance/strength athletes at an Active or Very Active activity level.
^ Total Sugars includes those naturally occuring in food and added sugars.
~ This value is a recommended consumption limit, not a goal.
+ There is no established recommendation for Omega-3 and Omega-6.
5/28/20 1:01 PM
Page 2 of
2
Spreadsheet Report
The Spreadsheet shows all the values for all nutrients. Nutrients are displayed horizontally, with totals at the
bottom of the list.
Profile Info
Personal: assignment Female 24 yrs 160 cm
120 lb
Day(s): 2020 May 28 (Dinner)
Activity Level: Sedentary
(Strive for an Active activity level.)
BMI: 21.3
Normal is 18.5 to 25.
Weight Change: Lose 1 lb per week
Best not to exceed 2 lbs per week.
Day
Thu 0528-2020
Meal
Item
Amount
Cals
FatCal
SatFatCal
Prot (g)
Dinner
garlic cloves, fresh (USDA)
0.2 ea
1.1
0.0
0.0
0.0
sage, fresh (British Food
0.5 Tbs
1.2
0.4
oil, olive, extra virgin (Natural
1 Tbs
126.0
126.0
17.6
0.0
onion, yellow, fresh, chopped
0.2 cup
16.0
0.4
0.2
0.4
carrots, fresh, medium (USDA)
0.2 ea
6.3
0.3
0.1
0.1
cabbage, savoy, boiled, drained,
0.2 cup
8.7
0.3
0.0
0.7
chard, swiss, boiled, drained,
0.2 cup
8.8
0.3
0.0
0.8
kale, boiled, drained (USDA)
0.2 cup
9.1
1.2
0.2
0.6
tomatoes, crushed, canned
0.2 cup
19.4
1.5
0.2
1.0
1 cup
224.8
8.0
1.2
15.3
potato, boiled, peeled, diced
0.2 cup
33.5
0.4
0.1
0.7
celery, boiled, drained, diced
0.2 cup
6.8
0.5
0.1
0.3
kidney beans, boiled (USDA)
Day
Thu 0528-2020
Meal
Item
Dinner
0.0
Day Total
—
461.6
139.3
19.7
20.1
Average Day Total
—
461.6
139.3
19.7
20.1
Fib-S (g)
Fib-I (g)
Fat (g)
Carbs (g)
Sugr^ (g)
Fiber (g)
garlic cloves, fresh (USDA)
0.2
0.0
0.0
sage, fresh (British Food
0.2
oil, olive, extra virgin (Natural
0.0
0.0
0.0
onion, yellow, fresh, chopped
3.7
1.7
0.7
carrots, fresh, medium (USDA)
1.5
0.7
0.4
0.2
0.2
0.0
cabbage, savoy, boiled, drained,
2.0
1.0
0.5
0.5
0.0
chard, swiss, boiled, drained,
1.8
0.5
0.9
kale, boiled, drained (USDA)
1.8
0.4
0.7
0.3
0.4
tomatoes, crushed, canned
4.4
2.7
1.1
kidney beans, boiled (USDA)
40.4
0.6
11.3
4.6
6.7
0.9
potato, boiled, peeled, diced
7.8
0.3
0.7
0.3
0.4
0.0
celery, boiled, drained, diced
1.5
0.9
0.6
0.1
0.5
0.1
Day Total
65.3
7.8
17.5
6.0
8.7
15.5
Average Day Total
65.3
7.8
17.5
6.0
8.7
15.5
0.0
0.0
0.0
0.0
14.0
0.0
0.0
0.1
0.2
Day
Thu 0528-2020
Meal
Item
Dinner
garlic cloves, fresh (USDA)
Fat-S (g)
Fat-T (g)
Fat-M (g)
Fat-P (g)
Chol (mg)
Water (g)
0.0
0.0
0.0
0.0
0.0
0.4
sage, fresh (British Food
0.0
oil, olive, extra virgin (Natural
2.0
onion, yellow, fresh, chopped
0.0
carrots, fresh, medium (USDA)
0.0
cabbage, savoy, boiled, drained,
0.7
10.8
1.3
0.0
0.0
0.0
0.0
0.0
0.0
35.6
0.0
0.0
0.0
0.0
13.5
0.0
0.0
0.0
0.0
0.0
33.4
chard, swiss, boiled, drained,
0.0
0.0
0.0
0.0
0.0
40.5
kale, boiled, drained (USDA)
0.0
0.0
0.0
0.1
0.0
29.6
tomatoes, crushed, canned
0.0
0.0
0.0
0.1
0.0
54.1
kidney beans, boiled (USDA)
0.1
0.0
0.1
0.5
0.0
118.5
potato, boiled, peeled, diced
0.0
0.0
0.0
0.0
0.0
30.2
celery, boiled, drained, diced
0.0
0.0
0.0
0.0
0.0
35.3
Day Total
2.2
0.0
10.9
2.0
0.0
391.8
Average Day Total
2.2
0.0
10.9
2.0
0.0
391.8
A-RAE(mcg)
B1 (mg)
B2 (mg)
B3 (mg)
B6 (mg)
B12 (mcg)
0.0
0.0
0.0
0.0
Day
Meal
Item
Thu 0528-2020
Dinner
garlic cloves, fresh (USDA)
0.0
0.0
sage, fresh (British Food
1.1
0.0
0.0
0.0
0.0
0.0
0.0
0.0
127.4
0.0
0.0
0.1
0.0
0.0
16.1
0.0
0.0
0.0
0.1
0.0
chard, swiss, boiled, drained,
134.0
0.0
0.0
0.2
0.0
0.0
kale, boiled, drained (USDA)
221.3
0.0
0.0
0.2
0.0
0.0
tomatoes, crushed, canned
6.5
0.0
0.0
0.7
0.1
0.0
kidney beans, boiled (USDA)
0.0
0.3
0.1
1.0
0.2
0.0
potato, boiled, peeled, diced
0.0
0.0
0.0
0.5
0.1
0.0
celery, boiled, drained, diced
9.8
0.0
0.0
0.1
0.0
0.0
Day Total
516.2
0.5
0.3
2.9
0.7
0.0
Average Day Total
516.2
0.5
0.3
2.9
0.7
0.0
D (mcg) E-Toco (mg) Fola (mcg)
Calc (mg)
Iron (mg)
1.4
0.0
0.0
oil, olive, extra virgin (Natural
onion, yellow, fresh, chopped
carrots, fresh, medium (USDA)
cabbage, savoy, boiled, drained,
Day
Meal
Item
Thu 0528-2020
Dinner
garlic cloves, fresh (USDA)
C (mg)
0.2
sage, fresh (British Food
0.0
0.0
0.0
0.0
oil, olive, extra virgin (Natural
6.0
1.7
onion, yellow, fresh, chopped
3.0
0.0
0.0
7.6
9.2
0.1
carrots, fresh, medium (USDA)
0.9
0.0
0.1
2.9
5.0
0.0
cabbage, savoy, boiled, drained,
6.2
0.0
16.7
10.9
0.1
chard, swiss, boiled, drained,
7.9
0.0
0.8
3.9
25.4
1.0
kale, boiled, drained (USDA)
13.3
0.0
0.3
4.2
23.4
0.3
tomatoes, crushed, canned
5.6
0.0
0.8
7.9
20.6
0.8
kidney beans, boiled (USDA)
2.1
0.0
0.1
230.1
62.0
3.9
potato, boiled, peeled, diced
2.9
0.0
0.0
3.5
3.1
0.1
celery, boiled, drained, diced
2.3
0.0
0.1
12.4
15.8
0.2
Day Total
44.3
0.0
3.9
289.2
182.6
6.6
Average Day Total
44.3
0.0
3.9
289.2
182.6
6.6
Zinc (mg) Omega3 (g)
Day
Meal
Item
Thu 0528-2020
Dinner
garlic cloves, fresh (USDA)
0.2
1.1
3.0
0.1
0.0
sage, fresh (British Food
1.6
0.3
3.9
0.0
0.0
onion, yellow, fresh, chopped
4.0
11.6
58.4
1.6
0.1
0.0
carrots, fresh, medium (USDA)
1.8
5.3
48.8
10.5
0.0
0.0
cabbage, savoy, boiled, drained,
8.7
12.0
66.7
8.7
0.1
0.0
chard, swiss, boiled, drained,
37.6
14.4
240.2
78.3
0.1
0.0
kale, boiled, drained (USDA)
5.8
9.1
74.1
7.5
0.1
0.0
tomatoes, crushed, canned
12.1
19.4
177.3
112.5
0.2
0.0
kidney beans, boiled (USDA)
74.3
244.3
716.9
1.8
1.8
0.3
potato, boiled, peeled, diced
7.8
15.6
127.9
1.9
0.1
0.0
celery, boiled, drained, diced
4.5
9.4
106.5
34.1
0.1
0.0
Day Total
158.5
342.5
1623.6
257.2
2.5
0.5
Average Day Total
158.5
342.5
1623.6
257.2
2.5
0.5
Omega6 (g)
Alc (g)
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
Magn (mg)
Phos (mg) Potas (mg)
Sod (mg)
oil, olive, extra virgin (Natural
Day
Meal
Item
Thu 0528-2020
Dinner
garlic cloves, fresh (USDA)
0.0
0.1
sage, fresh (British Food
Caff (mg) MyFrt (cup) MyDry (cup) MyGrn (oz
eq)
oil, olive, extra virgin (Natural
1.1
0.0
0.0
0.0
0.0
0.0
onion, yellow, fresh, chopped
0.0
0.0
0.0
0.0
0.0
0.0
carrots, fresh, medium (USDA)
0.0
0.0
0.0
0.0
0.0
0.0
cabbage, savoy, boiled, drained,
0.0
0.0
0.0
0.0
0.0
0.0
chard, swiss, boiled, drained,
0.0
0.0
0.0
0.0
0.0
0.0
kale, boiled, drained (USDA)
0.0
0.0
0.0
0.0
0.0
0.0
tomatoes, crushed, canned
0.1
0.0
0.0
0.0
0.0
0.0
kidney beans, boiled (USDA)
0.2
0.0
0.0
0.0
0.0
0.0
potato, boiled, peeled, diced
0.0
0.0
0.0
0.0
0.0
0.0
celery, boiled, drained, diced
0.0
0.0
0.0
0.0
0.0
0.0
Day Total
1.5
0.0
0.0
0.0
0.0
0.0
Average Day Total
1.5
0.0
0.0
0.0
0.0
0.0
MyVeg MyProt (oz
(cup)
eq)
XxFruit
XxOCarb
XxStarch
XxVeg
Day
Meal
Item
Thu 0528-2020
Dinner
garlic cloves, fresh (USDA)
0.0
0.0
0.0
0.0
0.0
0.0
sage, fresh (British Food
0.0
0.0
0.0
0.0
0.0
0.0
oil, olive, extra virgin (Natural
0.0
0.0
0.0
0.0
0.0
0.0
onion, yellow, fresh, chopped
0.3
0.0
0.0
0.0
0.0
0.7
carrots, fresh, medium (USDA)
0.1
0.0
0.0
0.0
0.0
0.3
cabbage, savoy, boiled, drained,
0.3
0.0
0.0
0.0
0.0
0.4
chard, swiss, boiled, drained,
0.2
0.0
0.0
0.0
0.0
0.4
kale, boiled, drained (USDA)
0.3
0.0
0.0
0.0
0.0
0.4
tomatoes, crushed, canned
0.2
0.0
0.0
0.0
0.0
0.9
kidney beans, boiled (USDA)
0.0
4.0
0.0
0.0
2.7
0.0
potato, boiled, peeled, diced
0.2
0.0
0.0
0.0
0.5
0.0
celery, boiled, drained, diced
0.3
0.0
0.0
0.0
0.0
0.3
1.9
4.0
0.0
0.0
3.2
3.4
Day Total
Day
Meal
MyVeg MyProt (oz
(cup)
eq)
Item
Average Day Total
Day
Thu 0528-2020
1.9
XxFruit
XxOCarb
XxStarch
XxVeg
0.0
0.0
3.2
3.4
XxAlc XxNoFtMlk
XxLnMeat
4.0
Meal
Item
Dinner
garlic cloves, fresh (USDA)
0.0
0.0
0.0
0.0
sage, fresh (British Food
0.0
0.0
0.0
0.0
oil, olive, extra virgin (Natural
2.8
0.0
0.0
0.0
onion, yellow, fresh, chopped
0.0
0.0
0.0
0.0
carrots, fresh, medium (USDA)
0.0
cabbage, savoy, boiled, drained,
0.0
chard, swiss, boiled, drained,
0.0
0.0
0.0
0.0
kale, boiled, drained (USDA)
0.0
tomatoes, crushed, canned
0.0
0.0
0.0
0.0
kidney beans, boiled (USDA)
0.0
potato, boiled, peeled, diced
0.0
celery, boiled, drained, diced
0.0
XxFat
Day Total
2.8
0.0
0.0
0.0
Average Day Total
2.8
0.0
0.0
0.0
^ Total Sugars includes those naturally occuring in food and added sugars.
5/28/20 1:00 PM
Page 4 of
4
Single Nutrient Report
The Single Nutrient Report shows a sorted list of foods based on how they contribute to the total for one nutrient.
Profile Info
Personal: assignment Female 24 yrs
Day(s): 2020 May 28 (Dinner)
Activity Level: Sedentary
BMI: 21.3
Weight Change: Lose 1 lb per week
160 cm
120 lb
(Strive for an Active activity level.)
Normal is 18.5 to 25.
Best not to exceed 2 lbs per week.
Calories
Amount
Item
Cals
0
1.00 cup
1.00 Tbs
0.25 cup
kidney beans, boiled (USDA)
oil, olive, extra virgin (Natural Oils)
potato, boiled, peeled, diced (USDA)
224.79
126.00
33.54
49 %
27 %
7%
0.25 cup
0.25 cup
tomatoes, crushed, canned (USDA)
onion, yellow, fresh, chopped (USDA)
19.36
16.00
4%
3%
0.25 cup
0.25 cup
kale, boiled, drained (USDA)
chard, swiss, boiled, drained,
chopped (USDA)
cabbage, savoy, boiled, drained,
shredded (USDA)
celery, boiled, drained, diced (USDA)
9.10
8.75
2%
2%
8.70
2%
6.75
1%
carrots, fresh, medium (USDA)
sage, fresh (British Food
Composition: Vegetables Herbs &
Spices)
garlic cloves, fresh (USDA)
6.25
1.19
1%
0%
1.12
0%
0.25 cup
0.25 cup
0.25 ea
0.50 Tbs
0.25 ea
Total
5/28/20 1:34 PM
461.55
25
50
75
100
100%
Page 1 of
1

Purchase answer to see full
attachment