Saturday, June 16, 2007

Part B: Database Usage for Teaching and Learning

Science Lesson Plan: Finding Out About Dinosaurs
Objective: Students will create a dinosaur database, learn about dinosaurs, sort alphabetically, practice using Boolean operators, and sort by number.

Materials: Dinosaur Database Form, Microsoft Access, and a 1 Computer per group (3 students per group).

Procedures:
1. Have each group read about a dinosaur.
2. After the reading the assignment is completed, have each student fill out the dinosaur database form. The Dinosaur Database Form fields will include Name, Habitat, Food, Feet, and Armored.
3. Instruct each group to enter their information on the same data file disk.
4. After the task has been completed, have the groups do the following:
a. Sort the file by the number of feet in the field, highest to lowest.
b. Using the Boolean operator and, find out if there are any two-legged plant eaters and any four-legged meat eaters.
c. Sort alphabetically by name and print out the list.


1 comment:

Shawndra Johnson said...

Very cool use of sorting and filters in this lesson. The results will probably encourage questions, discussions and critical thinking in your students!