Detailed Mechanism Funding and Narrative

Years of mechanism: 2010 2011 2012 2013 2014 2015 2016 2017 2018

Details for Mechanism ID: 7328
Country/Region: Mozambique
Year: 2010
Main Partner: University of North Carolina
Main Partner Program: Carolina Population Center
Organizational Type: University
Funding Agency: USAID
Total Funding: $725,000

MEASURE Evaluation will work with the USG strategic information team to develop and implement a data warehouse that will serve as a repository for all implementing partner reported data for USG Mozambique. There is a critical need for USG technical program staff to have access to user friendly

databases.

The main objectives of this data warehouse are: serve as repository for all retrospective and prospective PEPFAR program data; complement program data with added on data analysis, trend monitoring and mapping capabilities and capacity and; reduce data entry and data cleaning time required of USG technical staff during mid-year and final-year program reports.

Related activities to these objectives include, design and development of data warehouse to meet specified USG requirements, retrospective data entry of USG data reported for the last four years, and training of relevant USG staff and implementing partners in the use of the data warehouse.

Through this activity, the USG will work closely with MEASURE Evaluation around the development and implementation of the data warehouse. In addition, the USG team will continue to monitor the effectiveness and capacity of the data warehouse to provide increase understanding of program data and trends.

In addition, MEASURE Evaluation will also work with the USG SI Team to begin to implement external data quality audits for all USG PEPFAR implementing partners. During FY 2009, the USG worked with MEASURE Evaluation to develop a Routine Data Quality Assurance (RDQA) tool. During 2009, implementing partners were trained to use this tool for internal data quality assessments at least one time per year. The expectation is for this tool to be adapted slightly for external RDQA audits by MEASURE Evaluation.

The main objectives of this external RDQA tool are: ensure the data quality integrity and accuracy by an external auditor for implementing partner reported semi-annul and annual data; meet USG Mission requirements for routinely implemented external data audits as required from Program Monitoring Performance (PMP) and; increase USG technical staff understanding of implementing partner systems and data reporting and collection capacity

Related activities to these objectives will include the adaptation of the RDQA for use by an external team of auditors, the development of a project timeline for implementation of the RDQA for all USG implementing partners and a plan for results dissemination and use.

Funding for Strategic Information (HVSI): $725,000

The partner will work with USG SI staff and PEPFAR implementing partners to develop and implement the data quality assurance and warehouse systems. These services are intended to improve the internal strategic information and data quality monitoring and assessment capacity of both the USG strategic information team and USG implementing partners. There is a critical need for USG SI to enhance the data entry and monitoring systems used to track PEPFAR implementing partner data submissions for semi-annual reports. Data verification and quality checks as part of the planned data warehouse will assist in report monitoring and APR and SAPR data quality assurance checks.

External data quality audits are critical for ensuring that PEPFAR implementing partner program data is validated for validity, reliability, integrity, precision, timeliness and accuracy. Given the volume and breadth of USG programs it is critical to develop and routine systems for assessing data management systems and data flow between provincial-level and national-level programs and between PEPFAR implementing partners and sub-partners.