Note to Faculty:  Because of the manner in which Blackboard stores data internally in the grade center, we are unable to use Grade Schemas and Letter Grade Displays to feed grades directly into MyZou.  The primary display of the MyZou Grade Column must be set to TEXT.  Do not set it to score, percentage, letter, or complete/incomplete. 


Two options are presented below for preparing grades in Blackboard for import into myZou.

  • Option 1 is configured for hand-entry of grades in Blackboard. It is suitable for small classes.
  • Option 2 allows instructors in large classes to translate grades figured in Blackboard by Grade Schemas and Letter Grade Displays to Text columns via Excel. It also allows instructors to enter grades in Excel and upload them for import into myZou.


Part I - Setup in Blackboard

Option 1 (suitable for smaller classes)

  1. Create a column in the Grade Center titled “myZou Grade” (See, Fig. 1). There should be no more than one “myZou Grade” column in the course. Please delete or rename any other columns with that title.
  2. Set the Primary Display to “Text”.
  3. Points Possible is a required field, but is ignored by this process. It is recommended that it be set to zero and/or that the column not be included in calculations.
  4. Set other options as desired.
  5. Click submit.



    Fig. 1, create a grade center column.
  6. Enter valid letter grades (A+, A, A-, B+, B, B-, C+, C, C-, D+, D, D-, F, FN, S, U, W, WF, I). Note that grades that are invalid for a student may not be converted in myZou to a valid grade. Grades for these students will have to be entered by hand in myZou.
  7. Proceed to Part II.


Option 2 (recommended for large classes, instructors who figure grades in Excel, or use a Blackboard Letter Grade schema to figure final grades)

  1. Download the total or final grade column from Blackboard into Excel or open your Grade Center spreadsheet in Excel.
    1. In the Grade Center, choose “Download” from the Work Offline menu (right hand portion of your screen).
    2. Select Full Grade Center in the “Select Data to Download” section (See, Fig. 2). Any other option will cause calculated columns to download letter-grade data incorrectly.
    3. Choose the Delimiter type. Generally it is best to set this to “Tab”. (On Windows, you may need to change the file extension to “.txt” after it downloads.
    4. Click “Submit”.
    5. Click “Download” on the next screen.
    6. Save or open the file as normally. Options will depend on the operating system and browser.


      See, Fig. 2, downloading the grade center
  2. Open the file in Excel.
    1. Rename the column containing the final grade “myZou Grade”. (Instructors who keep grades in Excel should create a column called “myZou Grade”.) (See, Fig. 3)


      Fig. 3, excel columns

    2. Ensure that it contains only valid letter grades (A+, A, A-, B+, B, B-, C+, C, C-, D+, D, D-, F, FN, S, U, W, WF, I). Make any necessary changes (such as assigning Incompletes). Note that grades that are invalid for a student may not be converted in myZou to a valid grade. Because of this, do not use a grade schema to figure grades in a grad/undergrad class. Grades for these students will have to be entered by hand in myZou.
    3. Save as a .CSV or .TXT file.
  3. Upload the column into Blackboard. There must be no more than one “myZou Grade” column in the course. Delete any columns by this name before uploading grades. (If more than one column of that name exists, this may cause errors.)
    1. In the Grade Center, choose “Upload” from the Work Offline menu (right hand portion of your screen).
    2. Browse for the file and select it.
    3. Choose the Delimiter Type. In most cases, this may be left on “Auto”, but in some cases, Blackboard may need to be told if the delimiter is “Comma” or “Tab”.
    4. Click “Submit”.
    5. A confirmation screen will appear.
    6. Ensure that only the “myZou Grade” column is selected (See, Fig, 4)


      Fig. 4, uploading the column

    7. Click “Submit”.
    8. Review the grades. If they are correct, proceed to Part II.
See also the documents, Downloading and Uploading Grades, Grading Schemas, and the video tutorial Grade Center Download and Upload.

Part II - Pulling the Grades into MyZou

  1. Login to the myZou Student Information System.
  2. Click on Self Service then click on Faculty Center. Your courses should each be listed.
  3. Click on the grade roster icon ps_traning_request_icn_1.gif for the course you would like to grade. Note that cross-listed courses (and those with multiple graded sections) will show up separately. It will be necessary to import the grades separately into myZou for each one.
  4. To import the grades for the selected course/section:
    1. Choose the Blackboard course ID from the “Select Grades From” pull-down menu (See, Fig. 5). A list of your current semester’s Blackboard course ID’s should show here. If you are unsure of the correct course ID, open Blackboard in a new window of tab.
      1. The course ID shows up in the parentheses at the end of the course title in Blackboard, e.g., “ELPA/ISLT 7822: COLLEGE TEACHING WITH TECHNOLOGY I, SEC. 1 – FS2008 (LIVENGOOD AND VESSELL) (ELPA_7822_ML)”.
      2. If the course does not appear in the list, please contact blackboard@missouri.edu


        Fig. 5, MyZou

    2. Click on the “Retrieve Grades From Blackboard” button. This will assign the grades you have entered in the “myZou Grade” column of Blackboard to the “Roster Grade” column in myZou.
  5. Review the grade assignments that display on the screen. An invalid grade from Blackboard cannot be assigned by myZou, and so will not be displayed. You may assign a grade as you normally would in myZou from the pull-down menu in the Roster Grade column for any given student.
  6. Save editing changes frequently.
  7. Your grades are not officially submitted until you mark them as “Approved” in the “Approval Status” menu.
  8. Click “Save” to save your approved grades.

Note: There is not always a one-to-one correspondence between graded sections in MyZou and Blackboard course sites.  For instance, if your course is set up to have labs as the graded sections in MyZou, but you have one Blackboard site for the entire course, you will need to repeat the import portion of the process for each graded section.  On the other hand, if the graded section is a lecture in MyZou but the course is broken up in to separate Blackboard sites for each lab section, then you will have to repeat step 4 for each Blackboard site in the "Section Grades From" menu.


For help with the Blackboard portion of the process, please contact blackboard@missouri.edu

For help with the myZou portion of the process, please contact myzou@missouri.edu

Importing Final Grades to myZou from Blackboard