Grade Entry

This feature of Banner allows you to reflect your students’ grades on the system. And there are two ways of doing this, you can either enter the grades for a batch of students at once through an Excel sheet, or enter it manually. The later is advised to be used when you would like to enter/update a grade for very few students.

#Enter the Grades for a batch of students at once

To use this method of grade entry, you need to access Argos, Microsoft Excel, and Banner by following the below steps:

#Access the Grade Entry Sheet on Argos

1. You can access Argos through this link or through Banner’s home page or as illustrated below:
2. Click on Argos Web Viewer.
3. Go to Faculty folder.
4. Click on the Grade Entry Sheet.
5. By default, the current semester is chosen. Choose the Exam Type, which reflects the grades you’d like to enter.
6. Choose the course.
7. From the navigator, click on Reports and then on Student Excel Grade Entry Data Report.
8. Click on Run, as illustrated below. This will download a predefined Excel Sheet with a list of all the students in the specified course. Kindly use this sheet to proceed to the next steps.

#Fill and save the Grade Entry Sheet

1. Open the downloaded Excel sheet.
2. Note that the sheet contains the list of student ID, student name, the maximum grade assigned to the Exam Type which was specified in step 5 in the previous section, etc. Fill the Score column (column G) for each student.

   Note:

   1. You can sort the students based on student ID or name for an easier grade entry.
   2. You can enter the grades for a few students only and leave the rest empty.
3. Save the Excel Sheet in .xls format by following this sequence: Click on File -> Save As -> Enter the File name -> Choose Excel Workbook type -> Click on Save.

#Import the Grade Entry Sheet to Banner

1. Log in to Banner.
2. Go to the menu on the left, click on Banner, then click on Faculty and Advisors and, and then on Grade Entry.
   
   
3. Click on Gradebook.
4. Choose the course, which you have already filled the Excel sheet for, and click on Components.
5. Click on the Description that matches the Exam Type selected is step 5 in the first section of this article.
6. From the navigator, click on the gear icon then on Import.
7. Click on Browse, to locate the Excel Sheet, then click on Upload, and then on Continue.
8. Preview the data and then click on Continue.
9. Click on Continue.
10. Check the number of records that contain errors and click on Continue if the are no errors.
    

    Note:

    If there is an error or more, follow the below steps:

    1. Click on Download the validation report to locate the errors (the cells in the first column will be highlighted in red). 
    2. Implement the needed changes in the Excel Sheet which you have already worked on and saved. 
    3. Save the file.
    4. Repeat the steps in this section.
11. Click on Finish.

#Enter/Update the grades manually

1. Log in to Banner.
2. Go to the menu on the left, click on Banner, then click on Faculty and Advisors and, and then on Grade Entry.
   
   
3. Click on Gradebook.
4. Choose the course, which you have already filled the Excel sheet for, and click on Components.
5. Click on the Description that matches the Exam Type selected is step 5 in the first section of this article.
6. Enter the grade in the Score column, then scroll down and click Save. Noting that you can enter the grade/update at once for 20 students maximum.