Anyone know what the syntax for this would be?
I have 3 grade items set up;
O, K, and F
They have an ID of, T1, T2, T3 respectively.
What I am doing is taking the 3 grades and dividing them by their sum.
For example:
O = 2
K = 1
F = 2
This gives me 3/5 which is .6
Then I multiply that by 100 to get a 60% grade
Below is the formula:
If two of the grade items do not have a grade then the value of the grade goes above 100. For example:
O = 2
K =
F =
The result is: 3/2 = 1.5 multiplied by 100 = 150
Does anyone know what the syntax for not allowing that to happen? It confuses the student when all
items have not been graded and the course total shows grade values above 100.
I'm sure there is a better way to calculate this by having missing grades but I am having trouble figuring out a way to do it.
Any help is appreciated,
Dennis