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:
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 |
To run the Macro you will need to enable Developer bar in Excel https://support.microsoft.com/en-us/office/show-the-developer-tab-e1192344-5e56-4d45-931b-e5fd9bea2d45#:~:text=On%20the%20File%20tab%2C%20go,select%20the%20Developer%20check%20box.
Under “Developer” hit Macros and Run the Sheet1.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 XML Creator
Add Comment