Creating a Database
- Computer
- Elementary

- Activity Time
- Materials
- Concepts / Topics
Students organize their research on African countries in a database, enter and search records, compare information, and use their findings to prepare group presentations.
Standards Addressed
Social Studies
- Explore and describe similarities and differences in ways groups, societies, and cultures address similar human needs and concerns.
- Use appropriate resources, data sources, and geographic tools such as atlases, databases, grid systems, charts, graphs, and maps to generate, manipulate, and interpret information.
Technology
- Use technology to locate, evaluate, and collect information from a variety of sources.
- Use technology tools to process data and report results.
General Goal
The student will create a database for the continent of Africa.
This is the culminating activity for a social studies unit on Africa. Students have compiled research on individual countries on the continent. After compiling the database, students will use the information to make a presentation on the continent of Africa.
Procedures
Choose Categories and Set Up the Database
Students brainstorm categories for the information they have. These categories will become the fields in the database. The teacher should set up the original fields.
- Open AppleWorks by clicking on its icon. Scroll down to Database and click OK to open the Define Database Field page.
- Type in the field name/category.
- Select the field type. We used text.
- Click Create, then click Done. Repeat this process for each field you create.
- To add new fields, go to Layout, scroll down to Define Field, and release. Follow the procedures above to define and add each new field.
- Save, close, and name the file.
Enter the Research
Students will need their research and access to a computer to add information to the database.
- Go to My Documents and open the named file.
- Go to Edit, scroll down to New Record, and release. Enter the data in the fields. If you have no information for a field, leave it blank.
Find and Compare Information
Once all students have added their information to the database, I explain the program's Find function. Students must use exact terms and tell the program what information to find and which field to search.
- Go to Layout, scroll down to Find, and release. The fields you have defined will appear on the screen.
- Click on the field you want to search and type in the search criteria—the data you want to find. You can enter search criteria in as many fields in the find request as you want.
- After entering the search criteria, click the Find button on the sidebar. The computer will bring up the matching records.
I had students play with different find requests to see how the information broke down. They printed the results, and then the class decided which criteria we would use to compare data.
Group Presentations
I divided the class into six groups and assigned them the following categories:
- Cultures
- Types of government combined with economy
- Points of interest
- Geology
- Natural resources combined with climate
- Holidays combined with language
The groups made a variety of find requests using their assigned fields. They used the information they gathered to put together presentations on their areas. The class presented the information at our multicultural fair.
Assessment: Database Rubric
| Points | Data Entry | Find Requests | Discussion |
|---|---|---|---|
| 5 | Input at least 12 fields of information into the database. | Complete at least 5 find request searches and print them out. | Consistently discuss the results and importance of the data. |
| 3 | Input at least 8 fields of information into the database. | Complete at least 3 find request searches with printouts. | Satisfactorily discuss the results and importance of the data found. |
| 1 | Input at least 3 fields of information into the database. | Complete at least 1 find request search with a printout. | Minimally discuss the results and importance of the data found. |
Teachers.Net · https://teachers.net/lessons/2582.html