• 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 ...
    bishop.thomas
    created by bishop.thomas
  • 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 updat...
    jm28915
    created by jm28915
  • 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 HT...
    natasha46
    last modified by natasha46
  • Query for courses not used during a term

    Hi, I would like to track courses that have not being use during a specific term, either because they were not accessed by any instructor's or were not made available during this period. Or any other idea ? Thanks !!
    axelle.noiret
    last modified by axelle.noiret
  • Content Collection SQL query similar to SysAdmin GUI Content Collection listing?

    in the system admin gui I am able to open a course and select the course contents listing to obtain a list of content items like this:   Course Content: W_ASV-133-03-JC-W18   FILE TYPE NAME EDITED SIZE ...
    dl0055113
    last modified by dl0055113
  • 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?
    bh0076300
    last modified by bh0076300
  • 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...
    lm29482
    last modified by lm29482
  • 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 oth...
    jm28915
    last modified by jm28915
  • 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...
    km28576
    last modified by km28576
  • 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? 
    rs0068755
    last modified by rs0068755
  • External Grade Designation

    We use a third party application called StarFish.  This application pulls the grade from the column that's been set as the External Grade.  I need to pull a report from OpenDB that shows me which column in e...
    lee.mcminn
    last modified by lee.mcminn
  • 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 ...
    highland.hanrahan
    last modified by highland.hanrahan
  • 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...
    mattlingard
    last modified by mattlingard
  • 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 course...
    bishop.thomas
    last modified by bishop.thomas
  • 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 th...
    lm29482
    last modified by lm29482
  • 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 i...
    tp36301
    last modified by tp36301
  • 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 colum...
    sharon.clucka
    last modified by sharon.clucka
  • 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 activ...
    chrisboon
    last modified by chrisboon
  • How are you reporting/tracking Ultra course conversion?

    We are starting to layout plans to move to Ultra.  Has anyone figured out how to determine the status of a course after the switch to Ultra Experience ?    I thinking that we would need to understa...
    rs0040357
    last modified by rs0040357
  • Report on Course Structure

    Hi All, We are currently auditing the content opf our Bb courses and are looking to run a query which would return the course structure of each of our Bb Courses. We are looking to get the Course Menu items, Content...
    f.galeta@uws.edu.au
    last modified by f.galeta@uws.edu.au