Closure Notice - The Registrar's Office will open at 12:30 pm on Thursday, December 5.

Exporting Grades

Understanding How to Export Grades from the Banner Faculty Grade Entry (FGE) Module

Grades for class rosters can be exported from the Banner Faculty Grade Entry (FGE) module using the options in the Tools menu.

The module includes a wizard for guiding users through the process of exporting. The files exported from the module are spreadsheet files in Microsoft Excel's ".xls" or ".xlsx" format. These files are designated as "Read Only" at first, but they can be saved using the "Save As" command and then renamed, allowing editing.

Selecting a Course for which to Export Grades from the Banner Faculty Grade Entry (FGE) Module

  1. Select the Midterm Grades or Final Grades tab.
  2. Select a Course from the list of gradable courses.
  3. Select the Export Template option from the Tools menu.
Screenshot
  1. To increase the number of records shown, adjust the "Per Page" selector.
Screenshot

Exporting Grades from the Banner Faculty Grade Entry (FGE) Module

  1. Select the export file type as Excel (.xls or .xlsx). Then click "Export."
  2. Open the file in the default application: Microsoft Excel.

The default file name uses the term code, subject, course number, section number, and "_Template."
For example: 201802_Biomedical Engineering_2210_Template.xls

Screenshot
  1. Review the exported date in the spreadsheet file.

The file is "read only." You can use the "Save As" command and rename the file in order to edit it. Do not change the student ID.

Screenshot