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

• Compare the student list in the program you use to manage grades against the current official roster. Make corrections as necessary - most commonly, 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 try to upload the correct file
• Make sure you type in grades that are acceptable by the Registrar

eGradebook

To CREATE A gradebook:

1. Go to UMD home page
2. Enter url (http://www.d.umn.edu/egradebook) authenticate to your computer account:
3. Click on "Create a Gradebook"
   a. pick from the list of classes listed which you are teaching (if your class is not there please talk with your secretary)
   b. click on "Create Gradebook" at the bottom of the page
4. Create categories (i.e. Exams - which would include all of your exams and final). Hit the add button and fill in information and then hit add (weights can be changed).
5. Create assignments (i.e. Exam 1, Exam 2, Extra Credit, Final) Use the pull down menu to pick Which category.
6. If Spring is entering grades and you would like her to add/update grades, please enter her as an "Owner-designate" in the access section. Internet ID: sbilliar (click on add) Click on all 3 to the right and hit submit.

TO EXPORT FINAL GRADES:

1. Select the appropriate gradebook (when all is well and done and you are happy with the grades entered) If you make changes, wait for the update to finish before moving on to next step.
2. Click on reports (at top of gradebook selections) Go to bottom of file and click on "EXPORT FINAL GRADES"
3. In the dialogue box, choose "Save" to start saving the file to your personal computer.
4. Choose where to save the file and what name to use. Try using the class alias and place it on your desk top for easy access during the upload process. This file is in comma separated value format and
   should be named with ".csv" at the end (i.e. psy1003.csv)
5. Go to UMD homepage: click on FACULTY STAFF
6. Click on SUBMITTING GRADES TO WEB.
7. Click on SUBMIT FINAL GRADES
   Select Term, Select Class
8. Login into your email account
9. Select Term and then Select Class
10. Browse (look for the class file name you used ie. psy1003.csv (which is the file saved on your hard drive) Click on that file (click on OK in the information box that comes up) CLICK ON UPLOAD
11. Check to see if grades came across
12. Scroll to bottom of page and click on 'SUBMIT TO REGISTRAR'
    1. A message will come back saying ## of grades for ## students...
    2. Print out this page to keep in your files for a hard copy.

If you have questions or problems please contact:

Melissa Jokela - 8468, Bruce Reeves - 6831, Amanda Evans - 7680 or Spring Billiar - 8843.

IF YOU HAVE STUDENTS WITH ZERO IN FRONT OF THEIR id'S 0555123 You must remove them from the save filed on desktop and add them in before you send to registrar... Be sure to look up which student has the zero so you can add them into the final upload...

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