Introduction to Epi Info Epi Info is a Database and Statistics - - PDF document

5/5/2018 1

Epi Info is a Database and Statistics software for public health professionals

By

• Dr. Sahibzada Azhar Mujib

Data Management Coordinator

Introduction to Epi Info

Course Objectives

After completing the course participants will able to

 Understand the key features of Epi Info Software.  Design data entry forms and apply customization such as

legal values and Jump.

 Enter & Edit data in the electronic form.  Generate Data Line list, Frequencies, Cross tabulations,

Means, Graphs and New variables in Visual Dashboard analysis tool of Epi Info.

 Output the analysis results into Word and Excel formats.

5/5/2018 2

Course Plan

• Introduction to Epi Info Software & Epi Info Training

Portal.

• Introduction to the Training Manual.
• Introduction to the Questionnaire (Food Poisoning Out-Break).
• Practical Work

 Activity-1: Creating Food poisoning outbreak

questionnaire.

 Activity-2: Enter Data and Manage data entry.  Activity-3: Basic data analysis (Visual Dashboard).

Who can benefit From this course?

Those who have Basic Computing skills including good working knowledge of

Operating system Microsoft Word Microsoft Excel

5/5/2018 3

http://www.epiinfo7.azhwebs.com

Epi Info-7 Training Portal

This web Portal Contains;

• Brief About Field Epidemiology Training Program (FETP).
• Electronic Registration of the Participants.
• Course Introduction and Training Activities.
• Illustrated guidelines for each Training Activity.
• Training Material and Software Download.
• Uploading of Training Activities.
• Evaluation Forms.
• Photo Gallery of Participants and Training Activities.
• Online Quiz for Epi Info.

Epi Info-7 Training Portal

http://www.epiinfo7.azhwebs.com

5/5/2018 4

This presentation gives a brief

• verview of the Epi Info 7 and its

main features.

What is Epi Info?

Epidemiology Information

5/5/2018 5

What is Epi Info?



Epi Info is a computer program for managing epidemiological information and research data.



It can be used for

• Outbreak investigations
• Public health surveillance
• Other health and allied research

Projects



This program is developed and maintained by Center for Disease Control and Prevention (CDC) Atlanta, Georgia USA.



Epi Info is in existence for more than 25 years.



Epi Info software is in the public domain. There is no Copy Right. It is free to copy, distribute and translate.

Development of Epi Info

5/5/2018 6



Epi Info is a key component in public health education around the world.



Used in more than 181 countries of the world.



There are more than one million users of Epi Info worldwide.



Translated in more than 13 different languages.

Scope of Epi Info Epi Info Main Features

• Rapidly create electronic form with data customization

and validation.

• Enter data and manage data entry.
• Data Analysis: including
• Listing, Sorting and Selecting subsets of data.
• Frequencies & Means.
• Cross tabulations.
• Basic and advance statistical tests.
• Import and Export data to Excel and other formats.

5/5/2018 7

Epi Info Versions

Three Versions of EPI Info are available

• DOS Version (Older Version)
• 1. Epi Info 6.04d
• Windows Version (New Version)
• 1. Epi Info 3.5.4
• 2. Epi Info 7

Epi Info Versions

• DOS Version (Older Version)
• First Version was released in 1985
• Last Release Version is 6.04d in Jan 2001
• Size of the Software 6 MB
• No Support form CDC

5/5/2018 8

Epi Info Versions

• 1- Windows Version
• (Epi Info 3.5.4) 74 Mb (Latest release Date is 30 July 2012)

Epi Info Versions

2- Windows Version

Epi Info 7.2.2.6 (Latest release: 2nd Feb. 2018)

5/5/2018 9

Epi Info Versions

2- Windows Version

• Latest Version (Epi Info 7.1.5)
• Epi Info 7.2 (Pre-view)

History of Epi Info DOS Ver.

Epi Info Series Version Support status Release date Significant changes

Epi Info for DOS 1

No

1 Sep 1985 2

No

20 Aug 1986 3

No

1988 4.1

No

15 Nov 1988 5.01

No

Oct 1990 Allowed European date formats and non-English characters in data fields. 6.0

No

1992 Added programmable menu system 6.02

No

Oct 1994 6.04c

No

1998 6.04d Yes Jan 2001

Year 2000 compatibility upgrade

5/5/2018 10

History of Windows Version

Epi Info Series Version Support status Release date Significant changes

Epi Info 2000

2000 1.1, 1.2 No 2 Nov 2001

First Windows-compatible version of Epi Info.

2002 R2 No 30 Jan 2003

Bug Fixing

Epi Info 3

3.0, 3.01, 3.2 No Nov 2003

Windows 95 no longer supported

3.3 No 5 Oct 2004

Case-based mapping functionality added to the Analysis MAP command.[

3.4 No 30 Apr 2007

Ability to run reports from Analysis, disallowed multiple instances of the Analysis module, added and CDC flags added to the Nutrition module.[3

3.5 No 9 Jun 2008

Added feature to use standardized vocabularies. First version to require Service Pack 3 if running Epi Info on a computer with Windows XP.[

3.5.1 No 13 Aug 2008

First version compatible with Windows XP. This version also fixed compatibility for languages that are read right-to-left.[

3.5.2 No 17 Dec 2010

Windows Vista and Windows-7 compatibility. Includes OpenEpi suit of Stat Calculations and Fixes the known bugs and issues.

3.5.3 No 26 Jan 2011

History of Windows Version

Epi Info Series Version Support status Release date Significant changes

Epi Info 7

7.0.5 (Apha) Windows XP, Vista, 7, Ubuntu No 5 Jan 2009

Programming language changed to Visual C# .NET; MySQL and SQL Server database support added; XML meta-data support added; Linux compatibility added; first Windows version of Epi Info to be

• pen source.

7.0.7.0 Windows XP, Vista, 7 No 27 Sep 2011 Upgraded framework to .NET version 3.5; Added ability to run Epi Info 7 from a flash drive without administrator rights; Added ability for Epi Info 7 forms to work with essentially unlimited number of fields; Mapping module added; Geocoding added; Visual Dashboard module added; Release build. Added ability to install Epi Info 7 using a traditional setup file; Added new check code commands; Added ability to calculate z-scores for the WHO Child Growth Standards and WHO Reference 2007. 7.0.8.0 Windows XP, Windows Vista, Windows 7 Windows 8, 8.1 & 10 No 17 Nov 2011 7.0.9.0 No 16 Apr 2012 7.1.1.0 No 21 Dec 2012 7.1.3 No 07 Nov 2013 7.1.4 No 11 Jul 2014 7.1.5 No 19 Mar 2015 7.2. No 27 June 2016 7.2.1 No 12th Jan 2017 7.2.2 Yes 2nd Feb 2018

5/5/2018 11

Where to get Epi Info Software?

http://www.cdc.gov/epiinfo

5/5/2018 12

New Features in

EPI Info Version 7

• Version 7 : developed as an open-source project.
• MySQL and SQL server database support.
• Support for Multi-user environment.
• Support for Windows and Linux operating systems.
• Mobile data collection (Android and IOS)
• Web & Cloud based data collection.
• Create forms that have more than 255 fields.
• Can run from a flash drive.

5/5/2018 13

Epi Info 7 Community Edition http://www.codeplex.com/Epiinfo

Epi Info 7.2 Main Screen

5/5/2018 14

Epi Info 7.2 Main Screen

To create electronic data entry Forms with validation and customization

Epi Info 7.2 Main Screen

To manage data entry and editing in the electronic form

5/5/2018 15

Epi Info 7.2 Main Screen

Create Maps shows distribution

• f data in accordance with the

geographic boundaries of the area.

Epi Info 7.2 Main Screen

StatCalc is an epidemiologic calculator that produces statistics from summary data such Chi- Square, Fisher Exact etc & Sample and Power Calculations.

5/5/2018 16

Epi Info 7.2 Main Screen

Classic analysis is the command driven analysis tool which can generate frequencies, means, cross tabulation, graphs, statistical tests with various data management options

Epi Info 7.2 Main Screen

A visual tool for generating frequencies, means, cross tabulation, charts, statistical tests. The analysis is generated in analysis gadgets.

5/5/2018 17

Epi Info 7.2 Main Screen Epi Info 7.2 Main Screen

5/5/2018 18

Epi Info 7.2 Main Screen

Activity-1 Activity-2 Activity-3

Form Designer Module

 The Form Designer module is used for creating Electronic Data

Entry Form.

 It contains all the necessary Field Types for building form questions.  The form can consist of one page or many pages depending upon

the number of questions in the form.

 Different customizations such as conditional skip patterns, data

validation, and custom calculations can applied.

 Multiple forms can be created in the same project file.  The form can also be transferred to Android device for mobile data

collection.

 You can create, save and use Template for quick building of the

questions.

5/5/2018 19

Form Designer Module

Canvas: For creating questions Fields: For different types

• f questions

Enter Module

 Enter module automatically creates data table from the

questionnaire created in the form designer.

 The data table holds all the data which is entered through the

form.

 Form Customizations are applied during the data entry

process which prevents the entry of invalid or ambiguous data.

 Entered record can be revisited using navigations buttons and

if needed can be edited or deleted.

 Finding a particular record for data correction.  Data can be imported from Android device.  On click export of the data to Microsoft Excel.

5/5/2018 20

Enter Module

Electronic Data entry form Pages available in the Electronic Form Record navigation buttons

• Data Line List, Data sorting, frequencies,

means, cross tabulations.

• Statistical analysis (Basic & Advanced).
• Generate new variables.
• Graphical representation of the data.
• Import/Export data (Access, Excel, Dbase).
• Export Analysis to Word, Excel and

HTML format.

• Create program file/syntax file.

Type of Analysis in Epi Info

5/5/2018 21

Epi Info-7 Analysis Modules

Two data analysis modules are available in Epi Info-7

Classic Analysis Visual Dash Board Analysis

These Analysis module can analyze data from two sources:

 Data entered in Epi Info Project.  Data from other sources (Access, Excel, Sql etc).

Classical Analysis Module



Continuation of the analysis module of the older version of epi info 3.5.x.



Command driven point and click analysis.



As the command is run, its codes are added to the program editor.



These analysis codes can be customized, saved, shared, and re-used for revised and further analysis.



The Output window shows the result of data analysis, like frequencies, tables, statistical results graph etc. Commands Output Window Program Editor

5/5/2018 22

• Visual dashboard is new analysis tool for Epi Info-7.
• The characteristic feature of the dashboard is the

Analysis Gadgets.

• Analysis Gadgets are square or rectangular shaped
• bjects which contains analysis results i.e., frequencies,

tables, means, charts etc.

• These gadgets are placed on the work space which is

called Dashboard Canvas.

• The whole dashboard along with gadgets can be saved

and reloaded and exported to Excel, Word or HTML format.

Visual Dashboard Analysis Visual Dashboard Analysis

5/5/2018 23

Visual Dashboard Analysis

Dashboard Canvas Analysis Gadgets

EPI Info-7 Project Files

 When a Project in created in Epi Info-7, it

Creates a folder with the same name.

 Within the folder, two files are

created having same name. 1- Prj file 2- mdb file

5/5/2018 24

Epi Info-7 Data Storage

Two Database Storage Systems can be used in Epi Info-7.

• 1. Microsoft Access Database (Standalone System)
• 2. Microsoft SQL server (Network System)

Microsoft Access Database

• It has an extension of (.MDB)
• Double clicking this file does not
• pen it in Epi Info but opens in

Microsoft Access.

• The data file has to open through Epi Info program.

Main Components of Epi Info Data file

Epi Info Project File

Form (Electronic Questionnaire)

Data Table (Contains Project Data) Program File (Containing analysis Syntax)

5/5/2018 25

Epi Info

Form 1 Form 2 Form 3

DataTable1 DataTable2 DataTable3 Program1 Program2 Program3

Single Epi Info Data file can contain many Forms, Tables and Program files.

What is Form and Data Table?

5/5/2018 26

Comparison of Form and Data Table Data Table Form

Data Table

Comparison of Form and Data Table Data Table Form

Data Table

5/5/2018 27

Steps Involved in Managing Research Data using Epi Info Software

Steps of Managing Data Using Epi Info Software

Step 1

• Create an electronic form in EPI Info
• Create Forms/Form Designer
• Create an electronic form in EPI Info
• Create Forms/Form Designer

Step 2

• Enter data in the form/questionnaire
• Enter Data
• Enter data in the form/questionnaire
• Enter Data

Step 3

• Data Analysis based on analysis plan
• Analysis Data (Classic, Visual Dashboard)
• Data Analysis based on analysis plan
• Analysis Data (Classic, Visual Dashboard)

Step 4

• Exporting analysis output in Microsoft Word
• Analysis output file HTML
• Exporting analysis output in Microsoft Word
• Analysis output file HTML

5/5/2018 28

Steps of Managing Data Using Epi Info Software

Step 1

• Create an electronic form in EPI Info
• Create Forms/Form Designer
• Create an electronic form in EPI Info
• Create Forms/Form Designer

Step 2

• Enter data in the form/questionnaire
• Enter Data
• Enter data in the form/questionnaire
• Enter Data

Step 3

• Data Analysis based on analysis plan
• Analysis Data (Classic, Visual Dashboard)
• Data Analysis based on analysis plan
• Analysis Data (Classic, Visual Dashboard)

Step 4

• Exporting analysis output in Microsoft Word
• Analysis output file HTML
• Exporting analysis output in Microsoft Word
• Analysis output file HTML

Thank you Questions?