• 1  Student List by Criteria Report
• 2  Adding Conditions
• 3  Results Table

Student List by Criteria Report

This report produces a list of students' contact information, filtered by grade, level of participation, or a combination of both. This report can be used to identify students at varying levels of performance and engagement, in order to provide feedback or intervention. This report provides a list of student email addresses that can be copied or exported to CSV.

1. To begin, click on the Reports tab at the top of your main course page.

2. Then select Advanced usage from the list under Reports.

3. Click on Add a Report.

4. Select the Student list by criteria report.

5. Click on the Add button.

Adding Conditions

Once you have added the report, you will have the choice between two buttons which will allow you to select the type of criteria (conditions) that you’d like to add. The criteria can be mixed and matched to generate the final list.

The simplest filter to apply is the Grades button, which will allow you to select a grade item from your course, an operator (greater than, less than, or equal to), and a number.

In the example above, the selected options would allow us to filter for students who achieved a grade higher than 15 on the selected 'Midterm' grade item. Click on the + to add the condition.

In a similar fashion, the Actions button allows you to select an activity, action, operator (greater than, less than, or equal to), and a number. This allows a wider variety of options to select different activities (quizzes, assignments, forums etc) or even different topics of content, which can be filtered even further by different actions (i.e., 'View, Assignment submitted', 'Post created' etc). Note that the report will display students that match ALL of the given criteria.  There is currently no way to generate results based on matching ANY of the given criteria instead.

The Dates section can be used to further filter your results using the dropdowns. You can also click on the Show Advanced setting in the bottom-right corner to access the Users per page setting, which lets the user control how many results will be displayed on one page below. If the total number of users exceeds this amount, the results will be displayed across multiple pages.

Results Table

Once you are satisfied with the conditions you have selected, click on the Apply filter button. This will generate a table containing the list of students (including their profile picture, full name, and email address) who meet the criteria you selected.

To select individual users from the list, you can click on the checkbox to the left of the user or simply click the checkbox at the top to select all users. If multiple pages are used, you’ll be able to control the active page by using the pagination controls at the bottom of the table.

The copy button in the top right of the table can be used to copy the email addresses of the currently selected users to your clipboard. You can then open an email in Google and paste to drop the email addresses directly in the “to/cc/bcc” field to contact the filtered students.

Note: some older browsers or operating systems may not support adding information directly to your clipboard (newer versions of Chrome or Firefox all generally support this feature).  If this fails, an error will be displayed to you.

There is also an export to a CSV file button in the top right corner that will allow you to export the entire list of filtered students into a .csv document.  The exported CSV document is configured to allow for import into Google contacts so that you can easily create a list of contacts if desired.