search

jschildgen / scan_and_mark

0 stars 1 forks source link

randomize ordering of students #3

Closed timobaumann closed 2 months ago

timobaumann commented 2 months ago

the students are always ordered alphabetically. Ordering errors are a well-known problem in exam grading (e.g.: you start with high standards and grow ignorant to small mistakes after a while; a fair result is judged badly after a stellar result; ...). It would be nice if the student list had a shuffle button which one can select before grading a next question as to randomize ordering across all students and questions.

jschildgen commented 2 months ago

Good point. But I would not randomize students in the left overview. I would randomize the answers in the right part.

timobaumann commented 2 months ago

either will work for me.

jschildgen commented 2 months ago

ORDER BY sin(matno)
is a simple "solution" to "randomly" sort the students in a deterministic way. Multiplying the ORDER BY sin(matno*exercise_id) gives a different ordering for every exercise.

jschildgen commented 2 months ago

It's implemented now. The random ordering is not done via SQL, but by Java using the exercise id as the seed.