How do I prepare my marks spreadsheet for submission to Student Records Service? (Summary guidance)
Policy
Module Leaders must collate all marks for their module and clearly indicate the marks for each task identifying the tasks and the weightings as per the module descriptor. All task marks must be submitted out of 100 and not pre-weighted according to the task weighting.
Complete sets of internally moderated marks must be submitted on a spreadsheet to Student Records Service by the marks submission deadline. The spreadsheet must be in Excel format, and it is recommended that the spreadsheet is downloaded from the Grade Centre in Blackboard .
This guide provides a summary of the information that Student Records Service require in the marks spreadsheet. There is also a more comprehensive guide that includes detailed step by step instructions and the support available.
This guidance was updated on 13 September 2018.
What information do I need to provide?
Ensure only the following columns and information is 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 if all columns were visible at the time of download.
- 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. Subtask marks should be aggregated and calculated at the task level before returning to Student Administration.
Check and correct student marks as follows:
| Category | Information required |
| In Module Retrieval Mark | Cap at the minimum pass mark in the relevant cell of the mark column |
| Student has submitted late but within 24 hours of the deadline | Cap at the minimum pass mark in the relevant cell of the mark column |
| Student has attempted, but not passed | Enter a mark between 1-100. Zero will be treated as a non submission |
| Non-submission of coursework / Non-attendance at examinations |
Where zero is entered as the result of a non-submission or non-attendance, either:
|
| No marks / Missing marks |
Where there are missing marks, an explanation of why they are missing is required, by either:
|
| Extensions (Marks not yet due) |
If marks are coming in later for students with extensions, make this clear by either:
|
Above: Example of a set of internally moderated marks ready to be emailed to Student Records Service
Submitting marks for students with extensions
If marks are subsequently being submitted for students with extensions, you should re-use the marks spreadsheet previously saved that was submitted to Student Records Service. Replace the text ‘extension given’ with the relevant mark for each student with extension and highlight the entire row(s) in yellow. Make it clear in the body of the email that the marks being submitted now are for students with extensions.
Above: Example of a set of internally moderated marks highlighting those for students with extensions
Follow on actions that are completed by Student Records Service Teams
Once your marks spreadsheet has been received, Student Records Service will:
- Enter marks against module records in SITS
- Complete data quality checks in relation to student module outcomes including the application of outputs from ancillary processes such as Extenuating Circumstances Panels and Academic Misconduct Panels to student module results
- Calculate progression outcomes and compensation for students in preparation for the DAB
- Calculate awards for students in preparation for the DAB
- Produce and publish reports for modules and courses to enable Review of Reports meetings to be held and in preparation for the DAB. Please note: on receipt of these reports Module Leaders are NOT expected to complete a line by line check of the module data as this is checked for transcription errors on input, however if any issues are identified please contact your Academic Administrator