QLA Question Level Analysis grid Spreadsheet excel
This excel spreadsheet can be used to perform QLA for up to 200 students with 23 questions per exam paper.
The spreadsheet provides clear colour coding for each question with green for full marks and red for zero marks with a gradual change from red to green for marks in between.
It is a powerfull tool to analyse students performance enabling areas of common weakness to be identified for the whole group or individuals.