Skip to Navigation Skip to Content
  • Students
  • Alumni
  • Parents
  • Employees
  • Administration
  • Apply Now
  • Give
  • Libraries
  • Map
  • AU Access
  • Toggle Search
  • Apply
  • Libraries
  • Give
  • AU Access
  • Map
  • A-Z
  • Find People
A-Z | People Finder
Auburn University black and white logo Auburn University logo
Biggio Center Office of the Provost
Skip to Content
  • Home
  • Teaching
  • Technology
  • Testing
  • Opportunities
  • Remote Instruction
  1. Instructional Technology
  2. Canvas-to-Banner Midterm and Final Grades

Canvas-to-Banner Midterm and Final Grades

 

Unless otherwise noted, links within this help guide go to additional help guide pages. These are not links to the specific section in your own course.

 

1) Set up the gradebook. If you need help ensuring Canvas is accurately calculating your student’s grades based on your syllabus, please call us at (334) 844-5181 and we’ll go through each step together. Then follow the tutorial for creating a grading scheme. Beside each student’s grade in the gradebook should be the corresponding letter grade.
 

with a grading scheme set each student should have a letter grade displayed in the Canvas gradebook

2) Once the grading scheme is accurate, then export the gradebook.
 

3) For your spreadsheet to import into the Faculty Grade Entry site, three components are necessary: Student ID (Banner ID or GID), Term Code, and CRN. The Term Code and CRN fields can be found under the Faculty Grade Entry page located at aub.ie/fge.

 

the GID and CRN are located on the spreadsheet in the Faculty Grade Entry page

Open the CSV spreadsheet and change the following:

  • Student ID: Rename “SIS Login ID” to “Student ID”.
  • Renaming the SIS Login ID column in Excel
  • Term Code: Create a new column called “Term Code” and enter the 6-digit term code for each student. If you click the bottom-right dot in Excel, you can drag the field down to autopopulate the cells.
  • Renaming the SIS Login ID column in Excel
  • CRN: Create a new column called “CRN.” Enter the 5-digit CRN for each student.
  • Creating the CRN column in Excel
    • If you feel uncomfortable with any of these instructions, please contact Biggio Tech
    • Note: If you have cross-listed sections (i.e., multiple sections in one course), then we recommend filtering one section at a time. Filter one section, add the CRNs, then filter each additional section, adding CRNs as needed. Each student needs the correct CRN for the import to work correctly.

 

  • Final Grade: Double-check to see the Grade has the correct letter grade.
  •  

    Verifying the grade column in Excel
  • Save: Save as an XLSX file. CSV files are not supported.
  • Be sure to save as Excel Workbook / XLSX format
    Saving to XLSX on a PC
    Be sure to save as XLSX on your Mac
    Saving to XLSX on a Mac

4) Navigate to aub.ie/fge – the Faculty Grade Entry portal. Once at Faculty Grade Entry section, select the course for which to submit grades. Then click the Tools icon at the top right, followed by Import.

select the import option to begin

5) The import wizard will appear. Follow the prompts to upload and import your grades.

  • Click the white box to the left of “Upload” and select your XLSX file. Click Open to add the file name to the Browse box
  • Click Upload. A progress bar will show towards the bottom, then disappear. Click Continue once it’s disappeared.
choosing the file to import
  • On the preview screen, verify that your data has been properly imported and visually correct. Click Continue.
image of preview
  • On the mapping screen, ensure your headers are mapped to the four needed components: Student ID, CRN, Term Code, and Midterm/Final Grade.
  • If not, click the drop-down menu for the mismatched header and choose the correct component. Click Continue when green checkmarks appear next to each.
image of mapping
  • If you received an error when importing the grades you can download a validation report. One example of an error would be trying to import a spreadsheet into the wrong roster in Faculty Grade Entry.
  • Click Download the Validation Report. Open the report and view any errors under the Error title.
  • If you would like a copy for your own records, download the Validation Report.
  • Once validated, click Continue in Faculty Grade Entry.
image of validation
image of error
  • Click Finish to import the grades.
image of completion

6) Click on the course in the Faculty Grade Entry section to make sure the information was imported correctly

verifying the information on the grade entry page

Last modified: April 9, 2020

This Is Auburn vertical
Contact

Instructional Technology

Hours: 7:45am - 4:45pm

540 Devall Drive
Auburn, Alabama

(334) 844-5181 biggiotech@auburn.edu
Connect
Facebook
Twitter
YouTube
Staff


Website Feedback
Privacy
Campus Accessibility
Copyright ©