How do I prepare my marks spreadsheet for submission to Student Administration? (Full guidance)
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 Administration by the marks submission deadline. The spreadsheet must be in Excel format, adhering to requirements set out in Stage 2 (below), and it is recommended that the spreadsheet is downloaded from the Grade Centre in Blackboard.
This guide provides a detailed breakdown of each stage involved in preparing, downloading and formatting the spreadsheet with the information that Student Administration require in the marks spreadsheet. There is also a guide that provides a summary of the information that Student Administration require in the marks spreadsheet.
Stage 1: Prepare and download Grade Centre
Step 1: From the Control Panel, click to expand Grade Centre then select Full Grade Centre.
Step 2 (a): In Full Grade Centre, ensure that the following columns are visible at the left of the Grade Centre spreadsheet, and in the order of, Last Name, First Name, Student ID.
If any of these columns are not visible (or not in order), you can make them visible (or re-order them) by clicking on the Manage tab and selecting Column Organisation.
In this view you can select hidden columns (e.g. Student ID) and make them visible by clicking on Show/Hide and choosing Show Selected Columns, and/or use the cross-hair to drag the columns to the correct order. Click Submit to save changes.
Step 2(b): For users of Blackboard-generated grading schemas only. SITS requires numerical marks. A simple way of converting grades back to their numerical equivalent is to create a weighted column linked to the column containing the grades. Note: This step only supports those schemas generated in Blackboard. If you manually typed grades into a text-only column, you will need to create a new grade column that is hidden from students and type in the numerical equivalent manually.
In Full Grade Centre, click the Create Weighted Column tab and select Weighted Column.
In Column Name enter the task number and weighting.
Ensure Primary Display is set to Percentage.
Select the name of the column currently containing the grades and click the forward arrow to move it across to the Selected Columns area.
Enter the weight percentage as 100 for the selected column and ensure Calculate as Running Total is set to No.
Ensure that Show this Column to Students is set to No.
No other settings need to be changed or checked. Click Submit.
A new column that is hidden from students will appear automatically displaying the numerical equivalent of the grades.
Your Grade Centre is now ready to download.
Step 3: To download your Grade Centre, click Upload/Download and select Download.
Step 4: On the Download Grades page, ensure that Full Grade Centre is selected against Select Data to Download and click Submit. You do not need to change any other options on this page.
Step 5: On the next screen you will see a confirmation that the data has been saved to a file. Click the Download button.
Step 6 (a): For Internet Explorer users: When prompted, click Open and Excel will launch.
Step 6 (b): For Chrome users: When prompted, choose a location to save the file to and click Save. Either open the file from the saved location or the prompt that appears in the bottom left of the screen.
Step 6 (c): For Safari users: Open the file from the Downloads folder.
Step 6 (d): For Firefox users: When prompted, click Open with Excel.
Before the file opens, you will see a prompt that your file is in a different format than specified by the file extension. Click Yes to open the file now.
Step 7: You will see a spreadsheet version of your Grade Centre. Save this file to a local drive. You will see a warning that the file may contain features that are not compatible with Unicode Text. Click No. This will automatically prompt you to save the file in Excel format. By not renaming the file, it will automatically contain the module code.
Above: Downloaded Grade Centre example 1 containing individual marks for tasks and an overall weighted mark for the module
Above: Downloaded Grade Centre example 2 spreadsheet containing both individual and aggregated marks for subtasks, and an overall weighted mark for the module
Stage 2: Prepare your marks spreadsheet for Student Administration
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. (Select the top row, right-click and select Insert).
- 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. Subtask marks should be aggregated and calculated at the task level before returning to student admin – individual subtask marks should not be returned.
Above: Downloaded Grade Centre example 1 with tasks correctly named with weighting information and in the correct order
Step 9: Delete all other columns (e.g. student usercode, last accessed, availability, calculated columns not at the task level, columns containing non-numerical marks, subtask and formative mark columns, and columns containing non-assessment information).
Above: Downloaded Grade Centre example 2 with aggregated subtask marks correctly named at the task level with weighting information and in the correct order, and all individual subtask information removed
Step 10: Check and correct student marks as follows:
|In Module Retrieval Mark||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: Downloaded Grade Centre example 1 showing zero marks for non-submission replaced with the letters NS and 'Extension given' to identify where a mark is not yet due
Step 11: Save the file to a local drive. Your marks spreadsheet is ready to send to Student Administration.
Stage 3: Submitting marks for students with extensions
Step 12: If marks are being submitted for students with extensions, you should re-use the marks spreadsheet created during Stage 2. Open the file saved in Step 11.
Step 13: Replace the text ‘extension given’ with the relevant mark for each student with extension and highlight the entire row(s) in yellow.
Above: Downloaded Grade Centre example 1 updated to show the mark given for the student with an extension and the entire row for the student highlighted in yellow.
Step 14: Save the file. Your updated marks spreadsheet is ready to send to Student Administration. Make it clear in the body of the email that the marks being submitted now are for students with extensions.
Stage 4: Follow on actions that are completed by Student Administration Teams:
Once your marks spreadsheet has been received, Student Administration 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 Student Administrator