New project - Exam question bank with export to Word

  • Thread starter Thread starter Steve the Pirate
  • Start date Start date
S

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
 
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.
 
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?
 
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?
 
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
 
Back
Top