• Services
  • Active Directory
  • Classroom Technology
  • Computer Repair & Support
  • Computing & Development Services
  • Data Storage
  • Email
  • Network Access
  • Printing
  • Software
  • Telephone Services
  • Training & Workshops
  • UMD Google Apps
  • Virus & Security
  • Web Services
• Facilities
  • Classrooms
  • Multimedia Hub
  • Student Computing Labs
  • TechCenter
  • Viz Lab
• Help

• Faculty & Staff
• Students

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

• Please be aware of the "Last Date of Participation" requirement for students with a "F" or "N."
• Compare the student list in the program you use to manage grades against the current official roster. Make corrections as necessary. Often students will have dropped without informing you.
• Make sure everyone in your list has a student ID number and that it is correct.
• Make sure you upload the correct file.
• Make sure you type in grades that are acceptable to the Registrar (e.g., no A+ or D-).

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 Trish 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

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 have questions or problems please contact:

Trish Crace (tcrace, 8843), Amanda Evans (amevans, 7680) or Bruce Reeves (breeves, 6831)

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