Preparing to import grades to PeopleSoft from CourseWeb

Please note: As of 5/29/19, the ability to import grades to PeopleSoft from CourseWeb has been temporarily disabled due to an identified security vulnerability. We will return this service to operation once a bug fix is applied. Please call LMS Support and Consulting with any questions at 412-648-2832.

 

Before you can import grades from Blackboard (CourseWeb) into PeopleSoft, you need to take a few steps from within Blackboard to ensure that the grades will import successfully.  We will walk you through these steps below, but first there are a few things to consider:

  • For Fall 2017 and Spring 2018, the only grades that can be transferred are those that align to the standard letter grade schema. In Summer 2018 you will be able to add your own schemas, and some additional grading schemas: H/S/U and S/NC will be added to courses by default in Fall 2018.
  • There is a default grading schema already in Blackboard, however this schema may or may not correspond to the letter grading schema for your course or department. This is something that you will want to check manually.
  • Only grades from a single External Grade column with this grading schema selected will import into PeopleSoft. By default this External Grade column is currently set to the Total column, which is not using the letter grading schema by default. You will need to alter this column, or designate a new column as the External Grade

If you want to proceed with setting up your grades in Blackboard you’ll need to follow these steps:

  1. You will first want to decide if you want to have Blackboard calculate your final grades for you, or if you’ll want to enter them manually.
  2. If you are going to have Blackboard calculate your grades for you, and automatically apply letter grades you’ll want to check the underlying details of the letter grade schema. To do this, navigate to your full grade center.

Next hover over the “Manage” tab and select “Grade Schemas”.

On the next page, you can choose to “Create Grading Schema” to add the H/S/U or S/NC Schemas to your course. For standard letter grades: hover over “Letter”, click the chevron icon () and select “edit”.

Here you can review the percentages and their associated letter grades, and also make any adjustments to this schema so that it matches yours. If you are adding a new schema, simply name it appropriately (e.g. H/S/U or S/NC) and set the percentage ranges to your desired grade result. When you are finished, click “Submit” to save any changes.

The official University of Pittsburgh schema mappings for both H/S/U and S/NC are shown below.

H/S/U:

S/NC:

If you wish to use the existing Total column you will want to change the primary display from Score to Letter. To do this, click the chevron icon next to the column name. () From the drop-down menu that appears, select “Edit Column Information.”

On the edit column information page, read down until you find “Primary Display” and its drop down menu.

From the drop down menu, select “Letter.”

Scroll to the bottom of the page and click “Submit.” You have now changed your total column to use the letter grade schema.

If you want to use a new column, you’ll need to create it first and then designate it as your External Grade column. To use Blackboard’s built in calculations you will want to create a calculated column. Steps to create calculated columns can be found in our Knowledge Base article here. If you want to simply enter letter grades manually, you can create a basic column. If you wish to designate a different column as the External Grade Column, follow these steps:

  1. Click the chevron icon () for the column that is to be designatedas the External Grade Column to reveal the drop down menu
  2. From the drop-down menu that appears, select Set as External Grade

Once these steps have been completed, the green check mark will be assigned to this column, confirming that it is the External Grade column.

Once you’ve confirmed that everything looks good in the Blackboard, it is time to head over to PeopleSoft to begin the grade import. Steps to follow in PeopleSoft can be found on the registrar’s website here, starting on page 6.