Cereal Database
Cereal Information
Description: Students will gather information
on 20 different breakfast cereals on the market today. Then, they will create a
database, design the table, insert the data into the table through a Form, run
some queries and then finally make a report.
Number of records to
gather:25
Use these links to
gather your data:
Field Names:
1. Name: Name of Cereal
2. mfr: Manufacturer
of cereal where A = American Home Food Products; G = General Mills; K = Kelloggs; N = Nabisco; P = Post; Q = Quaker Oats; R =
Ralston Purina
3. type: cold or
hot
4. calories:
calories per serving
5. protein: grams
of protein
6. fat: grams of
fat
7. sodium:
milligrams of sodium
8. fiber: grams of
dietary fiber
9. carbo:
grams of complex carbohydrates
10. sugars: grams
of sugars
11. potass:
milligrams of potassium
12. vitamins: vitamins
and minerals - 0, 25, or 100, indicating the typical percentage of FDA
recommended
13. weight: weight
in ounces of one serving
14. cups: number of
cups in one serving Sort the cereals in the table by their calories, from
highest to lowest.
Create queries to answer the following questions: Type your answers to
the questions in Microsoft Word
- Too much sugar and fat are not good for your body.
Too much of both over a long period of time can lead to cancer and heart
disease, the two leading causes of death in the United States. What
three cereals have the most sugar AND how much fat, vitamins and calories
does each one have.
- What three cereals have the lowest amount of
fat, how much sugar, vitamins and calories does each one have?
- Dietary fiber is important to good heath. In addition
to keeping you "regular", it reduces the chance of colon cancer,
which is now one of the top ten causes of death in the United States.
Which 3 cereals have the most fiber and how much carbohydrates,
potassium and vitamins does each one have?
- Vitamins are also important for good health. Some
vitamins help with memory, strength, cancer prevention and energy. Create
a QUERY which selects only those cereals which have no fat (zero), no
sodium (zero), but at least 25% of the daily vitamins recommended by the
FDA.
- If you were to eat cereal or if you do eat
cereal, which types would you choose to eat?
- How healthy for you is the cereal that you eat
or would eat?
- Knowing what you know now about cereals and vitamins,
fiber, and sugar and fat, would you change your cereal eating habits?
WHY or WHY NOT?
Turn in your assignment into the Shares Folder.
Created by Keith
Jain, Westview High School