I am in the process of making an Excel spreadsheet ‘app’ that assists teachers in creating an analysis grid for their exams. It’s simple, straight-forward, intuitive and works very well! I have yet to tweak it for teachers to be able to use it for Practical papers but that will have to happen another time. At the moment, the spreadsheet will work wonderfully for Theory and most other papers. It is available to purchase in the Tech Teachers store.
- Automatically selects the Level for the question based on a keyword/phrase
- Grid automatically created
- Keywords are editable
- Progress bar
- Safety-checks in place with data validation
- Stats generated
- Graphs created
You will need Microsoft Excel 2013 (at least) but 2016 is preferred. Macros must be enabled. It will work on most desktop PCs/laptops but not on mobile devices (who the heck wants to work on a small screen anyway?).
Check out the preview video below. The new (Version 2) overview is below it.