Electronic Submission of Grades
In order to add, change, or submit a student's grade, follow the steps below:
|
Step |
Action |
Result |
||||||||
|
1. |
Using your internet browser, |
Your My UW Madison page displays. |
||||||||
|
2. |
In My UW Madison, |
The Academic page displays. |
||||||||
|
3. |
Click on Faculty Center. |
The Faculty Center opens in a new window. |
||||||||
|
|
Key |
|||||||||
|
4. |
Select the Term which needs grade entry. |
The Select Term displays selected term. |
||||||||
|
5. |
Click the Class section Grade
Roster icon For combined sections, if you'd rather see
the aggregate grade roster, click the XL-MW Grade Roster icon |
|||||||||
|
|
Tips: (Grade Roster)
|
|||||||||
|
|
Tip: (XL-MW Grade Roster) [Submit] button is at the bottom of the page. Use to Submit to
Registrar.
|
|||||||||
|
6. |
To enter or update student grades, follow the steps below:
Tip: You can use the Export and Import feature to enter grades in Excel. |
|||||||||
|
7. |
Once final grades are entered for every student in the section and you are ready to submit grades to the Registrar's Office for posting: a. On Grade Roster,
select b. Click [Save]. |
The grade roster status changes to Tip: To print your grade roster, click the [Printer Friendly Version] button, then use your browser's print feature (>File >Print). |
||||||||
|
8. |
If you need to enter grades for additional classes, click [Return]. |
The Faculty Center page displays. |
||||||||
|
9. |
When finished, save your work, then click 'Sign out'. |
You will receive a message saying |
||||||||
|
10. |
Close your Internet browser. |
The browser session you were using is closed. |
||||||||
You can export a course section's grade roster into Excel as a comma separated file (csv) and then enter students' grades. Exporting is useful for grade entry on very large sections.
In order to enter students' grades from the grade roster in Excel, follow the steps below:
|
Step |
Action |
Result |
|
1. |
The File Download dialog box displays. Tip: If Export does nothing, change a browser setting. In IE: Select >Tools >Internet Options; Click Security tab; select 'Internet' icon; Click [Custom Level]; under Downloads level find 'Automatic prompting for file downloads' and click 'Enable' |
|
|
2. |
Click [Save] on the File Download dialog box. |
The Save As dialog box opens. |
|
3. |
In the Save As dialog box:
|
The file saves. Note: The Excel spreadsheet must be saved in the .csv file format.
|
|
4. |
If a Download Complete dialog box displays, click [Close]. |
|
|
5. |
Open Excel. |
Excel opens. |
|
6. |
Open the .csv file you just saved. |
Your file opens in Excel. Tip: From the Open
dialog box in the Files of Type field, |
|
7. |
Enter the Grade for each student in the Grade Input column. |
The Grade Input displays the correct grade for each student. |
|
8. |
Save the file, making sure to keep it a .csv file. (>File >Save) |
The file saves. |
|
9. |
If you get asked if you want to keep the file in the Comma Delimited format, click [Yes]. |
The spreadsheet displays and is saved in Excel. |
|
10. |
Close the spreadsheet file. |
A dialog box displays asking if you want to save... |
After exporting the grade roster, entering grades, saving, and closing the file, you can then import the grades back into the Grade Roster page.
Note: The import is only available if the grade roster has not been posted.
To import the students' grades from the exported spreadsheet, follow the steps below:
|
Step |
Action |
|
1. |
Login to My UW Madison, http://my.wisc.edu/. |
|
2. |
Click the [Academic] tab. |
|
3. |
Click on Faculty Center . |
|
4. |
Select the Term which needs grade entry. |
|
5. |
Select the class section which needs grade entry using
the same grade roster you exported using the Grade Roster |
|
6. |
With the Grade Roster page displayed, click the [Import]
button, |
|
7. |
From the file upload window, click [Browse] to find your saved file. |
|
8. |
From the Choose File dialog box, select and Open the .csv file you saved. |
|
9. |
From the file upload window, click [Upload]. |
|
10. |
From the Grade Roster page, click [Save]. Notes:
|
|
11. |
When all grades for this section are entered, submit grades to the Registrar's Office for posting: a. Change the grade roster status to 'Submit to Registrar'. b. Click [Save]. |
|
12. |
If you need to enter grades for additional classes, click Return. |
|
13. |
When finished, save your work, then click 'Sign out' in the upper right-hand corner. |
|
14. |
Close your Internet browser. |
Important Note:
You must only import the .csv spreadsheet that was saved from the export feature from the grade roster. Every field must match exactly!
Do: Delete the saved .csv files after you have imported them ~ especially if public kiosk used.





