Morning,
Does anyone have a querry that would allow a specific course to be tracked ie number of page hits per month, with maybe student ID (so that we can cross tab with the school / program)
The main issue that we have is that the general stats that BB has often time out (too much data - all stduents are enrolled on this module)
We have Crystal Reports but again many issues with accessing such a large set of data.
Is there anywhere/ one whom has a selection of stat generating querries that they are willing to share
Kind regards
Mark Pelling
________________________________
From: Blackboard/Courseinfo userslist on behalf of Andrew Raistrick
Sent: Tue 20/01/2009 16:19
To: [log in to unmask]
Subject: Re: Does anyone know a suitable database query for...
Try this for a specific student
select f.file_name,f.link_name,u.status_ind,u.upload_date,u.dtmodified
from bb_bb60.files f , bb_bb60.course_user_uploads u , bb_bb60.course_users c, bb_bb60.users s
where f.pk1=u.files_pk1 and u.course_users_pk1=c.pk1 and c.users_pk1=s.pk1 and s.user_id='u0870483'
order by u.upload_date asc
Note, The STATUS_IND column represents the following :
a = Added
s = Sent
r = Received
Hope this helps
Andy Raistrick
Email: [log in to unmask]
Tel: (01484) 471315
The University of Huddersfield
Computing and Library Services
PO Box No. 341
Huddersfield
HD1 3DH
________________________________
From: Blackboard/Courseinfo userslist [mailto:[log in to unmask]] On Behalf Of CLAY Gary M
Sent: 20 January 2009 15:41
To: [log in to unmask]
Subject: Does anyone know a suitable database query for...
... obtaining details of Student work submission into Blackboard (via dropbox/assignment/turnitin) - per student/module?
--------------------------------------------------
Gary Clay
Learning Development Manager
Learning Development and Innovation
Staffordshire University
Beaconside Campus
Stafford ST18 0AD
Telephone +44 (0) 1785 353648
e-mail [log in to unmask]
The information in this email is confidential and is intended solely for the addressee. Access to this email by anyone else is unauthorised.
If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, except for the purpose of delivery to the addressee, is prohibited and may be unlawful. Kindly notify the sender and delete the message and any attachment from your computer.
1 Vision. Our students voted us top new University for student satisfaction.
This transmission is confidential and may be legally privileged. If you receive it in error, please notify us immediately by e-mail and remove it from your system. If the content of this e-mail does not relate to the business of the University of Huddersfield, then we do not endorse it and will accept no liability.
|