✍ External Public Page ✍
RDQA Technical Manual: Overall Program Calculations
- Henry Lopez
Overall Data Quality Score
Average of the Data Verification and System Assessment scores
Result:
Overall Data Quality Score = (Part 1 + Part 2) / (1 + Do you want to do an M&E assessment?)
Part 1
(
(
(Source vs. Donor or MIS (%variation)
+ Source vs. Summary (%variation)
+ Summary Report vs. Donor or MIS (%variation)) / 3
)+ Availability
+ Completeness
+ Timeliness
+ (Confidentiality: Client data is protected * 100)
+ (Integrity: Are there unauthorised changes? * 100)
+ (Precision: Data has sufficient detail * 100)
+ (% of reports received on time)
) / 7The calculations for the following Data Elements can be found at the following link:
Availability
Completeness
Timeliness
Source vs. Donor or MIS (% variation)
Source vs. Summary (% variation)
Summary Report vs. Donor or MIS (% variation)
Part 2
(
(
(d2:zing(1.1 Staff explained indicator correctly)
+ d2:zing(1.2 Standard reporting tools for services)
+ d2:zing(1.3 Standard reporting tools for stock)
+ d2:zing(1.4 Tool guidance available)
+ d2:zing(1.5 Documented review of site level reports)
+ d2:zing(1.6 Staff explains data checks correctly)
+ d2:zing(1.7 Documented reporting guidelines)
+ d2:zing(1.8 Documented feedback to site of reports)
+ d2:zing(1.9 Staff explain data use correctly)
+ d2:zing(1.10 Documented data handling guidance)
+ d2:zing(1.11 Documented quality controls in place)
+ d2:zing(1.12 Adequate and sufficient filing system)
+ d2:zing(2.1 Paper to digital entry quality control)
+ d2:zing(2.2 Digital 1st data entry quality control)
+ d2:zing(2.3 Passwords in place)
+ d2:zing(2.4 Systems back ups in place)
+ d2:zing(2.5 Documented stock management guidance)
)
/
d2:zpvc(
1.1 Staff explained indicator correctly,
1.2 Standard reporting tools for services,
1.3 Standard reporting tools for stock,
1.4 Tool guidance available,
1.5 Documented review of site level reports,
1.6 Staff explains data checks correctly,
1.7 Documented reporting guidelines,
1.8 Documented feedback to site of reports,
1.9 Staff explain data use correctly,
1.10 Documented data handling guidance,
1.11 Documented quality controls in place,
1.12 Adequate and sufficient filing system,
2.1 Paper to digital entry quality control,
2.2 Digital 1st data entry quality control,
2.3 Passwords in place,
2.4 Systems back ups in place,
2.5 Documented stock management guidance
)
) * 100
)Functions:
d2:zing: Evaluates the argument of type number to zero if the value is negative, otherwise to the value itself.
d2:zpvc: Returns the number of numeric zero and positive values among the given object arguments. Can be provided with any number of arguments.
System Assessment Score
The system assessment checklist enables the qualitative assessment of the strengths and weaknesses of the functional areas of the data management and reporting system. While is it recommended that both parts of this tool (Data Verification and System Assessment) be used to fully assess data quality, the system assessment component could be conducted less often. This can be done during the initial assessment (baseline) and can be triggered when the site scores low on the data verification component.
Final Result:
Part 1:
Part 2:
Functions:
d2:zing: Evaluates the argument of type number to zero if the value is negative, otherwise to the value itself.
d2:zpvc: Returns the number of numeric zero and positive values among the given object arguments. Can be provided with any number of arguments.
Overall Data Verification Score
This section facilitates the assessment of the quality of data for the selected indicator. It involves the review of documents based on the data quality dimensions i.e. accuracy, completeness, etc.
Related content
✍ External Public Page ✍
"RDQA Metadata Package" by Population Services International is in the Public Domain.