We provide a couple of short video tutorials with practical examples that will be very useful to you.

Downloading the Attendance Report from Class for Web

In this video, you learn where to download the reports and how to tabulate them step-by-step in Excel.

Steps: Downloading and Preparing the Report

1. Access the Blackboard Collaborate Scheduler and log in with your manager type user.
2. In the left sidebar menu, click on Reports and select Institution Reports.
3. Click on Attendance Report.
4. Select the start date and end date of the period you want to check on the calendar.
5. Click the Download Report button to generate the CSV file.
6. Open the downloaded file in Microsoft Excel.
7. Select Column A, go to the Data tab, and click on Text to Columns.
8. Choose the Delimited data option, check Comma as the delimiter, and click Finish.
9. Accept the prompt to replace the data.
10. Delete unnecessary columns and keep only: Session Date, Session Name, Attendee Name, and Total Time Spent.

Analyzing Attendance Reports from Class for Web with MS Excel

In this video, you discover how to analyze reports using pivot tables to obtain and calculate the minutes consumed.

Steps: Creating a Pivot Table and Calculating Minutes

1. Place your cursor on any cell within your data table in Excel.
2. Go to the Insert tab and click on Pivot Table.
3. Confirm creating the pivot table in a new worksheet.
4. Drag the Session Name field to the Rows section.
5. Drag the time field to the Values section.
6. Click on the time field in values, open Value Field Settings, and change the function to Sum.
7. Go to the Analyze tab, select Fields, Items & Sets, and click on Calculated Field.
8. Create the field Sum of Hours by multiplying the total time by 24 (`Attending Total Time session * 24`).
9. Change the number format of the Sum of Hours field to General.
10. Create a second Calculated Field called Sum of Minutes by multiplying the time by 24 and 60 (`Attending Total Time session * 24 * 60`).
11. Change the number format of this field to General or Number with no decimals to see the total minutes.
12. (Optional) Drag the Attendee Name field below the session name in the Rows area to see the breakdown by student.