Click to play the below video if you would like to watch how to complete the Question Bank Template.
The Question Bank Template will be pre-populated with the following headings:
This table tells you how to complete the spreadsheet:
|Column A: External ID||All External lDs must be unique to the Question Bank. For example, this could be Q001, Q002 or DD001, DD002 etc.|
|Column B: Activity Codes||
This is where you can link the question to related learning by pasting the Code which has been given to the Activity.
For example, you would like to link a question to an eCreator course you have created. You will need to copy the Code from the eCreator's administration area and paste it into the Activity Codes column. If a Code hasn't been assigned to the course, you can add one at this point.
You can link to more than one Activity by using a comma to separate each Activity Code.
|Column C: Deleted||
If you would like to delete a question when editing an existing Question Bank, type in 'yes', otherwise type in 'no'.
This column must be completed with 'yes' or 'no' or the upload will fail.
|Column D: Question Text||This is the question the end User will read.|
|Column E: Feedback||
This is an optional field, however completing it allows feedback to be shown to the User for that question on completion of the Assessment.
The feedback will be displayed whether the User answers correctly or incorrectly.
|Column F: Reference||This is an optional field and allows a reference to be shown to the User for that question on completion of the Assessment and can be used to direct the User to further reading.|
|Column G: Correct Answers||
This is a list of the correct answers to the question. You can either put in one number to specify there is only one correct answer or you can enter multiple correct answers separated by a comma e.g. 1, 3. In this example, the answers 1 and 3 are correct.
For Likert Scale questions where only one answer is expected but more than one possibility equates to a correct answer, e.g. 4 or 5 are correct, you separate the correct answers using the 'pipe' separator.
You must enter the answer number, not the column.
|Column H: Answers Ordered||
This tells the LMS whether the answers must appear in the order they are entered into the template. If using a Likert Scale then you will need to put Yes in this column. If you wish for the answers to be randomised, to avoid the possibility of the User memorising the correct order for answers when retaking assessments, put No in this column.
If you enter 'no', you should not use 'All the above' as a possible answer.
|Column I to R: Answer1 to Answer10||This is where you enter the possible answers the User can choose from. You do not need to have 10 answers - you can have as few or as many as you like. If you leave the field blank, it will not be shown in the Assessment so there is no need to delete any redundant columns.|
|Column S, T and U: Library1, Library2 and Library3||
This allows you to categorise your questions and defines the question hierarchy structure presented to the Administrator when creating Assessments. It allows the Administrator to build an Assessment according to the categories - they may have two questions from one category and two from another while using the same Question Bank.
You can use multiple Libraries to break down your questions in to sub categories. You are not limited to 3 libraries. If you need more, you can continue with Library4, Library5 etc., until you have as many as you need.
You must make sure you have at least one or you will not be able to find the questions when compiling the Assessment.