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 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 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