Bb Learn Data Reporting User Group | Blackboard Community

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

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) 2 weeks 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

bishop.thomas in Bb Learn Data Reporting User Group1 month 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)

jm28915 in Bb Learn Data Reporting User Group2 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)

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

Specify case sensitivity for Blackboard tests when designing outside of Blackboard?

I am trying design tests in Blackboard that have many questions. I've been using MS Excel to make long collections of questions that I upload to Blackboard. This has been working very well and I've been able to use HTML to my advantage to specify formatting of the question text itself. I'm hitting one small snag. I would really like to specify… (Show more)

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

Where does the attendance tool store its data?

Does anyone know what table the attendance tool uses to store its data such as present, late, absent, and excused?

2 repliesShow more activity

bh0076300 (to heather.crites) 2 months ago (Show more Show less)

That is disappointing to hear but I really appreciate you sharing this information with me. Thank you very much.

Actions

lm29482 in Bb Learn Data Reporting User Group3 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)

7 repliesShow more activity

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

Jonathan, You will just have to ask your query to do the math and subtract the logout time from the login time. For SaaS (in PosgreSQL) it is just logout_time - login_time

Actions

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

Where find achievements in database.

We're trying to pull a list of users who have earned badges (achievements) in our SaaS environment. However, we are receiving an error that the ach_notification table does not exist. I'm not certain if other tables/columns are not the same. We've reviewed the schema for MH which we were told is almost the same as SaaS - - guess this is one of… (Show more)

1 replyShow more activity

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

Janet, That table exists in SaaS as it does in Managed Hosting. Are you sure you've connected to the right schema? I'm not sure if there was a transcription error in your post, but I made two little changes and it ran AOK for me. (I added u to .firstname and swapped brackets out for double quotes around Date Received) select …

Actions

km28576 in Bb Learn Data Reporting User Group3 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)

2 repliesShow more activity

km28576 (to heather.crites) 3 months ago (Show more Show less)

This makes sense! I will have to adjust it for MSSQL to test on our system, but the concept seems like it will work perfectly. Thank you very much.

Actions

highland.hanrahan in Bb Learn Data Reporting User Group5 months ago (Show more)

OpenDB SQL query: courses in which grading has occurred

We need to get a list of IDs for courses in which there has been some grading activity (eg grades have been added to the Grade Centre by any means) within a specified time period (eg the past two academic years), for courses with a specific subset of DSKs. If there was also some indication of "how much" grading has occurred in each course, that… (Show more)

6 repliesShow more activity

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

Ooops, forgot to add in the data source key - select cm.course_id as "Course ID", count(gl.pk1) as "nActivity" from bb_bb60.gradebook_log gl join bb_bb60.gradebook_main gm on gl.gradebook_main_pk1 = gm.pk1 join bb_bb60.course_main cm on gm.crsmain_pk1 = cm.pk1 join bb_bb60.data_source ds on cm.data_src_pk1 = ds.pk1 where gl.date_logged >=…

Actions

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

Re: How to Connect to ASR using MSSQL