Creating randomised test questions with Mailmerge

[eswin]

Mailmerge may be a bad tool for this but it's the only thing I understand at the moment




I like to multiple choice quizzes to my classes every week, however, many of my old quizzes have been memorised/or photographed by older students.

I thought it would be a great idea if I could randomise the answers order and also the question order. Is it possible to randomise a mailmerge from excel?

Bonus: if I could also create an answer key for myself (A,C,D) for the random questions and answers that would be AMAZING!

I know Mailmerge is probably not the most efficient system for this. I would really love to be able to hit a button and print out a randomised quiz and answer key.
Thanks!

[gmayor]

A while back I created a Word add-in that creates multichoice questions and answers that you might find useful as an aid to creating such questions. http://www.gmayor.com/interactive_multichoice.html