I have formulated this spreadsheet so that you can entered in a 1 (i.e. correct answer) or a 0 (i.e. incorrect answer) and it will appear green or red respectively. Also, there are tabs for both a pre-test and a post-test. The third tab compares the scores between the two tests and shows the difference in scores. This spreadsheet is formulated for 25 students, but could be easily changed.