It's a script in VBScript used to generate exam documents based on multiple choice and free text questions

Download: MultiChoice_20090625a.rar

Instructions:

1. Edit document templates at "Templates" folder. Unused test documents are prefixed with "~" char
2. Clear output folder from old documents
3. Navigate to Data folder
4. Edit "OldQuestions.doc" to add any questions used in previous tests that you don't want to reuse (copy-paste the question text - text formatting isn't important)
5. Edit multiple choice questions spreadsheet at "Data" folder. See existing sample there (mark unused questions with a * at the 1st column and mark correct answers with bold font)
6. Edit Generate.vbs with Notepad
   • to select how many questions to pick from spreadsheet's tab A, tab B and tab C
   • to select how many shuffled versions of the multiple choice document to generate [one for each student group to avoid them copying from each other])
   • to edit the length of the text that is used for spreadsheet questions to compare with old questions (from OldQuestions.doc) to see if it will be ignored
   • to select whether a filled-in with answers document will also be generated
   • to select whether comments from spreadsheet cells are shown at the generated answers document
7. Drag-drop a questions spreadsheet (.xls file) onto the Generate.vbs script (need to have installed Windows Script Host [WSH] - it is preinstalled at recent Windows versions)

This will process all templates (apart the ones prefixed with ~) from "Templates" folder and will pick questions from the spreadsheet tabs to fill them in, ignoring any old questions. Results will be placed in "Output" folder. If you edit the script to generate a filled-in with answers document it will also generate one for each questions document generated.

Requirements: you must have Microsoft Word, Microsoft Excel and WSH (Windows Scripting Host) installed. If you don't have WSH, you can download WSH from Microsoft

(C)opyright 2009 - Zoomicon / George Birbilis
Free to use / give due credit