Sorting and Filtering the Student Data Table

The student data table includes several powerful sorting and filtering tools that allow you quickly jump to important information like viewing data for a specific student or filtering for students that match specific criteria, like students who are struggling or who are excelling in the class. You can also then use the Delphinium Gradebook messaging tool to communicate directly with these students. Sorting and filtering tools include the following:

  • Sorting columns

  • Filtering text boxes

  • Filtering check boxes

  • Filtering sliders

  • Filter count

Sorting Columns

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.

Filtering Check Boxes

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.

Filter Count

As you filter the student data table using the filter tools described above, a live count of the number of the students currently shown in the table is displayed in the top right of the student data table in the header to the "Details" column. This number is useful when you are trying to count how many students match a specific filtering criteria. For example, you can quickly get a count for the number of students in the class by not filtering at all; or you can quickly identify the number of students currently earning an A grade.