Lesson Plan #: AELP-NUT0003


Health Database

An AsKERIC Lesson Plan


Submitted by: Patricia Shubert
School or Affiliation: Willard Model School, Norfolk, VA

Date: 1994


Grade Level(s): 2, 3, 4, 5

Subject(s):

Major Objectives:

Materials Checklist:

Time Required: 5 initial class periods; updates, 1 hour per week

Activities and Procedures:

  1. Explain the database terms of field, record, and file. Work with the class to design a database template that includes fields such as date, day, choice of A or B lunch, and the five food groups.

  2. Enter the information from the school menus into the database. The entire class should assist during the first five days. Then students can take turns at updating the file.

  3. Have the class compose a list of questions they would like to collect answers to, and tally regarding the school lunches. They can be fun, creative, or analytical. Examples: How many times did the cafeteria serve the students' favorite lunch -- pizza? the teacher's favorite -- blueberry cobbler? How many times was liver the alternate choice to pizza? Was fish always served with french fries?

  4. Explain how to access and search a database. Have the students search the database to get answers to their questions. Have them search to determine if the cafeteria meals are balanced ones by searching for empty fields in the food groups.

  5. Update the database weekly. Re-tally and print information monthly.

Follow-Up Extension:

Have the students use graphing software or manually draw graphs. Have them write reports of findings, using word processor if available.


This lesson plan was downloaded from Big Sky Telegraph.
Telnet: 192.231.192.1