M&E StudioTools

Review Data Quality

Review Data Quality: Your prompt

You are a senior MEAL specialist conducting a data quality review for "program name" (from the material, if given). You will assess data quality across five standard dimensions used by USAID, the Global Fund, and other major frameworks.

the attached or pasted document

Review the data against these five dimensions:

  1. Completeness: What proportion of expected records are present? Are there missing values, skipped questions, or gaps in coverage? Identify which variables or time periods have the highest rates of missing data. Flag any systematic patterns (e.g., specific sites, enumerators, or demographic groups with more missing data).

  2. Accuracy: Are the recorded values plausible and free from systematic errors? Check for outliers, impossible values (e.g., ages over 120, negative counts), and data entry errors. Assess whether measurement tools were applied correctly and consistently.

  3. Consistency: Do related data points align with each other? Check for internal contradictions (e.g., a respondent reporting zero children but answering child health questions). Compare across data sources if available. Flag discrepancies between aggregated and disaggregated figures.

  4. Timeliness: Was data collected and reported within required timeframes? Assess whether delays affected data relevance or usability. Note any gaps in the reporting schedule.

  5. Validity: Do the indicators actually measure what they claim to measure? Assess whether data collection tools capture the intended constructs. Check that skip logic, sampling, and response categories are appropriate.

For each dimension, provide:

  • Rating: Strong / Adequate / Weak
  • Key findings (2-3 bullet points)
  • Specific issues identified with examples
  • Recommended corrective actions

If the material is incomplete: Work only from the data description or dataset summary provided. If a dimension needs detail the summary does not include, such as missing-data rates, known error patterns, or a reporting timeline, rate that dimension as not assessable, say what is missing, and continue with the rest of the review. Do not invent completeness rates, error examples, or findings the summary does not support.

Output Format:

  1. Executive Summary: 3-4 sentences on overall data quality with a composite rating
  2. Dimension-by-Dimension Assessment: Table with columns: Dimension | Rating | Key Findings | Corrective Actions
  3. Priority Issues: Top 3 issues ranked by severity and impact on data usability
  4. Corrective Action Plan: Table with columns: Issue | Action | Responsible Party | Timeline | Verification Method
  5. Recommendations for Future Data Collection: 3-5 bullet points to prevent recurring issues

Where the material is silent, write "Not in the material" rather than guessing.

Document to review: Attached, or pasted below. Base everything above on it and do not invent details that are not in it.

Prompt · Review a Document · about 432 words

A prompt that scores it against the standard, with evidence.

You'll Need

Your document

You Get Back

A scored review with the evidence and the fixes

Parts