How to Use Blackboard Grade Center Download for Faculty Grade Entry

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).

• Set Primary Display
• Download your Blackboard Grade Center
• Add the Remaining columns to the Excel Spreadsheet
• How to Add Columns to Your Excel Spreadsheet
• Save your Spreadsheet 

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.
   
    
   Please Note: Final Grades must be entered as a Letter grade. See the section above on how to Set Primary Display.
5. Select the options:
   1. Delimiter Type = Comma 
   2. Include Hidden Information = Yes
      
       
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) 

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 either Excel Workbook or Excel 97-2003 Workbook in the Save As type field.

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

To request help related to this article, please see our Service Catalog.