Bulk Import Assessment Questions

Creating the CSV file:

  1. Navigate to the Create an assessment module.
  2. From the Questions sub tab, select “Import questions in bulk” from the right.
  3. Select the “use this template to get started” link.

Bulk_Import_Assessment_Questions_-_1.png

 

Once the file loads, open it in Excel and follow these directions:

  1. Delete sample Rows 2, 3, and 4.  (Do not delete the header in row 1.)
  2. In column A, Row 2:  Write your first question (For example:  What does LMS stand for?)
  3. In column B, Row 2:  Write the question type of your first question.  This must be one of the following:  MULTICHOICE, KEYWORD, or FREETEXT.
  4. In column C:  For multiple choice, enter the first possible answer given to a user.  For keyword, enter the first possible keyword and repeat for columns E, G, I, K, M, O, Q, S, and U or until all answers or keywords have been entered.  No text should be entered for Free Text questions.
  5. In column D:  For multiple choice, enter TRUE if the answer in column C is true or FALSE if the answer in column C is false.  Repeat for columns F, H, J, L, N, P, R, T, and V or until all answers have been addressed with a TRUE or FALSE.  No text should be entered for these columns for Keyword and Free Text questions.
  6. Repeat steps 6 through 9 for each additional question moving to the next row.  Do not skip rows.
  7. In Column W:  If you would like to show the number of correct answers enter TRUE.  If not, enter FALSE.
  8. In Column X:  If you would like the learner to answer the question correctly before they can proceed enter TRUE.  If not, enter FALSE.
  9. In Column Y:  If you would like to show feedback if the learner answers the question incorrectly, write the feedback you would like to give.  If not, leave this field blank.

Bulk_Import_Assessment_Questions_-_2.png

Uploading Questions:

  1. Navigate to or create an assessment module.
  2. From the Questions sub tab, select “Import questions in bulk” from the right.
  3. Select the file.
  4. Decide if you need to check “The first row of my file contains column titles.”  (If the instructions for creating the file were followed, you will need to check this box.)
  5. Click “Upload”.

Helpful Hints:

  • All cells from columns A-Y must be included in the file.  Do not delete any columns from the CSV. 
  • It must be in the American CSV format, meaning that each cell will need to be separated by commas.
  • Because this is a comma delimited file, a common reason why the import will fail is if a question or answer contains commas in the text.  To avoid this, put quotes around the answer or question that contains a comma. 
  • If quotes are added to a cell, Excel may include additional quotes.  Check all files in Notepad before importing them to ensure that quotes only appear once.
  • At least one row must contain 26 columns.  The easiest solution is to retain the headers in the sample file and select "The first row of my file contains column titles" at import.
Have more questions? Submit a request

0 Comments

Article is closed for comments.