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)
1. click on "Create Gradebook"

1. Create grade categories
2. Create assignments
3. If Spring is entering grades and you would like her to add/update grades, please enter her as an "Owner-designate" in "Access Rights"
   • Internet ID: sbilliar

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:

Spring Billiar (sbilliar, 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 (tab delimited)" 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