Versions Compared

Version Old Version 6 New Version 7
Changes made by

Ashley Mattingly

Ashley Mattingly

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Download and Import a Grade Center Excel File

Step 1: Select Letter Grade as your Primary Display. 

...

  1. Go to the Full Grade Center. 

  2. Click on the drop-down menu at the top of your final grade column.

  3. Select Edit Column Information.

    Image Removed

    Edit Column InformationImage Added

  4. Next to Primary Display, select Letter.

     Click 

    Click Submit.

    Image Removed

    Select LetterImage Added

Step 2: Download Grades

  1. In the Full Grade Center, click on Work Offline at the upper right, and then on Download.
    Work Office and then DownloadImage Modified
  2. Change the setting under “Data” to Selected Column, choose . Choose the column in the Grade Center that contains final letter grades and select Comma as as the delimiter type, and . Then select My Computer as the Location.
    Image Modified
  3. Use Excel to open the .CSV file downloaded from HuskyCT. Remove all columns except for Username and the column with the course grades.
    Image Modified
  4. Add two new columns to the left of the column that contains the NetIDs.
    Image RemovedImage Added
  5. Enter the term code (e.g., 1148 for Fall 2014) in just Row 2 of Column A as shown here.
    Image Modified
  6. 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.
    Image Modified
  7. Enter the class number for your course section in just Row 2 of Column B.
    Image Modified
Note

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.

Image Modified

Step 3: Import Grades to Student Admin (PeopleSoft)

...

  1. Go to https://studentadmin.uconn.edu/
  2. Click on Self Service and then on Faculty Center.
  3. Click on the icon (shown below) to access the grade roster.
    Image Modified
  4. Click on “Upload Grades.”
    Image Modified
  5. Click on the Browse button and select the file needed to upload. After the file appears in the text box next to browse, click the upload button Upload.
    Image Modified
Note

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.

...