Faculty Grade Entry

We do not recommend using a mobile device to access Faculty Grade Entry as it appears the import/export feature is unavailable as well as the column headers from the grading roster are missing.

Follow these steps to submit midterm or final grades:

  • Select the Midterm Grades or Final Grades tab above the list of courses. The default is set to open on the Faculty Grades tab.
    • Clicking on any column header will sort the list ascending or descending depending on the number of times you click the header label.
  • Select a course from the My Courses list of by clicking in the row. This will only show gradable sections.
  • After selecting a course, the list of students that require grades will display below the course list.
  • Again, clicking on any column header will sort the list ascending or descending depending on the number of times you click the header label. This may be useful after entering grades to sort the list by grades entered to find students still with grades not entered or to sort by actual grades assigned.
  • Grades can be assigned to an individual student by using the dropdown box or by typing in the respective letter grade. Only applicable grades can be entered or selected in this field.
    • Instructors that wish to enter midterm or final grades for multiple students can use the “Import/Export” feature.
  • For Final Grades, the last date of attendance is required for “F” grades and should be entered for withdrawals. Last date of attendance can be typed or selected via the calendar icon.
  • Be sure to select the “Save” button at the bottom of the class list to submit the final grades that have been entered.
  • After saving, the green success message or red failure message in the upper right corner of the screen appears. In addition, the Grading Status in the My Courses list will change to In Progress or Completed.
    • Once the Grading Status for a course changes to Completed, the course is entirely graded. However, you can still make changes to grades that have not been rolled.
  • Repeat these steps for each section that requires midterm grades to be entered.

Import/Export Feature

Follow the instructions below to use the new mass grade entry tool:

  • Click on the gear/cog icon in the top-ride side of the page, then click on Export from the drop-down menu that appears.
  • From “Export files as” click the radio button next to the Excel file type you prefer (.xls or .xlsx).
  • Select the Export button.
  • Save the file to a secure location, as this is non-directory information about students.
  • The exported spreadsheet will have the correct column titles needed for using the Import feature.
  • Enter the grade for each student on the spreadsheet and save when complete. Note: For Final Grades, F grades must be accompanied by last date of attendance in MM/DD/YYYY in the spreadsheet. Do not change any values in the spreadsheet other than final grade, last date of attendance, or Hours Attended.
    • Example of final grading spreadsheet:
  • Click on the gear/cog icon in the top-ride side of the page, then click on Import from the drop-down menu that appears.
  • Click inside the Browse field to open your file manager.
  • Select the graded file.
  • Click the Upload button.
  • Once the blue ribbon no longer says “Preparing,” click Continue.
  • You will then be shown a preview of the spreadsheet you uploaded. If the file is ok, click Continue.
  • If you made no changes to the column titles on the exported spreadsheet, the Map Columns will not need anything changed. Select Continue.
  • If you made changes or did not use the Export feature, then you need to map each column to the required data elements.
    • Required data elements are:
      • Term code
      • CRN
      • Student UIN- map column to Student ID
      • Midterm Grade or Final Grade
        • For Final Grades- If you have any failing grades (F or U) in your spreadsheet, a last date of attendance is required.
    • When you have mapped your spreadsheet to the required data elements, those columns turn green.
    • Click Continue.
  • The next page will give you an overview of what will be imported and any errors that will cause a grade to not be imported.
    • For example, if you assign an F or U but do not include a Last Attend Date, then the grade will not import to the roster.
  • Once you’ve reviewed the import information, click Continue.
  • Click Finish.
  • If there were no errors upon import, the Grading Status will show as Completed.
  • If there were errors on import or a grade was purposely left blank, then the Grading Status will show as In Progress.
  • If you need to submit previously blank grades or make changes to already submitted grades, be sure to do so before Final Grade Entry closes. Click Save at the bottom-right of the screen to submit any updates.

Please contact the Academic Records Unit within the Office of the Registrar at record-info@illinois.edu or 217-333-9774, if you have any questions or require assistance.