This program takes an input of a properly-formatted *.csv file that contains student marks, then appends marks (course, summative, exam, and final) to each student record.

[anything]
Type,[header],[O.Ax],[Sx],[Ex]
[data],[data],[level],[level],[level]
[data],[data],[level],[level],[level]
[nothing should come after the table of records]

[anything]: the beginning of the spreadsheet, precedes the header row. Can include anything but a row whose first cell is Type, like the header row.

Type: case-insensitive and whitespace padding-insensitive. This cell marks the beginning of the header row.

[header]: any headers that do not begin with O.A, S or E. Data in these columns will be ignored.

[O.Ax]: a header cell that shows which column contains a mark for a unit. The x denotes which unit. For example, O.A2 means this column contains marks for unit 2.

[Sx]: like O.A, but for summatives.

[Ex]: like O.A, but for exams.

[data]: can be anything, this is ignored.

[level]: this is a level for the unit, exam, or summative. The levels use the following conversions to percentage points:

A: [no mark],
[nothing]: [no mark]
R-: 25, R: 35, R+: 45,
1-: 52, 1: 55, 1+: 58,
2-: 62, 2: 65, 2+: 68,
3-: 72, 3: 75, 3+: 78,
4--: 80, 4-: 85, 4: 90, 4+: 95, 4++: 100,
5: 100

The reverse of any mark is also valid. For example, --4 and 4-- are equivalent.

If the exam mark for a unit is higher than the course mark for a unit, the average calculations will use the exam mark for that unit instead of the course mark. The reverse is not true. For example, if a student has

Type,   O.A1,   S1, E1,
Name,   -2,     3,  5

The course mark will be replaced by a 5, giving:

Type,   O.A1,   S1, E1, Term Mark,  Summative Mark, Exam Mark,  Final Mark
Name,   -2,     3,  5,  62.0,       100.0,          100.0,      100.0

However, the exam mark cannot be replaced by a course mark. For example, if a student has

Type,   O.A1,   S1, E1
Name,   5,      3,  -1

The result will be:

Type,   O.A1,   S1, E1, Term Mark,  Summative Mark, Exam Mark,  Final Mark
Name,   5,      3,  -1, 100.0,      75.0,           52.0,       87.9

This table shows how a student with a mark in everything would be calculated. The course mark counts for 70%, the summative for 10%, and the exam for 20%:

Type,   O.A1,   S1, E1, Term Mark,  Summative Mark, Exam Mark,  Final Mark
Name,   5,      3,  4+, 100.0,      75.0,           95.0,       96.5

This table shows how a student with a mark in everything except the exam would be calculated. The course mark counts for 70% and the summative mark for 30%:

Type,   O.A1,   S1, E1, Term Mark,  Summative Mark, Exam Mark,  Final Mark
Name,   5,      3,  A,  100.0,      75.0,           ,           92.5

This table shows how a student with only a course mark would be calculated. The course mark counts for 100%:

Type,   O.A1,   S1, E1, Term Mark,  Summative Mark, Exam Mark,  Final Mark
Name,   5,      A,  A,  100.0,      ,               ,           100.0

Created by Patrick Melanson, 2013

Contact: [email protected]

Licensed under the MIT license. See accompanying LICENSE file