Skip to Main Content

University of Tennessee

Main Navigation:

Get Help!

Contact Information
Phone: 865.974.9670

Innovative Technology Center
The Kingston Pike Building
2309 Kingston Pike
Knoxville, TN 37996

Send us suggestions for changes and new services:
bbsuggestions@itc.utk.edu


Instructors > How To...

Grade Center: Download Grades

You can download Grade Center data to your computer as a tab or comma delimited file that you can use in other applications such as Excel or statistical analysis programs.

Download to archive grades

If you manage all your grades in your Online@UT course site, it’s a good practice to download the Grade Center data to your computer after entering each major grade into the Grade Center. You can choose to select specific grades to download or download the complete Grade Center spreadsheet.

Download to upload grades later

If you plan to upload grades to the Grade Center from an external application such as Excel spreadsheet, you may wish to download the Grade Center data first as a tab-delimited file. A tab-delimited file can be imported to Excel and then formatted for uploading back to Blackboard.

In this tutorial, you will learn how to:

Download the Grade Center spreadsheet

  1. Click Manage in the Action Bar of the Grade Center (the gray bar above the spreadsheet).
  2. Select Download from the drop-down menu.
  3. Select the Full Grade Center button next to Select Data to Download.
  4. Leave Tab as a delimiter type. Tab delimited files have the file extension .xls.
  5. Choose Yes next to Include Hidden Information if you want hidden columns and students to be included in the spreadsheet.
  6. Press the Submit button.
  7. Press the Download button and save the file to your computer.
Note:
Blackboard recommends saving a file as tab-delimited.

back to top

Download a selected grade column

  1. Click Manage in the Action Bar of the Grade Center (the gray bar above the spreadsheet).
  2. Select Download from the drop-down menu.
  3. Click on the Selected Columns radio button.
  4. Select the grade column in the drop-down menu.
  5. Check the “Include comments for this column” box if desired.
  6. Leave Tab as a delimiter type. Tab delimited files have the file extension .xls.
  7. Choose Yes next to Include Hidden Information if you want hidden columns and students to be included in the spreadsheet.
  8. Press the Submit button.
  9. Press the Download button and save the file to your computer.
back to top

Download a Roster of Students

You can use the downloaded spreadsheet to manage the grades in an Excel spreadsheet on your computer. For example, you can:
  1. Click Manage in the Action Bar of the Grade Center (the gray bar above the spreadsheet).
  2. Select Download from the drop-down menu.
  3. Click on the “User Information Only” radio button.
  4. Leave Tab as a delimiter type. Tab delimited files have the file extension .xls.
  5. Choose Yes next to Include Hidden Information if you want hidden columns and students to be included in the spreadsheet.
  6. Press Submit.
  7. Press the Download button and save the file to your computer.
back to top

Download a Grading Period

  1. Click Manage in the Action Bar of the Grade Center (the gray bar above the spreadsheet).
  2. Select Download from the drop-down menu.
  3. Click on the Selected Grading Period radio button.
  4. Select the Grading Period in the drop-down menu.
  5. Leave Tab as a delimiter type. Tab delimited files have the file extension .xls.
  6. Choose Yes next to Include Hidden Information if you want hidden columns and students to be included in the spreadsheet.
  7. Press the Submit button.
  8. Press the Download button and save the file to your computer.
Note:
You can use this function if you previously set up a Grading Period in the Grade Center.

back to top

Download Smart View

If the spreadsheet is displayed in a Smart View, you can download only the information that pertains to the Smart View. Download by Smart View will be the only option in this case. To download the Smart View spreadsheet, follow the instructions for downloading the Grade Center spreadsheet.

back to top

Open the downloaded tab-delimited file in Excel

Double-click the downloaded file.

OR
  1. Open the Excel program.
  2. Select File > Open. Select the saved tab-delimited file. Select Open.
  3. If Text-Import Wizard opens, leave the default “Delimited” option unchanged and press Next.
  4. Leave Tab selected as a delimiter and press Next.
  5. Press Finish.
back to top

Edit and Save the Downloaded Spreadsheet as a regular Excel file

  1. Select File > Save as.
  2. Type the descriptive name of the file including the course code and date (e.g., ed255_050508) in the File Name box.
  3. Select “Microsoft Excel 97-2002 & 5.0/95 workbook” in Save As Type (on a PC) and Format (on a Mac) drop-down menu.
  4. Click Save.
back to top

Download Grade History

  1. Press the Grade History button in the Action Bar of the Grade Center (the gray bar above the spreadsheet).
  2. Press the Download button in the toolbar above the table with grade records.
  3. Leave Tab delimited type selected.
  4. Choose whether you want to include comments in the grade history.
  5. Press Submit.
  6. Press the Download button and save the file to your computer.
Note:
The Grade History can be downloaded to your computer as a tab-delimited file.

back to top