Changing Role after completing exams

Re: Changing Role after completing exams

by Ray Hinton -
Number of replies: 0
Oof, that's a weird one!

Off the top of my head, I cannot think of a perfect solution that would keep their work and grade intact, while correctly restoring the role. Not to say that kind of solution is not possible, or even imply that my knowledge is exhaustive. Perhaps some combination of altered permissions would fix it? Sounds messy.

That said, given the odd nature of the scenario, perhaps an imperfect-yet-simpler-to-implement solution is acceptable? Do you have access to your database? And is the exam using the Quiz module, or something else? I wonder if you might be able to find the quiz attempt (or other module records) for the student, and find the grade history.

Potentially useful database tables:
- quiz_attempt
- quiz_grades (or other module)
- grade_grades
- grade_grades_history
- etc.

Then you could export those, and at least have an administrative record of their performance. Then, when you restore their role as a Student, you could just override their empty grade (in the gradebook) with the value from the database archive.