Bb Learn Data Reporting User Group | Blackboard Community

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

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 hours 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.

Actions

bishop.thomas in Bb Learn Data Reporting User Group2 weeks 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) 18 hours 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

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

4 repliesShow more activity

tg0047770 (to highland.hanrahan) 1 day ago (Show more Show less)

Hi Hanrahan, Yes, the query I wrote is based on a date range working from the last attempt date which is the timestamp of the last submission by a student, rather than the date of grading activity itself. I only really wrote it around the tables I was more familiar with. To get results more specific to your question, you would probably be…

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) 3 days 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 weeks 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

rs0068755 in Bb Learn Data Reporting User Group10 months 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

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

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 running Python scripts to move data around. vidmate

Actions

sharon.clucka in Bb Learn Data Reporting User Group2 years ago (Show more)

Grade column report for all active courses

Does anyone have a query to pull a particular grade column from all active courses using a date range, with the following information displayed: student first name, last name, course id weighted grade column We need this report for Early College and Career and College Promise students. The report will be sent to the high schools for… (Show more)

6 repliesShow more activity

adam6347 (to sharon.clucka) 1 month ago (Show more Show less)

I am hoping they set the weighted grade as an external column so we can pull all in one report, psiphon otherwise each instructor will have to pull their own and upload to box or other cloud storage space.

Actions

chrisboon in Bb Learn Data Reporting User Group12 months ago (Show more)

Reporting on tool usage within courses

We are currently completing a full audit of all Blackboard courses, and are looking for a quick way to find out which courses have used interactive tools. We're looking to report on whether each course has actively used blogs, journals, discussion boards or wikis in the last year, and are concerned that doing a manual audit will be time… (Show more)

35 repliesShow more activity

anna89 (to jkelley_blackboard) 1 month ago (Show more Show less)

Thank for the feedback @jeffkelly The problem is resolbved now.

Actions

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

Re: Help with SQL re parent/child courses

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

Re: Does anyone have a simple postgres query that will show courses that are unavailable/available