To learn more about populating a question bank template, watch this video or follow the below guidance.
The downloaded question bank template will be pre-populated with headings. Do not delete these headings as Access LMS Evo reads these when the question bank is uploaded.
Each question must appear in it's own row without spaces (empty rows) in between. The below table provides guidance on how to populate fields.
Column | Mandatory or optional | Notes |
ExternalId | Mandatory | All questions must have unique ID within the Question Bank. For example: Q001, Q002 or DD001, DD002 etc. |
ActivityCodes | Optional | Link the question to a module by pasting the relevant module code. For example, linking a question to an eCreator course you have created.
Copy the code from the eCreator's administration area then paste it into the Module Codes column. If a code hasn't been assigned to the course, you can add one at this point.
You can leave this field blank if preferred. |
Type | Mandatory | Type of answer required for the question. Can be one of the below options.
|
Deleted | Mandatory | Enter Yes or No. Entering Yes will mark questions as deleted and retire them from the bank. |
QuestionText | Mandatory | Enter the question text presented to the user.
๐ Note: Maximum of 4000 characters. |
Min | Range type questions only | Provide a minimum value for the slider on a Range type question. |
Max | Range type questions only | Provide a maximum value for the slider on a Range type question. |
Step | Range type questions only | Provides an increment for the slider on a Range type question. i.e. how much the slider will go up by when moved. |
Feedback | Optional | Not applicable, as the user will not be presented feedback after a survey. |
Reference | Optional | Not applicable, as the user will not be presented feedback after a survey. |
CorrectAnswers | Dependent on question type | โ ๏ธ Important: Should only be completed if the survey has been given an Overall Survey Pass Mark.
A comma-separated list of the correct answers. For example, if answers 1 and 4 are correct, a value of 1,4 should be entered.
๐ Note: FreeFormText & Range type questions do not require this column populating. |
AnswersOrdered | Dependent on question type | Dictates if answers must appear in the order they are entered into the template.
For the answers to be randomised, put No in this column.
If using a Likert Scale then you'll need to put Yes in this column. |
Answer1, Answer2 | Dependent on question type | Enter the possible answers for users to choose from.
No set amount required. Leaving the field blank means it won't be shown in the assessment so there's no need to delete any redundant columns.
๐ Note: FreeFormText & Range type questions do not require this column populating. |
Library1, Library2 | Mandatory | Categorise the question to make it easier to find when creating assessments or surveys. |