Calcutta Kids has always been focused on a data-driven approach to improve the status of maternal and child health and nutrition in Fakir Bagan. We have been collecting, monitoring and evaluating data from the field regularly to inform our programmatic interventions. We teamed up with a creative and passionate group of individuals from the Social Impact Program at ‘Thoughtworks’, a software company in the US with offices across India. They worked with us to enhance our old database, review the existing monitoring systems and helped create an updated and user-friendly tool.
The new ‘MYCHI database‘ is a tool to enhance the provision of health and other services to groups of pregnant women, mothers and children. The database collects and stores health and other information about women and children, displays the information on individual dashboards and uses visual representations of data and series of predefined reports to guide program management on the ground. The database is open source software, meaning its code is free and with the help of a developer, it can be tailored to the needs of a wide range of organizations.
The MYCHI database was developed around three overarching objectives
- To empower implementers with the tools to practice “developmental evaluation” and make evidence-based adaptations to a program, and maximize the impact on the beneficiaries.
- To monitor and guide day-to-day organizational operations and focus on beneficiaries in need of special attention.
- To identify beneficiaries who may fall through the cracks as they may not independently show up to receive the preventative care.
MYCHI’s foundation is built around information most public health organizations collect about their beneficiaries such as: i. monthly weight and height of children and pregnant beneficiaries, ii. attendance at immunization sessions and iii. incidences of illness to name a few. Once uploaded, MYCHI displays this information on graphs and in reports and uses it to guide day-to-day program management.
Building on this foundation, MYCHI can be tailored to collect a vast amount of additional information about beneficiaries relevant to an organization’s focus and interests. Using beneficiary survey data collected in adaptable online forms, an organization can capture data points as varied as socioeconomic status, medical history and access to government services. This information can be analyzed to identify correlations between demographics and health indicators, red flags in beneficiary health and health seeking behavior, even the success or failure of a programmatic intervention.
A personalized dashboard is generated for every beneficiary immediately following his or her registration. The dashboard displays basic information, familial relations and links to any previously submitted forms. A child’s dashboard displays weight and height records from all GMP sessions on growth charts for growth tracking and captures a child’s personal immunization schedule in a color-coded table that indicates immunization status, (i.e. given, due, critical, overdue.)
Growth Monitoring and Promotion (GMP) and Immunizations
MYCHI makes tracking and encouraging attendance for GMP and Immunization sessions easy using reports that display the names of all beneficiaries due for an upcoming session. Over the course of a three-day GMP session, a report is filled with the height and weight or absent reason of every beneficiary. An Immunization report will be similarly filled during an immunization session as beneficiaries receive their inoculations. When the reports are uploaded, GMP and Immunization data is stored, displayed on beneficiary dashboards and accessible for analysis.
Data is pulled from the backend using reports written in SQL and generated in Jasper. These predefined reports fall into three broad categories, program management reports, status reports and reports for analysis. The first category includes reports that track our progress completing regular tasks like ANC visits for all pregnant women over the course of a month. An ANC status report will identify those beneficiaries who have not been visited so we can complete their visit in the time allotted. These reports help us stay accountable to our beneficiaries in providing the services integral to our program.
The second two categories, status reports and reports for analysis, display information pulled from forms and uploaded reports that a program manager can use to develop new programs and organize work flow.
The MYCHI Database has streamlined the work and improved the monitoring and evaluation systems at Calcutta Kids. As a result, our approach is more targeted and we are able to focus our attention to those who need it the most.
– Post by Lilian Olson