Upload Grades to SI-net via SI-net merge tool

Introduction

The marks spreadsheet you can download from the Grade centre cannot be directly uploaded to SI-net as it is not in the required format. Furthermore, marks from the Grade Centre spreadsheet cannot be copied and pasted into a SI-net course list, as students are listed in a slightly different order.

Steps

To upload grades to SI-net from the Blackboard Grade Centre you need to:

1. Download your course list from SI-net.
2. Use the Blackboard SI-net Merge tool to create a spreadsheet with a SI-net compatible version of your grade centre content.
3. Move (using a formula) the final student marks and grades to correct SI-net column OR
   calculate the final mark and grade in the correct SI-net column.
4. Keep a copy of this working file, then reduce it down to a grades spreadsheet containing only the two columns required by SI-net.
5. Upload your grades spreadsheet to SI-net.

How to download your course list from SI-net

To obtain a file into which to enter students’ grades follow the steps in the mySI-net Guide for Staff,

1. Grade Upload
2. Download a Class List

How to use the Blackboard SI-net Merge tool

To merge the marks from Blackboard’s Grade Centre into your previously downloaded SI-net spreadsheet:

1. From the Control Panel select Course Tools > SI-net Merge.

2. Click on the Browse button.
3. Browse to, and open your previously downloaded SI-net spreadsheet.
4. Click on the Submit button.

5. Wait for the file to process.

6. A merged class list file will be automatically downloaded to your computer. 

Tip: This file will usually be downloaded automatically by your browser to a folder called Downloads.

Calculate final student marks and grades

1. Open the new merged SI-net spreadsheet.
2. The marks from Grade Centre will have been copied into the spreadsheet.
3. Calculate your final grade and copy this into column B, do not replace any grades listed as K, W or SP.

Note: The spreadsheet cannot contain formulas when it is uploaded to SI-net. If you used any formulas you will need to copy the column with the formula and paste it back into the column using the paste + values option.

Note: Save this working file as a record of all of your calculations (with a different name).

4. Delete all of the marks columns that came from Grade Centre.

Tip: These are found from Column M onwards.

5. Save the grades spreadsheet.

Warning: You might receive a warning dialogue box because the format you are saving in is a .CSV, if so click on the Yes button.

Upload your grades spreadsheet to SI-net

Contact one of the SI-net Expert Users in your School or Faculty for assistance on how to complete the grade upload to Si-net.