Peter Ruthven-Stuart

Hello Itamar,

Thank you for your reply.

What I am after is a formula that will drop the lowest two grades ONLY IF a student has done more than 13 units, and then divide the total by 13 regardless of how many units a student has actually done. So the problem with dropping the lowest two grades regardless of how many units a student has completed is that even if a student does the required 13 units, two of these grades will be dropped thus penalizing them because their total will still be divided by 13.

Hello Bob,

Thank you very much for your reply. Yes, you're right, there have been some significant improvements in and additions to the Gradebook. I'll have to wait for our system to be upgraded in order to keep the highest 13 grades.

Hello,

Is it possible to use the Moodle Gradebook formulas to calculate the average of the highest 13 units of a 15 unit course?

I am running a course in which students are required to do 13 of 15 units. Each unit consists of about 10 graded activities. They may do any 13 of the 15 units (i.e. they do not need to do 2 of the 15 units). If they do less than 13 units, their final score will still be the average of 13 units. If they do 14 units their lowest unit will be dropped from the calculation. If they do all 15 units their two lowest units will be dropped from the calculation.

Put simply, the Final TOTAL = Highest 13 units ÷ 13

I have attached an Excel file to illustrate how this calculation is done with Excel.

Can this calculation be done within the Moodle Gradebook (we are using Moodle 1.9.3+)?

Note, it is possible to drop the lowest X number of grades (see Drop the lowest help), but this function is carried out regardless of the number of units completed. For example, even if a student only does 5 units, his lowest X units will be dropped. We only want unit scores dropped IF students have done more than 13 units.

I suspect this is not possible given that we can't use IF functions in the Moodle Gradebook. Still, suggestions will be most welcome.

Hello Helen,

Thank you for your help.

My username in both systems was the same. Changing my username in the new system allowed me to copy the course from the old system and restore it into the new system.

BUT, none of the user data was copied over. The participant list in the new course is empty, as is the list of users viewable from the top page - as the admin, I am the only user listed. However, activities in this course-copy contain 'ghosts' of the original students, their names and activities are still visible (e.g. forum postings are preserved, quiz attempts are visible), but clicking on a student name shows a profile headed with, "This user account has been deleted". When I backed up the original course and did the restore, I made sure that all user data was included, and the backup included all course users. I have also looked in the moodle.xml file contained within the zipped course, and have confirmed that all the user data was included in the backup.

Any ideas how to ensure that users are also copied over with the course contents?

Glenys,

Thank your for your reply.

Unfortunately, I'm still not able to copy the course content and its users to another another moodle system. Here's what I tried:

1. While logged in as an admin I de-selected Administrator (and Course Creator) as you suggested, and then backed up the course.
2. In the other Moodle, again logged in as an admin, I tried to restore the course and again got the same error message as described above.
3. I again tried to restore the course, but this time logged in as a teacher. I was able to restore the course, but not any users.
   

So, I am in the odd position of being the admin in both systems, but unable to copy over a complete course (content and users) from one system to the other. I can see that this is to prevent the admin login details getting in to the wrong hands, but it also prevents the legitimate transferring over of content and users from one system to another.

I must be missing something. I wonder if there is a solution?