For all of these WEC courses , can we allow 2 Quiz attempts and remove the time completely from the Quizzes?Thanks.
Digital Photography I - Siegel 1Digital Photography I BrownDigital Photography I RobortsDigital Photography I - SeigelCareer Planning - BrownCareer Planning - RobortsCareer Planning - RiosIntroduction to Manufacturing Sec. 1 SweetingIntroduction to Manufacturing Sec 2 HanssIntroduction to Agriscience - Mintonye 1Introduction to Agriscience - Mintonye
Translated, that means could you allow a second attempt for all the quizzes in the courses and remove the 1 hr time limit.
I remoted into the moodle DB using MySQL Workbench 5.2 CE and ran these two snippets of code - changing the course ids in each query.
Query one
#use this to remove time limits from quiz in multiple coursesUPDATE `dbname`.`mdl_quiz`
SET timelimit = 0 # a timelimit of 0 means no timing set - endless time to take the quiz
WHERE course in (course id list);
Query two
UPDATE `dbname`.`mdl_quiz`SET attempts = 2
WHERE course in (course id list);
About 200 quizzes in 11 courses where updated at once, in two places [attempts, timelimit]. I could have updated both fields in the same query, since it was the same courses.
Imagine doing this from moodle. It would take a couple hrs of very tedious work.
No comments:
Post a Comment