Teaching Database. Students in Prince William County,
Virginia are required to begin learning database software in grade three, and the biggest challenge
is making it meaningful and relevant. Microsoft Access is a very professional
has many features that will NEVER be needed in the elementary school setting.
Yet, it is not a bad product for the students to begin using. There is a lot of
flexibility for the students.
What to do first, teach about or use? I have always
talked to the kids about the concept of databases before letting them plunge in with
tables, records and fields. I tell them that grocery stores, banks, phone companies and even the
school systems use databases to manage the individual items of importance each day.
I start off introducing the concept of a "record" by identifying "them" as a
record in the school student data base. We go to fields by talking
of birthdays, first names, addresses, etc.
We next talk about cans of tomato sauce, and how these are probably managed in a
grocery store database. They have a bar code, a price, a vendor name etc. Phone companies
have business customers, residential customers, bills, payments, individual phone calls etc.
In these commercial companies, it is easy to get the students to realize that databases
become very big as individual transactions are treated as a record. A phone call has
a date, the phone number that made it, etc. I always teach the concept of electronic
databases and telecommunications at the same time so students can see that databases
touch our lives almost every hour of the day!
A new concept for using Microsoft Access. I learned
a different way to expose children to database from an In-Service conducted by
Priscilla Norton of
George Mason University. She recommends teaching
technology through the assignment of complicated activities that force students to become
proficient with the software in order to get the assignment done. In the minds of the
student, the end result is the most critical, yet with a properly constructed assignment,
they will have waded through a lot of technology.
The fourth grade Solar System Project, or "What
Planet are the Campers On?" In this activity, students were given:
- a database of solar system facts in Microsoft Access
- a set of letters from ficticious campers. These are futuristic campers on
planets in our solar system who are writing home to their moms and dads. Their letters
contain clues about their various planets, but of course don't say which planet they are on.
- a quick lesson about records, fields, and how to query. The students had
to use Microsoft Acess to query the data in order to determine the
whereabouts of the campers.
First, I want
to say that this project was universally enjoyed (well, almost) and left the students asking
to do more database work! Second, within 10 minutes of first seeing Microsoft Access,
around 90% of the students (remember they are ages 8 and 9)
were successfully building their own queries using the design view.
Here are the steps I took:
- I first created a small database with solar system facts.
See the data base facts here in a table form.
Of course, this table is a flat file because our server isn't quite up to online databases just yet.
- Next I created a fantasy world of scouting for the year 2428, in which summer camp
is held on the various planets. The Star Scouts have to choose one of three programs.
Read all about it here. It's really quite comical. I read
this to the classes, and the students had a copy to read along with.
- At this point, I introduced some letters from campers to mom and dad. We read
these together as a class. Letter 1,
Letter 2, and Letter 3.
- The last thing we did together as a class was to create a sample
query, view the results, go back to query mode,
modify it, and view the results again. We used the design view, and the students were
instructed not to save queries because they would need to modify them too often.
The vast majority of the students, surprisingly, caught right on. The graphic
below shows a Microsoft Access screen in the design view.
As you can see, in the design view, Access queries require
a person to select the field they want from a list of all fields. The key for the
students was to select fields for their queries which match the clues.
Then after viewing the query results, they had to analyse the data.
Example. If the letter indicated the camper was less than 90 million miles
from the sun, the
student must realize that the field "Distance from the Sun" is indicated. Then the
student must create the query and study the results in order to
determine which planets are eliminated and which are still possibilities. If
more than one possible planet still exists, the student must go back to the query
mode and find other fields to match other clues in order to narrow down the search
The Follow on Activity, or "You are the Camper." In this
part of the assignment the students had to
write a letter from a ficticious
camper. This required the students to think backwards, and to look at the data in a
different way. No longer could they rely only on queries to view the data. They
needed several views into the data. Here are the tools the students were given for
|The students were shown how to use table view. This allows them
to browse all data of all planets, but essentially only one field at a time. It can
get a bit akward, though, because of its size. The
graphic below shows a slice of the table view, and how only one or a few fields at a time
can really be compared across the planets.|
They were advised to continue building queries if they needed custom views of
the data. They were also advised to use query mode to test their logic after they had
finished their letter.
Their letters were required to make a person revise a query at least 2 times. In
other words, the students were supposed to have at least 3 clues which had to be queried
together before one planet was indicated. Here are some of the student created letters:
|They were shown how to use a form view which gave them one
screen with all data for one planet. They could scroll through the planets, but each screen
gives data for only one planet at at time. The picture below shows part of
the form view screen.|
Can you guess which planets these campers are on? I'm not telling!