Date: Sun, 17 Oct 2021 07:48:20 +0000 (UTC) Message-ID: <1828675448.144583.1634456900783@3ecc041e.tietoverkkopalvelut.fi> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_144582_685297183.1634456900779" ------=_Part_144582_685297183.1634456900779 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html MyCourses grade total calculation

### Case

The course is graded on a scale of 1-5. The student's must complet= e 50% of the assignments in order to pass. Doing more than 50% of the assig= nment gives up to two bonus points. Exam grade is added to the assignment g= rades 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 cl= ick 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:
=3Daverage(100*([]-1),[],[],[],100*([]-1))*0.04-2+0.25= *[[E]]

Now let's see how it is built.
• =3Daverage
• calculates an average
• (100*([]-1),[],[],[],100*([]-1))*0.04-2
• For assignments 1 and 5 the grade is subtracted by 1. Since the g= rade is either 1 or 2, this converts it into 0 or 1
• The converted value is multiplied by 100, so the end grade is eit= her 0 or 100
• Grades for assignments 2, 3 and 4 are taken as is, they use point= s 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 fin= al 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 =3D 5
• 8*0,25 =3D2

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 [] =3D 1, calculation is 0
if [] =3D 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 [] =3D 1, calculation is 0
if [] =3D 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 ass= ignments need to completed, effectively using a grade scale of -2 to 2. Val= ues above zero are considered here as bonus points. Below zero and the stud= ent 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 =3D 21 grade choices (0-20)
Grade choice is multiplied by 0,25 to reach a grade in 0-5 range, wit= h quarter values.
E.g. 20*0,25 =3D 5
8*0,25 =3D2