Tools for Information Literacy ⑫ Data control

Sorting rows by column data

According to Microsoft

Sorting data is an integral part of data analysis. ... Sorting data helps you quickly visualize and understand your data better, organize and find the data that you want, and ultimately make more effective decisions.

Still using your downloaded workbook ... do a single level sort

Why we do this	What we are to do
to sort by one value in the data set	Sort only the data rows on the 08-Single Level Sort worksheet by Population Estimate as of July 1 - 2010. Have the sort display from smallest to the largest.
	be sure to sort all the rows by the values in one columns; do not sort the values in one column

Do a multi-level sort

Why we do this	What we are to do
to sort first by one value in the data set then to sort any duplicate values in the first sort by a second value	Sort only the data rows on the 09-Two Level Sort worksheet first by German Champion, from largest to smallest, and then by Level from smallest to largest.
	It will sort all the rows by the number of German championships won; then, when it finds a duplicate number of championships, it will sort the duplicates by the level value.