Campus Solutions mark transfer
Before starting spreadsheets for the individual components must be obtained and saved in the db/CAMPUS-SOLUTIONS directory. Currently, Jennie obtains these and emails them to those involved in running Arcade.
The generation process will produce the populated spreadsheets in the db/CAMPUS-SOLUTIONS/NEW directory.
The process of transferring marks happens on a copy of the information stored in the Arcade.
./make-final-marks
This copy is created in the directory ./FINAL-MARKS. Each time the final marks are made, a new copy is created in this directory. By convension, only copies that have been used to send marks to SSO for entry into Campus Solutions are kept.
It is possible to compare two versions of the final marks using
./final-diff
Generating Spreadsheets for All Course Unit Elements
The spreadsheets for all courses can be generated using the command
../LOCAL-EXECUTABLES/create-composte-sheets
Note, this command assumes that any name alignment required has been setup in the AFC/latest-final-marks file as described in the section on individual course units.
Generating Spreadsheet for Individual Course Unit Element
In the following, element is assumed to be all or a major part of a course unit (e.g. the laboratory, coursework or examination component); it does not equate to an individual activity.
Can check that have all that expect for an element using:
./outstanding element
For some course units, this will show outstanding for students who have never attempted an exercise. These can be detected by x in the completed by deadline field, E-xxx in the extension field. Can remove them from outstanding list by putting X in date field.
The names used in Campus Solutions and those used in Arcade can be aligned by inserting entries into the AFC/latest-final-marks file. Once the name configuration has been completed, it is possible to populate the spreadsheets using:
./AFC/latest-final-marks -list | ../LOCAL-EXECUTABLES/load-marks-into-Campus-Solutions-XLS.pl -f CAMPUS-SOLUTIONS/element -a element
Note by this stage, the element has the COMP prefix.
Messages about no Arcade marks for a student often mean that they have left after the spreadsheets were generated. This can be confirmed by asking someone with Campus Solutions access to check.
Spreadsheet Transfer
The generated spreadsheets need to be sent to Jennie. All new spreadsheets can be sent using the command:
../LOCAL-EXECUTABLES/send-composte-sheets
As well as sending the spreadsheets to Jennie, this will also move them from the db/CAMPUS-SOLUTIONS/NEW directory to the db/CAMPUS-SOLUTIONS/SENT directory.
If a spresdsheet has already been sent, a message indicating this will be displayed followed by any differences between the new spreadsheet file and the one previousl sent. This means that in the summer, for first semester course units, it is necessary to (re)move the February versions before the updated ones can be sent. By convension, the db/CAMPUS-SOLUTIONS/SENT directory is renamed to db/CAMPUS-SOLUTIONS/SENT-FEBRUARY.
Checking Transferred Marks
A check for differences between the marks in Arcade and those send to Jennie can be performed using:
../LOCAL-EXECUTABLES/compare-latest-final-marks-with-sent-to-composte