Title: Africa – South of the Sahara
Developed by Bobby Jetelina and Elaine Spence
1. The students will research different aspects of African countries using books,
atlases, online databases and other websites.
2. The students will create a database which compares different aspects of African
3. The students will use the Find and Sort features of the database to analyze and
Timeline: two to three 45 minute class periods
Content Area: Social Studies Grade Level: 6
Materials/Resources: World Cultures Technology Focus:
and Geography by McDougal Littell Database
(textbook), Africa Data sheet, Africa Internet
Analysis sheet, Facts on File World Atlas or
other current atlas, Microsoft Access,
Subject Area - §113.22.3(A, B, C)
Technology Applications - §126.12.1(A, B, C, E, F), §126.12.2(A), §126.12.3(B),
§126.12.4(A), §126.12.5(B), §126.12.6(A), §126.12.7(C), §126.12.8(E),
Before Coming to the Computer Lab
Download and make student copies of the following files:
Africa Data sheet
Africa Analysis sheet
Africa Student Instruction Sheet
In the Computer Lab
Get Started and Create Fields
1. Go to Start > Programs > Microsoft Access.
2. Click Blank Database.
3. In the Save in box, click the down arrow and navigate to the student’s folder.
4. In the File name box, type: Africa.
5. Click the Create button.
6. Double click the Create table in Design view link.
7. In the first Field Name box, type: Country and press Enter.
8. In the Data Type column, make sure Text is selected.
9. Repeat steps 7 and 8 for the following fields:
Field Name Data Type
a. Capital Text
b. Religions Text
c. Government Type Text
d. Life Expectancy Number
e. Literacy Number
f. Population Number
g. Currency Text
h. Region Text
10. Make sure the cursor is in the Religion cell. In the bottom of the window in the
Field Size box, highlight 50 and change it to 200.
11. Go to View > Data Sheet View.
12. Click Yes.
13. Type the following as a name for the table: Countries of Africa.
14. Click OK.
15. Choose No on the Primary Key window.
Adjust Column Width and Row Height
1. Go to Format > Row Height.
2. Type: 25 and click OK.
3. Position the cursor on the line between the Country heading and Capital
heading. (cursor should change to a double arrow).
4. Double click. The column should automatically adjust to the correct width.
5. Automatically adjust the width of the remaining columns.
1. In the Country field, enter the following countries:
*Note: Remind students that a column is a field and a row is a record (all
information related to country).
b. South Africa
d. Congo, Dem. Rep.
j. Equatorial Guinea
k. Student's Name and class period
2. Use the student worksheet to enter the database information.
*Note: For the Religion column, enter only the top three.*
3. Adjust column width as needed.
Teacher/Student Note (Check Chart)
If a column is “left out”, follow the steps below to add it to the database. If all
columns are present, go to Print the Table section (below).
1. Go to View > Design View.
2. Click in the next available cell at the bottom of the list and type the missing
3. Press Enter.
4. Go to View > Datasheet View.
5. Click the name of the column to highlight it.
6. Move the cursor back over the column name until it becomes a white arrow.
7. Click the white arrow and drag the column left or right to the new location.
*A black bar appears to show where the column will be dropped*
Print the Table
1. Go to File > Print Preview > Setup.
2. On the Margins tab, change all boxes to 0.5.
3. Click the Page tab and choose Landscape.
4. Click OK.
5. Go to File > Print > OK.
6. Close the table.
Sort and Analyze
1. Hand out the Africa Analysis sheet to students.
2. Open Microsoft Access and the Countries of Africa table if it is not
3. Click inside the Literacy Rate column.
4. Click the Sort Ascending button .
5. Answer question number one on the analysis sheet.
6. Click inside the Population column.
7. Click the Sort Ascending button.
8. Record the answer for question two on the analysis sheet.
9. Click inside the Currency column.
10. Click the Sort Ascending button.
11. Find and record the answer to question three on the analysis sheet.
12. Analyze the information in the Religion column to answer question number
Find and Analyze
1. Click inside the Government Type column.
2. Click the Find button .
3. In the Find What box, type multiparty (be sure to spell all words
*Note: If students did not use commas or semicolons between their
Government Type words, the Find feature not access the
4. In the Match box, choose Any Part of Field.
5. Make sure the Match Case box at the bottom of the window is unchecked.
6. Click the Find Next button and record the answer.
7. Click the Find Next button again and continue to record any additional
8. When record searching is finished, click OK > Cancel.
1. Click inside the Region column.
2. Click the Sort Ascending button .
3. Answer question number six on the analysis sheet.
4. Save and close the database.
Completed Africa data sheet
Completed Africa analysis sheet
Printed database table
Modifications: Require fewer countries Extensions: Formulate questions which
Provide partially completed information analyze life expectancy and provide the
Additional Resources: Facts on File World Atlas (subscription)
Manage a database utilized in
Identify parts of a database (field, record, form) X
Create a blank database X
Enter data in a consistent form X
Create a table X
Add/Delete records X
Move through records X
Edit data X
Change column width X
Find data X
Sort records X
Skills utilized in the
Use appropriate keyword and Boolean
Use electronic communication to share
Create a product collaboratively