Report of reassessment to be undertaken by students

The basic report is now available for you to export from RPS with all reassessment data input for the current RPS season. You can use this report to identify which students have been flagged for reassessment in the modules run by your department. The report will also show whether students have chosen to take the voluntary reassessment or not.

You can run this report as often as you like, but please note a) the report should not be run until the bulk of the main backloads have taken place or it will be showing data that has not yet been through an exam board, and b) the deadline for students to make their decisions online is 22 July 2018 and after that date we will have to make manual amendments.

How to report the data

1. Go into Result Processing System.
2. Click on Reassessment Report (which is on the right hand side of the main screen).
3. Choose your department and the level of module you wish to retrieve.
4. Basic data will appear on the screen (you can also change the ordering using the sort facility in the top right hand corner).
5. Reading data on the screen won't give you the complete data. You must click Export which will create a spreadsheet.
6. A dialog box will appear for you to save the file. Note it is a .csv file. You will have to save as a .csv file initially. However, when you make changes to the file you will need to re-save it as a .xlsx file (excel workbook file).
7. You can manipulate the data in Excel by using the filter functions - see instructions below.

Note that you can change the year if you need to look up a previous years reassessment flags for instance. When preparing for May/June exams you might find it useful to see which students are due to return to take exams/coursework without attendance. The system is defaulted to the current academic year (eg 16 for the 16-17 academic year) but you can change it to 15 to see who was flagged in the 15-16 academic year to return for the 16-17 exams.

How to interpret the report

The fields on the report reflect everything which has been flagged for reassessment on the database. Most column headings are self explanatory, but some need further explanation. The column headed 'Choice Type' shows the following reassessment codes: VC = voluntary reassessment CR = compulsory reassessment CC = compulsory choice reassessment.

If VC or CC are showing you will need to check other columns to see whether the student has made their choice yet.

If they had to make a choice of 'Decision' outcomes see whether the column headed INT ASSESS (interim assessment) still has DECI in it, it means that the student hasn't yet made their final choice. When they have, it will show in the column headed FINAL ASSESS. Please see the list of assessment codes to see what other outcomes mean.

In some cases the students will be final years who can graduate but have failed final year modules - they've been offered the chance to graduate without reassessment (SUCG) or graduate and return for reassessment (SUGR). You can see what they have chosen by looking at the 'Int Assess' column. If it says DECI they haven't chosen yet. If it is blank look in the 'Final Assess' column and see what outcome has been chosen.

How to filter in Excel

1. Filtering in Excel allows you to view sub sets of records in a spreadsheet. It does not sort or remove the data, just hides the data you do not want to view.
2. Click on the 'select all' button Excel select all button in Excel (you will find this to the left of the "A" column and above the "1" row
3. Click on the 'sort and filter' button at the top of the screen and select 'Filter'. Filter arrows will appear beside each column heading.
4. Click on the filter arrow of the heading you want to filter. It will show you a drop down list of the entries in that column so you can select only the entries you want to see in your list. For example, if you want to show only modules that are "Voluntary", click on the filter arrow for the "Choice type" heading and select the tick only against "VC". If it's a long selection list remove the tick against "Select All" and select the items required.
5. Click OK. Your list would then show you only Voluntary Choice reassessment. Bear in mind that if a student is given the option of taking, say, one out of two exams we had to flag both of them as voluntary and tell the student they could only take one exam. We input a limit on the number of credits they could be reassessed, which should stop them picking more via the web results page.
6. You can apply filters to multiple columns by following the instructions above for each column of data required, for instance, if you want students taking voluntary reassessment and who have confirmed they are taking the reassessment, once you've filtered the voluntaries on the 'Choice type' column you would then follow steps one to four above for the 'Attending' column selecting 'Yes'. NB - 'Attending' is the term used to describe that the student is taking the reassessment and we use if for exams and coursework.
7. To remove a filter Click on the Sort and Filter Button and select 'Filter'. The filter arrows will then disappear beside each column heading. This clears the filters so you view all data. At this point you can choose to Filter again following steps one to four/five selecting different data.