Africa South of the Sahara

Document Sample
Africa South of the Sahara Powered By Docstoc
					                   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
     answer questions.

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,
Internet 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.

Enter Data

    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).

          a. Angola

          b. South Africa
          c.    Ethiopia

          d. Congo, Dem. Rep.

          e. Mali

          f.    Kenya

          g. Botswana

          h. Cameroon

          i.     Nigeria

          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
           already open.
      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.

Region Conclusions

      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
sheets                                               answers

Additional Resources: Facts on File World Atlas (subscription)


                                           Sixth Grade


                  Manage a database                                         utilized in
                                                                           the project

                   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
                  Query data
                   Find data                                                     X
                   Sort records                                                  X


                                                                   Skills utilized in the
               Accessing Information

                 Use appropriate keyword and Boolean
                 search strategies
                 Use electronic communication to share
                 Create a product collaboratively

Shared By: