Organizing Data

Analysis: The process used to make sense of the data collected.

Sorting and Filtering

Using SQL to filter data:

SELECT _____
FROM   _____
WHERE _____  AND _____

Sorting Data in Spreadsheets

Sort sheet: A spreadsheet menu function that sorts all data by the ranking of a specific sorted column and keeps data together across rows.

Sort range: A spreadsheet menu function that sorts a specified range and preserves the cells outside the range.

Writing the SORT function

SORT(DataRange,ColumnNumber,True/False)
*True means sort the data in ascending order. 
**False means to sort the data in descending order.

You can add another sorting criterion.

Sorting Data in SQL

ORDER BY: A SQL clause that sorts results returned in a query.

SELECT _____
FROM _____
WHERE _____ AND _____
ORDER BY "Criteria" (DESC)
#If you include DESC in the clause, SQL will sort the data in descending order. 
#If DESC is not included, SQL will sort the data in ascending order.