If you have access to the database it should be fairly simple to design a
SQL query that does it for each class
----------------------------
Select count (distinct course_user.pk1), course_id
from course_user U, course_main c
where U.course_pk1 = c.pk1
group by course_id
----------------------------
gives you how many users in each course
------------------------------
Select count (distinct user_pk1), course_id
from activity_accumulator a, course_main c
where a.course_pk1 = c.pk1
group by course_id
------------------------------
will give you a count of active users by each course
just need a date limiter
----------------------------------
Select count (distinct user_pk1), course_id
from activity_accumulator a, course_main c
where a.course_pk1 = c.pk1
AND ([TIMESTAMP] > CONVERT(DATETIME, '2011-02-01 00:00:00', 102))
AND ([TIMESTAMP] < CONVERT(DATETIME, '2011-03-01 00:00:00', 102))
group by course_id
---------------------------
All active in February this year.
hope this helps sorry its a bit rushed but Im off home
Joseph Gliddon
--On 17 March 2011 12:18 +0000 Arthur Loughran <[log in to unmask]> wrote:
> Hi,
> I am trying to find a way of getting a snapshot view (no pun intended) of
> course activity expressed as a percentage of active/inactive users over a
> period of time. For example by doing a cut-and-paste job on a course
> user activity report I have found that in one course a relatively high
> percentage of the student users have never even entered the course.
>
> I do not want to do that for all courses and would be grateful if list
> members could tell me if there anything out there that will generate this
> information at the press of a button.
>
> thanks,
> Arthur Loughran
Regards
Joseph
----------------------
Joseph Gliddon
e-Learning Implementation Officer
Education Support Unit
University of Bristol
[log in to unmask]
|