 |
 |
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<http://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 http://library.blackboard.com/ref/fea8bb86-1720-4b14-bb81-542d973b5338/index.htm Its the backboard database schema On 17 June 2013 11:37, Harrison, Peter <[log in to unmask]<mailto:[log in to unmask]>> wrote: OK we do not use the grade centre much so apologies if this is a really trivial question :) 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