Downloading Raw Data from BB9.1 to Excel

This lesson will demonstrate how to download test and survey results from Blackboard to a spreadsheet.

Accessing the Grade Center

Image of the Blackboard Control Panel open at the Grade Center heading with the following annotations: 1.Click on Grade Center.2.Select Full Grade Center.

Log into your Blackboard course and go the Control Panel:

  1. Click on Grade Center.
  2. Select Full Grade Center.

Locating the Grade Column

Image of the Grade Center with an arrow pointing to the column header for a test.  Instructions read to click on the chevron that appears in the column header. A menu is shown on screen with the Grade Questions option outlined with a red circle.  An arrow is pointing to this option with instructions to Select Attempts Statistics.

Locate the grade column for the test in the grade center.  Click on the chevron in the column header, and select Attempts Statistics from the menu.

Downloading Results

Image of the Download Results screen with the following annotations: 1.Select the delimter type (comma or tab). The recommended setting is Tab.2.Format Results: Select how to format the results download.  The recommended settings is By User.3.Attempts to Download: Select which attempts to download.  The recommended setting is Only Valid Attempts.4.Click on Click to Download Results. Your browser will now ask you where to save your results to.  Select a location on your computer.

You will now see a screen labeled Download Results.  To download results of the survey:

  1. Select the delimter type (comma or tab). The recommended setting is Tab.
  2. Format Results: Select how to format the results download.  The recommended settings is By User.
  3. Attempts to Download: Select which attempts to download.  The recommended setting is Only Valid Attempts.
  4. Click on Click to Download Results. Your browser will now ask you where to save your results to.  Select a location on your computer.