This cleverly designed spreadsheet has two main areas:
 The first area allows the user to build up a question bank, from which 20 question quizzes may be quickly and easily generated and printed.
 The second area allows the user to record data from any 20 question test that has been set. All you need to add are the names of your students, their target grade and the results of their 20 question tests.
The spreadsheet can record data for 10 tests and 100 students.
The question bank is designed to hold 999 questions [with associated answers and marks].
The key features of the record of student test data include:
 It's simple to input data.
 It’s tablet-friendly.
 It calculates a mean score out of twenty for all tests taken by each student.
 It produces an overall grade for each student based on the tests taken.
 It highlights whether students are underachieving or overachieving relative to their target grade [target grade format may be chosen by the user].
 It calculates a total score for the tests undertaken for each student which may help raise academic standards by promoting healthy competition between students.
 It highlights the top five and bottom five performing students based on total points scored.
 It highlights the top five scoring students for each test.
 Each test result is given a grade [the grade format may be chosen by the user].
 It calculates a mean score out of twenty for each test.
 It produces a graph of total points against student number. This enables the user to observe performance of all students in a visually effective way.
I've been using this recording system for over ten years, and its usefulness / effectiveness has been most noticeable during lessons where students are regularly made aware of their progress, during departmental meetings where weak students can easily be identified and subsequently supported, and during meetings with parents.
On average, I teach over two hundred students each academic year, which results in a lot of marking! However, I’ve found that the regular use of these factual recall tests [which are easy to produce once a question bank has been formed and quick to mark] allows me to produce data points that build up an accurate picture of each student’s performance on a test by test basis or cumulatively over a longer period of time. The students appreciate regular and rapid feedback on their performance and find the tests a useful revision resource for end of topic, end of term or end of year exams.
I use the 20 question test format more than the 10 or 15 question format as the students need to perform at a higher level to achieve the higher grades.
Using the spreadsheet is straightforward, but some tips are provided within it.
Look out for more products of a similar nature, including 10 and 15 question test spreadsheets as well as a quiz generator for Biology!