(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
Bookmarks