Developement of an easy to use and flexible M&E database for HAI-Heartland Alliance for Human Needs & Human Rights
- Date : April 2016 – May 2016
- Categories : DHIS2 Development and Implementation
- Client : Heartland Alliance International
Heartland Alliance International (HAI) is the youngest and fastest growing part of Heartland Alliance for Human Needs & Human Rights, a family of organizations that has been leading anti-poverty and social justice work in chichago for more than 125 years. HAI is comprised of nearly a dozen country offices implementing programs on a broad range of human rights issues globally, as well as the Chicago-based Marjorie Kovler Center for the treatment of survivors of torture, which serves individuals from more than 50 countries.
Scope of Assignment
Centrifuge undertook the following:
- Develop an easy to use and flexible M&E database for HAI using the District Health information system (DHIS) platform.
- Build capacity of relevant staff to create and modify data elements in the database
- Travel to two (2) states(Benue and Cross River) to conduct trainings.
- Developed an easy to use and flexible M&E database for HAI using the District Health Information system (DHIS) platform.
- Travelled to two (2) states (Benue and Cross River) to conduct trainings.
- Took cognizance of the existing program specific M&E framework, determined how the key data elements can be integrated into the DHIS software which will be known as the “Heartland Alliance International Design, Monitoring, Evaluation, and Learning System” or “HAI DMEL system.”
- Created a data for M&E using DHIS platform and ensuring the following
- The capture of all facilities in HAI-supported Local Government Areas (LGAs.)
- Categorizing all facilities in the states according to level of care, LGAs, clusters, type, exact location, ownership, and any other pertinent information for precise cataloguing in the database.
- Ensuring the capture of selection HAI program data elements including logistics data elements in the database.
- Create of appropriate data entry form in the software.
- Making provision for appropriate composite indicators as necessary.
- Ensuring appropriate validation rules exist to capture qualitative data.
- Integrate mapping capability into the database.
- Integrate multiple dashboards into the database.
- Create modules to capture data from surveys and assessments encompassing standard and HAI surveys and assessments.
- Populating the database with already existing programmatic data from the M&E data.
- Built capacity of relevant staff to create and modify data elements in the database.
- conduct of training of key HAI staff to create and modify data elements and build organizational units. This includes full information cycle of collecting data, running quality checks, data access at multiple levels, reporting, making graphs/maps/other forms of analysis, enabling comparison across time (for example, previous months) and space (for example, across facilities and districts), and see trends (displaying data in time series to see their minimum and maximum levels.)
- conduct training of selected HAI staff to enter data and produce all standard and required reports.
- Build capacity f key HAI staff to troubleshoot database including, but not limited to, issues with organizational heirarchy, data elements, datasets and data entry forms, validation rules, indicators, report tables, GIS, charts, and dashboards.
- Build the capacity of HAI staff to creeate data elements, periods, orgainization units, and attribute combinations to store data from all HAI surveys.
- Create a simple manual to capture relevant skills required to operate the database and troubleshoot the most common problems.
- Provide technical support for the database.
Key Deliverables and Outcomes
- This activity led to the creation of a simple, effective and easy to use M&E database for HAI.
- Relevant staff were trained to use the database to create new data elements and organizational units, enter and analyse data and troubleshoot the database.
- Relevant staff are conversant in the database and are able to create new data elements and organizational units, enter and analyze data, display data in multiple formats, and troubleshoot the database.
- A manual covering relevant skills required to operate the database and troubleshoot the most common problems.
- Available for troubleshooting, maintenance, and training on request of database for a period of 12 months from the installation date.
- From N 5, 500,000 to N 16, 000, 000