TEMPLATE - VirtualClassroomUsage.xlsx
Originally published June 30, 2020
This article is intended to provide information on how you can leverage the Virtual Classroom Partner Data Set and provides a few practical examples of how to leverage this product.
Data hub houses all the data exports from within Brightspace and Bongo Premium customers will have weekly fulls that authorized users can run and export into CSV. These can be combined with Brightspace Data Sets to provide detailed telemetry on courses to become a valuable tool in your data strategy.
What field information is available in this data set.
Field | Description |
|---|
OrgUnitId | Unique org unit identifier of the course where the meeting was scheduled. Will be NULL if the meeting was cancelled. |
CourseName | The name of the course where the meeting was scheduled. Will be NULL if the meeting was cancelled. |
MeetingId | Unique meeting identifier. If a meeting is reoccurring, each occurrence is represented in a new row. |
MeetingName | The name of the Virtual Classroom meeting. |
CreationUserId | Unique identifier of the user who scheduled the meeting. |
CreationDate | The date and time the meeting was created (UTC). |
ScheduledDate | The date and time the meeting is scheduled to start (UTC). |
ScheduledDuration | Planned length of the meeting in minutes. |
IsPublished | Indicates if the option to automatically publish the recording to attendees is enabled. |
ExternalLinksEnabled | Indicates if the option to use external links to join the meeting was enabled when the Virtual Classroom session was scheduled. |
WholeClassInvited | Indicates if all users in an org unit were invited. |
IsCancelled | Indicates if the meeting is cancelled. Comparable to IsDeleted in other data sets. |
StartDateTime | The DateTime that the Virtual Classroom session was started (UTC). Will be NULL if the meeting was not started or canceled. |
EndDateTime | The DateTime that the Virtual Classroom session was ended (UTC). Will be NULL if the meeting was not started or canceled. |
IsRecorded | Indicates if the meeting was recorded. |
Pre-requisites:
- You must be a bongo premium client to have access to the data sets. If they are currently using Freemium, requests need to be routed through your CSM and/or TAM for more information.
- Some form of product that can process these data sets into a table format
- User must have access to data sets permissions to download the Bongo Premium - Virtual Classroom data set
- Data Set Access: Admin > Roles & Permissions > Role group > Data Platform & Brightspace Data sets
- Data Platform
Figure: The Brightspace Data Platform permissions.
Figure: The permission Can Access Brightspace Data Sets.anipulating your Partner Data Set to create virtual classroom reporting:
These instructions will use the complimenting excel template to create some simple reports for your use.
- Open the accompanying excel template for your use.
- Within your environment, navigate to your Data Hub area (You may need to speak with your LMS Administrator to be granted this access/addition on the Navigation bar if its not present)
- Goto your environment - Navigate to data sets and look for the virtual usage data set
- Note: This is will be generated weekly on Mondays with full data set only
- Download the latest full data set
- Open the respective data set in Excel (for the purposes of this walk through)
- Using the attachment at the bottom of this report - copy/paste the information into the "Virtual Classroom Usage" tab in the excel template
- Once the data has been pasted into the tab - Fill down columns P - Q
- Note: This is pulling the scheduled start date elements into a format that can be used by pivot tables, based off meeting start date.
- Formulas for these columns:
- P: (Start Month) =MID(M2,6,2)
- Q: (Start Year) =LEFT(M2,4)
- R: (Start Date) =MID(M2,9,2)
- S: (Week Number) =IF(ISERROR(WEEKNUM(DATE(Q2,P2,R2),1)),"",WEEKNUM(DATE(Q2,P2,R2),1))
Reporting – By Course
Report Purpose: This report shows all virtual classroom sessions by month by course over the entire time of using Virtual Classroom (regardless if its freemium or premium)
- Navigate to the VC-ByCourse-YY-MM worksheet located in the accompanying worksheet
- Right click anywhere on the pivot table; and refresh
- Result: This will update based on the data in the Virtual Classroom Usage Tab
- Note: Ensure that you select that the "IsCancelled" is a zero (meaning the meeting was not cancelled
Figure: The Virtual Classroom worksheet showing IsCancelled.
Reporting – By Course, Date with Meeting Name
Report Purpose: Shows you the detailed meeting name by course (that are not cancelled meetings)
Figure: The Virtual Classroom worksheet reporting by course, date with meeting name.
Reporting – Weekly Usage by Year
Report Purpose: Identify, by month, the total number of meetings by year and the total duration of time taken
- Navigate to the VC-ByCourse-ByDate-MtgName worksheet located in the accompanying worksheet
- Right click anywhere on the pivot table; and refresh
- Result: This will update based on the data in the Virtual Classroom Usage Tab
- Note: Ensure that you select that the "IsCancelled" is a zero (meaning the meeting was not cancelled)
Figure: The Virtual Classroom worksheet Reporting – Weekly Usage by Year
Need further help working with data? Stuck on any of the above steps? Lacking one of the skill sets needed? D2L provides flexible levels of Data Solutions Consulting services that can assist with any or all steps in the process detailed in this post. If you are interested, please contact your D2L Customer Success representative.
