This article explains how faculty and staff can import final grades to Student Admin (PeopleSoft).
There are two ways to send grades from HuskyCT to Student Admin (PeopleSoft). If you have your grades set up and ready to go in your HuskyCT course, one option is to use the "Grade Approval and Transfer" feature found under the "Manage" menu in the Full Grade Center. This is usually the easiest method if you already have your grades recorded in your HuskyCT Grade Center. Please review the instructions linked here for that information.
The other option involves downloading your Grade Center as an Excel file, making some modifications to that file, and then uploading that file into your Student Admin (PeopleSoft) grade roster. Those instructions are outlined below.
Download and Import a Grade Center Excel File
Step 1: Select Letter Grade as your Primary Display
Go to the Full Grade Center.
Click on the drop-down menu at the top of your final grade column.
Select Edit Column Information.
Next to Primary Display, select Letter. Click Submit.
Step 2: Download Grades
- In the Full Grade Center, click on Work Offline at the upper right, and then on Download.
- Change the setting under “Data” to Selected Column. Choose the column in the Grade Center that contains final letter grades and select Comma as the delimiter type. Then select My Computer as the Location.
- Use Excel to open the .CSV file downloaded from HuskyCT. Remove all columns except for Username and the column with the course grades.
- Add two new columns to the left of the column that contains the NetIDs.
- Enter the term code (e.g., 1148 for Fall 2014) in just Row 2 of Column A as shown here.
- Name the first column “Term” and the second column “Class Number”. The order of the data columns is a requirement. The header names can vary.
- Enter the class number for your course section in just Row 2 of Column B.
When saving the edited file, it must remain a CSV file. Excel may ask you to confirm that you wish to keep the file in CSV format. Click Yes.
Step 3: Import Grades to Student Admin (PeopleSoft)
- Go to https://studentadmin.uconn.edu/
- Click on Self Service and then on Faculty Center.
- Click on the icon (shown below) to access the grade roster.
- Click on Upload Grades.
- Click on the Browse button and select the file needed to upload. After the file appears in the text box next to browse, click Upload.
NOTE: Once the grades have been uploaded you will need to complete the usual review, save, and approve process. Please contact the Office of the Registrar (860-486-3331; registrar@uconn.edu) for questions regarding the recording of grades.
Still need help?
For further information or assistance with HuskyCT, please contact the Educational Technology Office at edtech@uconn.edu or 860-486-5052.
Related Articles