As teachers we need to utilize data constantly. Google Forms is an excellent way to collect data from formative assessments. The purpose of formative assessment is to utilize the data to form what your next steps are. To reteach, to examine the quality of your instruction, to differentiate, to identify struggling students, etc…
Sorting the data in your spreadsheet helps you to quickly be responsive to your formative assessments. Try some of these techniques to help you sort in Google Sheets.
If you want to sort your data by class period, then by last name and then by first name that requires doing a multiple column sort.
If you have column headers you may want to freeze the first row. If you are using data from a Google Form the first row is already frozen for you.
To the right of column A and above row 1 is a blank box. I will call this the “awesome box.” Clicking on the awesome box will select all cells in the spreadsheet. RIGHT CLICKING on the awesome box gives you options for the entire sheet.
Repeat until you have selected all of the columns you want to sort by. Click the blue “Sort” button to sort the sheet.
In the toolbar is an icon that looks like a funnel. Clicking this icon will turn on filter options for the entire sheet. If you want to only filter a particular range, highlight the range first. You may need to click on the “awesome box” or highlight a column before selecting the filter icon.
In the column headers or in the upper right of your selected range, drop down arrows will appear. This is NOT the same as the drop down arrow on the column indicators. The filter arrows will appear on the actual cells.
Clicking the drop down arrow shows a list of all of the values in the range of that column. By default all of the options are selected. To view rows that only show certain data values, click on “Clear” to uncheck all of the values.
Click on the data values that you want to filter by. You can select multiple options. You can also use the search box in the filter options to help you locate the desired data more quickly. Click the blue “OK” button.
The rows of data that do not satisfy the filter are hidden. You can go back to the filter drop down arrows to change the filtering options.
=SORT ( )
I usually prefer not to mess with my original data. I prefer to manipulate my Google Forms data in a separate tab. You can use the formula =sort( ) to bring data from one area of the spreadsheet to another.
In a blank cell type =sort(
Highlight or type in the range of data that you want to have sorted.
Instead of saying the name of the column, you want to count how may columns you are sorting. If are possibly displaying multiple columns from your data but do not necessarily want to sort by the first column. After the comma put a 1 to sort by the first column, a 2 to sort by the 2nd column, a 3 to sort by the 3rd column, etc…
If you have column headers do not include these in the sorting range. Your column headers will become sorted into the data.