Manual Data Processing of Census Data

1
Manual Data Processing of Census Data

• 2004 Population and Housing Census
• Statistics Sierra Leone
• Thekeka Moses Conteh
• Sierra Leone

2
(No Transcript)
3
Population Figures of Sierra Leone

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

4
Administrative Division

• Administrative Blocks Number
• Region/Province 4
• District 14
• Chiefdom 166
• Sections 1,321
• Enumeration Area 9,673
• Localities 16,734

5
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

6
Planning

• Office and Equipment / Accessories
• Personnel
• Scheduling and timing
• Budgeting

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

8
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

9
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

10
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

11
Programming (b)

• IMPS
• Design of data structures
• Data Capture
• Verification
• Validation
• Tabulation
• Other SOFTWARE
• SPSS WIN Version 12.0
• MS ACCESS

12
Training

• Coders
• Verifiers
• Data Entry Operators

13
Operations (a)

• Coding

14
Operations (b)

• Data Entry / Verification / Validation / Back up
  / Tabulations

10 Sample
The Rest
June
July
Aug
Sep
Oct
Nov
Dec
15
Primary Data Processing Flow
Main Data Entry
Structure Check
Verification Data Entry
Backup Raw Data
Secondary Editing
Backup Final Data
16
Secondary Data Processing Flow

Export Data from IMPS
Import Data into SPSS
Set up a Tabulation Plan
Run Tables with IMPS and SPSS
17
Creation of Census Databases

• Population
• Housing
• Ownership
• Agriculture
• Deaths
• DBMS
• MS-Access

18
Dissemination of Census Information

• CDs
• Internet
• Monographs

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

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

21

• Thank You