Guide for Uploading Final Grades via File

Follow the steps below to upload your final grades using a file. 

Step 1: Select "Upload Final Grades"

Image of link, "Upload Final Grades"

 

Step 2: Download Sample Comma Separated File 

Sample csv file link

 

Step 3: Format File

Sample File

Do not edit the column headers on the sample file. As instructed on the sample file, delete the rows containing instructions and column descriptions (rows 3-15).

Image of Final Grade Sample file with box around rows 3-15 with text "delete rows 3-15"

 

NOTE: When using UniversityID, Format UID cells to include lead zeros (example below). 

Example: 00000000

Image of steps to format cells containing UID

ICON Export

After exporting your grades from ICON format the file before uploading to MAUI.

  • Delete Columns: Student, ID, Section, Current Points, Final Points, Current Score, Unposted Score, Unposted Final Score, Current Grade, Unposted Current Grade, Final Grade, Unposted Final Grade.
    • Keep Columns: SIS User ID or SIS Login ID, Final Score.
  • Update Column Headers:
    • SIS User ID or SIS Login ID = student
    • Final Score = grade
  • Add Column Headers:
    • status
    • date
ICON export file with all column headers and green boxes around columns to be deleted, and a blue box around student identifier columns with instructions to delete SIS User ID or SIS Login ID.

Step 4: Enter Grades and Attendance

Include the following required data:

  • student
    • Enter HawkID or UID.
  • grade
    • Enter grade earned. Refer to the course grading instruction to identify the appropriate grading scheme.

Optional data:

  • "status"
  • "date"
image of final grade data within excel file

 

Step 5: Save file as .csv or .txt

When saving the Excel file choose: CSV (Comma delimited)(*.csv) or Text (Tab delimited)(*.txt).

 

Step 6: Upload .csv or .txt file

  • Select "Choose File"
 web interface for importing grades. The page title is "Dashboard > Grade Import." There is a section labeled "Select the data file you wish to import:" with a button labeled "Choose File" and text indicating "No file chosen." Below this, there is another button labeled "Show Sample Data
  • Locate the file and select  "Open"
File explorer window showing the "Grade Upload Test File" folder with a selected file named "AFAM Test File.xlsx". Options to open or cancel are at the bottom right
  • Select "Show Sample Data"
image of "show sample data" button
  • Select "Validate Data" if sample data is correct, if sample data is incorrect select 'Reject File"
image of "Validate Data" button

 

  • Select "Import File" if validation is successful or "Reject File" if an error occurs
Image of "Import File" button

 

Step 7: Review Upload Results

  • Verify grades and attendance uploaded correctly
  • Correct errors

NOTE: Invalid grade options will not load into MAUI. Review all final grades after uploading your .csv file to ensure appropriate grades are entered.

 

Step 8: Save and Submit Grades

Select "Save and Complete Later" to save grade entries and return later to edit before submitting.

Select "Submit" when all grades are entered and ready for DEO review.

Grading system interface with options to "Save and Complete Later" and "Submit" highlighted in red. Columns for "Attendance Status" and "Last Attendance Date" are empty. "Cancel" buttons are at the top right and bottom right corners.

Have more questions? Contact Us

Person with question mark icon.
Pinned content, custom sorted.

Registrar MAUI Support

Title/Position
Reg-MAUI-Support
Assists faculty and staff with processes in MAUI under the Registrar tab, including Administrative Registration, Section Offerings, Grades and more.