RDQA Technical Manual: Program Indicators

Overall Data Quality Score

Part 1

We don't have a way to export this macro.

(
  (
    (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

(
  (
    (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:

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