Create a Blackboard Test with Excel | Scribe

    Create a Blackboard Test with Excel

    • 3 minutes
    1
    Create the test file in Excel.
    2
    Enter the following for each question in separate columns: 1. In column A, enter the question type (see legend below) 2. In column B enter the question 3. In columns C and beyond, enter responses (see example below). 1. True/False questions: enter the correct response 2. Essay questions: Leave column C blank 3. Multiple choice / multiple answer questions: enter choices in separate\ columns with either correct or incorrect in the adjacent column of each choice 4. Ordering and matching questions: enter answers in the correct order;\ Blackboard will scramble them for you
    information ordinal icon
    - TF = True or False - ESS = Essay question - MC = Multiple Choice - MA = Multiple Answers - ORD = Ordering - MAT = Matching - FIB = Fill in the blank
    3
    Your test will look like the example in the image.
    4
    Save the file as a Text (Tab delimited) (\*.txt). Excel will warn you about losing\ features using this format. Click “Yes” to confirm this selection.
    5
    Navigate to your course
    6
    Then Navigate to where you want to create your test.
    7
    Hover your mouse over a line and click the purple + that appears.
    8
    Click "Create" from the menu
    9
    Locate "Test" in the panel on the right and click on it.
    10
    Find the + button in the test
    11
    Click "Upload questions from file"
    12
    Navigate to your text file from Step 4.
    13
    Check your test over once the upload is complete.