{"id":44,"date":"2006-03-01T18:10:27","date_gmt":"2006-03-01T22:10:27","guid":{"rendered":"http:\/\/kevincreamer.net\/panda\/?p=44"},"modified":"2006-03-01T18:10:27","modified_gmt":"2006-03-01T22:10:27","slug":"bb-world-%e2%80%9906001-sql-for-blackboard-system-administrators","status":"publish","type":"post","link":"https:\/\/kevincreamer.net\/panda\/2006\/03\/01\/bb-world-%e2%80%9906001-sql-for-blackboard-system-administrators\/","title":{"rendered":"Bb World \u00e2\u20ac\u212206.001: SQL for Blackboard System Administrators"},"content":{"rendered":"<p>Continental breakfast at the Manchester Grand Hyatt is $19.  $19!  I hadn\u00e2\u20ac\u2122t yet registered for the conference so I decided to register then check the Marriott\u00e2\u20ac\u2122s buffet price.  Perhaps I missed it somewhere on the Bb World site, but they\u00e2\u20ac\u2122re serving breakfast in the San Diego Conference Center, so my anger with the Hyatt\u00e2\u20ac\u2122s pricing actually helped save Richmond a bit of money.\n<\/p>\n<p>\nI was a little late getting to the first session of the conference, but I managed to get a seat towards the back of the room.  One of the nice things at the conference is that rather than provide just rows of chairs, Blackboard has long tables where you can put out your stuff.  I promptly pulled out my PowerBook and looked for the wireless network.  There wasn\u00e2\u20ac\u2122t any!  My only option was to pay $24.00 a day to the convention center.  In disbelief I checked the conference program, where I learned that if I sit on the ground within 50 feet of the e-mail stations, I can pick up a small wireless network set up for the conference.\n<\/p>\n<p>\nBlackboard, if you\u00e2\u20ac\u2122re reading, please fix this for next year.  It\u00e2\u20ac\u2122s a technology conference, for Pete\u00e2\u20ac\u2122s sake.  And you have the means to make this happen.  This is the first conference I\u00e2\u20ac\u2122ve attended in years (more than 3) that didn\u00e2\u20ac\u2122t have a wireless network available to all.\n<\/p>\n<p>\nGlen Parker\u00e2\u20ac\u2122s presentation was a good start.  He\u00e2\u20ac\u2122d made his presentation slides available before the conference.  I shared them with Betsy, who told me she hoped I\u00e2\u20ac\u2122d attend his session to hear more.  The slides are available <a href=\"http:\/\/presentations.glenparker.net\/\">online<\/a>.\n<\/p>\n<p>\nHere are some of the things I heard that weren\u00e2\u20ac\u2122t on the slides:<\/p>\n<ul>\n<li> Glen likes the Activity Accumulator information because it provides a better query interface (SQL) than looking at the system logs.  We should understand how this information is stored for those times we want to know what a person was doing in the system when a problem occurred.<\/li>\n<li>Gradebook Main stores student attempts on gradebook items.  The qti field contains XML information about the attempt.<\/li>\n<li>Gradebook scores, along with when they were recorded are kept in the Attempts table, not Gradebook Main.<\/li>\n<li>Glen presented four problems in need of a SQL solution.  Each of the four examples is a roadmap to most any other query you might want to make against the system.  The introductory slide of features you can query is based on version 6.2; for 6.3 it would be a much longer list.<\/li>\n<li>His Student Performance Assistant query was used for a Building Block that shows faculty how many times a student has accessed the course over time.<\/li>\n<li>USF keeps a year\u00e2\u20ac\u2122s worth of data in the Activity Accumulator.  I think this is a default.  We should check to see how long we keep our data.<\/li>\n","protected":false},"excerpt":{"rendered":"<p>Continental breakfast at the Manchester Grand Hyatt is $19. $19! I hadn\u00e2\u20ac\u2122t yet registered for the conference so I decided to register then check the Marriott\u00e2\u20ac\u2122s buffet price. Perhaps I missed it somewhere on the Bb World site, but they\u00e2\u20ac\u2122re &hellip; <a href=\"https:\/\/kevincreamer.net\/panda\/2006\/03\/01\/bb-world-%e2%80%9906001-sql-for-blackboard-system-administrators\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"nf_dc_page":"","_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[6],"tags":[],"class_list":["post-44","post","type-post","status-publish","format-standard","hentry","category-technology"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/kevincreamer.net\/panda\/wp-json\/wp\/v2\/posts\/44","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kevincreamer.net\/panda\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kevincreamer.net\/panda\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kevincreamer.net\/panda\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kevincreamer.net\/panda\/wp-json\/wp\/v2\/comments?post=44"}],"version-history":[{"count":0,"href":"https:\/\/kevincreamer.net\/panda\/wp-json\/wp\/v2\/posts\/44\/revisions"}],"wp:attachment":[{"href":"https:\/\/kevincreamer.net\/panda\/wp-json\/wp\/v2\/media?parent=44"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kevincreamer.net\/panda\/wp-json\/wp\/v2\/categories?post=44"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kevincreamer.net\/panda\/wp-json\/wp\/v2\/tags?post=44"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}