Using Epi Info in Community Health Assessments

1
Using Epi Info in Community Health Assessments

• John Wallace
• NC Center for Public Health Preparedness

North Carolina Institute for Public Health
2
Session Outline

• Introduction to Epi Info
• Why use Epi Info?
• Epi Info in Community Health Assessments
• Using Epi Info
• Make View
• Enter Data
• Analyze Data
• Questions

3
Epi Info Contact Information

• CDC Epi Info Web Site
• http//www.cdc.gov/epiinfo/
• John Wallace
• NC Center for Public Health Preparedness
• [phone]
• john.wallace_at_unc.edu

4
What is Epi Info?

• Tool used to create questionnaires for outbreak
  investigations, studies or surveillance
  activities, data entry, data management, and
  analysis of data.
• Developed by CDC using Microsoft Access foundation

5
Why use Epi Info?

• 3 Functions All-in-One
• Survey Design
• Data Entry
• Analysis
• FREE!
• Designed for Field Investigation, Community
  Assessment, Outbreak Investigation

6
Using Epi Info in Community Health Assessments
7
Community Health Assessment Process

• From Community Health Assessment Guide Book by
  Healthy Carolinians
• Using Epi Info in Phase 2

http//www.healthycarolinians.org/pdfs/02Guidebook
.pdf
8
Epi Info in Community Assessments

• Phase 2
• Collect Community Health Data
• Primary Data
• Analyze Community Health Data
• Primary/Secondary Data
• Map Community Data
• Basic GIS Software

9
Steps in Using Epi Info

• Develop survey tool, administer survey
• Best done outside of Epi Info
• Create electronic version of survey (Make View)
• Enter collected data into electronic survey
• Analyze electronic data

10
Epi Info Demonstration
11
Epi Info Menu
12
Step One Create Electronic Survey

• Use Make View
• Convert Survey into Electronic Format in Epi Info
• Create a file
• Create survey within file
• Add questions (fields) to the survey

13
Creating Electronic Surveys

• Open Epi Info
• Click on Make View
• View Survey in Epi Info
• Create and name a new file
• Name the view
• Add questions

14
Epi Info File Structure
Project

• View
• 2002 Questionnaire
• 2006 Questionnaire

• Table
• 2002 Data
• 2006 Data

15
Make View Demonstration
16
Epi Info Menu
17
Step Two Enter Data

• Use a view created in Make View to enter
  collected data
• Data entry from hardcopy data
• Be thorough and meticulous!

18
Entering Data in Epi Info

• Open Epi Info
• Click on Enter Data
• Open file for data entry
• Begin data entry

19
Enter Data Demonstration
20
Epi Info Menu
21
Step Three Analyze Data

• Analyze survey data
• Basic Analysis
• Frequencies, Means, Tables, Graphs
• Advanced Analysis
• Regressions, Complex Sampling Statistics
• Consult a statistician!

22
Analyzing Data in Epi Info

• Open Epi Info
• Click on Analyze Data
• Read in a data set for analysis
• Conduct analysis

23
Analyze Data Demonstration
24
Other Epi Info Resources

• CDC. Epi Info http//www.cdc.gov/epiinfo/
• CDC. Epi Info Community Health Assessment
  Tutorial. Version 2. October 2005. Available at
  http//www.cdc.gov/epiinfo/tutorials.htm
• NC Center for Public Health Preparedness Training
  Web Site, Epi Info Training Modules
  http//nccphp.sph.unc.edu/training/

25
Questions?
John Wallace NC Center for Public Health
Preparedness [phone] john.wallace_at_unc.edu