Transcript f2 world vision - Coverage Monitoring Network

Global Health and WASH
Development and rollout of an
online system that improves
CMAM program performance
and operations
Presented by Diane Baik, WVI
Working in maternal and child health, nutrition, HIV and AIDS, and water, sanitation and hygiene
GLOBAL HEALTH & WASH
Presentation Overview
1.
2.
3.
4.
5.
6.
Rational for Online Database (DB)
Development Process for DB
DB Functionalities
Results and outputs from WV CMAM DB (2006-2013)
Lessons Learned
Future Plans (Additional Features)
EMPOWER, EQUIP, ADVOCATE
GLOBAL HEALTH & WASH
1. Rationale for development of online system
o 2006 – CMAM programming started in WV
o Excel-based data collection sheets had many limitations
•
•
•
•
•
Time consuming
Prone to human error
Frequent staff turnover – lost data
Data not used to inform programming
Challenge to respond to regional/global requests for program
data in a timely manner – frequent visits to the field required.
o 2009- rapid expansion of WV supported CMAM programs,
urgent need to address these limitations and standardize
indicators across WV
EMPOWER, EQUIP, ADVOCATE
GLOBAL HEALTH & WASH
2. Process of Database Development
o 2009 – consultant hired
o 2010 – url launched http://cmam.wvncoe.org
– 9 mo pilot in Kenya & Niger (available in French)
– 3 mo pilot in Ethiopia
– Collected historical data from 10 countries (paper/MS Excel)
– Roll-out and scale-up
• Development of training materials (3 day)
• Training of external consultants (Valid)
• Orientation sessions for Regional, Support Office staff
• 2011-2012 – DB rolled out to 15 countries and 14 are currently
utilizing it
•
Angola, Burundi, Chad, DRC/E DRC, Ethiopia, Kenya, Somalia, Sudan, S Sudan, Mali, Mauritania,
Niger, Pakistan, Zambia, Zimbabwe – 330 users in total
EMPOWER, EQUIP, ADVOCATE
Financials (2010 – 2013)
Budget Item
Cost
Consultant* – Development of Database
$34,000
Consultant* – Addition/Revision of Features
$8,000
Roll-out **– (Ex. DRC, Ethiopia, S Sudan, Zambia, Regional $18,000
Advisors, Kenya, Niger)
TOTAL $60,000
*Consultancy costs do not include NCOE Staff Time
*Consultant hired on his reduced rate ($60/hr vs. $70-80/hr)
**Trainings included participants from additional countries
New
User Fees: Annual Fee of $500/CMAM program
-to be introduced in FY14
GLOBAL HEALTH & WASH
3. Functionalities of online CMAM db
o New Online CMAM db allows WV, and in some countries, MoH
personnel, to:
1. Input monthly tally sheets
2. Generate clear reports and graphs (including, monthly and
summary reports for the site, district, and region) at a ‘click of a
button’
3. Export raw data to Excel
EMPOWER, EQUIP, ADVOCATE
GLOBAL HEALTH & WASH
3. Functionalities of online CMAM db (cont’d…)
Functionalities
EMPOWER, EQUIP, ADVOCATE
GLOBAL HEALTH & WASH
3.1 Input Tally Sheets/Data – OTP, SC, SFP, & SFP-PLW
EMPOWER, EQUIP, ADVOCATE
GLOBAL HEALTH & WASH
3.2 Generates Summary Reports
EMPOWER, EQUIP, ADVOCATE
GLOBAL HEALTH & WASH
Summary Reports in MS Excel
EMPOWER, EQUIP, ADVOCATE
GLOBAL HEALTH & WASH
Graph #1 Generated in Excel
EMPOWER, EQUIP, ADVOCATE
GLOBAL HEALTH & WASH
Graph #2 Generated in Excel
EMPOWER, EQUIP, ADVOCATE
GLOBAL HEALTH & WASH
Graph #3 Generated in Excel
EMPOWER, EQUIP, ADVOCATE
GLOBAL HEALTH & WASH
3.3 Export Raw Data into Excel
EMPOWER, EQUIP, ADVOCATE
GLOBAL HEALTH & WASH
4. WV CMAM Program Results (2006-2013)
Total OTP admissions by country
All years (2006-2013)
35,000
33,300
32,393
Children admitted
30,000
25,000
20,000
18,303
14,610
15,000
9,990
9,183
10,000
6,498
5,000
3,495
1,885
1,935
1,375
2,504
-
EMPOWER, EQUIP, ADVOCATE
588
356
GLOBAL HEALTH & WASH
Total SFP admissions by country
All years (2006-2013)
70,000
65,092
Children admitted
60,000
57,195
50,000
42,229
40,000
34,056
29,953
30,000
20,000
17,814
20,149
10,000
3,357
4,168
4,875
1,208
-
EMPOWER, EQUIP, ADVOCATE
GLOBAL HEALTH & WASH
Total OTP admissions by country and admission type
All years
30,000
Children admitted
25,000
20,000
15,000
10,000
5,000
0
Oedema
EMPOWER,
EQUIP, ADVOCATE
WFH
MUAC
Other (including referral)
Empower
Proportion of OTP discharges by discharge outcome
All countries, all years
Equip
Advocate
Died
0.6%
Defaulted
7.6%
Non-recovered
2.1%
Recovered
89.7%
Empower
Equip
Proportion of SFP discharges by discharge outcome
All countries, all years
Advocate
Defaulted
5.6%
Non-recovered
2.1%
Recovered
92.2%
Empower
Proportion of OTP discharges by country and discharge outcome
Equip Advocate
All years
100%
90%
Sphere
standard
for SAM
is >75%
80%
70%
60%
50%
40%
30%
20%
10%
0%
Recovered
Died
Defaulted
Non-recovered
Empower
Proportion of SFP discharges by country and discharge outcome
Equip Advocate
All years
100%
90%
Sphere
standard
for MAM
is >75%
80%
70%
60%
50%
40%
30%
20%
10%
0%
Recovered
Died
Defaulted
Non-recovered
EXAMPLE OF FUTHER ANALYSIS: CORRELATION BETWEEN PROGRAM
SIZE AND OUTCOMES
Proportion of discharges recovered by country total admissions
All years
100%
Somalia
Burundi
90%
Mauritania North Sudan
80%
Ethiopia
Pakistan
DRC
South Sudan
Niger
Sphere
standard
for SAM
is >75%
Kenya
70% Zimbabwe
Mali
60%
Chad
Zambia
50%
40%
30%
20%
10%
0%
0
5,000
10,000
15,000
20,000
25,000
30,000
35,000
GLOBAL HEALTH & WASH
5. What have we learned?
Improved complete collection of data
Time-saving (data entry & generating reports/graphs)
Improving accuracy of data (flags inaccurate data)
Facilitate process of feedback back to field level for
decision making
o Accessibility of data online from anywhere (support offices
and national offices – provide info to donors quickly)
o Improve program quality and project summaries help to
prioritize the programs to provide extra support
o Majority of Feedback: DB is user-friendly, not very time
consuming to use, yet it collects sufficient info/data
o
o
o
o
EMPOWER, EQUIP, ADVOCATE
GLOBAL HEALTH & WASH
6. Additional features to come….
1.
mHealth
– use mobile phones to input/collect data (track individual child level data/aggregate)
– New indicators: Average Length of Stay and Average Weight Gain
2.
Tracking RUTF Consumption:
– Account for RUTF consumption, projections and shortages
3.
Tracking Essential Medications for Systematic Treatments:
– Account for the different medication usage, projections and shortages
4.
Data Validation:
– Improve the validity of our CMAM data with the introduction of features that minimize
data inputting errors
5.
Accounting for Missing Data
– Automatic msging embedded in online reports/graphs to account for missing data
6.
CMAM Capacity Building
– Track the # of staff (MOH, WV and Other) trained on the various CMAM competencies
7.
Blanket Supplementary Feeding Program (BSFPs)
– Input, Monitor and Evaluate all BSFP program data
EMPOWER, EQUIP, ADVOCATE
GLOBAL HEALTH & WASH
Acknowledgments
Special thanks to the following contributors:
o Tim Roberton, JHU
o Sarah Carr, Diane Baik, Colleen Emary, Bridget Aidam,
World Vision International (Nutrition Centre of Expertise)
EMPOWER, EQUIP, ADVOCATE