I just installed Configurable Reports and am hopeful it can help me with
something. I am trying to produce a report which will list each
resource / activity in a course and what percentage of students in that
course have completed that activity. The output might look like this:
Slides for Lecture 1: 98%
Slides for Lecture 2: 45%
URL link to TED talk: 76%
I do not want to see each student. I want a summary. Is there a way to produce this with this great tool?
In reply to John Andre
Re: Report showing number of students who completed each activity
I would like to dedicate some time for helping you on it. Let me get some slot and think useful guidelines ;)
In reply to Miguel González Laredo
Re: Report showing number of students who completed each activity
by John Andre -
Thanks a lot. I appreciate your help.
In reply to John Andre
Re: Report showing number of students who completed each activity
I could think an approach to help you beginning: Completion for module types
select co.course, co.module_type, co.nUsers/us.nParticipants*100 from
( -- Completion stuff
select count(distinct userid) as nUsers, cm.course, m.name as MODULE_TYPE
from prefix_course_modules_completion cmc, prefix_course_modules cm, prefix_modules m
where cmc.completionstate=1 and cmc.coursemoduleid=cm.id
and cm.module=m.id
group by cm.course, m.name
) co,
( -- Participants as students
select x.instanceid as course, count(distinct ra.userid) as nParticipants
from prefix_role_assignments ra, prefix_context x where x.id=ra.contextid and roleid=5
group by x.instanceid
) us
where co.course=us.course
-- /*Use for current course restriction */ and co.course = %%COURSEID%%
select co.course, co.module_type, co.nUsers/us.nParticipants*100 from
( -- Completion stuff
select count(distinct userid) as nUsers, cm.course, m.name as MODULE_TYPE
from prefix_course_modules_completion cmc, prefix_course_modules cm, prefix_modules m
where cmc.completionstate=1 and cmc.coursemoduleid=cm.id
and cm.module=m.id
group by cm.course, m.name
) co,
( -- Participants as students
select x.instanceid as course, count(distinct ra.userid) as nParticipants
from prefix_role_assignments ra, prefix_context x where x.id=ra.contextid and roleid=5
group by x.instanceid
) us
where co.course=us.course
-- /*Use for current course restriction */ and co.course = %%COURSEID%%
In reply to Miguel González Laredo
Re: Report showing number of students who completed each activity
by John Andre -
Thanks, Miguel, for your help. However, when I try this SQL, I get this error when I attempt to save it:
Query failed
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'co,
( -- Participants as students
select x.instanceid as course, count(distin' at line 7
Do you have any idea what it could be?