Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Overall Data Quality Score

Part 1

Orah latex
an.spaceKeyRDQA
idajbtnq049ce
\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(
      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:

Code Block
Overall Data Quality Score = (Part 1 + Part 2) / (1 + RDQA - M&E Assessment)

System Assessment Score

Part 1:

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)

Part 2:

Code Block
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
)

Final Result:

Code Block
System Assessment Score  = 
(
  (
    Part 1 / Part 2
  ) * 100

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)
depth1
allChildrentrue
style
sortAndReverse
first0