The Filter

You are able to filter data based on one or more independent queries across Course Insights. The filter is available on the Enrolment, Engagment, AssessmentStudents and Student pages.

Create a filter(s)

  1. Select either Match All (which inserts an "and" in between queries) or Match Any (which inserts an "or" in between queries) from the dropdown list. 

match all or any

  1. Select a variable from the Demographic, Enrolment, Engagement or Assessment dropdown list.

variable dropdown

  1. Select an operator from the Operator dropdown list. 

Note: Depending on the variable selected, only certain operators will be available for selection. 

operator dropdown

  1. Select a value from the value dropdown list

Note: Depending on the variable selected, you will have the option to either enter a value (i.e. Blackboard Engagement = "20") in the textbox or select a value (i.e. Tutorial = "Tutorial - T03") from the dropdown list.

operator

OR enter a number in the value textbox.

value dropdown

  1. Repeat Steps 2 to 5 to create more complex queries.

Make a query time specific

  1. To make your query time specific, select a week from the Please select a week dropdown list.

date dropdown

  1. Alternatively, select Choose custom date range from the Please select a week dropdown list.

custom date range

  1. Select the first date in the date range followed by the last date to apply a custom date range.

selecting date range

Apply the filter(s)

Once you are ready to apply the filter, click on the APPLY FILTER button.

filter applied

Remove a filter

Click on the button to remove a particular filter.

remove a filter

Reset the date filter

Click on the date dropdown and select Reset date filters from the dropdown list.

reset date filter

Reset the entire filter

Click on the RESET FILTER button to reset the filter. 

reset filter

Email students who have not accessed either Blackboard or edX (Edge) by the end of Week 1

  1. Access the Students page.
  2. Select Match Any from the Filter Builder dropdown list. 
  3. Select Blackboard Engagement from the Engagement dropdown list. 
  4. Select equals from the Operator dropdown list.
  5. Enter in the Value textbox.
  6. Select Edge Engagement from the Engagement dropdown list. 
  7. Select equals from the Operator dropdown list.
  8. Enter in the Value textbox.
  9. Select Week 1 from the Please select a week dropdown. 
  10. Click on the APPLY FILTER button.

students page filter

  1. Check the select all checkbox in the table. 
  2. Click on the EMAIL SELECTED STUDENTS button.

email selected students

Email students who have failed an assessment task and have low engagement with online content prior to census date

  1. Access the Students page.
  2. Select Match All from the Filter Builder dropdown list. 
  3. Select Blackboard Engagement from the Engagement dropdown list. 
  4. Select less than or equal to from the Operator dropdown list.
  5. Enter the threshold value (e.g. 50) in the Value textbox.
  6. Select Edge Engagement from the Engagement dropdown list. 
  7. Select less than or equal to from the Operator dropdown list.
  8. Enter the threshold value (e.g. 50) in the Value textbox.
  9. Select the first assessment task from the Assessment dropdown list. 
  10. Select equals from the Operator dropdown list.
  11. Enter in the Value textbox.
  12. Select Custom date range from the Please select a week dropdown. 
  13. Select dates ranging between the beginning of semester to census date
  14. Click on the APPLY FILTER button.

failed assessment and low engagement filter

  1. Check the select all checkbox in the table. 
  2. Click on the EMAIL SELECTED STUDENTS button.

email selected students

Email students who did poorly on an assessment item and have low engagement with online materials

  1. Access the Students page.
  2. Select Match All from the Filter Builder dropdown list. 
  3. Select Blackboard Engagement from the Engagement dropdown list. 
  4. Select less than or equal to from the Operator dropdown list.
  5. Enter the threshold value (e.g. 50) in the Value textbox.
  6. Select Edge Engagement from the Engagement dropdown list. 
  7. Select less than or equal to from the Operator dropdown list.
  8. Enter the threshold value (e.g. 50) in the Value textbox.
  9. Select assessment task from the Assessment dropdown list. 
  10. Select less than or equal to from the Operator dropdown list.
  11. Enter the threshold value (e.g. 2) in the Value textbox.
  12. Click on the APPLY FILTER button.

low enagagement and assessment tasks

  1. Check the select all checkbox in the table. 
  2. Click on the EMAIL SELECTED STUDENTS button.

email students