Overall Data Quality Score
Part 1
We don't have a way to export this macro.
( ( (Source vs. Donor or MIS (%variation) + Source vs. Summary (%variation) + Summary Report vs. Donor or MIS (%variation)) / 3 ) + + (% of available source documents) + (% of completed source documents) + (Confidentiality: Client data is protected * 100) + (Integrity: Are there unauthorised changes? * 100) + (Precision: Data has sufficient detail * 100) + (% of reports received on time) ) / 7
Part 2
( ( (d2:zing(1.9 Staff explain data use correctly) + d2:zing(1.8 Documented feedback to site of reports) + d2:zing(1.5 Documented review of site level reports) + d2:zing(1.11 Documented quality controls in place) + d2:zing(1.12 Adequate and sufficient filing system) + d2:zing(2.3 Passwords in place) + d2:zing(2.2 Digital 1st data entry quality control) + d2:zing(2.4 Systems back ups in place) + d2:zing(1.4 Tool guidance available) + d2:zing(2.1 Paper to digital entry quality control) + d2:zing(1.10 Documented data handling guidance) + d2:zing(1.6 Staff explains data checks correctly) + d2:zing(1.1 Staff explained indicator correctly) + d2:zing(1.2 Standard reporting tools for services) + d2:zing(2.5 Documented stock management guidance) + d2:zing(1.3 Standard reporting tools for stock) + d2:zing(1.7 Documented reporting guidelines) ) / d2:zpvc( M&E System Assessment.RDQA - Assessment - Explain data usage 2, M&E System Assessment.RDQA - Assessment - feedback 2, M&E System Assessment.RDQA - Assessment - periodic reports 2, M&E System Assessment.RDQA - Assessment - quality controls 2, M&E System Assessment.RDQA - Assessment - adequate storage 2, M&E System Assessment.RDQA - Assessment - quality controls database 2, M&E System Assessment.RDQA - Assessment - quality controls electronic 2, M&E System Assessment.RDQA - Assessment - back-up files 2, M&E System Assessment.RDQA - Assessment - clear instructions 2, M&E System Assessment.RDQA - Assessment - quality controls paper 2, M&E System Assessment.RDQA - Assessment - data handling guide 2, M&E System Assessment.RDQA - Assessment - routine data checks 2, M&E System Assessment.RDQA - Assessment - Explain indicators 2, M&E System Assessment.RDQA - Assessment - Standard tools for services 2, M&E System Assessment.RDQA - Assessment - written guidance copy 2, M&E System Assessment.RDQA - Assessment - Standard tools for stock 2, M&E System Assessment.RDQA - Assessment - written guidelines 2 ) ) * 100 )
Result:
Overall Data Quality Score = (Part 1 + Part 2) / (1 + RDQA - M&E Assessment)
System Assessment Score
Part 1:
d2:zing(M&E System Assessment.RDQA - Assessment - Explain data usage 2) + d2:zing(M&E System Assessment.RDQA - Assessment - feedback 2) + d2:zing(M&E System Assessment.RDQA - Assessment - periodic reports 2) + d2:zing(M&E System Assessment.RDQA - Assessment - quality controls 2) + d2:zing(M&E System Assessment.RDQA - Assessment - adequate storage 2) + d2:zing(M&E System Assessment.RDQA - Assessment - quality controls database 2) + d2:zing(M&E System Assessment.RDQA - Assessment - quality controls electronic 2) + d2:zing(M&E System Assessment.RDQA - Assessment - back-up files 2) + d2:zing(M&E System Assessment.RDQA - Assessment - clear instructions 2) + d2:zing(M&E System Assessment.RDQA - Assessment - quality controls paper 2) + d2:zing(M&E System Assessment.RDQA - Assessment - data handling guide 2) + d2:zing(M&E System Assessment.RDQA - Assessment - routine data checks 2) + d2:zing(M&E System Assessment.RDQA - Assessment - Explain indicators 2) + d2:zing(M&E System Assessment.RDQA - Assessment - Standard tools for services 2) + d2:zing(M&E System Assessment.RDQA - Assessment - written guidance copy 2) + d2:zing(M&E System Assessment.RDQA - Assessment - Standard tools for stock 2) + d2:zing(M&E System Assessment.RDQA - Assessment - written guidelines 2)
Part 2:
d2:zpvc( M&E System Assessment.RDQA - Assessment - Explain data usage 2, M&E System Assessment.RDQA - Assessment - feedback 2, M&E System Assessment.RDQA - Assessment - periodic reports 2, M&E System Assessment.RDQA - Assessment - quality controls 2, M&E System Assessment.RDQA - Assessment - adequate storage 2, M&E System Assessment.RDQA - Assessment - quality controls database 2, M&E System Assessment.RDQA - Assessment - quality controls electronic 2, M&E System Assessment.RDQA - Assessment - back-up files 2, M&E System Assessment.RDQA - Assessment - clear instructions 2, M&E System Assessment.RDQA - Assessment - quality controls paper 2, M&E System Assessment.RDQA - Assessment - data handling guide 2, M&E System Assessment.RDQA - Assessment - routine data checks 2, M&E System Assessment.RDQA - Assessment - Explain indicators 2, M&E System Assessment.RDQA - Assessment - Standard tools for services 2, M&E System Assessment.RDQA - Assessment - written guidance copy 2, M&E System Assessment.RDQA - Assessment - Standard tools for stock 2, M&E System Assessment.RDQA - Assessment - written guidelines 2 )
Final Result:
System Assessment Score = ( ( Part 1 / Part 2 ) * 100 ) / (1 + RDQA - M&E Assessment)
Overall Data Verification Score
Overall Data Verification Score = ( ( ( Data Verification.RDQA - Accuracy - DocsvsMISPlatform - Variation New + Data Verification.RDQA - Accuracy - DocsvsSummaryReport - variation 2 + Data Verification.RDQA - Accuracy - SummaryReportsvsMISPlatform - Variation 2 ) / 3 + Data Verification.RDQA - Availability - % of available docs + Data Verification.RDQA - Completeness - % of completed docs + Data Verification.RDQA - Confidentiality - Data 2 * 100 + Data Verification.RDQA - Integrity - Data 2 * 100 + Data Verification.RDQA - Precision - Data 2 * 100 + Data Verification.RDQA - Timeliness - ReportsOnTime 2 ) / 7 )
Availability
Data Verification.RDQA - Availability - % of available docs
Completeness
Data Verification.RDQA - Completeness - % of completed docs
Timeliness
Data Verification.RDQA - Timeliness - ReportsOnTime 2
Integrity
Data Verification.RDQA - Integrity - Data 2 * 100
Confidentiality
Data Verification.RDQA - Confidentiality - Data 2*100
Precision
Data Verification.RDQA - Precision - Data 2 * 100
Accuracy
(Data Verification.RDQA - Accuracy - DocsvsSummaryReport - variation 2 + Data Verification.RDQA - Accuracy - DocsvsMISPlatform - Variation New + Data Verification.RDQA - Accuracy - SummaryReportsvsMISPlatform - Variation 2) / Value count
Source vs. Summary
Data Verification.RDQA - Accuracy - DocsvsSummaryReport - variation 2
Source vs. MIS or donor
Data Verification.RDQA - Accuracy - DocsvsMISPlatform - Variation New
Summary vs. MIS or donor
Data Verification.RDQA - Accuracy - SummaryReportsvsMISPlatform - Variation 2
Number of Assessments conducted
Enrollment count