Results Processing Utility Tool (RPUT)

The Results Processing Utility Tool (RPUT) transfers student marks and grades from the Gradebook to Student Management.

Please note: These instructions are specific to Student Administration Services (SAS) teams.

Installation

Open the IDS Support Portal from your desktop shortcut or Start Menu
Select Install Software
Select Results Processing Utility Tool from the list. Make sure the version number is 1.2.2
Click Install

Check your version: Version 1.2.2 includes updates that check for common gradebook issues. Please update to the latest version.

Using the tool

Export the gradebook and the Fail or holding grade column from FLO. It should be a .csv file. If you are exporting a cross-listed (shared) topic, first filter for the relevant section.

When checking the Gradebook, you may find it useful to:

- Move the Total column to the front of the Gradebook
- Drag the Override column (if used) to the front of the Gradebook
- Move the Fail or Holding grade column nearer to the Total column

Note: This will need to be done for each site. This will not affect the order for other users and will not affect the order of columns in the exported .csv file.

The exported file will have many more columns than in FLO. For each assignment group, and for the final score and final grade column, the export will have four columns – Current, Unposted current, Final and Unposted final. RPUT uses the Unposted Final column.

Export the Topic Results Sheet from Student Management. This should also be a .csv file.
Drag and drop both files onto the main window.

The tool transfers grades and marks from the FLO Gradebook into Student Management’s Topic Results Sheet based on the following set of rules:

Student data

RPUT matches students in each document using their student ID number. In the exported FLO gradebook file, the student ID number column is called Integration ID.

Fail or Holding Grade

When you export the Gradebook, FLO will convert the letters in the Fail or Holding Grade column to numbers. RPUT will convert them back to letters that can be read by Student Management. The numbers align to the following letters:
4 = IDA
5 = IDE
6 = SA
7 = SE
8 = I
9 = FCP
10 = F
Errors will occur if the maximum score of the Fail or Holding grade is a number other than 10.

If the maximum score is changed before grades are entered, the wrong numbers will be exported.
If the maximum score is changed after grades are entered the holding grade will be incorrect.

RPUT will check the Fail or Holding Grade column for any scores not listed above. If it finds other scores RPUT will stop running and warn you in the logs there is an issue that needs to be addressed. This will catch the most common errors, but not all possible errors.

Grades in the Gradebook’s Fail or Holding Grade column are mapped to the Topic Result Sheet’s Grade column.

Final grade

RPUT will not update grades already recorded in the Topic Results Sheet. Changes to existing grades must be done manually.
Students with no mark in the Gradebook are left as-is.
RPUT will check that the Unposted Current Score and Unposted Final Score for each student matches. If a pair of scores do not match, RPUT will stop running and warn you in the logs there is an issue that needs to be addressed.
RPUT will round scores with decimal places to the nearest whole number (assuming the Unposted Current Score and Unposted Final Score for each student matches).
Marks in the Override column (if enabled) will override marks in the Unposted Final Score column. Marks with decimal places are rounded to the nearest whole number.
If a student has both a Fail or Holding grade and a mark in the Override column, RPUT will stop running and warn you in the logs there is an issue that needs to be addressed.

RPUT will create a folder called PROCESSED inside the folder containing the original Topic Results Sheet. This folder will contain two files:

- A new Topic Results Sheet with Grade and Mark columns containing the data transferred from the Gradebook. The new file will have _PROCESSED added to the file. This file is a .csv file.
- A log file recording decisions the tool made during processing, plus a summary of the result. This will also have _PROCESSED added to the file name. The file is a .log file.