Last year I wrote about analysing a grades book on my blog –

This video is a follow up 25 minute video walking through the entire process of analysing a test or exam that has been sat by a class (or classes) of students – containing multiple choice, short answer and extended response questions.

Starting with a blank worksheet, the entire process is demonstrated – from setting up the data headers, entering the data, using formula to calculate summary results, and then using sorting with conditional formatting to produce a heat mapped Guttmann progression. Finally, a nested IF statement is used to determine class strengths and weaknesses.