P { margin-bottom: 0.08in; }
Thanks Hunt for that explanation. To be
more specific, I have many many courses (which represent colleges)
each having a teacher (i.e. a dean, head of department, dean
deputy,...) and students (employees, staff faculty, ...). Every
student should fill the form. I have almost finished the form using
quiz because I am very familiar with quiz and the deadline is coming
soon. As a next step, I will do my best to learn dataform
However, there are several question related to form design by quiz:
1- How can we build a site-wide quiz? I
want to build the quiz (i.e. form) one time and use it in all
courses. Is it possible?
2- After finishing the quiz and
gathering all information from users, we are interesting in
collecting the answers of every question. I installed the
configurable report plugin which is an amazing tool. Then I
found several SQL statements in the forum. One related SQL of these
is to extract the results of all quizes in the site. I am a biggner
with SQL so could any one help us to extract these information from
Moodle? The mentioned SQL is as follows:
SELECT
prefix_grade_items.itemname,
prefix_grade_items.grademax,
ROUND(prefix_grade_grades.finalgrade, 0) AS finalgrade,
prefix_user.firstname,
prefix_user.lastname,
prefix_user.username
FROM
prefix_grade_grades
INNER JOIN prefix_user ON
prefix_grade_grades.userid = prefix_user.id
INNER JOIN prefix_grade_items ON
prefix_grade_grades.itemid = prefix_grade_items.id
WHERE (prefix_grade_items.itemname IS
NOT NULL)
AND (prefix_grade_items.itemtype =
'mod' OR prefix_grade_items.itemtype = 'manual')
AND (prefix_grade_items.itemmodule =
'quiz' OR prefix_grade_items.itemmodule IS NULL)
AND (prefix_grade_grades.timemodified
IS NOT NULL)
AND (prefix_grade_grades.finalgrade >
0)
AND (prefix_user.deleted = 0)
Thanks, and looking forward to hearing
from you soon.
Safaa O. Al-mamory