Import Quiz Questions from Excel

Introduction

In this guide, you will learn how to create Exam questions in Excel that can be created ahead of time and then further imported into Blackboard. You will also learn how to locate sample files and update them.

Creating Exam Questions in Excel

It is possible to create exam questions in Excel in a way that they easily import into Blackboard. Here are the instructions directly from the Blackboard site:

https://help.blackboard.com/Learn/Instructor/Tests_Pools_Surveys/Reuse_Questions/Upload_Questions

Download a Starter Excel File

Link to a starter Excel file to easily create a set of multiple choice questions as well as a link to a starter Excel file with examples of all kinds of questions:

bb-mc-quiz-starter.docx
bb-quiz-starter.docx

Upload a Question file

  1. From the test, survey, or pool, select Upload Questions.

  2. Select Browse to locate the file.

  3. Optionally, type a number in the Points per question box to set a default value for all questions. If left blank, all questions will be set to a value of zero. Later, you can edit the individual question values.

  4. Select Submit and OK. The questions appear in the test, survey, or pool. You can edit and reorder the questions.

Important Notes

  • Each file must be a saved as tab-delimited TXT file once final. You can edit this file in Microsoft® Excel® or in a text editor.

  • Don't include a header row in the file.

  • Don't include blank lines between records. The blank line will be processed and return an error.

  • Include only one question per row.

  • The first field in each row defines the type of question.

  • Separate each field in a row with a TAB.

Here is an example of how the Excel file should look like:

Additional Ideas

This page contains other ideas for easy ways to create Blackboard quiz questions that include using other sites to format files:

https://www.uvm.edu/it/kb/article/blackboard-import-questions/


Related Pages

Copy a Test/Exam in Blackboard

Exam Support