My formula doesn't work

My formula doesn't work

by George Thompson -
Number of replies: 1

I'm a volunteer for WorldTeach in Colombia.  The school has moodle, which nobody knows how to use.  I've been mostly successful in learning how to use moodle.  I can neither find nor figure out how to write a formula that drops the lowest grade and counts the final exam as a double grade.  I've copied the formula that I've written:

=((sum(E1.U1,E2.U2,E3.U3,E4.U4,E5.U5,Dram,Oral.U4)-min(E1.U1,E2.U2,E3.U3,E4.U4,E5.U5,Dram,Oral.U4))+(Fin.N3*2)/8

  The moodle module is in Spanish, which seems to require commas in place of decimals and semi-colons between arguments.  I'd appreciate infomation as to how to get the final calculation to show up as the final grade and also how to terminate the class this semester for the new class.  Thanks George R. Thompson

In reply to George Thompson

Re: My formula doesn't work

by Marty Soupcoff -

The first part where you drop the lowest grade you can completely get rid of. Moodle has a built-in drop the lowest feature. To use go into Categories and items and then select Full View link underneath the tabs. There will be a column for drop the lowest. Entering a 1 drops the lowest, entering 2 drops two lowest and so on.

You will first want to arrange these grades into a category though. The final exam should not be in this category.

Your formula would then be similar to what is below. For my formula I am using CT to represent the category total of all those assignments.

=sum((CT+(FinalExam*2))/8)

Happy Moodle Logooodling!