Manual Data Processing of Census Data by olliegoblue29

VIEWS: 59 PAGES: 21

									Manual Data Processing of Census
              Data


               2004 Population and Housing Census
               Statistics Sierra Leone

               Thekeka Moses Conteh

               Sierra Leone
Population Figures of Sierra Leone

    Year            Population
   1963            2,180,355
   1974            2,735,159
   1985            3,515,821
   2004            4,976,871
Administrative Division

Administrative Blocks Number
 Region/Province         4
 District                14
 Chiefdom                166
 Sections                1,321
 Enumeration Area        9,673
 Localities              16,734
FINAL FIGURES OF 2004 CENSUS

   Total Population              4,976,871
   Males                        2,420,218
   Females                      2,556,653
   Household Population         4,930,532
   Special Groups Population      46,339
   Enumeration Area               9673
   Total Number of Households    819,854
   Average Household Size          6.0
Planning
   Office and Equipment / Accessories
   Personnel
   Scheduling and timing
   Budgeting
Office Preparation / Installations
   Server Room
   Data Entry and Verification Room
   Coding Room
   Store Room



   Installation Power supply
   Air conditioners specifications
   Specifications for computers, printers, backup systems etc.
   LAN with star topology.
Recruitment and Training of
Personnel
   Data Processing Consultant
   1 Census Database Manager
   1 Census IT Manager
   5 Coding Supervisors
   4 Verifying Supervisors
   12 Data Entry Supervisors

   50 Coders
   40 Verifiers
   120 Data Entry Operators
Receiving and Batching
   5 Coding Supervisors
    To receive the questionnaires from logistics office on behalf
    Census Data Processing Unit

    To batch the census questionnaires in EA order in the store
    for processing
Programming (a)
    Main Application SOFTWARE
    The Integrated Microcomputer System (IMPS) developed by US Bureau of the census – is a
     system for entry, editing, tabulation and management of census and survey data.

    MODULES
    Data Dictionary (DATADICT)
    Data Entry (CENTRY)
    Data Edit And Imputation (CONCOR)
    Publication Tabulation (CENTS)
    Quick Tabulation (QUICKTAB)
    Table Retrieval (IRS)
    Variance Calculation (CENVAR)
    Data Entry Control (CENTRACK)
    Utilities
    Quit
Programming (b)
   IMPS
     –  Design of data structures
     –  Data Capture
     –  Verification
     –  Validation
     –  Tabulation

   Other SOFTWARE
     –  SPSS WIN Version 12.0
     –  MS ACCESS
Training
   Coders
   Verifiers
   Data Entry Operators
Operations (a)
   Coding




             10% Sample
                                      The Rest
                                                        Re-batching



     April May   June   July   Aug   Sep   Oct   Nov   Dec   Jan   Feb
Operations (b)
     Data Entry / Verification / Validation / Back up / Tabulations


           10% Sample

                                                 The Rest




    June         July      Aug         Sep         Oct        Nov      Dec
Primary Data Processing Flow

         Main Data Entry
         Structure Check
       Verification Data Entry

         Backup Raw Data
         Secondary Editing
        Backup Final Data
Secondary Data Processing Flow

           Export Data from IMPS


           Import Data into SPSS



         Set up a Tabulation Plan


       Run Tables with IMPS and SPSS
Creation of Census Databases
   Population
   Housing
   Ownership
   Agriculture
   Deaths



   DBMS
    MS-Access
Dissemination of Census
Information
   CDs
   Internet
   Monographs
Challenges with Manual Entry

   Duplication of EA codes and household
    numbers
    The use of F2 key in IMPS to force values that
    are out of range.
   Transposition errors were prominent
   Incomplete entry of household records
   Incomplete entry of modules
   Data Verification was not effective.
       Benefit of Manual Data Entry
                 Approach


   Build institutional capacity by the purchase of more
    microcomputers which can be used for other activities
    after the census.
   Creates employment facility and training for more
    people.
   Data can be easily identified and keyed.
   Inconsistent data can be identify and resolved before
    keying.
   Relatively less expensive
   Data was processed within reasonable period of eight
    months.
Thank You

								
To top