University of Minnesota Duluth
 
 
Search | People | Departments
Information Technology Systems and Services.
ITSS home

Instructions for Exporting Files for Web Grade Entry

The following sections give instructions for exporting from the programs most commonly used for in-progress grade management at UMD. The online tutorial (How Do I Upload?) gives some very good general instructions.

General Tips to Ensure Success

eGradebook

To CREATE a gradebook:

  1. Go to eGradebook
  2. Enter your authentication information
  3. Click on "Create a Gradebook"
    1. pick from the list of classes you are teaching. If your class is not listed please email egb_help@d.umn.edu with the Course Designator, Number and Section (e.g., ITSS 1000 001).
    2. click on "Create Gradebook"
  1. Create grade categories
  2. Create assignments
  3. If Kathy is entering grades and you would like her to add/update grades, please enter her as an "Owner-designate" in "Access Rights" (Internet ID: tcrace)

To EXPORT Final Grades:

  1. Select the appropriate gradebook
  2. Click on "Reports"
  3. Go to bottom of the page
  4. Click on "Export Final Grades"
  5. Save the file to your personal computer – pay attention to where you save the file

Moodle

After "The Upgrade" happens this coming February 2015, the Moodle grade book will be able to send grades directly to the Registrar. For this semester, please use the instructions at "Moodle 2.6: Export Grades for Import to PeopleSoft."

Submitting Grades to the Registrar

  1. Go to Online Grading Resources
  2. Click on "Submit final grades"
  3. Enter your authentication information
  4. Select Term
  5. Select Class
  6. Click on "Upload"
  7. Clcik on "Browse"
  8. Look for the class file you saved from eGradebook on your computer
  9. Choose the file (click on OK in the information box that comes up)
  10. Click on "Upload"
  11. Verify the grades are correct. If you do not see any grades (this is a known issue with the twin cities Registrar):
    1. Click "Save"
    2. Click "Select a Different Class"
    3. Choose the same class you just uploaded
    4. Your grades should now appear
  12. For any "F" or "N" please enter the "Last Date of Participation"
  13. Scroll to bottom of page
  14. Click on "Submit to Registrar"
  15. Securely delete the eGradebook file from your computer

If you encounter problems with the Web Grades system, please contact the Student Records Training Team at 612-625-2803 or srhelp@umn.edu.

Excel

Before "exporting" from an Excel spreadsheet, you will need to have created a file that has only the required information: student ID numbers and corresponding letter grades.

To save that file in the proper format:

  1. From the "File" menu, choose "Save As..."
  2. Set the file format by choosing "Text (comma separated value)" from the drop down menu in the "Format" field (Mac OS) or the "Save as type" field (Windows)
  3. Name the file and save it in a location you can readily find later. You might consider naming the file using the class alias and placing it on your desktop to make it easy to locate the appropriate file during the upload process

© 2014 University of Minnesota Duluth
The University of Minnesota is an equal opportunity educator and employer.
Last modified on 12/02/14 08:43 AM
University of Minnesota Campuses
Crookston | Duluth | Morris
Rochester | Twin Cities | Other Locations