Question Import Template
- Alastair Izzard
This Excel template with macros will create the XML for question import.
It allows up to 6 question choices and allows you specific question properties as follows:
NOTE - the converter requires all 6 answer columns to be present. If question has less than 6 answer choices just leave the other columns blank
Correct Answer | Allow Multiple Choices | Require All Correct Choices | Tags | Notes allowed |
Specify which answers are correct by the letter of the column separated by commas e.g. A,B,C | TRUE / FALSE | TRUE / FALSE | Specify tagset/tag. Multiple tags can be separated by comma e.g. Route/R1, Vessel/V1 Tagsets and tags must exist on LMS for successful import | TRUE/FALSE |
The file uses Macros and so Excel may warn you about the security of the file. You may need to unblock the file by right-clicking the file in File Exporer and going to Properties. Check “Unblock” as per screenshot below.
To run the Macro you will need to enable Developer bar in Excel Show the Developer tab - Microsoft Support
Under “Developer” hit Macros and Run the GenerateQuestions.Question macro
This will create a file in the same location you have the Excel saved with XML questions.
Customer template
This is a template without macros that can be sent to customers to fill in. You can then copy into the XML Creator
