Details

New Feature

Status: Closed

Major

Resolution: Fixed

1.9, 3.4, 3.5, 3.6

na

MOODLE_19_STABLE, MOODLE_34_STABLE, MOODLE_35_STABLE, MOODLE_36_STABLE

MOODLE_36_STABLE

MDL14274master 
Description
I understand that when calculating the grade for a category or total grade in moodle 1.9, it is possible to use various formulas:
http://moodle.org/help.php?module=grade&file=calculation.html
However, it does not appear to be possible to use an IF formula (condition) as can be done in Excel.
It would be very useful to be able to calculate the total of x number of graded activities, but not include the scores of those activities that are less than a certain %.
So for example, if there are three graded activities for which students must get 50% or more, the formula in Excel would be as follows:
=SUM((IF(A1>=50,A1,0))+IF(B1>=50,B1,0)+IF(C1>=50,C1,0))
where A1, B1, & C1 are the three graded activities. Here, A1, A2 & A3 are added together, but if the score of any one activity falls below 50%, it is treated as 0%.
For example:
student1
activityA1: 30
activityA2: 80
activityA3: 70
Total: 150 (Not 180)
the total for student1 is only 150 (not 180) because his score for quizA1 is less than 50, and so is treated as zero, so 0+80+70=150
I know it's possible to indicate a "Grade to pass" for any item or category, but this seems to only change the background colour of a score: green for pass, red for fail. It does not effect the category score to which that item belongs.
So, I can see three possible ways of achieving this goal:
1) make it possible to use the 'IF' function in the gradebook as in Excel
2) make it possible to remove from the total calculation any grade that falls below the designated 'Grade to pass": this should be an option, not automatic
3) make it possible for each activity module to return 0% to the gradebook if the score falls below a specified amount  probably the least practical solution
Why would this feature be useful?
Short answer = motivation
In activities that students can do (i.e. submit) more than once, they would be 'encouraged' to achieve more than a bare minimum. For example, in a course in which there were many quizzes, it would be possible for a student to pass by doing very well in just a few quizzes, and then doing lots of other quizzes badly. Yes, their average would be pulled down, but because they had done a few very well, their average may still be high enough to pass. Allowing the teacher to specify a grade below which certain activities must not fall will assist teachers to motivate their students.
Attachments
Issue Links
 has a clone

MDL39787 CLONE  Make it possible to add conditions (IF) to grade calculations in gradebook
 Closed
 is duplicated by

MDL61060 Addition of boolean logic operations to Gradebook Calculations
 Open

MDL39787 CLONE  Make it possible to add conditions (IF) to grade calculations in gradebook
 Closed
 is parent of

MDL64414 Make it possible to use AND, OR in ifconditions for grade calculations
 Closed