Overall Data Quality Score
Part 1
| Code Block |
|---|
( ( ( |
...
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 |
Part 2
| 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) ) / 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
| Code Block |
|---|
Enrollment count |