Nigeria - National Literacy Survey Nigeria-2009, First Round

National Literacy Survey 2009 data were processed in 4 stages namely, manual editing and coding, data entry, data cleaning and tabulation.
Manual Processing
Completed questionnaires started arriving at the NBS headquarters two weeks after training from the states.
Manual processing started with the development of editing/coding guidelines which were used to train the officers on manual editing.
Development of data entry programme; data entry and editing and tabulation. Census and Surveys Processing System (CSPro) software were used for data entry, Statistical Package for Social Sciences (SPSS) and Census and Surveys Processing System (CSPro) for editing and a combination of SPSS, Statistical Analysis Software (SAS) and EXCEL for table generation.

The guidelines include errors that could be found in the completed questionnaires and how they could be corrected. These likely errors include omissions, inconsistencies, unreasonable entries, impossible entries, double entries, transcription errors and others found in the questionnaires. 10 officers were selected as editors, while 20 data entry staff were used in addition to 3 programers.

Data Entry
The data entry was done manual.
The data entry started with a trial entry by the data entry clerks to acquaint them with the modalities and/or procedures for the data entry after which substantive data entry began. A total of about 20 operators working at the NBS headquarters. The data entry was completed within 8 weeks. Data entry supervisors working under the Data Processing Coordinator supervised data entry.
1) Questionnaire reception
2) Office editing and coding
3) Data entry
4) Structure and completeness checking
5) Verification entry
6) Comparison of verification data
7) Back up of raw data
8) Secondary editing
9) Edited data back up
After all clusters are processed, all data is concatenated together and then the following steps are completed for all data files:
10) Export to SPSS in 4 files
11) Recoding of variables needed for analysis
12) Adding of sample weights
13) Structural checking of SPSS files
16) Production of analysis tabulations





Data Cleaning
Data entry was followed by trial tabulation to check for and to correct inconsistencies in the data. A frequency check was done on the values of the variables in all the modules to examine quality of the data. All inconsistencies found were reconciled and all errors found were corrected.
UNICEF also provided a Consultant from Macro International, New York, who evaluated the data and all inconsistencies discovered at this stage were also corrected. Analysis similarly benefited from the various workshops organized by the WCARO specifically for MICS 2

Data processing began in March 1999 and draft tables produced by August, 1999. The final tables were produced in September 2001. The delay in producing the final tables was due to the need to conduct extensive data verification and to the necessity to undertake a series of evaluations to ensure consistency and comparability of figures with those of other countries in the region.