Skip to main content
Indiana Wesleyan University Support Knowledge Base

Learner Usage Report for Student Engagement

Goal

After completing this how-to you will have a report showing student's last date of engagement/last day of attendance 

First Step

On Brightspace go to the Data Hub Link.

Data Hub.png

Inside of the Data Hub Select the Learner Usage Advanced Data Set.

Learner Usage.png

  1. Enter the Org Unit ID for the Academic Unit you want a report for.
    • IWU-SHS: 6650
    • IWU-SON: 6651
    • IWU-SEM: 6652
    • IWU-CAPS: 6653
  2. Select Student as the role.
  3. Enter a date range going back one month from the current date. **Always make sure that the end date is the current date.
  4. Click Export

Export.png

You will then be taken to the Job Status tab. You will have to refresh this page to see if the status has changed.
When your process is finished the status will change from processing to Complete.

Job Status.png

You will be sent an automated email in Outlook when the report is ready.
Click the link to be taken back to the Job Status page.

Email.png

  1. Click Complete to download the file.
  2. Then right-click on the download and open the folder you downloaded it to.

Complete.png

  1. Right click on the .zip you downloaded.
  2. Then click Extract All.
  3. Click Extract on the Pop-up that opens.

Extract.png

You can then open the extracted .csv in Excel.

Extracted.png

In Excel add a filter to the document to make it easier to use.

Add Filter.png

Right click on column AA and click Insert.

Insert.png

Paste this formula into cell AA2: =MAX(IF(Y2<>"",DATEVALUE(LEFT(Y2,10))+MID(Y2,12,8)),IF(AB2<>"",DATEVALUE(LEFT(AB2,10))+MID(AB2,12,8)))-5/24

Formula.png

  1. Select column AA and click Format Cells.
  2. Then chose a date format and click OK.

Format Cells.png

Double-Click on the square in the bottom of cell AA2 to fill the formula to the whole column.

Apply Formula.png

  1. To filter to the current semester, click the filter button on column G. 
  2. Then select the current Semester and click OK.

Apply Filter.png

  1. Select column AA and sort oldest to newest to bring the most in danger students to the top of the list. 
  2. Make sure to click on expand current selection before sorting. 
  3. Then click Sort.

Sort.png

Extras

If you would like to add coloring to the document:

  1. Select column AA and apply conditional formatting to cells with a value Less Than... 
  2. Enter the date three weeks ago. 
  3. Click OK. This will highlight all students in violation.

Format Cells.png

To search for a specific student, click the filter button on column K. This will allow you to search for
students by ID.

Search.png

  • Was this article helpful?