OBJECTIVE OF THE CLASS
Learn to organize information contained in a table, through the Sort and Filter tools of Google Sheets.
EXAM REVIEW Clarification of doubts, comments and important details after taking the exam and having obtained a grade. How did it go? What did you fail at? What was the most difficult? What do you think should be revised or strengthened? COVER PAGE PERIOD 3 After the review period, a short time will be determined for the creation of the cover of Period 3, which will continue with the theme of the spreadsheet with filters, sorting, logical and graphic functions, remember that the cover must use the same data than the previous period.
TABLE
We’ll call Table to a limited collection of information, stored and organized within a spreadsheet.
The line records are organized by the table headers, which we will call Fields.
For example:
In a "directory" we record the data of many persons but we write them by the headers, that is, in their corresponding field.
SORT
This is a spreadsheet tool specifically used on a data table. With it, we can place the data records according to a certain criteria, for example, ordered by surname, or by age. The order may be ascending or descending, that is, from A-Z or Z-A, from the smallest to the largest number or vice versa.
Obviously the order of the rows will be altered, but the data will not be mixed with other records.
This tool is used to organize and analyze the information contained in a table.
Look at the table above and tell: which record would be the first if the table is sorted by age in ascending order? or What would be the first if they are ordered by last name but in descending order?
To apply Sorts in Google Sheets I suggest the following procedure
Select the entire table, from the names of the fields to the last data.
Display the DATA tab and select the SORT RANGE option.
It will ask you if the table has headers, because it shouldn't involve them in the ordering.
Finally, you will choose the main Sorting criteria.
Optionally, you can use secondary Sortering criteria, which will be applied after the main one.
Let's do a couple of examples with the table proposed by your teacher, if the examples are done completely and correctly we will do an example of the filters tool.
FILTERS
This is another tool to analyze and locate information within a table but, unlike sorting, the filters will only show some records from the table, those that match the filter criteria.
For example, in the table above you can use filters to show only 14-year-olds. Who are they?
Another example, use a filter to show the people who live in Zapopan. Who are they?
To apply Filters in Google Sheets I suggest the following procedure
Select the entire table, from the names of the fields to the last data.
Display the DATA tab and select the CREATE FILTER option.
You will see a control in each header of the table that will show you the filtering options.
To filter, choose the filter criteria.
Optionally you can filter a table that has already been filtered, selecting the control of another header.
To show the complete table you will have to mark all the criteria again.
ACTIVITY 01
You will apply the following sorting and filters examples. You will make a copy of the result and paste it under the original table (as we did in the example together during class).
Sort the table using the Last Name, ascending, as the main criteria. Copy and paste the result. Change the header fill color to ORANGE.
Sort the table using age, descending, as the main criteria. Copy and paste the result. Change the header fill color to YELLOW.
Filter the original table so that only female people are shown. Copy and paste the result. Change the fill color of the header to GREEN.
Filter the original table so that only people who play “Fútbol” are shown. Copy and paste the result. Change the header fill color to BLUE.
Turn off filters to show the entire original table.
You will deliver the file with the 5 results or mini tables through Classroom, as shown below.
