MEASURE EVALUATION Data Quality Assurance Workshop Session 8

MEASURE EVALUATION Data Quality Assurance Workshop Session: 8 Disseminating Results

Topics to Cover Ø How to prepare the final reports Ø Disseminating results Ø Storage and archiving of RDQA files

The RDQA Process Data Verification System Assessment Interpret the Output Develop Action Plans Disseminate Results Ongoing Monitoring & Follow up

Final RDQA Tool Ø A final RDQA Tool file must be compiled § Lock and password protect it to prevent any accidental or intentional changes being made to the archived files § Three simple steps in Excel

Final RDQA Tool – Step 1 On the “Review” tab in Excel, click on “Protect Workbook”

Final RDQA Tool – Step 2 ØA small pop-up window will appear ØLeave the default box checked for “Protect workbook for Structure”

Final RDQA Tool – Step 3 § Carefully enter the password to be used to lock the workbook and then click OK

RDQA Summary Report Ø Based on the consolidated findings of all sites the final report includes: § Brief narrative summary of strengths and weaknesses within the system § RDQA Tool summary dashboards for service delivery points, intermediate aggregation site and M&E Unit § Brief interpretations of the graphs from the tool § Final action plan

Site Briefers Ø Unique to each site visited Ø Includes: § Site specific RDQA Tool dashboard for service delivery points and intermediate aggregation site § Brief interpretations of the graphs from the tool § Site specific recommendations

Copy & Pasting Graphs § To maintain the formatting of the graphs generated by the tool, use “paste as picture” § First, select the dashboard you want to copy/paste § Copy using CTRL+C and pasting CTRL+V

Copy & Pasting Graphs • • Next, open your summary report or site briefer word document. To paste the dashboard as a picture: • Click where the dashboard should appear on the document • Click on the “Paste” dropdown from the upper left • Select “Paste Special” from the dropdown

Copy & Pasting Graphs § From the window that appears, select “Picture” to paste the dashboard

Copy & Pasting Graphs Ø As a shortcut, copy the dashboard (CTRL+C) and right click where you want the image to appear Ø On the drop down menu that appears, select the small picture icon (a mountain with a sun) from the options displayed

Timeline for Disseminating Results (A recommendation) Ø Each country can have a different timeline to disseminate results. The picture below is a recommended timeline.

National Stakeholder Presentation Ø Done at the discretion of the M&E Unit Ø Decision to require a stakeholder presentation should be made before commencing an RDQA Ø Present RDQA results to stakeholders and allow for feedback on the findings

Storage & Archiving the RDQA Files (A recommended approach) Ø While conducting an RDQA, save the files on the server at Ministry of Health Ø Recommended file naming convention Ø Upload daily – usually by the end of the day Ø Archiving of RDQA files to the server should be conducted in accordance with national policy guidelines Ø All RDQA files should be kept on the server for at least 5 years

Questions & Answers

MEASURE Evaluation is funded by the U. S. Agency for International Development (USAID) and implemented by the Carolina Population Center at the University of North Carolina at Chapel Hill in partnership with Futures Group, ICF International, John Snow, Inc. , Management Sciences for Health, and Tulane University. Views expressed in this presentation do not necessarily reflect the views of USAID or the U. S. government. MEASURE Evaluation is the USAID Global Health Bureau's primary vehicle for supporting improvements in monitoring and evaluation in population, health and nutrition worldwide.

www. measureevaluation. org