This excel 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 |
|---|
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.
...
| View file | ||
|---|---|---|
|
| Note |
|---|
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 |