Syracuse University

Registrar

Grades from Blackboard

Downloading your Grade Book from Blackboard

  1. Login to Blackboard at http://blackboard.syr.edu
  2. Enter course
  3. Click on the "Grade Center" menu button located in the Course Management -> Control Panel
    Course Management Navigation
  4. Click on the “Full Grade Center” link which is a sub menu under the Grade Center menu button
    graphic depicting location of the Download selection
  5. In the grade center, click on the “Work Offline” located on the right. Grade Center Work Offline Button
  6. Drop down menu presents two options. Upload or Download. Select Download.
    Work Offline - Download dropdown
  7. On the Download Grades page, be sure to select:
    #1 Data – full grade center.
    #2 Options – Tab as the delimiter.
    Download Grades
  8. #3 Save Location – Select My Computer
    #4 Click Submit
  9. To save the file, click on Download, then click Save and browse to the location in which you wish to save the file.
  10. Change the file name if you would like to. By default the file name is "gc_course id_fullgc_date.xls". MAC Safari
  11. Change the file name if you would like to. By default the file name is "gc_course id_fullgc_date.xls". Windows – Internet Explorer 9

To open the Gradebook in Excel:

  1. Start Excel.
  2. In the File menu, select Open, find the gradebook file, highlight its name and click on Open.
  3. In the Text Import Wizard Window, select the radio button for Delimited, then click Next.
  4. In the next window under Delimiters, click the checkbox next to Tab if it is not checked.
  5. Click the box next to Other and type in the | character (the top character on the key under Backspace key; it looks like 2 vertical dashes). Then click Next.
  6. Click Finish.

You will see your gradebook in Excel with separate columns for name/username, student ID and each grade. Click File, Save As and select Save as type "Microsoft Office Excel Workbook (*.xls)".

To prepare your Excel file for uploading to Online Grade Input:

  1. Open your Excel file.
  2. Delete all columns except A (SUID) and B (final grade).
  3. Delete all headers.
  4. Click File>Save As. Select location and file name. Save as type CSV (Comma deliminated) for PC’s, “CSV (Windows)” for MAC.
  5. Click Save.
  6. Message displays: "Do you want to keep the workbook in this format?" Click yes.
  7. Close Excel file.

To upload grades:

  1. Open your Grade Roster in MySlice (see tutorial: http://www.syr.edu/registrar/staff/finalgradeinfo/onlinegradingoverview.pdf)
  2. Click green Upload Grades button.
  3. Using Browse, select file to be uploaded.
  4. Click Upload*.
  5. Review Grade Roster for accuracy of grades.
  6. Click Submit to Registrar button.

* If your Excel file was not formatted correctly, or if there are grades missing for a student in your Excel file, you will receive an error message when uploading. Click OK to close the message window, and then click Show Errors to troubleshoot. If the error indicates that grades are missing, you can manually enter them on the grade roster.