External Public Page

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this content. View the current version.

Compare with Current View Version History

« Previous Version 10 Next »

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

(
  (
    (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(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
  • No labels