Introduction
Firstly,
we must know how to used Microsoft word and excel. We are asked by our
instructor to do IT assignment. It is about nutritional information of any food
that I had choosen.We are also can find the nutritional information just
searching on the internet so that it can be more easier to get. After that, I
have to identify 15 types of food (any kinds of food) and we must record the
serving size, fat in grams and calories.
Nutritional Information
Nutrition
(also called nourishment or aliment) is the provision, to cells and organisms, of the materials necessary
(in the form of food) to support life.
Many common health problems can be prevented or alleviated with a healthy diet.
The diet of an organism is what it eats, which is
largely determined by the perceived palatability
of foods. Dietitians are health professionals
who specialize in human nutrition,
meal planning, economics, and preparation. They are trained to provide safe,
evidence-based dietary advice and management to individuals (in health and
disease), as well as to institutions. Clinical nutritionists
are health professionals who focus more specifically on the role of nutrition
in chronic disease, including possible prevention or remediation by addressing
nutritional deficiencies before resorting to drugs.
The nutrition
facts label (also known as the nutrition
information panel, and various other slight variations) is a label
required on most packaged food in many countries.
Here
is my assignment according to the nutritional workbook task 1(Data Collection).Its has been arranged in a perfect Microsoft
excel.
Nutritional Information
|
|||
Meal
|
Serving Size
|
Fat(Grams)
|
Calories
|
Pineapple Cubes(heavy syrup)
|
4
|
0
|
72
|
Fried baby clam with Chili
|
1
|
2.2
|
10
|
Ayam Brand Tuna Mayones
|
4
|
5
|
0
|
Chicken curry with potatoes
|
2
|
7.9
|
0
|
Apollo chocolate layer cake
|
1
|
22.7
|
0
|
Oat krunch
|
1
|
19
|
16
|
Fried Sardines in chili sauce
|
16
|
6
|
150
|
Nasi lemak(Sambal,egg,Chicken)
|
2
|
35
|
802
|
Fish Oil Sardines in Tomato
|
1
|
218
|
1966.4
|
Fried Chicken(thigh, meat only)
|
1
|
3.2
|
67.6
|
Beef Curry(Homemade)
|
1
|
13
|
261
|
Sardines in Tomato
|
5
|
11.9
|
197
|
Chicken Curry
|
0.2
|
8.6
|
160
|
Beef Rendang Curry
|
200
|
33
|
650
|
Mi Sedaap
|
1
|
17
|
0
|
Task
2, its vLookUp.
All the information data of nutritional facts had been entered to Microsoft
Excel spreadsheet. Here, I have been used formula to get the total of fat (grams)
and calories. Formula I had used to calculate are listed below:-
=(B3*C3)
means to find the total of fat(grams)
=(B3*D3)
means to get the total calories and then followed by other.
=(Grams
of fat*9/Total calories per serving)*100 means to calculate the percentage of calories from fat.
Here
show the percentage of calories from fat is less than 2, the cell with blue
shading else with green shading.
Task
3, Charts
show the fat (grams) and calories of all food that I have stated as above.
Another chart
that shows the percentage of calories from fat calculated.
Conclusion
From all what I
had gain is, it make me more understanding and more new knowledge that I
haven’t done it before this. This is much challenging to me even thought it
looks simple but to me it’s hard and creativities are very useful here.
My difficulty is
when I’m gonna to do the chart, if some data or information missing then your
chart also can be made. If the chart creates, may be it look weird and none of
the question want.
References
·
Notes
IT about how to use excel
·
WWW.Nutrition.htm
·
WWW.nutrition.asp.htm
·
WWW.Nutrition_facts_label.htm
