Last year I wrote about analysing a grades book on my blog – https://educationstylus.com/2015/04/22/storing-and-making-sense-of-grades-excel-to-the-rescue/

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.