Skip to main content Skip to navigation

This tutorial should assist you with the process of downloading your Blackboard gradebook and preparing your grades to import into myWSU.

  1. Convert the course overall grade in Blackboard Learn to display in letter format.
    1. Log in to your Blackboard Learn course space and navigate to the Full Grade Center.
      Screenshot: Grade Center menu, Full Grade Center chosen
    2. Access the contextual menu for the course overall grade and select Edit Column Information.
      Screenshot: Course overall grade dropdown, Edit Column Information chosen
    3. Change the primary display format to Letter.
      Screenshot: Primary Display dropdown, Letter chosen
    4. Save the changes by selecting Submit.
    5. If you wish to avoid modifying the primary display format for the course overall grade then you can add a new total column to the gradebook to display the course grade in letter format: Learn more about Total Columns.
  2. Ensure that the Student ID column is visible in the Full Grade Center.
    1. Navigate to the Full Grade Center and if you do not see a column for Student ID then select the column organization option listed under the Manage menu.
      Screenshot: Manage dropdown, Column Organization chosen
    2. Update the grade center to show the Student ID column.
      Screenshot: Show/Hide dropdown, Show Selected Columns chosen, Student ID checked
  3. Export the overall course grade as a csv file.
    1. Navigate to the Full Grade Center and select the Download option from the Work Offline menu.
      Screenshot: Work Offline, Download chosen
    2. Select the overall course grade column to download. Do not include comments.
      Screenshot: Data, Select Data to Download radio buttons, Selected Column chosen, dropdown Total chosen
    3. Export the document as a comma separated file (.csv).
      Screenshot: Options, Delimiter Type radio buttons, comma chosen, Include Hidden Information radio buttons, No chosen
    4. Save the file to your computer.
      Screenshot: Save Location, Download location radio buttons, My Computer chosen
  4. Format the csv file for myWSU upload.
    1. Open the csv file downloaded in step 2.
      Screenshot: CSV with columns Last Name, First Name, Username, Student ID, Total Points
    2. Delete all columns except for the Student ID and the overall grade columns.
      Screenshot: Only two columns in table - Student ID and Total Points
    3. Delete the header row.
      Screenshot: No header row in table
    4. Select all the WSU ID numbers, right click and select Format Cells.
      Screenshot: Column highlighted, dropdown menu, Format Cells selected
    5. Navigate to the Number tab, select custom and input 9 zeros into the Type input box.
      Screenshot: Format Cells menu, Number column chosen, Custom chosen, 9 zeros input
    6. Select OK and save the csv file.
  5. Upload to myWSU.