This tutorial will explain the basics of creating a MS Excel test that can be uploaded into Blackboard 9.1.
If you do not have access to the Internet or Blackboard, you can still create a test or quiz using MS Excel, save it to your computer or thumb drive, and upload it at a later time.
To create a test or quiz:
- Open an Excel spreadsheet.
- Format and enter the appropriate information for the questions in a unique row/cell.
- Save the file as an Excel Workbook (*. xlsx) to reuse or edit at a later date
- Save the worksheet as a Text (Tab Delimited) (*.txt) file that you can upload into Blackboard.
Format the cells as follows:
Column A – Indicate Question Type
Column B – Question Text
Column C – Correct Answer – for single answer questions. FoESS and SR questions, the field can be left blank or an additional prompt or sample response can be provided.
- Include only one question per row.
- The first field in every row defines the type of question.
- Separate each field in a row using a TAB.
- Correct, incorrect, true, false and other words that identify answers must be in English.
For questions with multiple answers, the subsequent columns must indicate if the answers are correct or incorrect.
Cell A1= question type "MC"
Cell B1=question; "What year was Hawaii granted statehood?"
Cell C1 = possible answer "1949"
Cell D1 = result if C1 was selected "incorrect"
Cell E1 = possible answer "1959"
Cell F1 = result if E1 was selected "correct"
Cell G1 = possible answer "1969"
Cell H1 = result if G1 was selected "incorrect"
Example question formats:
For more sample question formats see Tips & Tricks
After you have finished creating the questions,
the file should be saved as a an Excel Workbook for easy editing later
a Tab Delimited, .txt file to upload into Blackboard
You can then uploaded the .txt file into Blackboard using the Test, Surveys, and Pools tool from the Course Tools section of the Control Panel.
For even more information on formatting and uploading questions, please also see the Blackboard 9.1 help page at Uploading Questions
or watch a short video at Uploading Test Questions From Microsoft Excel