Electronic Data Processing, Analysis and Reporting for Public Health Surveys
This manual was prepared by the United States Department of Health and Human Services Centers for Disease Control and Prevention (HHS-CDC), Global AIDS Program (GAP) Surveillance Team in collaboration with the World Health Organization (WHO), Geneva.
The original manual was written by Kimberly Marsh, MPH.
CDC/GAP thanks the following ministries of health for hosting pilot trainings:
Thanks also to UNAIDS and the surveillance and survey working group of the Office of the Global AIDS Coordinator (OGAC), consisting of:
United States Census Bureau
United States Agency for International Development (USAID)
Appendix G, Banket HIV ANC Surveillance Data Collection Forms to be
Appendix H.1, HIV Surveillance Data-entry Audit Log – 2002 H.1-1
Appendix H.2, HIV Surveillance Data-entry Audit Log – 2001 H.2-1
Appendix I, Additional HIV ANC Surveillance Data Collection Forms I-1
Introduction Course Overview
What you should
This course is designed to provide basic technical skills in processing and analysing data, ultimately for the purpose of producing epidemiologic reports at the regional and national level.
To benefit from this course, you should be familiar with:
the Microsoft Windows computing environment, (including moving, copying and renaming files and file folders)
performing and interpreting both simple and more complex data analyses using either computer or paper-based statistical methods.
Familiarity with Epi Info is not required.
Finally, because antenatal clinic HIV sentinel surveillance is used as an example throughout this course, you should understand the basic approach to conducting such surveys in resource-limited settings. Become familiar with this type of surveillance before coming to class by reading the WHO Second Generation Surveillance Guidelines at (http://www.who.int/hiv/pub/surveillance/pub3/en/index.html)
or other published literature.
The purpose of this course is to provide you with basic skills in data processing, analysis and report writing for survey data.
Specifically, the course will introduce best-practice techniques for systematically collecting, managing, processing and reporting HIV survey data from antenatal clinics (ANCs).
You will engage in the planning and implementation of the 2002 HIV sentinel surveillance round in a fictitious country called Suri in order to understand and apply these best-practice techniques.
By the end of the course, you should be able to:
design easy-to-use data collection and electronic data-entry forms
develop simple and complex check code to validate data entry
develop and document data cleaning and database storage strategies
conduct simple exploratory analysis for data cleaning purposes
clean and prepare data for analysis
Perform simple and complex descriptive analyses
develop clear and concise national and regional reports.
Operation System and Epi Info Software Requirements
Epi Info [for Windows] is a public domain software package designed for the global community of public health practitioners and researchers. It provides for easy form and database construction, data entry and analysis with epidemiologic statistics, maps and graphs. Epi Info should be pre-loaded on classroom computers and can be accessed by double-clicking the icon on the computer desktop screen.
On your desktop, double-click the icon:
Note: If Epi Info is not loaded onto your computer, you can either request a copy by CD-ROM or download the latest version from http://www.cdc.gov/epiinfo/downloads.htm. Directions for installing the software are also available from this site.
for Epi Info
Windows 98, NT 4.0, 2000 or XP
A minimum of 32 MB of Random Access Memory is recommended for Windows 98, 64 MB minimum for Windows NT 4.0 and 2000 and 128 MB minimum for Windows XP
A 200 megahertz processor (recommended)
At least 260 MB of free hard disk space (Drive C) to install; 130 MB after installation
The course lasts five days. We plan to cover all exercises, Exercises 1 through 12, during the duration of the week. Additional group activities, such as the development of a data screen for a country-specific ANC form, sample national reports or a PowerPoint presentation (as described in Exercise 1 and Exercise 12) may require additional time, and may be condensed in the interest of time. See your course materials for a copy of the course-specific training schedule.
Using the Hints and Directions
Watch for the icons below. They will assist you by pointing out hints or directions.
1. A note icon is used to draw your attention to key information ()
Example: Note that you may need to…
2. A light bulb icon marks key information to aid in understanding how Epi Info works ().