Uploading grades to PeopleSoft from a spreadsheet

To upload grades, go to the Teaching tab of MyU. Select the appropriate class grade roster, then click the "grade upload" button.

Save your spreadsheet as  a .CSV file.

To save an Excel spreadsheet as a .csv file, select "Save as" from the File menu.

  • If using a PC, select “csv (comma delimited)” format
  • If using a Mac, select “Windows Comma Separated (.csv)” format.

Be sure to remove any column headings from your spreadsheet.

Note: Uploading midterm or final grades will overwrite any unofficial grades you may have previously entered. 
 

Uploading Midterm Grades

Midterm grades can only be uploaded from a file from Faculty Center. They cannot be mass uploaded from Moodle.

  • Column A must contain student ID numbers.
  • Column B must contain student grades.
  • Column C may contain the percentage of work on which the midterm grade is based. This field is not required.
  • Column D may contain the engagement (I = Intermittent, N = Never, R = Regular, U = Unknown). This field is not required.
  • Column E may contain a note to the student. This field is not required.

Leaving blank spaces for a non-required field not enter any data for that field. This will not erase or overwrite prior data.

Sample .cvs file for upload

Uploading final grades

  • Column A must contain student ID numbers.
  • Column B must contain student grades.
  • Column C must contain the last date of participation for any students receiving an F or N grade. Please use this format to enter a last date of participation: MM/DD/YYYY. Mac users may be able to omit extraneous zeroes from the date.

Sample .CSV file for upload

Additional grading resources

If you encounter errors when you attempt to enter final or supplemental grades, you may need to clear your internet cache. For best results, use Mozilla Firefox.

Support

ASR Training & Support
srhelp@umn.edu
612-625-2803

If you encounter problems when you attempt to enter grades, you may need to clear your cache or use a different or newer version browser.