MICS Data Processing Workshop

1. MICS Data Processing Workshop Structure Checking and Verification

2. Structure Checking Flow Chart Main Data Entry Data Entry Operator 1 Correct Main Data File Structure Check DP Supervisor Data Entry Operator 1 No Investigate Errors Check ok? DP Supervisor Yes Verification Data Entry Data Entry Operator 2

3. Structure Checking • Check the number of questionnaires in the data file matches number of questionnaires on the cluster tracking form • Check household information panel counts of women and under-fives (HH12-15) match number of questionnaires in the data file

4. The Cluster Tracking Form • Allows supervisor to organize and track data entry progress • Questionnaire totals entered by questionnaire administrator • Other information entered by supervisor

5. Cluster Tracking Form

6. Cluster Tracking Checks • Check questionnaires in data file equal questionnaires on cluster tracking form • Check done for: • Complete, Incomplete and Total Households • Complete, Incomplete and Total Women • Complete, Incomplete and Total Children

7. Cluster Checks • Women’s questionnaires = Σ HH12 • Completed women’s questionnaires = Σ HH13 • Under-five questionnaires = Σ HH14 • Completed under-five questionnaires = Σ HH15

8. Sample Output - Cluster MICS Data Structure Check Cluster: 3 Households | Women | Children Total Comp Incomp | Eligible Interviewed | Eligible Interviewed | HH12 FOUND HH13 FOUND | HH14 FOUND HH15 FOUND 2 1 1 | 5 5 4 4 | 4 4 3 3 • Compare totals to those on cluster tracking form • If totals different, check cluster’s questionnaires and resolve the difference

9. Household Checks • Women’s questionnaires = HH12 • Completed women’s questionnaires = HH13 • Under-five questionnaires = HH14 • Completed under-five questionnaires = HH15

10. Sample Output - Household MICS Data Structure Check Household: 1 Result: 1 Women | Children Eligible Interviewed | Eligible Interviewed HH12 FOUND HH13 FOUND | HH14 FOUND HH15 FOUND 4 4 3 3 | 2 2 1 1 • Use listing of households to identify source of cluster level problems

11. Verification Flow Chart Verification Data Entry Data Entry Operator 2 Correct Both Data Files Verification DP Supervisor Data Entry Operator 1 & 2 Yes Determine Correct Values Differences? Data Entry Operator 1 & 2 No Backup Raw Data File DP Supervisor

12. Verification • Purpose: Eliminating data entry errors • Method: 1. program compares main and verification data files 2. program produces list of differences 3. data entry operators use listing and questionnaires to determine corrections 4. Corrections marked on listing 5. BOTH data files corrected by original operators 6. repeat 1-5 until no differences in listing!

13. A Differences Listing Input File: C:\MICS\CSPRO\RAW\HH003M.DAT Reference File: A:\HH003V.DAT ----------------------------------------------------------------------------------------------- Case Id Item Input File Reference File ----------------------------------------------------------------------------------------------- [003001 ] ED3(6) 202 204 ED3B(6) 02 04 DA11(9) 2 1 [00300404] IM1 1 2 IM2 31032004 IM2D 31 IM2M 03 IM2Y 2004

14. Verification Application • The file compare.cmp defines which items (i.e., variables) are to be excluded • It is strongly recommended that this file not be changed