Third, Fourth, and Fifth Grade Lesson Plans:
Monday -
No School
(Ms. Young)
Tuesday -
Ms. Counts,
Ms. Gilmer
Mr. Achor
Wednesday -
Ms. Lee
Thursday -
Ms. Deleon,
Ms. Luten, and
Ms. Masopust
Friday -
Ms. Sexton and
Ms. L. White
|
Continuation of Unit 2 - World Wildlife: Orange
PC Lesson Two - Parts Two and Three .
Description
of the Unit:
In
World Wildlife, the second of five units, the children use a
database application to identify and locate an animal missing from the
World Wildlife Zoo. They are introduced to basic database
functions in the first lesson as they sort a list of zoo animals.
In the lessons that follow, they enter information into new records, and
format database tables and forms. By filtering these accumulated
data, they discover why the animal escaped and determine where to locate
it. In the process, the students use their desktop publishing
skills to create a MISSING! poster and a newsletter reporting the
animal's safe return to the zoo.
Lesson Two ~
After transferring data from a desktop publishing document to a database
table, the students will organize the table by labeling fields and
sorting records. They will also perform a filter and register the
penguin as a missing animal by adding its information to the table.
Finally, they will design a MISSING! Poster to help begin the search for
the missing penguin.
Materials
~
-
Microsoft Publisher 2000
-
Microsoft Access 2000
Opening ~ Review Lesson Two Part One. Remind the
children that they used both the database table and diagram to determine
the identity of the animal missing from the World Wildlife Zoo.
Remind them that we discovered that the Emperor Penguin was missing from
the World Wildlife Zoo.
Discuss the use of Microsoft
Access used last class period to recreate the registry of missing
animals.
This lesson will have you
reporting a missing zoo animal by entering its information in a registry
of missing animals. Then you will design a MISSING! poster
identifying the animal and indicating where to return it if it is found.
Steps Covered in the Lesson ~
-
Introduce the activity
-
Launch the Microsoft Access document "REGISTRY"
from the students' individual files
-
Create a new form in access
-
Select the fields for the form
-
Choose a colorful style
-
Save and close the form
-
Return to the Registry table
-
Discuss the importance of the
table
-
Define FILTER - a
database function that can be used to locate and display only those
records that match specific information in one or more fields
-
Perform a filter to locate cat
entries
-
Discuss the results of the
filter
-
Discuss the purpose of a
multiple-field filter
-
Remover the previous filter
-
Perform a multiple-field filter
to locate male cats
-
Discuss the results of the
filter
-
Remove the filter
-
Scroll to the bottom of the
table
-
Register the penguin by entering
the type of animal, description, date, name, lost from, and detective
name into the registry
-
Adjust the width of columns as
needed
-
Sort the table in ascending
order
-
Introduce the next activity
-
Save and Close the table
-
Close the database
-
Exit Access
-
Launch Publisher and open the "MISSING.PUB"
template
-
Read the text aloud
-
Enter today's date
-
Create a text frame
-
Change the font size
-
Change the font
-
Press the caps lock key
and enter "MISSING!"
-
Turn off the caps lock key
-
Align the text frames
-
Create a page border
-
Apply a bottom border to the
MISSING text frame
-
Save and close the file
-
Exit Publisher
-
Review the lesson
|