Syracuse Contact Search SUHome SU Info
University
Office of the Registrar MySlice Help MySlice SU Portal


Updated: 10/28/2009

> Faculty and Staff > Final Grade Information > Grades from Blackboard

Grades from Blackboard

To download your Blackboard Gradebook:

  1. Login to Blackboard at http://blackboard.syr.edu
  2. From your Blackboard @ SU tab (home page), select the course link you wish to download grades from.
  3. Click on the "Grade Center" link which is a sub-menu item in the "Evaluation" menu located in the Control Panel.
    graphic depicting location of the Download selection
  4. In the grade center, locate (on the right) the "Work Offline" button with two drop down menus being "Upload" and "Download". Select Download.
    graphic depicting location of the Download selection
  5. On the Download Grades page, be sure to select:
    1. Under #1 Data – full grade center.
    2. Under #2 Options - Tab as the delimiter.
      graphic depicting location of the Download selection
  6. Click on submit.
  7. To save the file, click on Download, then click Save and browse to the location in which you wish to save the file.
  8. Change the file name if you would like to. By default the file name is "gc_course id_fullgc_date.xls"

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://registrar.syr.edu/staff/finalgradeinfo/onlinegradingoverview.ppt )
  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 green Save or Submit button.
  7. More information for Blackboard users is at http://its.syr.edu/bbhelp/faculty/gradebook.shtml
spacer