1 / 21

Manual Data Processing of Census Data

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.

emily
Download Presentation

Manual Data Processing of Census Data

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Manual Data Processing of Census Data 2004 Population and Housing Census Statistics Sierra Leone Thekeka Moses Conteh Sierra Leone

  2. Population Figures of Sierra Leone YearPopulation • 1963 2,180,355 • 1974 2,735,159 • 1985 3,515,821 • 2004 4,976,871

  3. Administrative Division Administrative BlocksNumber • Region/Province 4 • District 14 • Chiefdom 166 • Sections 1,321 • Enumeration Area 9,673 • Localities 16,734

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

  5. Planning • Office and Equipment / Accessories • Personnel • Scheduling and timing • Budgeting

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

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

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

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

  10. Programming (b) • IMPS • Design of data structures • Data Capture • Verification • Validation • Tabulation • Other SOFTWARE • SPSS WIN Version 12.0 • MS ACCESS

  11. Training • Coders • Verifiers • Data Entry Operators

  12. 10% Sample The Rest Re-batching April May June July Aug Sep Oct Nov Dec Jan Feb Operations (a) • Coding

  13. Operations (b) • Data Entry / Verification / Validation / Back up / Tabulations 10%Sample The Rest June July Aug Sep Oct Nov Dec

  14. Primary Data Processing Flow Main Data Entry Structure Check Verification Data Entry Backup Raw Data Secondary Editing Backup Final Data

  15. Secondary Data Processing Flow Export Data from IMPS Import Data into SPSS Set up a Tabulation Plan Run Tables with IMPS and SPSS

  16. Creation of Census Databases • Population • Housing • Ownership • Agriculture • Deaths • DBMS MS-Access

  17. Dissemination of Census Information • CDs • Internet • Monographs

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

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

  20. Thank You

More Related