Sorting and Filtering the Student Data Table

You can sort columns so that their values are either in alphabetical or numerical order by clicking the up and down icon arrows next to the column title. Clicking the arrows once will sort the column in one direction, top to bottom, and clicking it again will reverse the order, bottom to top. Sorting is a useful way to focus on important information. For example, by clicking the sorting icon next to the "Points" will move the students with the fewest points to the top of the table and allow you to see which students are struggling most.

Filtering Text Boxes

When you want to view the data for a specific student, it is often useful, especially in large classes, to use the "Filtering Text Boxes" in the "First Name" and "Last Name" columns. Begin by clicking inside a Filtering Text Box, then type the first few letters of the name. Student rows that don't start with those characters will be hidden and only those that match will be displayed. In this way, you can quickly filter the student data table to view data for a specific student.

To clear a "Filtering Text Box" and view all the rows in the student data table again, click the X icon in the "Filtering Text Box" or delete all the characters in the box.

The "Section" and "Grade" columns can be filtered using the "Filtering Check Boxes". Display the "checkbox options" by clicking the filter icon. A tool tip will appear with a checkbox list including all the course sections or all of the grade levels. By selectively checking check boxes in the lists, you can hide and show student rows that match checked options. This is useful when you want to only view students in a specific section or with a specific grade level. For example, you could filter the student data table to only show students who are failing.

To clear a "Filtering Check Box" and view all the rows in the student data table again, click the X next to the "filter icon: below the column title, or selecting all the checkbox options in the list.

Filtering Sliders

Numeric data columns, like points and % of points earned out of points possible, can be filtered using "Filtering Sliders". Display the "Filtering Sliders" by clicking on the double arrow. A tool tip will appear with a slider in it. Each filtering slider has two "handles" at the min and max of the slider. You can show/hide rows in the student data table by sliding the min and max "slider handles" to make the display range narrower or wider. This is useful when you want to identify students in a specific range of points. For example, you could first filter for students who have 0 to 20 points to identify students that are having trouble getting started in the class; or you could filter for 600 to 1000 points to identify students who are doing very well in the class.

To clear a "Filtering Slider" and view all the rows in the student data table again, click the X next to the "double arrow icon" below the column title, or slide the "handles" to their min and max positions.