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
We don't have a way to export this macro.
( ( (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(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)
Part 2:
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 )
Final Result:
System Assessment Score = ( ( Part 1 / Part 2 ) * 100
Overall Data Verification Score
Overall Data Verification Score = ( ( ( 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 )
Availability
% of available source documents
Completeness
% of completed source documents
Timeliness
% of reports received on time
Integrity
Integrity: Are there unauthorised changes? * 100
Confidentiality
Confidentiality: Client data is protected * 100
Precision
Precision: Data has sufficient detail * 100
Accuracy
(Source vs. Summary (%variation) + Source vs. Donor or MIS (%variation) + Summary Report vs. Donor or MIS (%variation)) / Value count
Source vs. Summary
Source vs. Summary (%variation)
Source vs. MIS or donor
Source vs. Donor or MIS (%variation)
Summary vs. MIS or donor
Summary Report vs. Donor or MIS (%variation)
Number of Assessments conducted
Enrollment count