Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-18-2012, 06:23 AM
McDoug McDoug is offline Creating a multiple choice test Windows 7 32bit Creating a multiple choice test Office 2003
Novice
Creating a multiple choice test
 
Join Date: Oct 2012
Posts: 2
McDoug is on a distinguished road
Default Creating a multiple choice test

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
Reply With Quote
  #2  
Old 10-18-2012, 02:30 PM
macropod's Avatar
macropod macropod is offline Creating a multiple choice test Windows 7 64bit Creating a multiple choice test Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
  #3  
Old 10-19-2012, 10:02 AM
McDoug McDoug is offline Creating a multiple choice test Windows 7 32bit Creating a multiple choice test Office 2003
Novice
Creating a multiple choice test
 
Join Date: Oct 2012
Posts: 2
McDoug is on a distinguished road
Default

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
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating a multiple choice test How to make a multiple-choice test? micahfaulkner75 Mail Merge 1 09-12-2012 06:08 PM
Creating a multiple choice test Linking multiple choice questions to answers Microsoftenquirer1000 Word 2 08-12-2012 02:49 PM
Linking multiple choice questions to answers Microsoftenquirer1000 Word 1 06-11-2012 06:53 AM
Creating a multiple choice test Multiple choice option boxes burnsie Word 3 07-08-2011 05:10 PM
Creating a multiple choice test Creating multiple emails from a spreadsheet StephenGreen1985 Excel 1 05-04-2011 07:03 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:23 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft