Moodle測驗學生做完了但從未繳交該怎麼處理?

請參考以下資料

Re: Moodle Quiz: How to submit a quiz with "Never Submitted" status
Tim Hunt
2014年 02月 13日(四) 16:58
Try this:

Work out the ids for the 4 problem attempts. You can get this by going to the quiz reports, and reviewing the 4 attempts. The URL will end .../mod/quiz/review.php?attempt={id here}.
Change the quiz settings to When time expires: attempts are submitted automatically.
(being very careful) edit the data in the database. In the quiz_attempts table, matching the ids with the id column, find the rows for those 4 attempts. Edit the value in the 'state' column from 'abandoned' to 'inprogress'.(我是改為finished)
Wait until cron runs. The attempts should then be submitted.
I think that will work, but it is just an educated guess. Proceed at your own risk. The sensible thing would be to try this on a test server, with a dummy quiz and attempt you created just for testing, before trying it wilt real data.

連結

將測驗設定裡的"當作答時間限制已到時"改為"開放的作答將會被自動提交"，進資料庫找到quiz_attempts的資料表，找到該學生"回顧作答次"的attempt id，把abandoned改為finished，回到成績頁面，重新計分即可出現成績。