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 email@example.com.
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.
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.
In the Grade Center, find the column displaying the students' final grade and click the drop-down arrow.
From the drop-down menu, select Edit Column Information.
Under the Column Information section, locate the Primary Display field and select Letter from the drop-down list.
Download your Blackboard Grade Center
On your course, under the Control Panel, click Grade Center, and then click Full Grade Center.
Point to Work Offline, and then click Download.
In the Data section, select the Selected Column radio button.
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.
Select the options:
Delimter Type = Comma
Include Hidden Information = No
In the Save Location section, select the place you wish to save the grade center information.
Click Submit, and then click Download.
The Grade Center will download as an Excel file. The columns may look similar to the example below.
Add the remaining needed columns to the Excel Spreadsheet for upload to the Faculty Grade Entry system.
These columns need to be added and populated:
CRN (the five digit course reference number, which can be found in the CRN column for your class in Faculty Grade Entry)
Term Code in the six digit format ex. 201540 (this can be found in the Term column for your class in Faculty Grade Entry)
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.