Use Excel to Create an Exam or Test

How Do You Do This?

Create questions in Excel

  1. Open a Microsoft Excel spreadsheet
  2.  Format and enter each question in a unique row/cell
  3.  Save the worksheet as a Text; Tab Delimited file

Create test in Blackboard

  1. Access Control Panel; Course Tools, Test Surveys and Pools, Tests; Build Test
  2. Type in name for the test and any description and/or instructions
  3. Click Submit
  4. On the Test Canvas page, select Upload Questions
  5. Select Browse to the locate the Excel file (text, tab delimited format) you saved above
  6. Enter the points to be assigned to each question and click Submit

You should now see your test questions reformatted for Blackboard; click OK to accept

For printed, detailed instructions and examples of formatted questions/answers view (or print) the below PDF instructions

Create Tests in Excel