Grade: Consider top 5

Grade: Consider top 5

by Hardeep Singh Rai -
Number of replies: 7

To me, it looked that, it should be FAQ, or must be answered in the forum. But my search could not yield what I wanted. If already answered somewhere, please point me there, else suggest solution or trick to:

"consider only top 5 activities, out of total 8 for a particular category"

Say for a categories "Home work" students are give 5 reading assignments, each evaluated with the help of quizzes, and 3 other assignments, where students need to submit reports, which are evaluated by teacher (with the help of rubric). Each activity carry maximum grade point of 10.

If a student earn marks as below:

  1. Quiz1 8
  2. Quiz2 10
  3. Quiz3 Not attempted
  4. Report1 5
  5. Report2 8
  6. Quiz4 9
  7. Report3 10
  8. Quiz5 2

I wish lower 3 grade not be considered, and his grade, in category "Home work" should be by ignoring grades at Sr. No 3, 4 and 8 i.e Not attempted (may be treated as zero grade point), 5 and 2.

Sum of top 5 grade points = 

10 + 10 + 9 + 8 + 8  (considering items at Sr. No 2, 7, 6, 1 and 5) = 45 out of 50, and if I want to consider it out of 10 in overall grade, then I can use weight of 0.2 to get 0.2 * 45 = 9.

Average of ratings: -
In reply to Hardeep Singh Rai

Re: Grade: Consider top 5

by Rick Jerz -
Picture of Particularly helpful Moodlers Picture of Testers
Your need brings back some old memories. I used to give students 3 assignments but kept only their top two. Setting this up in the Moodle grade book took some thinking and time, but it was doable. Unfortunately, that was many years ago, and I cannot remember how I did it. I am posting to you just to keep you probing, and hopeful.
Average of ratings: -
In reply to Rick Jerz

Re: Grade: Consider top 5

by Hardeep Singh Rai -

Thank you Rick Jerz.

I could do 2 out of 3, by doing in formula:

sum of three minus minimum of three.

Best one is also doable easily.

But if we need to consider top n, or ignore bottom m, then what to do.

I am of the opinion that it will be doable.

Average of ratings: -
In reply to Hardeep Singh Rai

Re: Grade: Consider top 5

by Rick Jerz -
Picture of Particularly helpful Moodlers Picture of Testers
I am not suggesting that you do 2 out of 3. What I am saying is that the Moodle grade book is very powerful, and it provides "equations" for calculating some grades. However, you might need to think like a mathmatician to get what you want.

I did find the equation that I once used, shown below. As you can see, a bit complex, but it worked. I did this around 7 years ago, so I can't remember why. But maybe it will help you think through your own needs.

=(501+502+503+1176+max(501,502)+max(501,503)+max(501,1176)+max(502,503)+max(502,1176)+max(503,1176))/8
Average of ratings: -
In reply to Rick Jerz

Re: Grade: Consider top 5

by Pushpinder Singh -
If we want to pick best n, let say, best 5 assignments from the given 8 assignments, it can be done by 'Drop the lowest' feature provided by moodle. There is no need to form any mathematical formula for that.

We have to edit settings for a category. Let say, our category name is ''Assignments (grades)'' and this category has 8 assignments as the childern of this category. Click on edit settings for category ''Assignments (grades)'' and set the 'Drop the lowest' value as 3 if we want to pick best 5. Then, save changes. It will do the task.

For using 'Drop the lowest' feature, there are some constraints:

1) All the childern of category should have equal max. grades and equal weights.

2) There should not be any sub-categories and extra grade items in the category.
Average of ratings: Useful (1)
In reply to Pushpinder Singh

Re: Grade: Consider top 5

by Rick Jerz -
Picture of Particularly helpful Moodlers Picture of Testers

You might be correct.  Out of curiosity, could you provide a screenshot of where you are seeing this "Drop the lowest" feature/

Average of ratings: -
In reply to Rick Jerz

Re: Grade: Consider top 5

by Pushpinder Singh -

Yeah sure.

Here, Accessing the following link, you can see general view of a Gradebook. You can see here, a category named "Assignment" containing eight assignments as its childern. Click on 'Edit' and then, on 'Edit settings'.

https://github.com/PushpinderSingh722/Moodle-Grade-Aggregation/blob/master/DTL101.PNG?raw=true

It will open an another page, you can see by accessing the following link. There is "Drop the lowest" feature, where we can enter the required value (let say 3, for dropping three lowest grades) and then, clicking on save changes, will do the task.

https://github.com/PushpinderSingh722/Moodle-Grade-Aggregation/blob/master/DTL111.PNG?raw=true

Average of ratings: Useful (1)
In reply to Pushpinder Singh

Re: Grade: Consider top 5

by Rick Jerz -
Picture of Particularly helpful Moodlers Picture of Testers
Ah, now I see. From Moodle docs:

When using natural weighting, drop the lowest is only allowed when:

all children of the category have equal weights
all children of the category have equal max grade
there are no sub categories in the category
there are no extra credit items in the category

This is probably why I cannot drop the x lowest graded.
Average of ratings: -