Totara Learn Open Discussions

Applying a formula to calculate a final grade for a test activity

这个讨论区有规定周期内发帖数的限制，它被设置为 1天内最多发 3 个帖子。

Hi all,

I have an interesting problem regarding test activities. I have a scenario where I need to have a test activity where a section is deemed mandatory and the candidate has to get 100% in this section to pass overall. I have previously suggested splitting the mandatory away from the rest of the test, but the business doesn't want this. Consequently, I have weighted the mandatory in such a way that the candidate cannot pass without getting the 100% in the mandatory section.

What this presents is a problem in terms of reporting the final grade. In the legacy system, the passing grade is 70%, whereas with my current implementation, it's now 96.15% to pass. The business wants the final grade to reflect what they would have got in the legacy system as there is overarching policy in place dictating the process.

I have a formula that I want to apply, but no idea where I can apply it to the test activity. In the gradebook setup, there is scope to put in a calculation, but that's giving a grade conflict between the actual test and the overall course grade.

If anyone else has any other ideas, that would be much appreciated.

永久链接 | 回复

Hi Edward

A grade calculation that mutiplies the test activity by the correct amount sounds what you want.

The activity will need to be have an idnumber added and then you can create a grade calculation using the idnumber

e.g. =[[testactivity]]*0.75 + [[otheractivitiesgrades]]

Regards

永久链接 | 显示父帖子 | 回复

Hi Craig,

I am using Totara 12 currently. I would like to know if Totara 12 supports "if" function in the grade calculation. I was getting Invalid formula error trying to put this formula in, =if([[assessment11]]>=10, 1, 0). No issue if I change the formula to use 'sum'.

Hope you could shed some light on this. Thanks!

Best regards,
Allison

永久链接 | 显示父帖子 | 回复

Hi Allison

The IF function is not supported in the calculation field see calculations functions for a list of these.

I think this function could be simulated by creating a calculation that converts the value to a decimal and adding 0.4 to this Rounding the result to 0 decimal point so any value >=10 gets a value of 1

=ROUND(([[assessment]]/100)+0.4,0)

10/100 = 0.1

0.1 +0.4 =0.5

ROUND 0(.5, 0) =1

Regards

永久链接 | 显示父帖子 | 回复

Hi Craig,

Appreciate your reply and many thanks to the workaround, it worked. Brilliant idea!!

Best regards,

Allison

永久链接 | 显示父帖子 | 回复