Monitoring, Evaluation and Data Analysis for Projects Training Course

Participants can develop a theory of change and logframe for a project intervention.

• Theory of Change maps pathways, assumptions, actors and intended change
• Logframe hierarchy aligns goal, outcome, outputs and planned activities
• Vertical logic checks whether lower-level results plausibly support higher results
• Horizontal logic specifies indicators, verification sources, assumptions and risks
• Contribution analysis distinguishes project influence from wider contextual change
• Stakeholder validation tests causal assumptions before implementation begins

Participants can formulate measurable indicators and set credible baselines and targets.

• SMART indicator criteria test relevance, feasibility, precision and timeliness
• Indicator types distinguish quantity, quality, process, outcome and perception measures
• Numerator and denominator definitions prevent inconsistent percentage calculations
• Disaggregation categories reflect sex, age, disability, location and vulnerability
• Baseline studies establish starting values before significant project delivery
• Target-setting methods use trend data, capacity and implementation assumptions
• Proxy indicators selected where direct measurement is impractical or unsafe

Participants can document indicators so that different users measure them consistently.

• Indicator reference sheets specify definitions, purpose, calculation and interpretation
• Data sources identify records, surveys, observation and administrative systems
• Collection frequency matches decision timing, reporting cycles and resource availability
• Responsibility assignments separate data collection, validation, analysis and approval
• Indicator performance tracking tables compare baseline, target and actual values
• Results frameworks connect indicators with data sources and reporting responsibilities

Participants can design a practical monitoring system linked to project management routines.

• Monitoring questions focus data collection on operational and strategic decisions
• Performance monitoring plans schedule indicators, methods, owners and reporting dates
• Routine monitoring combines activity records, service data and field observations
• Monitoring calendars align collection with workplans, milestones and donor deadlines
• Feedback loops route findings to managers, communities and implementing partners
• Exception reporting highlights delayed activities, underperformance and emerging risks

Participants can select collection methods and design fit-for-purpose data instruments.

• Method selection matches indicators with surveys, interviews, observation and records
• Questionnaire design uses neutral wording, logical sequencing and response categories
• Observation checklists define observable behaviours, conditions and scoring rules
• Key informant interview guides organise evidence around focused evaluation questions
• Focus group discussion guides separate participant experiences from group consensus
• Skip logic and validation rules reduce respondent burden and entry errors
• Pilot testing identifies ambiguous questions, missing options and timing problems

Participants can select and justify a sampling approach for common project studies.

• Target populations, sampling frames and units of analysis defined precisely
• Probability sampling uses random, systematic, stratified and cluster selection
• Purposive sampling supports qualitative inquiry and hard-to-reach participant groups
• Sample size considers precision, confidence, resources and expected nonresponse
• Stratification improves representation of priority groups and geographic areas
• Sampling error and bias assessed before interpreting study findings

Participants can plan ethical data collection that protects respondents and sensitive information.

• Informed consent explains purpose, voluntary participation, risks and confidentiality
• Do-no-harm assessment identifies potential distress, stigma and protection concerns
• Safeguarding referral protocols address disclosures involving children and vulnerable adults
• Data minimisation limits collection to information required for stated purposes
• Anonymisation removes direct identifiers before analysis, sharing and publication
• Role-based access controls restrict sensitive datasets to authorised personnel

Participants can establish data management procedures and assess data quality systematically.

• Data management plans define storage, naming, access, retention and destruction
• Codebooks document variable names, labels, formats and permitted values
• Data cleaning identifies duplicates, missing values, outliers and invalid entries
• Range checks and consistency checks detect contradictory survey responses
• Data Quality Assessment reviews validity, reliability, precision, integrity and timeliness
• Source-data verification compares reported results with registers and supporting records
• Version control records changes to datasets, tools and calculated indicators

Participants can clean, calculate and summarise monitoring data using spreadsheet techniques.

• Structured data tables separate identifiers, variables, values and metadata
• Spreadsheet formulas calculate totals, percentages, rates and indicator achievements
• Pivot tables summarise service delivery by location, period and population group
• Filtering and sorting reveal incomplete records, unusual values and trends
• Lookup functions join beneficiary records with locations, services and classifications
• Calculated fields compare actual performance against targets and prior periods

Participants can interpret descriptive statistics and select accurate visual displays.

• Measures of central tendency compare mean, median and mode appropriately
• Frequency distributions show counts, proportions and category patterns clearly
• Measures of dispersion identify variation through range and standard deviation
• Cross-tabulations compare outcomes between demographic groups and project locations
• Bar charts, line charts and stacked charts match data types
• Chart titles, labels and annotations state findings without distorting evidence
• Dashboards combine priority indicators, target comparisons and exception signals

Participants can interpret common statistical tests and state appropriate evidence limits.

• Confidence intervals express uncertainty around estimated population values
• Statistical significance distinguishes likely patterns from random sampling variation
• Chi-square tests examine associations between categorical project variables
• T-tests compare average values between two relevant participant groups
• Correlation assesses directional relationships without claiming causal effect
• Effect size considers practical importance alongside statistical significance
• Interpretation notes sampling limitations, missing data and possible confounding factors

Participants can analyse qualitative evidence and integrate it with quantitative findings.

• Transcription and note preparation preserve context, speakers and source details
• Deductive coding applies predefined themes from evaluation questions and frameworks
• Inductive coding identifies recurring themes emerging from participant accounts
• Codebooks define themes, inclusion rules, exclusions and illustrative examples
• Thematic matrices compare evidence by respondent group, location and question
• Triangulation tests agreement and disagreement across methods, sources and investigators
• Mixed-methods integration explains numerical patterns through participant experiences

Participants can frame an evaluation design using appropriate questions, criteria and methods.

• Evaluation purpose distinguishes accountability, learning, decision-making and knowledge generation
• OECD DAC criteria assess relevance, coherence, effectiveness, efficiency, impact and sustainability
• Evaluation questions specify evidence needs, comparison points and intended users
• Baseline, midterm and endline designs serve different management decisions
• Before-and-after comparisons identify change while recognising attribution limitations
• Comparison groups strengthen causal claims when ethically and operationally feasible
• Terms of reference define scope, deliverables, methods, governance and timeline

Participants can convert monitoring and evaluation evidence into clear reports and management actions.

• Evidence synthesis combines indicator trends, qualitative findings and contextual information
• Results narratives explain performance against targets without unsupported attribution claims
• Management response plans assign actions, owners, deadlines and follow-up evidence
• After-action reviews capture operational lessons following major implementation events
• Learning questions focus reflection on assumptions, delivery choices and unintended effects
• Data visualisations present priority findings for technical and nontechnical audiences
• Report quality checks verify calculations, source references and conclusion logic

Participants can build, review and present a complete monitoring, evaluation and data analysis package for a project case.

• Project case diagnosis defines priority decisions, stakeholders and evidence requirements
• Results framework integrates causal pathways, indicators, assumptions and verification sources
• Indicator matrix documents definitions, disaggregation, baselines, targets and responsibilities
• Monitoring plan schedules collection, quality checks, analysis and reporting actions
• Data-collection tools align questions, response formats and indicator calculations
• Analysis plan specifies cleaning steps, tables, charts and qualitative coding
• Peer review tests logic, feasibility, ethics and decision usefulness
• Presentation communicates findings, limitations and recommended management actions