21 Things: Thing 13. Quest 7 "Hungry Mungry"
Introduction
In this Quest you will be examining the eating habits of a boy named Mungry as part of a case study for the Health Advisory Committee. Shel Silversteen tells us about what Mungry ate for just one meal in this poem Hungry Mungry. You will need to create a spreadsheet, a graph and chart to record what he ate from just the first stanza of the poem (it is in smaller type). You will then analyze the data and answer questions to prepare a report for the Health Advisory Committee on the eating habits of this young man.
PART 1
1. Open the Shel Silverstein poem below. (See the red button) You will be working with the first stanza (smaller print)
2. Open the chart below. (see the red button)
Begin entering the data by filling in the types of food eaten. (1st Stanza only) Continue by filling in the quantity, servings and food group for each item eaten.
PART 2: Preparing to analyze the data:
PART 3: Your Report
Prepare a report for the Health Advisory Committee regarding Hungry Mungry’s eating habits that shows your findings and includes the answers to the following questions (refer to the portion chart as needed):
Questions: (Answer these in a word document or text box on your page)
Post a screen shot of your excel chart with both pie chart and bar graph
Post a screen shot if you used a word document or your report (otherwise the text box will have the report.
Introduction
In this Quest you will be examining the eating habits of a boy named Mungry as part of a case study for the Health Advisory Committee. Shel Silversteen tells us about what Mungry ate for just one meal in this poem Hungry Mungry. You will need to create a spreadsheet, a graph and chart to record what he ate from just the first stanza of the poem (it is in smaller type). You will then analyze the data and answer questions to prepare a report for the Health Advisory Committee on the eating habits of this young man.
PART 1
1. Open the Shel Silverstein poem below. (See the red button) You will be working with the first stanza (smaller print)
2. Open the chart below. (see the red button)
Begin entering the data by filling in the types of food eaten. (1st Stanza only) Continue by filling in the quantity, servings and food group for each item eaten.
- In some cases, you may need to refer to the portion chart (red button below) to determine how many servings Hungry Mungry ate of one food. (For example: How many servings do you think a dozen stewed tomatoes should be?)
- Helpful Hints:
- A Shank = about ½ pound of meat
- A boiled ham = 10 pounds on average
PART 2: Preparing to analyze the data:
- Food Group: You will be totaling the number of servings per food group and then determine the total number of servings overall. (Use the SUM button on excel)
- You will create two charts to show the data in a visual manner. (a bar graph and a pie chart)
- Helpful Video:Visit http://www.gcflearnfree.org/excel2016 to grab the appropriate “How to” videos for your Spreadsheet tool to learn how to create Bar Graphs and Pie Charts
- Bar graph - Show total number of servings per food group. (Remember to include appropriate labels)
- Pie chart - Show percentage of servings per food group
PART 3: Your Report
Prepare a report for the Health Advisory Committee regarding Hungry Mungry’s eating habits that shows your findings and includes the answers to the following questions (refer to the portion chart as needed):
Questions: (Answer these in a word document or text box on your page)
- How many servings did Hungry Mungry eat overall?
- Did he eat a balanced meal?
- What food group(s) should he eat less of? Explain.
- What food group(s) should he eat more of? Explain.
- Choose which chart or graph gives you the best representation of Hungry Mungry’s diet.
- If Hungry Mungry had shared the food, how many people could he have fed?
Post a screen shot of your excel chart with both pie chart and bar graph
Post a screen shot if you used a word document or your report (otherwise the text box will have the report.