Facility Level Reporting Training Presentations_UNICEF HMIS

Day 1

Understanding your role in HMIS, key indicators, understanding your data

Introductions, Expectations, and ground rules

Please state:
Your name
Facility and role
One expectation

Training Objectives, Design, and Agenda

Training Objectives

To assist participants in understanding their data collection tools better
To

Workshop Design

You will interact with all your data collection tools and

Agenda

Day 1: Understanding your role in HMIS, key indicators, understanding your

HMIS Overview and Your Place In It

Understanding the system

Understanding the System

To understand data collection you have to first understand

Patient Level

The goal of the health system is to ensure that

Needs at each Level

What does each level need to have to

Putting it together

National: Results Policy Finance Goals
District: Results Finance Training Protocols

Understanding the Connectedness

Every critical item in the patient cycle does not

? We are now going to connect dependent items between levels

Where do information systems come in?

These information systems allow people who

Where do information systems come in?
National: Results Policy Etc.
District: Finance Training

Where does the HMIS come in?
National: Results Policy
District: Finance Training Protocols

This whole thing is the Health Management Information System
National: Results Policy
District:

…..and this is where you fit in data-wise
National: Results Policy
District: Finance

Current reporting challenges

Discussion

Facility Level Reporting

How will it work?

HMIS

Currently:

Facility Level Reporting:

Theory of Change

By having you (facility staff) directly enter data into

Key HMIS indicators

Understanding YOUR data

Maternal and Child Health

Fully immunized children
Underweight children
1st ANC visit
Institutional Deliveries
Family planning

HIV/AIDS

PMTCT
Virology/Serology
General counselling and Testing
Current in ART
ART retention
VMMC

Tuberculosis

Notifications for TB
Percentage of Retreatment cases
Cure Rate
Mortality Rate
Commenced on ARVs
Commenced

Sexually Transmitted Infections

STI cases
STI+ tested for HIV

Adolescent/Reproductive Health

1st ANC <18yrs old (measures teen pregnancies)
HIV positive adolescents
Adolescents on

Malaria

Incidence/1000
Cases under 5
Cases over 5

Your data collection tools

Understanding Facility Registers (DHIO to present)

Facility Registers

These are used to collect raw data
Individual data elements are

Tally Sheets

These “tally” up totals from registers
Consolidate register data into a

HIA1 and HIA2

Filled in at the end of the month
Sent to

HIA4 (Where applicable)

Filled in at the end of the month
Sent to

Exercise

Think about registers you have problems with. Depending on what the

Tips for making the collection and troubleshooting process easier

Fill in data

Data Quality

Generating Quality Data

Before submitting reports, data collectors must:
Spot-check a small percentage

What is wrong with this data?

Exercise

Use the registers and tally sheets you brought with you to

Day 2

Into DHIS2 -- creating charts and pivot tables, saving favorites,

What is DHIS2?

District Health Information System
Open source software
Born out of HISP
Zambia’s

What does it do?

The DHIS2 Model

Pivot Tables

Module:

A pivot table is …

A tool that allows you to reorganize

A pivot table is …

The foundation of
Data aggregation
Data analysis
Data

Open Module

Apps
Select ‘Pivot Table’ from dropdown

Default Pivot Table

Data Selection

Define
DE / Indicator / Reporting rates (WHAT)
Period (WHEN)
Orgunit (WHERE)
Update

WHAT
Indicator
Data Elements
Reporting Rates

WHEN
Relative e.g. last 12 months
Fixed e.g. Feb 2014

WHERE
Standard
Select

Pivot Table Parameters: When

Relative
Months
Years
Quarters

Fixed
Days
Weeks
Months
Quarters
Years

Pivot Table Parameters: Where

Organization Unit
+ to show subunits
Ctrl to select multiple
Right

Harmony RHC

WHEN: Monthly→ September 2015

WHERE: All subunits (i.e. Districts) under Luapula Province

WHAT:

Result

Data Element: ANC 1st visit
Org Unit: All Luapula Districts
Default pivot table

Pivoting / Changing layout

Select ‘Layout’
Drag-n-drop orgunits to rows

Pivoting / Changing layout

Select ‘Layout’
Drag-n-drop orgunits to column

Options

Small modifications in formatting
Show totals
Show sub-totals

Worked Example…

Not very intuitive to read. PIVOT!!!

Maternal health: ANC and PNC

Data elements
1st

Move Orgunits to Column (below Data)

Move Orgunits to Column (above Data)

Pivoted

Pivoted

Move Orgunits to Row (above Period)

Move Orgunits to Row (below Period)

Download

Click download
Excel (XLS)
Can then do other calculations / incorporate into other

Manage Favourites

Add New
Open saved chart
Rename
Overwrite
Share
Delete

Exercise Sheet

Work through each example on the worksheet
Don’t skip any sections
Ask

Charts

Module:

Overview

Charts, graphs, and tables provide a great deal of visual

Overview cont’d

In educational settings, charts, graphs, and tables can be

Six things conveyed by charts & graphs

Comparisons
Relationships
Distribution
Trends
Composition 
Flow/process, or

Reasons for creating charts and graphs

Make important trends easily recognizable
Allow users

Charting considerations

Type of data
Purpose of the data
Nature of the data or

Open Module

Apps
Select ‘Data Visualizer’ from dropdown

Default Data Visualizer

Chart type

Select from
Column
Stacked column
Bar
Stacked bar
Line
Area
Pie
Spider charts

Never use the ‘Back’ button

Chart parameters

Data:
Indicators
Date Elements
Reporting Rates

Period:
Relative e.g. Last quarter
Fixed e.g.

Example

Chipata District’s 1st ANC coverage over the last 6 months.

WHAT
WHEN
WHERE

Indicator –

Example

Chipata’s 1st ANC coverage over the last 6 months

SERIES
CATEGORY
FILTERS

DATA

X-axis

What

Chipata’s 1 ANC <14 weeks, Total ANC over the last 6

Options

Small modifications in formatting
Change Title
Show trendlines

Worked example …

Open a saved chart

Go to:
Favorites
Search for “Choma Reporting rates”
Select Title

Choma Reporting Rates

Line Chart
Series (Data), Category (Period), Filter (Organisation unit)
What:
Reporting

Download charts

Two options available
Standard image (PNG)
PDF
PDF is higher quality if this

Manage favorites

Rename
Overwrite
Share
Delete

Exercise Sheet

Work through each example on the work sheet
Don’t skip any

Data Entry

Module

When to do data entry

Entering HIA 1 and 2 forms
Suggested 1

WARNING!

Data entry is live
No undo button
I error in population data impacts

HOW

Apps > Data Entry

HOW

Select facility
Select Form
Select Period
Enter Data

Worked Examples

Use the tally sheets you brought from your facility to

Group Discussion

Feedback
Closing