This site requires JavaScript to be enabled

Import Final Grades in Banner from Spreadsheet

749 views

Occasionally, grade submission from Canvas to Banner can fail to process correctly. If this cannot be overcome easily, then you need to enter grades directly into Banner.

If you have a large class, it is possible to import the grades to Banner from a spreadsheet. You will still need to import the spreadsheet for each section in Banner so the spreadsheet import option may not save time in the long run from manual entry unless you have significant experience working with Excel. 

Steps to import grades to Banner via spreadsheet

You can prepare an appropriately formatted spreadsheet for import into Banner by either downloading the grade template from Banner, or exporting the Canvas gradebook and revising it so it meets the appropriate format.

Step 1: Prepare an Excel Spreadsheet, with the grades, for import into Banner.

Option 1. Download the Grade Template from Banner and enter grades in Excel

The first step is to download the spreadsheet template from Banner.

  1. Go to the Faculty Grade Entry page, click on the course section.
  2. Click on the gear icon in the top right-hand corner, then click on Export Template from the dropdown menu.
  3. Select your preferred spreadsheet file and click Export to download the file.
    Export Template prompt box with export file as Excel spreadsheet (.xls) selected and Excel spreadsheet (.xlsx) as another option with the Export button highlighted

Enter Grades in Excel

Open the downloaded file in Excel and enter the grades in the Final Grade column. Then, save the file. Make sure the file format is .xls (not .xlsx).
Spreadsheet column headers A1 is Term Code, B1 is CRN, C1 is Full Name, D1 is Student ID, E1 is Rolled, F1 is Confidential, G1 is Course, H1 is Final Grade, I1 is Last Attended Date, J1 is Incomplete Final Grade, K1 is Extension Date

 

Option 2. Export the Canvas Gradebook and revise it for import into Banner.

  1. Download the Canvas gradebook
  2. Open the csv file in Excel and save it as an xls file (not xlsx)
  3. Remove all columns except for the following:
    1. SIS Login ID
    2. Final Grade
    3. For courses with multiple sections, leave the Sections column for reference in entering CRNs.
  4. Remove the 2nd row containing Points Possible
  5. Remove the Student, Test (last row), if it exists
  6. Add a new column at the beginning and call it Term Code. Fill it with the current term code (YYYY## - 4 digit year and either 20 for spring semester, 30 for summer semester, or 40 for fall semester)
  7. Add a new column before Student ID and label it CRN. Fill each row of the column next to the Student IDs with the course section CRN. For courses with multiple sections, refer to the Sections column to input the correct CRN. You may find it useful to use an excel VLookup formula.
  8. Remove the Sections column, if you haven't already, once CRNs are entered for each row.
  9. Change the column label SIS Login ID to Student ID
  10. Add a new column after Final Grade and label it Last Attended Date.
  11. Add another new column after Last Attended Date and label it Narrative Grade Comment. This column can be left empty. The column headers of the revised spreadsheet should look like this:
    6 excel spreadsheet column headers are labeled Term Code, CRN, Student ID, Final Grade, Last Attended Date, and Narrative Grade Comment.
  12. Enter Last Attended Date for each student with an F Grade. The date format should be MM/DD/YYYY and cannot be after the last day of the semester. For online classes, you can get this date next to the student's name on the People page in Canvas. 
  13. Save the gradebook spreadsheet as an xls file.

 

Step 2: Import the Prepared Spreadsheet into Banner.

  1. Go back to Banner and click on the appropriate course section, then click the gear icon and choose Import. For courses with multiple sections, you will import grades one section at a time. However, your spreadsheet file can contain all sections. Banner will ignore those that do not match the selected section.
    Banner Faculty Grade Entry, Final Grades page with settings selected and Import highlighted
  2. Click in the browse field to browse your computer for the spreadsheet file. Select the saved file with the final grades.
  3. Click the Upload button. After it is successfully uploaded click Continue.
  4. A preview of the import will appear on the screen. It should look similar to your Excel gradebook. Click Continue.
  5. The next screen is the mapping screen. Your columns should have successfully mapped to the values Banner expects. You can re-map columns as needed. If you see no issues, click Continue.
  6. There may be a delay before the validation screen appears. Once it appears a summary of columns to be imported, not imported, or containing errors will be displayed, click Continue. There may be a pause, and you may have to click Continue again.
  7. When the import is finished click Finish. (You may see a message at this point that you have been signed out. Return to the Banner grade entry form to verify if your grades were imported.)
  8. Review the changes in the entry form and make any manual corrections needed.
  9. Click Save at the bottom of the page.
  10. For courses with multiple sections, repeat these steps for each remaining section. You can use one spreadsheet that has all sections on it. Banner will ignore rows with CRNs that don't match the section selected for import.
Authored by Elisa Taylor
Last modified 2 weeks ago