FAQ MARKSHEET ADVISORY

This document outlines common issues encountered with SRMS marksheets and provides steps for resolving them.

• MARKSHEET FORMATTING ISSUES

  • Lecturers may encounter an error indicating that the column headers in the marksheet are missing a specific column or do not match the assessment structure. In this case, the recommended solution is to re-download the marksheet and transfer any grades already entered in the previous file. This ensures you have the latest version of the marksheet, reflecting any changes made to its configuration.

  • If the lecturer receives an input error in the marksheet (e.g., “Please enter a decimal value between -”) or if formulas in the Excel file aren't working as expected, this issue has been observed primarily on Apple/Mac devices. The solution is to edit the marksheet on a Windows device or upload it to Google Sheets for adjustment.

  • If a lecturer uploads a flawed marksheet that hasn’t been submitted to the HOD and wishes to upload a corrected version, it is not necessary to remove the flawed marksheet. The system will automatically prioritize and overwrite the previous marksheet with the most recent upload.

  • When uploading any marksheet, the most recent upload will always take precedence and overwrite any grades uploaded from previous marksheets.

• ISSUES RELATED TO THE CREATION OF MARKSHEET

  • To create a marksheet, the lecturer must have a Teaching Allocation record for the course. Without this record, the course will not appear in the Marksheet interface. If you cannot see a course you expect, please contact your HOD to update your Teaching Allocations.

• COURSE GROUPS RELATES ISSUES

  • Some students who are enrolled in the class should be in the course group and appear on the corresponding marksheet, but they may not be showing up. This typically happens if the student registered for the course before the course groups were properly set up. In such cases, the lecturer or HOD will need to access the Course Groups interface and manually enroll the student in the correct course group.

• ISSUES AS A RESULT OF STUDENT REGISTRATION STATUS

  • If a student is missing from the marksheet but is visible in Moodle, the issue may be due to a registration problem. The student may have had their registration returned or did not register properly in SRMS. In this case, the student should be contacted to resolve the registration issue. If the registration period has passed, the Admissions department will need to be contacted to address the issue.

  • Sometimes, the student may have entered their name incorrectly in SRMS (e.g., placing their first name in the surname field) and this incorrect information was uploaded to Moodle. If the student later requests a name change in SRMS, this change will not automatically update in Moodle. As a result, the lecturer may be unable to assign a grade, as the marksheet requires the names to match. To resolve this, the lecturer should check the Moodle gradebook file and compare it with the class list report from SRMS. If there is a discrepancy, the name in the Moodle gradebook should be corrected to match the SRMS class list.

  • Additionally, if students are registered for a course that is offered in multiple semesters within the same academic year, the lecturer might encounter an issue when trying to upload the marksheet. They may receive an error saying that students are registered for the course but not for the selected semester. If the lecturer changes the semester for the marksheet, they may get a message saying the semester does not match the one attached to the course. In these cases, the Registry department should be contacted for further assistance.