Overall Data Quality Score
Part 1
Orah latex |
---|
an.spaceKey | RDQA |
---|
id | ajbtnq049ce |
---|
|
\begin{equation}
\frac{
\left(
\frac{
(\text{Data Verification.RDQA - Accuracy - DocsvsMISPlatform - Variation New}
+ \text{Data Verification.RDQA - Accuracy - DocsvsSummaryReport - Variation 2}
+ \text{Data Verification.RDQA - Accuracy - SummaryReportsvsMISPlatform - Variation 2})
}{3}
\right)
+ \text{Data Verification.RDQA - Availability - \% of available docs}
+ \text{Data Verification.RDQA - Completeness - \% of completed docs}
+ (\text{Data Verification.RDQA - Confidentiality - Data 2} \times 100)
+ (\text{Data Verification.RDQA - Integrity - Data 2} \times 100)
+ (\text{Data Verification.RDQA - Precision - Data 2} \times 100)
+ \text{Data Verification.RDQA - Timeliness - ReportsOnTime 2}
}{7}
\end{equation}
|
We don't have a way to export this macro.
Code Block |
---|
(
(
(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
Code Block |
---|
(
(
(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:
Code Block |
---|
Overall Data Quality Score = (Part 1 + Part 2) / (1 + RDQA - M&E Assessment) |
System Assessment Score
Part 1:
Code Block |
---|
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:
Code Block |
---|
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:
Code Block |
---|
System Assessment Score =
(
(
Part 1 / Part 2
) * 100
) / (1 + RDQA - M&E Assessment) |
Overall Data Verification Score
Code Block |
---|
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
Code Block |
---|
Data Verification.RDQA - Availability - % of available docs |
Completeness
Code Block |
---|
Data Verification.RDQA - Completeness - % of completed docs |
Timeliness
Code Block |
---|
Data Verification.RDQA - Timeliness - ReportsOnTime 2 |
Integrity
Code Block |
---|
Data Verification.RDQA - Integrity - Data 2 * 100 |
Confidentiality
Code Block |
---|
Data Verification.RDQA - Confidentiality - Data 2*100 |
Precision
Code Block |
---|
Data Verification.RDQA - Precision - Data 2 * 100 |
Accuracy
Code Block |
---|
(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
Code Block |
---|
Data Verification.RDQA - Accuracy - DocsvsSummaryReport - variation 2 |
Source vs. MIS or donor
Code Block |
---|
Data Verification.RDQA - Accuracy - DocsvsMISPlatform - Variation New |
Summary vs. MIS or donor
Code Block |
---|
Data Verification.RDQA - Accuracy - SummaryReportsvsMISPlatform - Variation 2 |
Number of Assessments conducted
...
The RDQA Program is designed to assess the quality of data and underlying systems related to indicators reported to programs or donors. It facilitates routine data quality checks at the service delivery level, including for program sub-recipient members.
The RDQA Program includes several Program Rules and Program Indicators to display results for each assessment conducted. The calculations and methodologies used are detailed in the following pages:
Child pages (Children Display) |
---|
depth | 1 |
---|
allChildren | true |
---|
style | |
---|
sortAndReverse | |
---|
first | 0 |
---|
|