New project - Exam question bank with export to Word

[Steve the Pirate]

I have an excel spreadsheet which holds our entire multiple choice exam
question database. At the moment creating a 50 question exam paper in Word to
print off for students is a lengthly process, involving pasting each Catagory
Title, Question and the three possible answers into a Word template.

What I would like is somthing that allows me to select a radio button for
each of the questions I would like to appear in the exam and then export that
data into the required parts of a template at the touch of a button. Am I
asking too much?

I was thinking maybe a macro? Unfortunately I have very little macro
experience, but am keen to learn. If anyone can point me in the right
direction I'd really appreciate it.

Thanks for your time,

Steve

 

[Don Guillett]

Should be doable with drop down boxes. Or, you could goto your list and
select each one and then copy/paste the selected rows..

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.

 

[James]

why not create a macro that allows for you to click on the questions you want
and have those exported. you could have the macro called with a button.

questions 1-6, 7 12 15 ...etc
button click and the questions get exported to word. or is that not possible?

 

[James]

why not create a macro that allows you to click on the questions you want to
export and then have a button call the macro. That way you could click on
questions 1-6, 7, 9 , 12 etc and then click a button to have the questions
export to word? or is that not possible?

 

[paul.robinson]

Hi
Have you thought about shifting to Moodle?
Here is a free Excel to GIFT converter (GIFT is a Moodle question
format).

http://moodle.org/mod/forum/discuss.php?d=45245

Go into the Moodle site as a guest if you are asked to login.
I can send you a document on creating Moodle multichoice quizzes if
you email me. In Moodle, you can put your questions in categories,
then lift out a number from each (a random selection and randomized
answers if you wish) to build your test.
The only question then would be delivery - do you have a server and
PC's to deliver an online test.

regards
Paul