1 / 15

Data management Key Issues in Data Entry and Management Cleaning Data, Who Should do What, When?

Data management Key Issues in Data Entry and Management Cleaning Data, Who Should do What, When?. Juan Muñoz. Levels of quality control. Range checking Simple consistency checks Inter-record checks. Range checking. Age should be a number less than 100

bayle
Download Presentation

Data management Key Issues in Data Entry and Management Cleaning Data, Who Should do What, When?

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. Data management Key Issues in Data Entry and Management Cleaning Data, Who Should do What, When? Juan Muñoz

  2. Levels of quality control • Range checking • Simple consistency checks • Inter-record checks

  3. Range checking • Age should be a number less than 100 • Gender should be coded either “1” for male or “2” for female • No numbers in the name field • etc

  4. Simple consistency checks • Age and birth date should be consistent with the date of the interview • Head of the household should be 18 years or older • A doctor should have completed university studies • etc.

  5. Inter-record checks • Sub-totals • Food consumption • Checks with reference tables (anthropometrics) • Cash balance • Item-specific unit prices • etc.

  6. Levels of quality control Easier to conceive and program • Ranges • Simple consistency • Inter-record Harder to conceive and program

  7. Levels of quality control Error likely to be due to miscoding or data entry • Ranges • Simple consistency • Inter-record Errors likely to be due to interviewing

  8. Why concurrent data entry? • Quality control • Turnaround time • General improvement of field procedures • Eliminates encoding as a separate task

  9. Data entry is an integral part of the LSMS, not an afterthought

  10. What is needed to develop an LSMS data entry program? • Integrated skills / tasks • Development time • Data entry software

  11. Integrated skills • Questionnaire and data entry program evolve synergistically(example: subtotals) • Data manager needs to be a part of the core team from the beginning • Integration will become even more important in future surveys

  12. Tasks • Data entry program development- screen design- range checks- consistency checks- reference data • Data entry manual • Training • Supervision during field work • Compilation and documentation

  13. Development time • First version to be completed before the field test • Working version needs to be ready for training • Debugging needed during first weeks of data collection

  14. Data entry software • In-house package • Six packages evaluated in 1994,IMPS and ISSA found adequate

  15. In-house package Six packages evaluated in 1994,IMPS and ISSA found adequate Has evolved synergistically with acquired experience and available technology IMPS and ISSA now superseded by CSPro Data entry software

More Related