Creating a Question Bank

A question bank is a pool of questions relating to a topic which can be pulled from to create an Assessment.

To upload and manage question banks, you must have access to the Question Banks area of the system. Please speak to your Relationship Manager if you would like to have access to Question Banks. This feature is not available to our multi-tenancy clients.

Navigate to the Menu and click on Question Banks.

Download and Complete the Template

To create a selection of questions to upload to the question bank you need to populate a question bank template using either XLSX (Excel 2007+) or CSV (comma separated values) format. The recommended format is XLSX. 

To download the Template, click on the Download Template dropdown menu, choose the file format you would like to use and click on the Go button.

The template can be opened in Microsoft Excel or alternative spreadsheet software which supports CSV files. When you open the template, you will see that the headings have been pre-populated for you:


Complete the Template as follows:
Column A shows the ExternalID which is the name of the individual question so all External lD’s must be unique to the question bank. This could be Q001, Q002 or DD001, DD002 etc.
Column B shows the ActivityCodes. This is where you can link the question to related learning by pasting the code which has been given to the learning activity. For example, you would like to link a question to an eCreator course as related learning. You will need to copy the code by clicking on the eCreator name within Content Manager, click on to the Details and pages tab and copy the code (if there is no code you can also add one at this point) into the Code field.

If you do not wish to link to related learning, you can leave this field blank. However, if you wish to use the question bank for Diagnostic Assessments, you have to link the questions to an activity. You can link to more than one activity by using a comma to separate each activity code.
Column C is a Deleted column. This will need to be completed in order for the spreadsheet to upload. If you would like to delete a question when editing an existing question bank, type in yes otherwise type in no.
Column D shows the Question Text, which is the question the end user will read.
Column E shows the Feedback to be shown (if any) to the user for that question on completion of the assessment. This will appear whether the user answers correctly or incorrectly. This is an optional field.
Column F shows the Reference to be shown (if any) to the user for that question on completion of the assessment and can be used to direct the learner to further reading. This is an optional field.
Column G shows CorrectAnswers. 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, - So for this example, the answers 1, 3 and are correct. Enter the answer number, not the column.
Column H is AnswersOrdered which tells the system whether the answers must appear in the order they are entered into the template. The recommendation is to put No. This will randomise the order the answers will appear for the end user. If the user has to retake an assessment, the answers should appear in a different order to avoid the possibility of memorising the answers. For this reason, when you enter No, you should not use 'All the above' as a possible answer.
Column I to R shows Answer1 to Answer10 and is where you enter the possible answers the user can choose from. You do not need to have 10 answers, you can have as little or as many as you like. If you leave the field blank then it will not be shown in the assessment, there is no need to delete any redundant columns.
Column S, T and U shows Library1, Library2 and Library3. This is to categorise your questions and defines the question hierarchy structure when 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.

In the following example, all the questions have been categorised as 'Insurance' but then they have been further categorised across Motor, Home and Life insurance. As a third category, they have been sorted in to Introductory, Intermediate or Advanced. 

Upload the Question Bank

Please ensure you have saved the completed template. Navigate to the Question Banks area as shown at the top of this guide.

Click on New Question Bank.

In the popup window, enter the Name of the Question Bank, click on Choose file to locate your saved question bank template and click on Create

A system message should confirm that the upload has been successful and confirm how many questions have been imported. 

If there is an error with any of the questions and therefore they cannot be imported, you will get a message like the one below.
  You will need to correct the error(s) before you can upload the file.

Feedback and Knowledge Base