For teachers: How to use Excel to analyse a test given to students. HD

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.