1 / 25

Presented by Diane Baik, WVI

Development and rollout of an online system that improves CMAM program performance and operations. Presented by Diane Baik, WVI. Presentation Overview. Rational for Online Database (DB) Development Process for DB DB Functionalities Results and outputs from WV CMAM DB (2006-2013)

kamran
Download Presentation

Presented by Diane Baik, WVI

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Developmentand rollout of an online system that improves CMAM program performance and operations Presented by Diane Baik, WVI

  2. Presentation Overview 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)

  3. 1. Rationale for development of online system 2006 – CMAM programming started in WV 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. 2009- rapid expansion of WV supported CMAM programs, urgent need to address these limitations and standardize indicators across WV

  4. 2. Process of Database Development 2009 – consultant hired 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

  5. Financials (2010 – 2013) *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

  6. 3. Functionalities of online CMAM db New Online CMAM db allows WV, and in some countries, MoH personnel, to: • Input monthly tally sheets • Generate clear reports and graphs (including, monthly and summary reports for the site, district, and region) at a ‘click of a button’ • Export raw data to Excel

  7. 3. Functionalities of online CMAM db (cont’d…) Functionalities

  8. 3.1 Input Tally Sheets/Data – OTP, SC, SFP, & SFP-PLW

  9. 3.2 Generates Summary Reports

  10. Summary Reports in MS Excel

  11. Graph #1 Generated in Excel

  12. Graph #2 Generated in Excel

  13. Graph #3 Generated in Excel

  14. 3.3 Export Raw Data into Excel

  15. 4. WV CMAM Program Results (2006-2013)

  16. Sphere standard for SAM is >75%

  17. Sphere standard for MAM is >75%

  18. Sphere standard for SAM is >75%

  19. 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 • Accessibility of data online from anywhere (support offices and national offices – provide info to donors quickly) • Improve program quality and project summaries help to prioritize the programs to provide extra support • Majority of Feedback: DB is user-friendly,not very time consuming to use, yet it collects sufficient info/data

  20. 6. Additional features to come…. • mHealth • use mobile phones to input/collect data (track individual child level data/aggregate) • New indicators: Average Length of Stay and Average Weight Gain • Tracking RUTF Consumption: • Account for RUTF consumption, projections and shortages • Tracking Essential Medications for Systematic Treatments: • Account for the different medication usage, projections and shortages • Data Validation: • Improve the validity of our CMAM data with the introduction of features that minimize data inputting errors • Accounting for Missing Data • Automatic msging embedded in online reports/graphs to account for missing data • CMAM Capacity Building • Track the # of staff (MOH, WV and Other) trained on the various CMAM competencies • Blanket Supplementary Feeding Program (BSFPs) • Input, Monitor and Evaluate all BSFP program data

  21. Acknowledgments Special thanks to the following contributors: Tim Roberton, JHU Sarah Carr, Diane Baik, Colleen Emary, Bridget Aidam, World Vision International (Nutrition Centre of Expertise)

More Related