Posts

Showing posts from September, 2018

Improved / Stayed Static / Regressed Assessment Measure

Image
One of the weaknesses of traditional assessment tracking is that combining results from all collections into one large spreadsheet is cumbersome and so you often end up looking at each data drop in isolation. Power BI is much better at handling large data volumes and this post is about how to add as tooltips to a graph showing different cohorts' progress through KS4, the proportion of grades which improved, stayed static or went down from the previous collection. You can follow along with my sample data here . I'm using a datasource called AssessmentResults where results are identified by AssessmentType, YearGroup, Term and Subject and the key result data fields are Result, ResultDate and Points (the numerical value of the result). I'll add my usual disclaimer that there could be more efficient ways of achieving this outcome and if so, please add them in the comments or ask to submit a guest post. Cohort and Stage Columns The first task is adding calculated columns