All Collections
Assessments
Bulk Uploading of Assessment Questions
Bulk Uploading of Assessment Questions

If you prefer to work in a CSV file and upload questions in bulk, this article covers what you'll need to do.

Catherine Wnuk avatar
Written by Catherine Wnuk
Updated over a week ago

Click on Teaching then Assessments. Click the Upload Assessment from Excel (CSV) button.

From there, click the Sample CSV Assessment Upload Template button.

Fill out the CSV file that you just downloaded.

In the Number field, simply enter the number of the question that you're currently creating.

The Question field determines what the question says.

The Answer x (x = a number) fields determine the multiple-choice possibilities. You can add extra columns to add more possible answers (ensure to name the columns correctly, ie. "answer 4", "answer 5", and "answer 6")

The correct-answer field is where you enter the correct answer โ€“ a number (separated by commas for answers with multiple correct answers) for multiple-choice, TRUE or FALSE for true or false, the correct answer (separated by commas for answers with multiple correct answers) for fill-in-the-blank, and nothing for short answer.

The Solution field determines the question feedback that the learner will see.

Question-style determines the type of question. They can be either multiple-choice, multiple-choice-multi, true-false, fill-blank, or short-answer.

For multiple choice questions that require more than one answer be selected, input multiple-choice-multi under the question-style column and input the correct answers, separated by commas under the correct-answer column.

Value determines the marking weight of the question.

If you want to use the Random Question Bank, you will need to add three additional columns:

question-category

is-random-question-placeholder

is-part-of-random-question-bank-only

question-category is used to set the random question category that the question is part of, such as HIPAA or Compliance.

is-random-question-placeholder sets the question number as a random question. You will need to enter TRUE in the cell and fill in the respective question-category that you want to pull the question from. The question and correct answer columns do not need to be filled in.

is-part-of-random-question-bank-only will add the question to the question bank. This cell needs to be set to TRUE and the respective question-category filled in as well. Create the question as normal by filling in the question, answers, and correct answers.

When you're done, click Choose File and select the file that you just uploaded and click Upload.

Did this answer your question?