Analysis & Interpretation

Once you have completed your intervention and testing you should put all of your data into an Excel spreadsheet with columns for the post-test data and a row for each pupil, then calculate an ‘effect size’ for your intervention.

  1. Effect Size Calculator

    24 KB xlsx - Effect_Size_Calculator_Excel.xlsx

The Excel template can be downloaded and used to calculate the effect size of your intervention.



Your analysis may show that the intervention had a positive effect. Equally, it may show a negative impact or an inconclusive finding. Record what you intend to do with the findings. Read more about more next steps for DIY Evaluation findings here.

show hint help_outline