Escrito el 9 de January del 2009 por smith.
Hello All,
Does anyone have a relatively simple VBA or formula solution for making multiple-choice exams in Excel? Tracking scores to a separate (hidden) worksheet would be a plus.
I would like to have the ability to change the questions by changing the database, so the original format can be used repeatedly.
ANY help would be greatly appreciated!
-Bob in CaliforniaAfter you get the first group of Option buttons set, then you can use the Group Box (on the Forms Toolbar) to put around those options that are together. Then with the next set of options do the same thing.Thanks very much for the Access tip, Mike! I will have to tear myself away from Excel and dust off my Access skills some time soon.
I very much appreciate your advice.
Take care,
-Bob in CaliforniaHello Tagger,
Thanks so much for your excellent advice! This is a Great Solution!
I very much appreciate your help,
Bob
P.S. Surf s Up!Sorry to bring such an old thread to the top again, but I was trying to use the option buttons like suggested and ran into a problem. I cant figure out how to get the buttons to act separately. For example, I have question 1 with four answers. Each answer has a button. On question 2 I have the same setup. After you choose your answer for question 1, the button is selected, but when you pick an answer from question 2 it deselects your choice from question 1.
How can I make this madness end? I'm trying to get this test to grade itself, but when the option buttons are deselected, it is messing my formulas up.:banghead:If you use the option buttons from the Form toolbar you can create an Option group then add the option button for each answer to a question. Once you have the option buttons added to the sheet, right click on the option and select Format Control and set the linked cell for each button. This will allow you to determine which answer have been selected.
If there is anything else I can do for you please let me know.
~TaggerIf you or someone you know has the know-how, one can make a test generator in Microsoft Access. You could make a relational database in which the questions are read into form one at a time, with the quiz takers answers recorded directly to an answer table. When ready, you can build reports that count the number of answers for each of the possible values of each multiple choice question.
FWIWIf you or someone you know has the know-how, one can make a test generator in Microsoft Access. You could make a relational database in which the questions are read into a form one at a time, with the quiz takers answers recorded directly to an answer table. When ready, you can build reports that count the number of answers for each of the possible values of each multiple choice question.
FWIW
Edited by - MikeR on Jun 11 2002 23:47:48#If you have any other info about this subject , Please add it free.# |
|
Catalogado bajo homelessguestb.comedit
