Help with creating final grading

[mikael0hlsson]

If here where an option for to replacing the grades in the grid with numerical values (user choice for more variability) for a grade (G, VG, MVG, A,B,C etc) then it should be possible to calculate the final grade in an spreadsheet (leave the calculations out of the app and let the user do it in his favorite spreadsheet program, since that might vary from course to course).

For example:

Lets say that we let
G=10
VG=20
IG=-10000000

then an G final grade would be an avarage of all the grades that is >=10 but <15
An VG final grade would be an avarage grade of >=15
and a IG (not passed) would be an avarage grade of <10

This should work for any number of different grades and any number of grades according to me, but I am a bit tired at the moment , so I might be wrong.

[mikael0hlsson]

An thought though... replacing a grade with an number is an easy search and replace function in a spreadsheet program (or just a formula that puts the number in another column (that can be hidden if needed)).... So it would perhaps be better to leave it out, for to keep the program simple?

[mikael0hlsson]

Decided that this is outside the scope of the application. Might be added to the documentation how to work in excel.