Versions Compared

Key

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

This article explains covers how faculty and staff can export their midterm and instructors can transfer midterm or final grades from their a HuskyCT Grade Centers course to the Student Admin Administration System (PeopleSoft).

For Ultra Course View refer to: Sending Grades from HuskyCT to Student Admin

Note

If you are repeatedly receiving emails regarding Confirmation of Grades or an Error in Grades see Troubleshooting Grade Transfer Emails and Issues

Overview

There are two ways to send transfer letter grades from HuskyCT to Student Admin (PeopleSoft).

  1. If

...

  1. your final grade calculation column is set up

...

  1. in your HuskyCT Grade Center course,

...

  1. the easiest option is to use

...

  1. Grade Approval and Transfer

...

  1. . This can found from either the the Full Grade Center

...

  1. Manage tab or Course Management > Course Tools.

  2. Download an Excel file of your grades from

...

  1. the HuskyCT Grade Center

...

  1. , make a few modifications to that file, and then manually upload that file

...

  1. into your grade roster in Student Admin.

Instructors can choose either method , depending on what suits their purposes bestneeds. Instructors can send grades to Student Admin using either method even if they have not assigned a grade to ALL students. The only time ALL students must have an assigned grade is in the Student Admin Grade Roster, when the Approval Status selection is changed to "Approved" thereby recording the official final grades.

Note

Midterm grades should only be saved in Student Admin; the approval status should not be changed to "Approved" for midterm grades.

Method 1:

...

Using Grade Approval and Transfer

...

Step 1: Prepare your Midterm or Final Grade column:

In the Grade Center, find your midterm or final grade column and select "Edit Column Information." 

Column menu and Edit Column Information optionImage Removed

Edit the column's name to begin with "MID" or "FIN" depending on whether you are sending midterm or final grades. (This is necessary for Student Admin to be able to properly accept the grade data. If the "Column Name" field and the "Grade Center Name" field are different, the "Grade Center Name" field is the one that must be edited to begin with "MID" or "FIN.") 

...

Info

This process will also work for combined course sections.

Iframe
srchttps://cdnapisec.kaltura.com/p/2090521/sp/209052100/embedIframeJs/uiconf_id/44374591/partner_id/2090521?iframeembed=true&playerId=kaltura_player&entry_id=1_tc5i6agx&flashvars[streamerType]=auto&flashvars[localizationCode]=en&flashvars[sideBarContainer.plugin]=true&flashvars[sideBarContainer.position]=left&flashvars[sideBarContainer.clickToClose]=true&flashvars[chapters.plugin]=true&flashvars[chapters.layout]=vertical&flashvars[chapters.thumbnailRotator]=false&flashvars[streamSelector.plugin]=true&flashvars[EmbedPlayer.SpinnerTarget]=videoHolder&flashvars[dualScreen.plugin]=true&flashvars[Kaltura.addCrossoriginToIframe]=true&&wid=1_gpqarwul
width400
height285

Overview:

There are three settings which need to be set for the final grade column before grades can be transferred from HuskyCT to Student Admin.

  • The column must be set as the External Grade (indicated by a green checkmark).

  • The column name must start with “Final” or “Midterm”.

  • The column’s Primary Display must display a letter grade.

If these settings are not set, the grades will not successfully transfer to your Student Admin grade roster and you will receive and error message. See the steps below for further details.

Instructions:

  1. In the Grade Center, find the midterm or final grade column and select Edit Column Information.

    Column menu and Edit Column Information optionImage Added
  2. On the Edit Column Information page, make sure the Primary Display is set to a letter grade schema

...

  1. ; Student Admin cannot accept numerical grade values. 

Edit Column page showing Primary Display as Default LetterImage Removed

...

  1. (warning) Note: HuskyCT includes default letter grade schemas

...

  1. . However, the default letter grade schema may not

...

  1. match what instructors use in their own courses and syllabi for grading, and your letter grade schemas may be named differently than the default one.

...

  1. Also, Student Admin does not accept grades of A+, as the highest grade that can be awarded to graduate and undergraduate students is A. (See the Registrar's page on grading policies.) Instructors can check their letter grade schemas in the HuskyCT Grade Center (Grade Center > Manage > Grading Schemas) and compare

...

  1. what they include on their course's syllabus.

...

  1. Edit as necessary.

    Primary Display window showing Sample Letter Grade SchemaImage Added

    For more information about using letter grade schemas,

...

  1. see Working With Letter Grade Schemas in HuskyCT.

...

  1. Using the column's option menu, set the midterm or final grade column as the

...

  1. External Grade.

...

  1. A green checkmark in the column's header

...

  1. designates the grade

...

  1. column that will be sent over to Student Admin.

...

Column menu, set as external gradeImage Removed

Once you have named your grade column correctly, set it as the external grade, and made sure the Primary Display is showing a letter grade, your are ready to proceed to Step 2 and "push" that column to Student Admin.

Info
titleChecklist for Grade Column Preparation

To recap Step 1, your grade column must meet the following conditions:

  1. Be named correctly, e.g. begin with the letters "MID" for midterm grades or "FIN" for final grades;
  2. Display a letter grade;
  3. Be the External Grade in your HuskyCT Grade Center, as indicated by a green checkmark.

If the grade column you intend to send to Student Admin does not meet all of these conditions, your grades will not populate in your Student Admin grade roster.

Step 2: Push Your Grade Column to Student Admin:

...

  1. Column menu, set as external gradeImage Added

  2. You can access the Grade Approval and Transfer, either:

    1. From Course Tools under Course Management, select Grade Approval and Transfer

...

...

    1. Image Added

On the Grade Approval and Transfer page, check the box for your course and click "Grade Column Approval and Transfer." (Note: This process also works for combined courses, e.g., courses with multiple sections combined into one HuskyCT course.)

grade approval and transfer page, selecting course sectionImage Removed

...

    1. Or from Grade Center >> Manage >> Grade Approval and Transfer

      Image Added
  1. Check the box next to the

...

  1. course ID and then click

...

  1. Approve Grades.

...

  1. This will send the grades

...

select column and click approve gradesImage Removed

...

  1. in the External Grade column to Student Admin; it may take up to 90 minutes for the grades to appear in your roster.

    Shows the Course Grade Approval and Transfer page with the course selected and Approve Grades boxedImage Added
    1. For midterm grades,you should not change the

...

    1. Approval Status

...

    1. selection on your Student Admin grade roster.

...

Once you have completed the steps to push grades from HuskyCT to Student Admin, it may take up to 90 minutes for those grades to appear in your Student Admin Grade Roster. It is recommended that instructors check their Student Admin grade rosters 90 minutes after sending grades from HuskyCT to confirm that the process completed.

...

    1. You can leave the Approval Status at "Not Reviewed" and click Save.

    2. If you need to change a student's grade after you have already pushed your grades to Student Admin, you can

...

    1. change that grade and

...

    1. repeat Steps 4-6. This will "re-push" grades to Student Admin. You can do this

...

    1. until you change the Approval Status in Student Admin to

...

    1. Approved.

...


Step 3: Approving Grades in Student Admin (Final grades only)

...

    1. (warning) Note: Clicking Approve Grades does not finalize grade approval in the Student Admin system. For final grades, you must log in to Student Admin and complete the grade approval process for your grades to become official.

  1. For final grades only, after all grades have been populated and saved in Student Admin, change the Approval Status at the top of the page to Approved.

...

  1. If you need to change grades after doing this and re-push from HuskyCT, change the field to

...

  1. Not Reviewed.

...

  1. Approved

...

  1. or

...

  1. Ready for Review

...

  1. will prevent grade pushes.

Next, a confirmation window should appear. Click OK.

Once your final grades are approved in Student Admin, the process is complete.

...

  1. (warning) Note: Only instructors with grade approver status

...

  1. can approve rosters in Student Admin.

...

titleNeed help setting up your Grade Center?

...

  1. A confirmation window should appear. Click OK.

Method 2:

...

Downloading and

...

Importing a Grade Center Excel File

...

  1. Go to the Full Grade Center. 

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

    2. Select Edit Column Information.
      Edit Column InformationImage Modified

    3. Next to Primary Display, select

...

Step 2: Download Grades

    1. whichever Grading Schema you use. (The options you see may not be exactly as shown below. However, you must choose a letter grade display for this process because Student Admin cannot accept A+ grades.) Click Submit.

...

    1. Image Added
    2. In the Full Grade Center, click

...

    1. Work Offline at the upper right, and then

...

    1. click Download.
      Work Offline and then DownloadImage Modified

    2. Change the setting under

...

    1. Data to Selected Column.

...

    1. Choose the column in

...

    1. Grade Center that contains final letter grades and select Comma as the delimiter type. Then, select My Computer as the Location.
      Image Modified

    2. Use Excel to open the .

...

    1. csv file downloaded from HuskyCT. Remove all columns except for Username and the column with the course grades.

...

    1. open the csv file in excel and delete all columns aside from username and course gradeImage Added
    2. Add two new columns to the left of the column that contains the NetIDs.

...

    1. add two new columns all the way on the leftImage Added
    2. Name the first column

...

    1. Term and the second column

...

    1. Class Number. The order of the data columns is a requirement

...

    1. ; header names can vary

      Title Column A Term and Column B Class Number. Image Added
    2. Enter the term code (e.g., 1148 for Fall 2014) in Row 2 of Column A.

...

    1. Enter the term code in Column A, Row 2.Image Added
    2. Enter the class number for your course section in

...

    1. Row 2 of Column B.

...

Step 3: Import Grades to Student Admin (PeopleSoft)

...

    1. Enter class number in Row 2, Column B.Image Added
    2. Save the file.
      (warning) 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 Removed

    1. Click Yes to keep the CSV format if prompted.Image Added
    2. Go to studentadmin.uconn.edu

...

    1. .

    2. Click

...

    1. Self Service and then

...

    1. Faculty Center.

    2. Click on the icon

...

    1. (shown below) to access the grade roster.

...

    1. icon of single, purple person and boardImage Added
    2. Click

...

    1. Upload Grades.

...

    1. click upload gradesImage Added
    2. Click

...

    1. Browse

...

    1. , and select the file

...

    1. to upload. After the file appears in the text box next to browse, click Upload.

...

    1. browse for and select the proper file. then click upload.Image Added
Note

NOTE: Once the final grades have been uploaded, you will need to must complete the usual review, save, and approve process. Please contact Contact the Office of the Registrar at (860-) 486-3331; or registrar@uconn.edu) for  for questions regarding the recording of grades.

...

Info

For further information or assistance with HuskyCT,

...

contact the Educational Technology Office at edtech@uconn.edu or (860

...

) 486-5052.

Filter by label (Content by label)
showLabelsfalse
max

...

10
spacesIKB
showSpacefalse
sortmodified
typepage
reversetrue

...

labelsgrade center import huskyct peoplesoft student admin final midterm
cqllabel in ( "student" , "final" , "admin" , "grade" , "import" , "huskyct" , "center" , "peoplesoft" , "midterm" ) and type = "page" and space =

...

currentSpace ( )
Page Properties
hiddentrue


Related issues