 |
 |
Thanks
From: Blackboard/Courseinfo userslist [mailto:[log in to unmask]]
On Behalf Of Joseph Gliddon
Sent: 17 June 2013 12:09
To: [log in to unmask]
Subject: Re: [BLACKBOARD-USERGROUP] Grade Centre and SCORM
Here is a query I did a few years back when I was looking at automatically extracting data from blackboard to put into our student records system.
It is designed to pull any grades for a particular gradecentre category (SITS Export Cat1 - in this case)
I have included Attempt date AND Grade date - because Blackboard can be a little inconsistent in which one it uses - feel free to remove the bits you dont need
---------------------
SELECT T.NAME,
CS.COURSE_NAME,
M.title,
u.user_id,
att.score,
G.manual_grade,
g.manual_score
ATT.date_added as attempt_date_added
ATT.date_modified as attempt_date_modified
g.date_added as grade_date_added
g.date_modified as grade_date_modified
FROM GRADEBOOK_TYPE T, GRADEBOOK_MAIN M, GRADEBOOK_GRADE G,
COURSE_MAIN CS, attempt ATT, course_users CU, Users U
-- Could change this
where T.Name = 'SITS Export Cat1'
-- Try this instead if you want to pull a paticular title
-- where M.title = 'The title of your assessment'
and T.pk1 = M.gradebook_type_pk1
and M.pk1 = g.gradebook_main_pk1
and M.crsmain_pk1 = CS.PK1
and att.pk1 = g.last_attempt_pk1
and g.course_users_pk1 = cu.pk1
and cu.users_pk1 = U.pk1;
-----------------------
and you might find this link useful as well
Its the backboard database schema
On 17 June 2013 11:37, Harrison, Peter <[log in to unmask]> wrote:
OK we do not use the grade centre much so apologies if this is a really trivial question
J
We are about to deploy a staff development module on Information Security to all staff which is a SCORM package. As far as I can tell this only returns
a completion flag to BB which I have set the grade centre to display. However when this gets updated to “completed” it also sets the item to “Needs Grading” is there any way to suppress that?
The second part is that they want the a report exporting to the HR system of [UserID, Date completed] where date completed is since the last report would
anyone be so kind as to point me at a suitable query before I go digging through the database schema.
In an ideal world the HR system would then reset the completion status when the validity period expired but I am sure that would be a step too far!
Peter
Peter Harrison
Research Information & Learning Technologies Manager, IT Department
Building 63, Cranfield University, Cranfield, Bedfordshire MK43 0AL
--
Joseph Gliddon
Learning Technologist
Technology Enhanced Learning
University of Bristol
0117 331 4403