2.5.2 Sorting the spreadsheet

By default the spreadsheet is sorted alphabetically by username. In this section all of the student information columns are displayed. The arrows in the column header are turned off to show the information more easily. To turn off column header arrows visit Section 2.5.3


Figure 2.5.2 A: Default sorting of the table.



The teacher can sort the table by pressing any of the top level spreadsheet columns. The first click sorts the table by that column in descending order and the preceding click sorts the table in ascending order.

The teacher clicks on the 'Project 1' cell.


Figure 2.5.2 B: The table is now sorted by Project 1 grades.



The table now displays the students with the highest grades on Project 1 in descending order. If two students have the exact same grade on an assignment, they are sorted secondly by username. The teacher now wants to sort the table by major. He wants to see how different majors do in his class. The teacher clicks on the 'Major' cell.


Figure 2.5.2 C: The table is now sorted by Major.



The table now displays the students in order of their major lexicographically. If students have the same major they are sorted secondly by username.




Prev: Enter Grades for Student | Next: Show different classes | Up: Using the Spreadsheet | Top: index