How to Import Grade Rosters in Faculty Grade Entry

Please Note: Faculty can enter grades in Banner using Faculty Grade Entry by importing an Excel file.  If at any point you have questions during the grading process, you are welcome to contact the Office of the Registrar (417-836-5520).

Step-by-Step Guide

Exporting Your Grade Roster from Blackboard Grade Center (Recommended)

Follow the instruction guide How to Use Blackboard Grade Center Download for Faculty Grade Entry to export your grades.  Return to this page to continue the instructions on importing your file.

  1. Click the tools icon in the upper right corner.
    tools icon
  2. Select Import.
  3. When the Import Grades wizard opens, click Browse and find your file. 
    Browse button
  4. Click Upload.
  5. Click Continue.
  6. Preview your file. If your file has column headers, make sure the My Spreadsheet has headers box is checked. If it does not have headers, make sure the box is unchecked.
  7. Click Continue.
  8. If your column headers are different than the column headers in the Faculty Grade Entry page, you will need to map your columns so they import correctly.
  9. Use the drop down menu above each column to choose the type of data that is displayed in each column. The Term Code, Student ID and CRN columns must be mapped to activate the continue button.
  10. Click Continue.
  11. Validate the data in the worksheet. The import wizard will give you a list of data that is going to be imported.
  12. Click Continue.
  13. Once the import has successfully finished, you will get a notification at the top of the import wizard page.
    the import wizard is complete notification
  14. From this page, you can download a validation report that will give you more information about the import, specifically which records were imported successfully and which records had errors.
  15. Click Finish.


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


Article ID: 98878
Thu 2/20/20 2:56 PM
Mon 12/6/21 12:18 PM