There is some code in cvs:/contrib/gradebook/ which provides calculated columns in the gradebook. These calculated columns give you a lot of flexibility in how you calculate grades from the scores of the individual assignments and quizzes. It would be good if this code could be included in Moodle 1.3. This would require some testing and improving of the code. Any volunteers?
The gradebook has been discussed in a rather long previous thread, see http://moodle.org/mod/forum/discuss.php?d=3784.
The instructions for the calculated columns are:
You can have additional columns in the gradebook whose entries are calculated from those in other columns according to a formula provided by you. The "Total" grade column is an example of this. The students will be able to see their grades from calculated columns alongside their other grades. They will also be shown the formula used.
To refer back to other columns in your formula you use the following notation:
If you need to refer to a whole range of grades you can use a shorthand notation, for example A2:4 stands for the list A2,A3,A4 and similarly for C and PA. You can also use all to denote the list of all activity grades (including grades from hidden activities) and Pall to denote the list of all percentage grades for all activities. Note that A(1+2) will not work, it has to be A2.
You can combine the grades using:
You can also use the following student-independent variables:
An example: if the final grade should be on a scale of 0 to 10 and should be obtained as the best 2/3 of all assignments then you could use the formula
The calculated grades are floating point numbers. Only the first digit after the decimal point will be displayed but all digits are used for calculations.
You can choose any name for a calculated column. However if you choose the name Total then the corresponding entry in the student's grade table will be presented in bold face.
Note: The ordering of the activity columns in the grade book are determined by the ordering of the activities on the course page. Thus if you change the order on the course page then the labeling of the activity columns may change and you will have to change the formulas by hand.