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:
- Download your course list from SI-net.
- Use the Blackboard SI-net Merge tool to create a spreadsheet with a SI-net compatible version of your grade centre content.
- 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. - Keep a copy of this working file, then reduce it down to a grades spreadsheet containing only the two columns required by SI-net.
- 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,
- Grade Upload
- 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:
- From the Control Panel select Course Tools > SI-net Merge.
- Click on the Browse button.
- Browse to, and open your previously downloaded SI-net spreadsheet.
- Click on the Submit button.
- Wait for the file to process.
- Save the file (a spreadsheet with Grade Centre content but in SI-net format).
Calculate final student marks and grades
- Open the new SI-net spreadsheet.
- The marks from Grade Centre will have been copied into the spreadsheet.
- Enter formulas to move OR calculate the final mark and grade into columns C and B.
Note: The spreadsheet cannot contain formulas when it is uploaded to SI-net. You will need to copy any column with formulas and paste the values only back into the cells.
Note: Save this working file as a record of all of your calculations (with a different name).
- Highlight the marks in column C and then select copy.
- With the marks still highlighted, select paste > Paste Values.
- Repeat the above steps to remove the formulas from column B.
- Delete all of the marks columns that came from Grade Centre.
- Delete all other working columns that SI-net does not accept.
- Save the grades spreadsheet, (using the name of the original class list file that you downloaded from SI-net).
- If the below dialogue box is shown, 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.