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( 1.9 Staff explain data use correctly, 1.8 Documented feedback to site of reports, 1.5 Documented review of site level reports, 1.11 Documented quality controls in place, 1.12 Adequate and sufficient filing system, 2.3 Passwords in place, 2.2 Digital 1st data entry quality control, 2.4 Systems back ups in place, 1.4 Tool guidance available, 2.1 Paper to digital entry quality control, 1.10 Documented data handling guidance, 1.6 Staff explains data checks correctly, 1.1 Staff explained indicator correctly, 1.2 Standard reporting tools for services, 2.5 Documented stock management guidance, 1.3 Standard reporting tools for stock, 1.7 Documented reporting guidelines ) ) * 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