Recording from March 10th, 2016 Session

Document created by ia24214 on Jul 27, 2016
Version 1Show Document
  • View in full screen mode

Hello all,

 

This link contains the Recording Session from March 10th, 2016:

https://sas.elluminate.com/site/external/jwsdetect/playback.jnlp?psid=2016-03-10.0930.M.3F93FB836BBF77C0CED9BAFD1348AB.vcr&sid=2011010

 

  • Isaiah Andrea from Blackboard Support presented a SQL Query that builds a Course Report to show User Activity by Item.


Note: The Query can only be run on OpenDB (Not ASR):

SELECT
    CA.CONTENT_PK1, CC.TITLE,
    SUM(CA.ACCESS_MINUTES) * 60 AS TOTAL_TIME_IN_SEC,
    SUM(CA.CONTENT_ACCESS_STARTS) AS TIME_ACCESSED,
    MIN(CA.INITIAL_DATETIME_ACCESS) AS ACCESS_TIME
    FROM
  BBLEARN_STATS.ODS_AA_CONTENT_ACTIVITY CA
    LEFT JOIN
  BBLEARN_STATS.ODS_AA_SESSION_ACTIVITY SA
    ON
    CA.LOGIN_PK1 = SA.LOGIN_PK1
    LEFT JOIN COURSE_CONTENTS CC
    ON
    CA.CONTENT_PK1 = CC.PK1
    LEFT JOIN
  COURSE_MAIN CM
    ON
    CA.COURSE_PK1 = CM.PK1
    LEFT JOIN
  USERS U
    ON
    CA.USER_PK1 = U.PK1
    WHERE CM.COURSE_ID='ENTER COURSE ID HERE'
    AND U.USER_ID='ENTER USER ID HERE'
    AND SA.LOGIN_TIME BETWEEN TO_DATE('01-04-2016','MM-DD-YYYY') AND TO_DATE('03-08-2016','MM-DD-YYYY')
    GROUP BY CA.CONTENT_PK1, CC.TITLE;

The query above can potentially gets updated and used in BIRT to develop a custom reporting B2 which was our second topic.

  • Brett Stephens from the University Of Miami also talked about developing a custom building block via BIRT. For those who are interested on creating their first Blackboard B2 BIRT Custom Report, please follow the instructions in this VIDEO

Attachments

    Outcomes