A colleague on the MoodleMayhem.org email list recently asked…
I have an industrial arts teacher that now uses Moodle 1.9 quizzes for all of his shop safety tests. He uses the same quizzes for 3 grade levels, thus the students are removed and re-enroll yearly. Now that we’ve rolled over to a new year, he reset the course, effectively removing all students. The issue that we’re having is that when students enroll for a second time, their prior quiz scores reappear. Sure, the teacher can select all scores and delete them, but I am wondering if there isn’t a method for achieving this in bulk, clearing all attempts for all quizzes with a single action.
Below is my response:
Version 2.0 deletes all grades information for students unenrolled from a course. This is opposite from previous behavior and IMO very undesireable. A moderate number of times each term a student will get accidentally unenrolled from a course. Retention of grades information permits them to be re-enrolled without issue.
Moodle courses are not designed to be reused for each new year while keeping all the old history in there. It may work in some cases but it is recommended to create a fresh copy of the course each year and at the end either hide the course are disable all enrolments.The keeping of all course info after full unenrolment is not a real solution because it causes problems in other scenarios. Source for remarks: http://moodle.org/mod/forum/discuss.php?d=164550
WHERE name = ‘Module 1 Test’
AND course =27
LIMIT 0 , 30
WHERE quiz =34
LIMIT 0 , 30
DELETE FROM mdl_quiz_gradesWHERE quiz=34
Enter your email address:
Delivered by FeedBurner