Data Management and Analysis using EpiInfo

This training provides comprehensive introductory you will need to know in order to manage and analyze the data collected during the PLACE assessment, as well as guidance in preparing the data tables used in a PLACE report. It begins with step-by-step instructions for preparing customized data entry screens in Epi Info for the prepared questionnaire.

EpiInfo is a public domain software package developed by the U.S. Centers for Disease Control and Prevention (CDC). Designed for the global community of public health practitioners and researchers, it provides tools for easy form and database construction, data entry, and analysis with epidemiologic statistics, maps, and graphs.

Target Participants

• Anyone with no EpiInfo background
• Anyone who wants to understand the workflow in EpiInfo

Course learning outcomes

After studying this course, you should be able to:

• Modifying or creating a questionnaire date entry screen
• Entering data and merging files
• Producing frequency tables
• Cleaning Data in Epi Info

Course content

SECTION 1: Preparing for Data Entry

• How to Use This Module
• Modifying or Creating a Questionnaire Date Entry Screen
• Data Entry Exercise: Understanding Data Entry Screen Programming
• Data Entry Exercise: Modifying Data Entry Screens
• Setting Check Parameters for Data Entry
• Date Entry Exercise: Using the Check Entry Program Window

SECTION 2: Data Entry

• Entering Data
• Merging Files

SECTION 3: Data Analysis

• Producing Frequency Tables
• Data Analysis Exercise: Creating a Text File
• Cleaning Data and Outputting a New Data Set
• Instructions for Data Analysis

SECTION 4: Data Use Exercise

• Data Use Exercise: Documenting the PPA Selection Process
• Data Use Exercise: Understanding PLACE Questionnaires
• Data Use Exercise: Understanding PLACE Questionnaire Legal Values
• Data Use Exercise: Understanding Data Cleaning
• Data Use Exercise: Cleaning Data in Epi Info
• Data Use Exercise: Creating New Variables in Epi Info
• Data Use Exercise: Filling in the PLACE Report Template Tables

Training Approach

This training on Data Management and Analysis using EpiInfo is delivered by our seasoned trainers who have vast experience as expert professionals using EpiInfo software language. The course is taught through a mix of practical activities, theory and group works.

Training manuals and additional reference materials are provided to the participants.

Prerequisites

The training is designed for students with little to no background with EpiInfo. Basic computer operational skills is ideal.

Certification

Upon successful completion of this course, participants will be issued with a certificate.

Tailor-Made Course

We can also do this as a tailor-made course to meet organization-wide needs. A training needs assessment will be done on the training participants to collect data on the existing skills, knowledge gaps, training expectations, and tailor-made needs.

Course Duration (classroom-based)

4 Days (8 hours a day)

Payment

1800 ETB

Course Level

Beginner level

Training Language

English (Optional - Amharic)

Download the Course Outline

Download this course outline for use offline or for other devices.

Using Epi Info in an Pandemic Investigation, Advanced Analysis & Mapping

Using a case study based on an actual investigation of COVID-19 pandemic in Ethiopia, you will use Epi Info for Windows (Version 7.2.5) software to perform data entry and analysis activities commonly encountered in a pandemic investigation.

This training is not intended to cover every function of EpiInfo for Windows but rather introduce the beginning user to the features that are required of a basic pandemic/ outbreak investigation.

Target Participants

The intended audience for this training activity is for Epidemiologist, Biostatisticians and Public Health professionals, however, anyone with the following prerequisites will benefit from the training.

Prerequisites

You should have an understanding of the following:

• Basic epidemiology
• Basic biostatistics
• The steps taken in pandemic/ outbreak investigations
• How to develop questions for an investigation
• Basic functions of Windows-based computers

It is not necessary, but may be helpful, to have experience with Epi Info 7 or any other database or spreadsheet software.

Training Objectives

Using EpiInfo for Windows, a summary of an original pandemic/ outbreak investigation, and a set of questions to be used in a questionnaire.

You will be able to:

• Recreate a questionnaire form
• Program code to check for inaccurate data entry or to facilitate data entry
• Enter data in a questionnaire
• Manage the data entered
• Analyze the data entered
• Read data from and write to other database formats
• Create reports using Epi Report
• Create a menu
• Map data using Epi Map

Course content

Module 1: Welcome to Using Epi Info in an Outbreak Investigation

• Overview of Training Activity
• Target Audience
• Training Objectives
• Resources & Time Required
• About this Training Manual
• How to Install EpiInfo

Module 2: Introduction to Infectious Disease

• COVID-19 Case Study
• Case – Control Study Design

Module 3: Recreate the Questionnaire in EpiInfo

• Open EpiInfo Main Menu
• Parts of an EpiInfo Project
• Start a New Project
• Create a New View
• Create Fields
• Changing Alignment (Grid) Options
• Revising Fields
• Resizing the Field’s Data Entry Box
• Creating and Naming Pages
• Group Fields
• Exiting Makeview
• Opening a Previously Created File
• Creating a Code Sheet
• Completing the Questionnaire

Module 4: Create Check Code in EpiInfo

• What is "Check Code"?
• How do you create check code in Epi Info for Windows?
• Identify fields that should contain check code
• Write Check Code
• Enter Code in Program Editor

Module 5: Enter Data in EpiInfo

• What is a record?
• Enter Data
• Working with Records
• Enter Data from Make View

Module 6: Manage Data in EpiInfo

• Before you Begin
• Open File in Analysis Window (Read a File)
• Display Variable Information (Create a Code Sheet)
• Create a Line Listing
• Sort a Line Listing
• Cancel Sort
• Create a Subset of the Data (Use Select Command)
• Save a Subset of Data in a New File (Use Write Command)
• Merge two data files with the same variables

Module 7: Analyze Data

• Describing the Epidemic by Time, Place, and Person
• Analyze Data Frequency
• Graphs: Displaying Data in a Bar Graph
• Work with Graph Files
• Analyze Means of a Single Variable
• Grouping Numerical Data
• Graphs: Displaying Data in a Histogram (Epidemic Curve)
• Analyzing the Risk Factors
• Analyzing the Probability that One Data Variable is Associated with Another (using Table command)
• Save Analysis Output
• Work with Program Files
• Environmental Survey Findings

Module 8: Read & Write Other Database Formats in EpiInfo

• Read an Epi 6 File
• Write an Epi 6 File
• Read an Excel Table

Module 9: Creating Reports Using Epi Report

• Open Epi Report
• Create a New Template
• Create a Label
• Working in the Design Area
• Save the Report Template
• Add a System Variable
• Generate a Report
• Displaying Analysis Output
• Display a Field Aggregate
• Add a Line Listing
• Insert an Image
• Save a Report

Module 10: Creating a Menu in EpiInfo

• STEP 1 Creating a New Menu
• STEP 2 Adding Menu Items and Options to the Pull-Down Menu
• STEP 3 Replacing Buttons
• STEP 4 Adding the Command Blocks
• STEP 5 Saving Your Work
• STEP 6 Creating a Shortcut
• STEP 7 Changing the Picture

Module 11: Conclusions from COVID-19 Pandemic Investigation

• Implement Control and Prevention Measures
• Communicate Findings
• Make Recommendations

Module 12: Advanced Analysis & Mapping Using EpiInfo

• Read the Dataset
• Questions for Consideration
• Using Epi Map Interactively
• Saving Maps in Different File Formats
• Complex Statistics – C Sample, Linear and Logistic Regression

Training Approach

This training is delivered by our seasoned trainers who have vast experience as expert professionals using EpiInfo. The course is taught through a mix of practical activities, theory and group works.

Training manuals and additional reference materials are provided to the participants.

Certification

Upon successful completion of this course, participants will be issued with a certificate.

Tailor-Made Course

We can also do this as a tailor-made course to meet organization-wide needs. A training needs assessment will be done on the training participants to collect data on the existing skills, knowledge gaps, training expectations, and tailor-made needs.

Course Duration (classroom-based)

21 Days (8 hours a day)

Payment

9100 ETB

Course Level

Specialization (for Epidemiologist, Biostatisticians, ...)

Training Language

English (Optional - Amharic)

Download the Course Outline

Download this course outline for use offline or for other devices.