Bb Learn Data Reporting User Group

kd0043639 in Bb Learn Data Reporting User Group2 months ago (Show more)

OpenDB Query to find course cartridge use?

In preparation for the Course Cartridge EOL in December, I want to make sure we've contacted instructors using cartridges now. I ran a quick and dirty query, select cd.*, cm.course_id, cm.course_name, cm.dtmodified from BB_BB60.cartridge_download cd, bb_bb60.course_main cm where cd.crsmain_pk1 = cm.pk1 order by cm.course_id desc but I don't feel… (Show more)

1 replyShow more activity

cyndi.castro (to kd0043639) 4 weeks ago (Show more Show less)

Kris, Thank you for the query. I added a few things to get a bit more information like instructor, etc. SELECT CD.DTCREATED, CM.COURSE_ID, CM.COURSE_NAME, CU.ROLE, U.USER_ID, U.FIRSTNAME, U.LASTNAME, U.EMAIL FROM CARTRIDGE_DOWNLOAD CD, COURSE_MAIN CM JOIN COURSE_USERS CU ON (CM.PK1 = CU.CRSMAIN_PK1) JOIN USERS U ON (CU.USERS_PK1 =…

Actions

km28576 in Bb Learn Data Reporting User Group7 months ago (Show more)

How can I tell if an Attempt was created by the student or professor?

I am working on a query to identify the last time a student submitted an assignment. I use the ATTEMPT table fairly heavily, but have discovered that if an instructor enters a grade of 0 for a non-submitted discussion thread, that gets recorded as an attempt with a grade of 0. When it is an assignment (other than a discussion) there is no attempt… (Show more)

3 repliesShow more activity

eichorn7c (to km28576) 2 months ago (Show more Show less)

If you gave the student multiple attempts for a quiz, the log will always show the most recent attempt by default krogerfeedback. SELECT * FROM ( SELECT DISTINCT ON (course_main.course_id , users.user_id) course_main.course_id, course_users.enrollment_date, users.user_id, users.firstname AS user_firstname, …

Actions

lm29482 in Bb Learn Data Reporting User Group6 months ago (Show more)

Query Needed - mobile vs computer users

Hi! We would like to begin gathering information regarding how many users access the system through computers versus mobile devices. Can this information be gathered through ASR? If so, is there a query that can be shared? Or, is it a Blackboard report request? The authentication logs only provide an IP number and does not differentiate if the… (Show more)

9 repliesShow more activity

jkelley_blackboard (to jd0054247) 2 months ago (Show more Show less)

Admittedly, I assumed "mobile" meant Apps. Sorry for that. The table auth_provider_log captures logins for ~10 days. The user_agent field will indicate mobile browser access.

Actions

je0078200 in Bb Learn Data Reporting User Group4 months ago (Show more)

OpenDB Query to Report Building Block Usage

Does anyone happen to have a SQL query to report a Building Block's usage (the building block name would be part of the query) showing the building block name, date modified, hits in the last year, node, course id, and instructor? Thank you in advance. Regards, Jane

1 replyShow more activity

jkelley_blackboard (to je0078200) 2 months ago (Show more Show less)

Jane, In follow up from the other thread... I have a few little investigation queries that can help you know what to look for. You can use this information to craft the queries specific to the tools you want to look at. #1 - Activity Accumulator (AA) "Data" - get a list of the unique values for the data field in the AA table. SELECT…

Actions

mf0052568 in Bb Learn Data Reporting User Group2 months ago (Show more)

The Ultra Course Experience and ods submission tables

We use the ods submission tables to pull information on student access and report it to advisors. Are the ods submission tables populated with course activity in the Ultra Course Experience like they are for Original Experience courses?

jkelley_blackboard in Bb Learn Data Reporting User Group3 months ago (Show more)

ETL from DDA (PostgreSQL) to Oracle?

Looking for institutions who have implemented procedures to move data from the SaaS Open Database (DDA/PostgreSQL) environment to an Oracle based warehouse/reporting database. What method(s) do you use to transfer?

3 repliesShow more activity

jkelley_blackboard (to jkelley_blackboard) 3 months ago (Show more Show less)

Has anyone tried this with Oracle HS (Heterogeneous Services)?

Actions

bishop.thomas in Bb Learn Data Reporting User Group5 months ago (Show more)

Has anyone created a process to review B2’s after a SaaS update?

Occasionally, we find that Blackboard or one of their partners has introduced a new Building Block and made it available on our system without much notice. We want a quick way to verify any new B2s, and that building blocks remain available and settings haven't changed after a SaaS CD upgrade. We are not using Ultra. One way we've found is to… (Show more)

3 repliesShow more activity

jkelley_blackboard (to bishop.thomas) 4 months ago (Show more Show less)

plugin.name and plugin.description are the unfortunate outgrowth of internationalization. The building block may have language bundles included to translate those fields to different languages. date added - point taken

Actions

jkelley_blackboard mentioned Bb Learn Data Reporting User Group 4 months ago Show mention context

Re: Building Block Usage Report

rs0068755 in Bb Learn Data Reporting User Group1 year ago (Show more)

Moving to SaaS and DDA

In the summer we will be moving from managed hosting with ASR to SaaS and the DDA. Can anyone offer me any guidance on using DDA - what client are you using to run queries, any help guides etc?

10 repliesShow more activity

rs0040357 (to rs0040357) 4 months ago (Show more Show less)

To get around some performance/connections issues with foreign data wrappers, I used the With Table As command. The following code first retrieves the data subset from the foreign table before doing something with the data - in this case, inserting the data into a local copy of the activity_accumulator.. Insert into activity_accumulator( …

Actions

jm28915 in Bb Learn Data Reporting User Group5 months ago (Show more)

Does anyone have a SQL query to pull SCORM scores for activities that are scored and if they were answered correctly? Looking for a query that enables us to pull detailed data.

We have a SME who requires a matrix to determine which questions/engagement that users are having difficulty with so they know what needs additional information/clarification in the training component when it is updated next year. Obviously, we can pull SCORM reports for individual users through the course that tells us what a user got correct… (Show more)

Manage

Recent Activity