Multiple-Choice and True-False Test/Quiz Maker

[leaning]

(Moderators: please feel free to edit/relocate this post.)
I was using the traditional method of printing copies of paper tests for the students to use, and then hand-grading those. Too much paper, ink, and time. I looked around for an Excel method of making a test/quiz, and found Test Maker and others, but couldn't find one I could get wrapped around that was easy for both the instructor to use and the students to test. So, I made one: Tester.

Basically, the instructor writes the questions and answers, marks the correct answer (or multiple answers) and then submits it to the students. The students indicate their answer and with those answers locked in, those answers are compared to the instructor's, and the test graded. The instructor can walk around and write down those grades, and then press a recover button to reset everything, or make copies of the file so the same test can be given multiple times (same test used for pre-test and then post-test, etc.)

So, here it is. Mad thanks to everyone on these threads without whose assistance it would still be limping along:

https://www.excelforum.com/excel-pro...er-tweaks.html
https://www.excelforum.com/excel-for...ther-cell.html
https://www.excelforum.com/excel-pro...selecting.html
http://www.utteraccess.com/forum/ind...wtopic=1870387

If anyone uses it sees anything to improve in the code or functionality or anything, please let me know. I'm posting this in hopes that it helps somebody not have to hand-grade multiple-choice and true-false tests anymore, and to have another option.

Regards,
leaning

[leaning]

A quick update. I added data validation so the number of questions has to be an actual number, and not a letter or other character. I removed the hard coding on the responses, so you can use whatever phrase you want for correct (Good job, Attaboy, etc.) and incorrect (Nope, Try again, etc.). And I extended all the formulas and references so it can really handle 200 questions now. As I use it more, I'll post updates as it improves. Regards, leaning

[leaning]

A small update: I froze the top rows on the Instructor tab so it's clearer when entering long tests.

Regards,
leaning