Stage 1: Prepare and download your Gradebook
Step 1: Access Gradebook from the navigation bar.
Step 2: Ensure your marks display in Gradebook in one of the following formats.
Pass/Fail Tasks – Pass or Fail should be displayed using the University Pass/Fail schema approach. Fails will display for students who didn’t attempt the task or attempted and failed.
Note: Assessment Teams will code Fails in SITS to refer or fail depending on the assessment attempt.
Numerical Task mark – a percentage should be provided for all students.
Please note: if you display grades using a schema, e.g. to show University Grade Descriptor categories, or out of a point value not equal to 100, you will need to temporarily revert your marks to a percentage. Please note that students will see the temporary change in the display of their marks while you complete the process of downloading your Gradebook.
If you need to change your marks to display as a percentage, follow these steps:
- Ensure your Gradebook is displaying in the Marks view.
- Click on the icon above the column name and select Edit.
- Change Mark using to Percentage and select Save.
If you require support completing this step in the process, please contact Digital Learning support.
Step 3: Select the Download Gradebook button (top right of the screen).
Step 4: From the Download Marks panel, choose:
- Full Gradebook from the Mark Records section.
- Then select the assessment items you require from the Record Details section.
- Leave the File Type selected as Tab-separated (.xls).
- Leave the Save Location as My Device.
- Finally select the Download button.
Step 5: You will see a Download Complete pop-up message, and you will then be prompted to save the download of your Gradebook. Make sure you save it to a location or folder where you can easily find it.
Step 6: If you temporarily reverted your marks to a percentage in Step 2, you can now revert them back to the scheme used for original display.
Stage 2: Finalise your marks spreadsheet
Step 7: Locate and open the Excel file containing the download of your Gradebook. You will see a warning that the file format and extension of the file don’t match. You can ignore this and click Yes to open the file.
Step 8: Ensure only the following columns and information are present in the spreadsheet:
- Module code and module title. Insert a blank row at the top of the spreadsheet and type in the module code and title.
- Student last name, first name and ID. This will be automatically contained within the downloaded spreadsheet. (The spreadsheet must be sorted alphabetically by student last name).
- Task number and weighting in task order. Rename each column header to identify the relevant task number and weighting and arrange in task order as on the agreed module descriptor (access via VPN). Only task-level marks should be submitted, not individual components of tasks (e.g. elements in a portfolio).
Step 9: Delete all other columns (e.g. student usercode, last accessed, availability, calculated columns not at the task level, subtask and formative mark columns, and columns containing non-assessment information).
Step 10: Save the file.
Stage 3: Submit marks to Assessment Teams via email
Step 11: Marks should only be submitted to College Assessment Team marks inboxes once there is a full set of task marks i.e. including students who have had 5 and 10 day extensions.
College Assessment Team Marks Email Addresses:
- ! SRA BTE Assessment Marks Submission
- ! SRA HWLS Assessment Marks Submission
- ! SRA SSA Assessment Marks Submission
Note: it is expected that module marks are accurate at the point that they are transferred.