Now searching for:
Tests can be created offline in Microsoft Excel and then uploaded to the Blackboard test centre. After you upload the file to Blackboard, you can still reuse or edit the questions if required.
To do this you need to:
Important: Questions that contain a formatting error will fail to upload.
When creating a test in Excel, the questions must follow a specific format.
Begin by opening an Excel document and saving it with an appropriate test name. When saving your file In the Save as type, select Text (Tab Delimited), and then click Save.
Important: To construct your questions, you must write questions in line with the format provided by Blackboard. For a sample question file and for question format guidelines visit Blackboard Upload Questions
Consider the following tips when creating your questions:
Question Type | Excel Format |
---|---|
Multiple Choice | MC |
True/False | TF |
Multiple Answer | MA |
Essay | ESS |
Ordering | ORD |
Matching | MAT |
Fill in the Blank | FIB |
Multiple/Fill in the Blank | FIB_PLUS |
File Response | FIL |
Calculated Numeric | NUM |
Short Response | SR |
Opinion/Likert Scale | OP |
Jumbled Sentence | JUMBLED_SENTENCE |
Quiz Bowl | QUIZ_BOWL |
Table: List of question types