Good day, I NEED HELP!



I am in the process of creating training modules (to meet OSHA training requirements) in power point and I need to create a series of Multiple Choice tests for each employee to take to verify they have reviewed and understand the material which will need to be saved with the test takers name as part of the file name.

I would like the test to address the following;

1. The employee must be able to enter his/her name (which needs to be the file name),

2. The employee must select an (ultimately the correct) answer from a drop down box (for example) but radio buttons are OK too,

3. Auto grade with immediate feed back so the employee knows if they have answered the question correctly or not (at the end of the test is OK),

4. The ability for the employee to go to any incorrectly answered question and change the answer,

5. Only after correcting ALL answers, the test needs to be saved to a secure folder.

So far I have created the power point presentation(s) with a hyper-link (at the end) to a word doc test (Word 2003) using check boxes and/or radio buttons but don't know how to grade the test.

I've looked at trying to do this in Google Docs but don't think that is a direction I want to go, I'd rather keep it all on site and within MSOffice.

I am considering trying either Excel or inserting tables in Word so I can use math function to grade.

I am a novice and am stumbling along here so any and all suggestions are appreciated.

Doug

Hi McDoug,

I'd suggest using MS Word for this, with text formfields for things like name & date input and dropdown formfields for answer selections. See, for example: https://www.msofficeforums.com/word/...s-answers.html

While it's easy enough to have the selection from a dropdown trigger the display of a correct/incorrect response, that seems to defeat the purpose, as an ignoramus can simply go through each answer until a 'correct' response is achieved without ever learning anything. A more sophisticated approach would be to display an overall score, only when all the questions have been answered. If it's less than 100%, the user then has to figure out which question was answered wrongly and change the answer.

All the above can be done without macros. If you want to prevent the document being saved unless all the questions have been answered (correctly or otherwise), that would require a macro and the user's cooperation in allowing it to run. If the user doesn't allow the macro to run, they can do as they please.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi Paul,

Thank you for your reply and guidance, I will try your approach and see how close I can get to meeting my needs.

Doug