### Case

The course is graded on a scale of 1-5. The student's must complete 50% of the assignments in order to pass. Doing more than 50% of the assignment gives up to two bonus points. Exam grade is added to the assignment grades which is then the course total grade. Exam must be passed (grade 1 or more) for final grade to be given. Also, total grades over 5 are given as 5.

• Assignments 2,3, and 4 are given points between 0-100
• Assignments 1 and 5 are either yes (2) or no (1), their grade are converted to either 0 or 100.

Turn editing mode on, go to the Course total -column, and click the calculator icon on the row below.
In this view you can give your grade items (assignments and such) an ID number, that can be referred to in the calculation formula. Above, before the grade items have been given ID numbers. Above, grade items have been given ID numbers (1, 2, 3, 4, 5 and E) Above the used formula:
=average(100*([]-1),[],[],[],100*([]-1))*0.04-2+0.25*[[E]]

Now let's see how it is built.
• =average
• calculates an average
• (100*([]-1),[],[],[],100*([]-1))*0.04-2
• For assignments 1 and 5 the grade is subtracted by 1. Since the grade is either 1 or 2, this converts it into 0 or 1
• The converted value is multiplied by 100, so the end grade is either 0 or 100
• Grades for assignments 2, 3 and 4 are taken as is, they use points 0-100
• After the primary calculations for assignments 1-5 are done, the grade is multiplied by 0,04, converting the 0-100 scale into 0-4 scale
• Finally -2 is subtracted to convert the scale to -2 to 2 -scale. If the student has a negative value on his/her exercise grade total, no final grade is given. Any positive value is added to the exam grade.
• +0.25*[[E]]
• Convert the 21-step scale into 0-5 scale E.g:
• 20*0,25 = 5
• 8*0,25 =2

More detailed explanations on grade items

Assignment 1 - referred to with []
uses scale: yes (2) / no (1)
given grade is converted either to 0 or 100
if [] = 1, calculation is 0
if [] = 2, calculation is 100

Assignment 2 - referred to with []
uses scale: 0-100
no calculations done

Assignment 3 - referred to with []
uses scale: 0-100
no calculations done

Assignment 4 - referred to with []
uses scale: 0-100
no calculations done

Assignment 5 - referred to with []
uses scale: yes (2) / no (1)
given grade is converted either to 0 or 100

if [] = 1, calculation is 0
if [] = 2, calculation is 100

Then grade items []...[] are multiplied with 0,04 to convert a 0-100 -scale to a 0-4 -scale .
Then from this value 2 is deducted, because 50% of the grade item assignments need to completed, effectively using a grade scale of -2 to 2. Values above zero are considered here as bonus points. Below zero and the student hasn't done the required amount of assignments.

Exam - referred to with [[E]]
uses scale: 0-5, with quarter grades
0, 0,25, 0,5 ... 4,5, 4,75, 5 = 21 grade choices (0-20)
Grade choice is multiplied by 0,25 to reach a grade in 0-5 range, with quarter values.
E.g. 20*0,25 = 5
8*0,25 =2