Marksheets for assessments taking place as part of the academic year should be generated using the Mark Sheet Creator task in e:Vision. If you need to generate marksheets for students taking re-assessments read the guidance below.

Which students and what assessments will be included in these marksheets?

Marksheets generated using this task will include all students taking assessments as part of the academic year.  Undergraduates being re-assessed during the academic year (i.e. after having failed in, or deferring from, IRDAP the previous year) will also be included. These marksheets are based on SAT records in SITS.

Undergraduates being re-assessed during IRDAP will be excluded. Postgraduate students taking assessments in RDAP1 and RDAP2 will not be included in marksheets generated using this task; all postgraduate students being re-assessed will be excluded. 

Any assessments where marks have already been submitted will be excluded from the marksheet. 

If you are expecting a student / assessment to appear on the marksheet but they do not please contact the SSC Student Records Team.

When to generate marksheets

The e:Vision task uses live SITS data so you should create your marksheets as late as possible to ensure that the data is as up to date as possible.

If you download the marksheet too early then it may not be fully up to date, for example deferrals may not have been processed. 

Which version of the marksheet to use

The e:Vision task allows you to generate two versions of the marksheet, either anonymous or with student email addresses included. 

• If you are sharing the marksheet with academic staff, who are marking anonymously, then you should always use the anonymous option.
• If professional services colleagues want to 'connect' the marksheet to other sources of data, for example using VLOOKUP or XLOOKUP,  you may find that the email address offers a useful value to query.

The existence of a marksheet with email addresses does not change any of the policies about anonymous marking. It is there to assist professional services colleagues in collating data into the marksheet. If you are ever in doubt about which marksheet to use always opt for the anonymous version. For guidance on when to mark anonymously please consult Instructions for Examiners. 

How to generate marksheets

The process of generating marksheets is simple and intuitive but there are some key things that you must do in order to ensure that your marksheet can be imported into SITS without error. Therefore, please ensure that you read the guidance on how to generate marksheets before generating and completing your marksheets. 

Read the guidance on generating marksheets for assessments (PDF)

You will also find helpful information displayed on screen as you work through the task. This is context specific so if you are working on undergraduate courses you will be presented with information relevant to undergraduate assessments. 

Saving marksheets as CSV files

It is vital that you save the marksheet as a CSV file before you start to complete it. If you do not do this you may not be able to re-open the file. Marksheets must also be submitted to the SSC as CSV files, if the marksheet is received in any other format it will be returned. 

You can name the file as you wish but must not use special characters such as &, £ or % as these can cause the upload to fail.  We'd suggest that you name the file using the course code and assessment period e.g. AB100 2022-3 Academic Year. 

Who can generate marksheets?

Given the data involved the number of colleagues that can generate marksheets is kept to a minimum. 

The SSC Student Records Team manage access to the marksheet creator tasks.  If access needs adding or removing the Department Manager should send an email to ssc.records@lse.ac.uk with the relevant staff member's name. 

Need help?

• If you do not have access to e:Vision at all, or if you need to reset your e:Vision password please contact ARD Systems.
• If you can access e:Vision but don't have access to the Mark Sheet Creator task please contact the SSC Student Records Team.
• If you are encountering technical difficulties generating marksheets please contact ARD Systems.
• If you need access to the Mark Sheet Creator task removing please contact the SSC Student Records Team.
• If students or assessments appear to be missing from the marksheet please contact the SSC Student Records Team.

Marksheets for re-assessments should be generated using the Marksheets for Resit & Deferred Assessment Periods task in e:Vision. If you need to generate marksheets for students taking assessments in the academic year read the guidance above.

Which students and what assessments will be included in these marksheets?

Marksheets generated using this task will include all students taking re-assessments during IRDAP, RDAP1 or RDAP2.

Students taking assessments in the academic year will not be included in any marksheets generated using this task. Undergraduates being re-assessed during the Academic Year (i.e. if they are being re-assessed after failing in, or deferring from, IRDAP) will not be included. These marksheets are based on SRA records in SITS.

Any assessments where marks have already been submitted will be excluded from the marksheet. 

If you are expecting a student / assessment to appear on the marksheet but they do not please contact the SSC Student Records Team

When to generate marksheets

The e:Vision task uses live SITS data, you should create your marksheets as late as possible to ensure that the data is as up to date as possible.

If you download the marksheet too early then it may not be fully up to date, for example deferrals may not have been processed. 

Which version of the marksheet to use

The e:Vision task allows you to generate two versions of the marksheet, either anonymous or with student email addresses included. 

• If you are sharing the marksheet with academic staff, who are marking anonymously, then you should always use the anonymous option.
• If professional services colleagues want to 'connect' the marksheet to other sources of data, for example using VLOOKUP or XLOOKUP,  you may find that the email address offers a useful value to query.

The existence of a marksheet with email addresses does not change any of the policies about anonymous marking. It is there to assist professional services colleagues in collating data into the marksheet. If you are ever in doubt about which marksheet to use always opt for the anonymous version. For guidance on when to mark anonymously please consult Instructions for Examiners. 

How to generate marksheets

The process of generating mark frames is simple and intuitive but there are some key things that you must do in order to ensure that your mark frame can be imported into SITS without error. Therefore, please ensure that you read the guidance on how to generate mark sheets before generating and completing your marksheets. 

Read the guidance on generating marksheets for re-assessments (PDF)

Saving marksheets as CSV files

It is vital that you save the marksheet as a CSV file before you start to complete it. If you do not do this you may not be able to re-open the file. Marksheets must also be submitted to the SSC as CSV files, if the marksheet is received in any other format it will be returned. 

You can name the file as you wish but must not use special characters such as &, £ or % as these can cause the upload to fail.  We'd suggest that you name the file using the course code and assessment period e.g. AB100 IRDAP 2023. 

Who can generate marksheets?

Given the data involved the number of colleagues that can generate marksheets is kept to a minimum. 

The  SSC Student Records Team manage access to the marksheet creator tasks. If access needs adding or removing the Department Manager should send an email to ssc.records@lse.ac.uk with the relevant staff member's name. 

Need help?

• If you do not have access to e:Vision at all, or if you need to reset your e:Vision password please contact ARD Systems.
• If you can access e:Vision but don't have access to the mark sheet creator task please contact the SSC Student Records Team.
• If you are encountering technical difficulties generating marksheets please contact ARD systems. 
• If you need access to the mark sheet creator task removing please contact the SSC Student Records Team.
• If students or assessments appear to be missing from the marksheet please contact the SSC Student Records Team.

Marksheets for assessment and re-assessment are completed in exactly the same way. 

The only thing you should add to the marksheet is marks between '0' and '100'. These should be entered into column which is labelled 'Mark'. Any explanatory notes should be included in the covering email. 

Marks are whole numbers and out of 100

All marks must be out of 100. If the assessment has been marked differently you will need to scale the marks before they are entered.

You cannot enter decimal marks, they must be whole numbers. If you enter decimals SITS will attempt to round the mark, but in many cases it causes the upload to fail. 

Which assessment is which?

You can use the #Ass#, Assessment Name and Weighting fields to establish which assessment is which. In most cases this is straight forward, however, if your assessments all have the same name you may need to use all three fields together. 

Zero marks

If a student was absent from the assessment, a mark of ‘0’ (the number zero) should be entered into the mark column. This will automatically be interpreted by SITS as ‘absent’. You should not add any additional comments to the marksheet and do not need to confirm absences in the covering email. If a mark of zero is submitted with no additional commentary SITS will assume it to be an absence. 

If a student has failed an assessment with a mark of ‘0’ (as opposed to being absent) you should enter a mark of ‘0’ (the number zero) into the mark column. You should also provide an explanatory note in the covering email. Do not write anything in the marksheet itself, just the covering email. 

As we are collecting component marks there will not be any instances where incomplete marks are being entered. If a student is incomplete across a course, SITS will calculate this.

Do not enter zeros into the marksheet for any other reason.

Students who have deferred their assessment

If a student has deferred an assessment then in most cases the assessment won't appear in the marksheet (i.e. the row for the assessment will not be there, or if the student has deferred all assessments for a given course they won't appear on the marksheet at all). 

However, in certain circumstances, it's possible that the assessment may still be present on the marksheet - the most common reason for this that the marksheet was generated before the deferral was processed. If the assessment does appear but you know that the student has deferred then you should leave the mark field blank (do not enter a ‘0’ or any other mark). If the deferral has been processed in SITS then you do not need to provide any extra notes in your email, just leave the field blank. 

There are two ways to check if a deferral has been processed in SITS:

1. Use the Current Deferral List tool in e:Vision. This tool will allow you to generate a list of approved and processed deferrals. As explained in the tool, there are however some limitations to the data that is presented.
2. You can check in the SITS client.

If you are at all unsure of the status of a deferral you should leave the mark field blank (do not enter a ‘0’ or any other mark) and explain this in your covering email. Do not write anything in the marksheet itself, just the covering email.

Students subject to allegations of academic misconduct

If a student is the subject to an allegation of academic misconduct you should leave the mark field blank (do not enter a ‘0’ or any other mark). Please also provide an explanatory notes in the accompanying email. Do not write anything in the marksheet itself, just the covering email.

Individual missing marks

If an individual mark is outstanding please leave the mark field blank (do not enter a '0' or any other mark). Please also provide an explanatory note in the accompanying email. Do not enter a ‘0’ for an unconfirmed mark as this could lead to a student being given an absence.

Information about how to submit marks that were missing when the main marksheet was sent can be found in Supplying previously missing marks and making late mark changes below. 

What about the Grade column?

Do not enter anything into the column labelled Grade. Due to the way SITS operates at LSE we need to maintain this column on the marksheets, but it must remain empty. If you enter anything into this column the upload may fail, or even worse the calculation of grades may become corrupted without us knowing.

What about the data in the other columns?

The data in the other columns is there to ensure that the correct mark is matched with the correct assessment and correct student when the marks are uploaded to SITS. If you want to know more, we've produced a quick guide to explain the other data in both versions of the marksheet. Please remember that you must not edit or reformat any of this data. 

Please do not:

• Change the format of any of the cells
• Enter information anywhere other than the in mark column
• Edit existing data

If you do these things it will mean that the marksheet cannot be uploaded to SITS and will be returned to the department. 

Need help?

• If you are unsure how to complete the marksheet please contact the SSC Student Records Team.

Marksheets should be sent by email to ssc.records@lse.ac.uk.
Please send one marksheet per email.

When complete, the marksheet should be sent to the Student Services Centre. This should take the format of an email with one marksheet (in CSV format) attached.

The subject line for the email follow the format of Course Assessment Period (e.g. AB100 2023/4 Academic Year or AB200 IRDAP 2024). The body of the email should be a quick covering note explaining any zero marks that are not absences, any missing marks and any marks that are being held due to academic misconduct. If you have no explanatory comments please note this.

The attached marksheets must be in CSV format. Marksheets received in any other format cannot be uploaded to SITS and will be returned. 

Marks are confidential and you should, therefore exercise the same level of care as you would with an exam paper. 

Need help?

• If you are unsure how to submit your marksheet please contact the SSC Student Records Team.

The deadlines for submitting marksheets are laid out in the Student Services Centre Key Dates document. They are also circulated in the SSC Bulletins. 

The deadlines for submitting marks must be considered as absolute, there is no flexibility.

If marks are submitted after the deadline they will not appear on the mark frames which will lead to delays in confirming progression decisions and awarding students. 

Need help?

• If you are unsure of the deadline for submitting your marksheets please contact the SSC Student Records Team..

Previously missing marks

If you submitted a marksheet with some marks missing then you should submit the missing marks in a new marksheet, on their own.

You should generate a new marksheet in e:Vision, add just the new marks to it and then send it to the SSC Student Records Team.

If the marks you submitted originally have already been uploaded to SITS then you should find that the e:Vision marksheet only asks for the marks that were missing. If we've not yet processed your original marks then you will get the full set presented to you again.

Please DO NOT add previously missing marks to the existing marksheet that you've already sent - we need a marksheet showing JUST the new marks. This is vitally important for audit purposes.

When you send the new marksheet please add a covering note to the email explaining that you're submitting some marks that were previously missing.

Legitimate late mark changes

There are some legitimate reasons why you may need to change marks after they have been submitted, for example if an Academic Misconduct case has been resolved or if you have waived a late mark penalty at your sub-board.

In these instances you should submit the change via the Late Mark Change spreadsheet located in your SubBoard-Chair-and-Sec-Only Teams channel. Please follow the instructions on the Late Mark Change spreadsheet and ensure that all columns (except those marked for the SSC) are completed. Please take particular care over course codes and candidate numbers. 

After completing the form you must also notify the SSC Records team of a late mark change by adding a message to the same Teams channel. You should tag the channel, not individual people e.g. @AB-SubBoard-Chair-and-Sec-Only - new marks have been added to the Late Mark Change spreadsheet.

Unless specifically requested you should not send an updated marksheet. 

Correcting mark errors

Marks should go through a rigourous quality process before being submitted to ensure that there are no errors. It is really important that you submit the correct mark the first time.

If you do identify an error in your marks then you should contact the SSC Student Records Team by email as soon as possible. You should explain the error and note how many students have been impacted. We will then advise how to proceed. 

After sending the email you must also notify the SSC Records team of the error by adding a message to the your SubBoard-Chair-and-Sec-Only Teams channel. You should tag the channel, not individual people e.g. @AB-SubBoard-Chair-and-Sec-Only - we've identified an error in the marks for AB100. We've sent an email with full details. 

It is important that you both send an email and a message in Teams. The email is important for audit purposes. The Teams message ensures that we know promptly and can block student results where necessary. 

Need help?

• If you need help with submitting missing marks or making late mark changes please contact the SSC Student Records Team. For urgent queries please post a comment in relevant sub-board channel, remembering to tag the channel.