Learn@Illinois Moodle - Exporting Final Grades for Banner Upload

Learn how to use Moodle to easily export final letter grades. Moodle provides a downloadable file that includes only UINs and final letter grades which can be uploaded in Banner.

For a permanent link to this information, please use: http://go.illinois.edu/MoodleBannerGrades

Make Sure the Grades are Correct

ATLAS-TLT offers complementary gradebook consultations M-F 9-5 to help you make sure that your gradebook is calculating the way that you want it to. Email us at atlas-tlt@illinois.edu for an email consultation or to schedule an appointment. You might also visit the Making Sure the Gradebook is Ready for Entering Final Scores help page.

Make Sure the Scale is Correct

By default, the settings in Moodle correspond with the University grading scale. However, it is a good idea to check the letter grade boundaries in your Moodle course site to verify that the letter grade distribution for final grades is on par with your expectations.
  1. Click on Grades.
    Click grades
  2. Click Grader report to expand drop-down menu and select Grade letters. This is how students' letter grades are determined based on their score in your course.
    Select Grade letters from drop-down menu
  3. Review the letters and edit as necessary.
    Grade letters scale

Export an Excel File with your Moodle Grades

  1. Click on Grade letters and select Export.
    Select Export from drop-down menu
  2. In the "Export as" drop-down menu, select UI Text Export.
    Select UI Text Export from drop-down
  3. Under "Options", click on the button labeled Banner Mass Grade Entry. This will make all of the default settings compatible with the Registrar's upload process. Specifically, it will exclude the header row, and provide only the students' UIN and final grade.
    Note: If you are using a manual grade item for the total final grade instead of the system total, expand the "Grade items to be included" heading, uncheck "Course total" (at the very bottom) and check the manual grade item that contains the course total calculation you are using.
    Banner Mass Grade Entry Button and settings below
  4. Scroll down and click Download.
    Select download
  5. Save and open the Excel file. Select the data and copy it.
  6. In the Banner interface, paste the data copied from Excel into the text box. Click Load Grades.
    Note: It should appear with tabs separating the UINs and the grades instead of commas.
    Note: See the Office of the Registrar's page on Final Grade Entry for more information.
    Box to paste data in Banner
  7. Now when you scroll up, you should see the correct grades appearing in the drop-downs for each student. You will need to enter the “Last Attend Date” for students with an “F” or “U,” and press Submit to finalize.

Related Topics

KeywordsMass Grade Entry, UI Text Export, BMGET, letter grades, email, boost   Doc ID71823
OwnerATLAS-TLTGroupUniversity of Illinois LAS
Created2017-03-17 12:34:27Updated2023-03-09 16:51:13
SitesUniversity of Illinois Liberal Arts and Sciences
Feedback  0   0