Third Integrated Household Survey 2010-2011

Data Entry:

Data Entry Clerks Each IHS3 field team was assigned 1 data entry clerk to process completed questionnaires at the team's field based residence. Each data entry clerk was issued a laptop with the CSPro based data entry application, a printer to produce error reports on entered questionnaire, and flash disks for transferring files. The field based data entry clerk's primary responsibilities included:
(1) receiving the completed questionnaires following the field supervisor's initial screening
(2) organizing and entering completed questionnaire in a timely manner
(3) generating and printing error reports for supervisor review
(4) modifying data after errors were resolved and authorized by the field supervisor
(5) managing data files and local data back-ups

The data entry clerk was responsible for beginning initial data entry upon receipt of questionnaires from the field and generating error reports as quickly as possible after interviews were complete in the EA. When long distance travel to an enumeration area by the field team was required and the field team was required to spend multiple days away from their field residence the data entry clerk was required to travel with the team in order to maintain data processing schedules. Field Based Data Entry and CAFE To better facilitate higher quality data and increase timely availability of data during the data capture process IHS3 utilized computer assisted field entry (CAFE). First data entry was conducted by field based data entry clerks immediately following completion of the team's daily field activities. Each team was equipped with 1 laptop computer for field based data entry using a CSPro-based application. The range and consistency checks built into the CSPro application was informed by the LSMS-ISA experience in Tanzania and Uganda, and the review of the IHS2 data. Prior programming of the data entry application allowed for a wide variety of range and consistency checks to be conducted and reported and potential issues investigated and corrected before closing the assigned enumeration area. Completed data was frequently relayed to the NSO central office in Zomba via email and tracked and processed upon receipt. Double Data Entry Double data entry was implemented by a team of data entry clerks based at the NSO central office. Electronic data and questionnaires received from the field were catalogued by the Data Manager and electronic data loaded onto a central server to enable data entry verification on networked computers.

Quality Checks:

To increase quality, the Data Entry Manager monitored the data verification staff and conducted quality assessments by randomly selecting processed questionnaires and comparing physical questionnaires to the result of double data entry. Data verification clerks were coached on inconsistencies when required. Data Cleaning The data cleaning process was done in several stages over the course of field work and through preliminary analysis. The first stage of data cleaning was conducted in the field by the field based field teams utilizing error reports produced by the data entry applications. Field supervisors collected reports for each enumeration area and household and in coordination with the enumerators reviewed, investigated, and collected errors. Due to the quick turn-around in error reporting, it was possible to conduct call backs while the team was still operating in the enumeration area when required. Corrections to the data were entered by the field based data entry clerk before transmitting data to the NSO central office. Upon receipt of the data from the field, module and cross module checks were performed using Stata to identify systematic issues and, where applicable, field teams were asked to investigate, revise and resend data for questionnaires still in their possession. Revised data files were catalogued and then replaced previous version of the data. After data verification by the headquarters' double data entry team, data from the first data entry and second data entry were compared. Cases that revealed large inconsistencies between the first and second data entry, specifically large amounts of missing case level data in the second data entry relative to the first data entry were completely re-entered. Further, variable specific inconsistency reports were generated and investigated and corrected by the double data entry team. Additional cleaning was performed after the double data entry team cleaning activities where appropriate to resolve systematic errors and organize data modules for consistency and efficient use. Case by case cleaning was also performed during the preliminary analysis specifically pertaining to out of range and outlier variables. All cleaning activities were conducted in collaboration with the WB staff providing technical assistance to the NSO in the design and implementation of the IHS3.