Bb Learn Data Reporting User Group | Blackboard Community

lm29482 in Bb Learn Data Reporting User Group3 weeks ago (Show more)

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) 1 hour 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 Group1 week 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) 1 hour 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 Group1 month 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) 1 month 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

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?

8 repliesShow more activity

yolanda847 (to rs0068755) 1 month ago (Show more Show less)

I encountered problems when I wanted to join this data with other Oracle data. I was never able to get Oracle to read the Postgresql tables or easily get a local Postgresql server to read DDA's tables. I tried to use Talend Community to copy the dda stats tables into a local flat file, but kept running out of heap space. So I recently started…

Actions

highland.hanrahan in Bb Learn Data Reporting User Group3 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) 2 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 2 months ago Show mention context

Re: How to Connect to ASR using MSSQL

mattlingard in Bb Learn Data Reporting User Group3 years ago (Show more)

Any Tableau & Open Db Users?

We are just starting to look at reporting from the Blackboard Learn Open Database. My institution has purchased access to it for a separate, wider learning analytics project but I'm keen that we take advantage for our (TEL Team) purposes to better understand current Bb usage. We don't have any SQL skills at present but are able to connect Tableau… (Show more)

19 repliesShow more activity

james2685 (to mattlingard) 2 months ago (Show more Show less)

I also have this same question and i cannot find any proper answers on the internet and also here. need solution. Dairy Queen Fan Feedback

Actions

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

Determine Empty Courses

I need to determine if certain courses are devoid of content at the start of term. Currently I use the following query which checks for zero course size and counts how many Grade Center columns there are. Blank courses only have two so I must further limit the results to only those. Is there a better way of doing this?: SELECT cm.course_id,… (Show more)

7 repliesShow more activity

bl31720 (to bishop.thomas) 2 months ago (Show more Show less)

I would check the numbers on your template. And then use that number to determine your usage beyond the creation status. So you need to run a script to determine number of default items in the course. Then run a script that looks for that number of course items to determine zero usage or beyond that to determine if the course was used. In our case…

Actions

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

Query that searches for content web links

Hi everyone, We had an interesting question from our librarians. They are trying to identify courses that link to one of their resources. They provide a URL to the instructors and the instructors make this link/URL available in their courses. They would like to identify the Bb courses using this URL/resource. I imagine that the instructors… (Show more)

4 repliesShow more activity

alfonso75 (to lm29482) 2 months ago (Show more Show less)

I have the same issue. Thanks so much, your suggestion worked for me. tellpopeyes

Actions

tp36301 in Bb Learn Data Reporting User Group2 years ago (Show more)

Master Course Management Needs for Online Campus

Greetings, Our online campus has brought this need to our attention. I am not sure if this would be better for the Data Reporting Group for MH as we do use OpenDB so I am cross posting this. This is what they our online campus sent us for requirements. I can't think of anything that would give them specifically data on these because they are… (Show more)

11 repliesShow more activity

sz0049424 (to tp36301) 3 months ago (Show more Show less)

As far as being able to identify the correct subset of courses, we follow a pretty tight master course naming convention that works well for us. [status prefix]_Master_[course#]_[campus suffix] Status prefixes are: DEV (in development) CUR (current production copy) RET (retired. we allow them to keep a single retired "previous version" per…

Actions