Computer Skills Curriculum
Database Lesson Plan
Title: And the Planet Isˇˇ
Other Curriculum Objectives that can be addressed by this lesson plan
English Language Arts 2.1,
2.2, 4.1; Science: (Gr. 6) 3.3, 5.2; Computer Skills: (Gr. 5) 2.2, (Gr. 6) 3.2;
Information Skills 1.3, 1.4, 1.5,
Competency 3.2: Use a database to search for desired information, given one
criterion and given two criteria (using "and" or "or" connectors where
Measure 3.2.3: Use a prepared solar system database to search for planets with
moons and with oxygen.
Materials Needed: Pre-activity: Prepared database file of solar system.
Activities: 3 jars or see-through containers; 3 sets of colored objects (plastic eggs,
candy, blocks, etc.) such that the third set is a combination of the other 2 colors;
prepared database file of solar system; media center or class material; index cards
labeled with search criteria, connectors, relationship phrases, and the words "no
Time: One class session.
Terms: File, Record, Field, Search, And, Or
- 1. Review the fields of the prepared database file on the solar system.
- 2. Practice searching each field using different relationships of equal to, greater
than, less than, etc.
- 3. Study the difference in the connectors "and" and "or."
- 4. Collect the necessary supplies for the non-computer activity.
Teacher Preparation with Media Professional
- 1. Locate the media center resources that contain the information needed for the
- 2. Plan for the students to use the resources in the media center or in the classroom.
- 1. Define the database function search: a process of selecting all database records that
satisfy a statement, rule, or criterion.
- 2. Ask the students to stand beside their seat if they satisfy the criterion you call
out (e.g., rode a bus to school that morning, have brown eyes, have a sister, brought
their lunch today). Identify this search relationship as "equal to." Discuss
other relationships provided as selection choices by your database program.
- 3. Introduce the concept of selecting records using the connector "or": all
records that satisfy either one criterion or both criteria. Use three see-through
containers. Fill one with one color of objects and a second with objects of another color.
Mix some of the third set (ones with a combination of the 2 colors) into each container.
(Object examples: orange candy, white candy, orange/white candy corn.)
- 4. Place the third container labeled "or" between the other two containers.
- 5. Ask students to decide what objects should go in the "or" container if it
is the collection of all objects satisfying one container or the other. (Answer: all
- 6. Introduce the concept of selecting records using the connector "and": all
records that satisfy both criteria. Use the same three see-through containers of step 3
but label the third container "and."
- 7. Ask the students to decide what objects should go in the "and" container if
it is the collection of all objects satisfying both containers. (Answer: only the objects
with both colors.)
(Pair students to test their database searching skills.) Given a prepared database of
the solar system and a stack of cards or a cube marked "and," "or," or
"no connector," draw a card (or roll the cube) to determine the type of search
to complete for planets with more than one moon; use planets with oxygen if a second
criterion is needed. Record your search criteria, connector, and resulting data.