Skip to end of metadata
Go to start of metadata


Faculty can use a download of the Blackboard Grade Center to upload grades into the Faculty Grade Entry application in Banner. However, specific data elements, or Excel columns, are needed to successfully complete the process. Follow the guide below to download the Blackboard Grade Center and to format the Excel spreadsheet to upload to the Faculty Grade Entry system. 

If at any point you have questions during the grading process, you are welcome to contact the Office of the Registrar: 417-836-5520 or registrar@missouristate.edu

Faculty Grade Entry (FGE) and Blackboard alphabetize grade rosters differently.  Please use these instructions to import your grades from Blackboard, rather than copying and pasting your grades from the Blackboard Grade Center Download into the FGE Export file.

Step-by-step guide

Set Primary Display

Final grades must be in a Letter Grade format. If your Total or Weighted Total column is not displaying as a Letter Grade, follow these steps to change the Primary Display.

  1. In the Grade Center, find the column displaying the students' final grade and click the drop-down arrow. 
  2. From the drop-down menu, select Edit Column Information.
  3. Under the Column Information section, locate the Primary Display field and select Letter from the drop-down list.

Download your Blackboard Grade Center

  1. On your course, under the Control Panel, click Grade Center, and then click Full Grade Center.
  2. Point to Work Offline, and then click Download.


  3. In the Data section, select the Selected Column radio button. 
  4. From the Selected Column drop-down list, select the column that represents the students' final grade. This is typically the Total or Weighted Total.


    Final Grades must be entered as a Letter grade. See the section above on how to Set Primary Display.
  5. Select the options:
    1. Delimter Type = Comma 
    2. Include Hidden Information = No


  6. In the Save Location section, select the place you wish to save the grade center information. 


  7. Click Submit, and then click Download




  8. The Grade Center will download as an Excel file. The columns may look similar to the example below. 


Add the Remaining Columns to the Excel Spreadsheet

  • CRN

  • Term Code

  • Last Attend Date (this is only required for students who receive an NP or F grade) 

How to Add Columns to Your Excel Spreadsheet

  1. CRN (the five digit course reference number, which can be found in the CRN column for your class in Faculty Grade Entry)


    1. With your Grade Center spreadsheet open, right click on the letter A to highlight that entire column and select Insert.


    2. In the new column, type CRN in the first cell (A1).


    3. Find the CRN for the class in Faculty Grade Entry.


    4. Type this number into the second cell (A2).
    5. Click on the Data tab.
    6. With cell A2 selected, click Flash Fill.


  2. Term Code in the six digit format ex. 201540 (this can be found in the Term column for your class in Faculty Grade Entry)

    1. Right click on the letter A to highlight the entire column and select Insert.


    2. In the new column, type Term Code in the first cell (A1).


    3. Find the six digit numerical term code (for example, Fall 2017 is 201740) for the class in Faculty Grade Entry.


    4. Type this number into the second cell (A2).
    5. Click the Data tab.
    6. With cell A2 selected, click Flash Fill.



  3. Last Attend Date (this is only required for students who receive an NP or F grade) 

Last Access column in Blackboard indicates the last time the student logged into the Blackboard course, and is not the same as Last Attend Date.

Save your Spreadsheet

  1. Click on the File tab.
  2. Click Save As
  3. Find a location for your document, type in a name, and choose Excel 97-2003 Workbook in the Save As type field.
It is very important that your file be saved as Excel .xls extension instead of .xlsx. Only .xls extension files will import successfully into the Faculty Grade Entry system.

Next, follow the guide on How to Import Grade Rosters in Faculty Grade Entry.

 


For questions or comments, contact the Computer Services Help Desk
HelpDesk@MissouriState.edu
417-836-5891