Cornell University Office of the University Registrar

• Home
• For Students
• For Faculty & Departments

Grading

Creation of Grade Rosters

The Office of the University Registrar (OUR) will create grade rosters for a group of classes in batch. College registrars will create individual grade rosters class by class:

• if a grade roster is required prior to the OUR batch processing;
• for classes that are dynamic dated;
• for classes that need to be graded prior to the end of term processing.

Printing Grade Rosters

The faculty and administrative assistants will see all sections of the classes they are associated with but only the graded component should have a grade roster created.

1. Click on the Grade Roster Icon next to the class you wish to print.
2. The grade roster opens. Click the Printer Friendly Version button and a new screen will appear that you can print from.
3. Click on the Download to Excel icon.
4. Save the file to your computer.

Entering Grades

The College Registrasr and their staff can also enter grades into the roster by using the grade upload feature or manually entering the grades into the roster. In most cases grades won’t be entered by college registrar staff.

• Anyone with Grade Access on the class meeting page of Faculty Center can enter grades. Typically this will be instructors and administrative assistants. Only people with the access equal to GRADE on the class meeting page will have access to grade rosters in Faculty Center.
• The grade roster icon will appear on Faculty Center once a grade roster has been created. Faculty and administrative assistants should NOT use the link for Grade Book. Cornell isn’t using this functionality.
• Grades will be entered into the grade roster either via the grade upload feature or by manually entering the grades into the roster (student by student) or by using the “add this grade to all students” button.
• The grade roster status should ONLY be changed to “Ready for Review” when all grades have been entered. If the grade roster status is changed before all grades are entered, the grader must contact the College Registrar who can change the status of the grade roster so entry can continue.
• The NGR process that is run prior to the final post will automatically change all grade roster statuses to approve.

Grade Upload Setup and Use

FILE SETUP

1. Download Grade Roster to desktop using the Download to Excel icon.
2. Remove Notify, Name, Official Grade, Grading Basis, Program and Plan and Level columns from the Excel spreadsheet. You should only have the ID and Roster Grade columns remaining in the spreadsheet.
3. Add the following columns to the spreadsheet in this order:
   

   a. Institution – this will be CUNIV for ALL students (must be all capital letters)
   b. Term Code – code for the term you are grading (Spring 2008 = 2342), this should be the same for every student on the grade roster. The college will need to provide the code to all graders if this functionality is to be used.
   c. Class Number – 4 or 5 digit PS-assigned class number, this should be the same for every student on the grade roster. This number can be found on the PS grade roster page under the link for Subject and Catalog number at the top of the Grade Roster page.
   

   Example: SPAN 1230 – 110 Cont Spanish
   Seminar (5795)
   The (5795) is the class number.
   

   d. Student ID – ID downloaded from the Grade Roster
   e. Roster Grade – Column downloaded from Grade Roster

4. Remove all column headings
5. Save File to Desktop as a CSV file (File, Save AS, File Type = TXT (Text Tab delimited)

LOADING THE FILE

1. Click Grade Upload (green button in the middle of the screen)
2. Click Browse and search for file
3. Click Open – the file name now appears is the box next to Browse
4. Click Upload
5. An Upload Summary will appear
6. Click Return and return to grade roster

If all grades are entered the Approval Status will be changed from Not Reviewed to Ready for Review. Once the status is Ready for Review the grader will not be able to make any changes. If changes need to be made before the grades are posted they can contact the appropriate college registrar’s office to have the status changed.

The College Registrars will monitor grade entry and posting. Posting is only done by OUR.

Grade Changes After Posting

Once OUR has completed the final posting process for the semester all grade changes, enrollments, drops must be done on a Manual Grade Form and processed through Quick Enroll or Enrollment Request pages.

Grading Calendar

Last Day of Classes	May 3
First Day of Grading	May 8
First Day of Exams	May 8
First Post to PS	May 12
Last Day of Exams	May 16
All Senior grades must be submitted no later than May 21.	Your college may have an earlier date. Please check with your College Registrar. AS: May 19 EN: May 20 by noon
All grades must be submitted by May 29.	Your College may have an earlier date. Please check with your College Registrar. EN: May 27 by 4:30 pm

Contact Information

For problems with entering grades or grading policy questions, contact your local College Registrar.

Please direct questions or feedback for the University Registrar via email to: David S. Yeh, Assistant Vice President and University Registrar.