week of 09 April 2020
Value Added | daily
Class Schedule
Basics | sessions 01-03
- 09 Jan intro and clients | lecture | labs
- 16 Jan servers and command line | lecture | labs
- 23 Jan networks and protocols | lecture | labs
Web Development | sessions 04-07
- 30 Jan structural layer | lecture | labs
- 06 Feb presentational layer | lecture | labs
- 13 Feb using a structure | lecture | labs
- 20 Feb behavioral layer | lecture | labs
Document Markup | sessions 08-09
Working with Data | sessions 10-13
- 26 Mar formulas, functions, vectors | lecture | labs
- 02 Apr data display | lecture | labs
- 09 Apr manipulate data sets | lecture | labs
- 16 Apr relational data bases | lecture | labs
Presentation | session 14
This work
is licensed under a
Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported License.
home & schedule | syllabus | contact | grades
Spreadsheets can be flat file databases.
The tools in Excel can manipulate such databases to array the data exactly as needed.
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.
back to top
Still using your downloaded workbook ...
Do a single level sort
- Sort the data rows on the 03-NC ZIP codes worksheet by ZIP Code.
- Have the sort display from smallest to the largest.
back to top
Still using your downloaded workbook ...
Do a multi-level sort
- Sort the data rows on the 06-VA-Religion worksheet
- first by Sikh from LARGEST to smallest,
- and then by Catholic from SMALLEST to largest.
back to top
week of 09 April labs | sorting | filtering | pivot tables