Skip to end of metadata
Go to start of metadata

If you want to create your test offline using Microsoft Excel, you can do so by saving the test in a special file, and then uploading to Blackboard. Once in Blackboard, the questions can be added to different tests as if they were created using the Blackboard system. 

Excel question format

You can create tests offline using Microsoft Excel. When you create a test in Excel, there are rules you must follow:

In the first column, you must indicate what type of question you are adding. See the table below for a full list of question type shorthand. 

You will notice there is not a Calculated Formula or Hot Spot Shorthand. As of now, these question types cannot be created offline using Excel.

Type of Question

Shorthand Version

Calculated Numeric

NUM

Essay

ESS

Fill in the Blank

FIB

File Response

FIL

Multiple Choice

MC

Multiple Answer

MA

True/False

TF

Ordering

ORD

Matching

MAT

Short Response

SR

Opinion/Likert Scale

OP

Multiple/Fill-in-the-blank

FIB_PLUS

Jumbled Sentence

JUMBLED_SENTENCE

Quiz Bowl

QUIZ_BOWL

 

  1. The second column is the question text.
     
  2. The third column will be the answer to the question. If you have multiple answers, you will place them in the following columns. Refer to the example below.
      

Step-by-step Guide

To create a test in Excel

  1. Open Excel.
  2. Following the format discussed above, enter your questions in Excel.
  3. When you have finished your test questions, click the File TabSave As, and then select a location.


  4. In the File Name box, type a name for your file.
  5. In the Save as type, select Text (Tab Delimited), and then click Save.

To upload test questions from Excel to Blackboard

  1. On the Control Panel, under Course Tools, click TestsSurveysand Pools.


  2. Click Tests.
  3. Next to the test you wish to edit, click to expand the Contextual Menu, and then click Edit.


  4. Click Upload Questions


  5. On the Upload Questions page, under Upload Questions, click Choose File and locate the .txt file that contains your Excel questions. 


  6. You will also need to type the points possible for each test question in the Points per question box. 


  7. When you are finished, click Submit.

Watch a Video Tutorial

 


For questions or comments, contact the Computer Services Help Desk
HelpDesk@MissouriState.edu
417-836-5891