Judy Hsu

Thanks Tim and Ian. This is very helpful!!

Dear all,

I have a special use case here and hope some of you can help. We have a teacher who set up a quiz with just essay type of questions, but she want to allow students to pick ONE question to answer out of three possible questions. The way we set it up for her right now is to give all three questions maximum possible points to be 100. This way no matter which question the student choose, it will be graded out of possible 100 point. However, this created a problem that in this quiz, even the student get 100 points, it will show up as 100 points out of 300 points (as there are three questions, each question worth 100 points). Is there any solution or workaround for this so that it will show up as 100 out of 100?

I thought of using "randomzied" questions, but this won't work as the teacher want students to choose which question to answer instead of Moodle randomly pick one for the student. If you have a good solution please let us know, thanks!

Hi all, thanks for reading this thread.

Just a quick question. Is it possible to use Book module with Moodle's "activity completion" feature (in Moodle 2.4 and 2.5) to automatically track whether students "viewed" all the pages in the Book module, and if so, count them as completed and pass the status to the 3rd party plugin Certificate so that students will be able to get a certificate? Is this possible with just Book module, Activity completion, and certificate module? Thanks!

Hi Anne, thanks for helping out. I found that I had a missing ")" in the original query and that's probably why it didn't run.. it's a human error. Thanks again for your kind help.

Hi Darko, thanks a million for your help!

I have another quick question. So this is a old query that we run on Moodle 1.9 before, to capture how many days teachers logged in to the LMS during a certain time period:

SELECT lo.course AS Course_ID, co.shortname as Course_ShortName, co.fullname AS Course_FullName, us.firstname as Instructor_FirstName, us.lastname AS Instructor_LastName, COUNT(DISTINCT(FROM_UNIXTIME(lo.time, '%Y-%m-%d'))) AS Days_Logged_In
FROM prefix_log lo
INNER JOIN prefix_course co ON (co.id = lo.course)
INNER JOIN prefix_user us ON (lo.userid = us.id)
INNER JOIN prefix_role_assignments ra ON (ra.userid = us.id)
INNER JOIN prefix_context ctxt ON (ctxt.id = ra.contextid AND ctxt.instanceid = co.id AND ctxt.contextlevel = 50)
INNER JOIN prefix_role r ON (r.id  = ra.roleid)
WHERE lo.course <> 1 AND r.name='Instructor'
AND (FROM_UNIXTIME(lo.time) > '2013-09-10' AND FROM_UNIXTIME(lo.time) < '2013-09-14') AND (co.shortname LIKE '%13/FALL%' OR co.shortname LIKE '%13/SPRING%')
GROUP BY us.firstname, us.lastname, Course_ID, Course_ShortName, Course_FullName
ORDER BY co.fullname, co.shortname

This query now seems to have some trouble to run correctly on Moodle 2.4. Do you see anything wrong with this query or can you make some suggestions about how to improve this query? Thanks again!