SILS iSchool

week of 29 October 2020



Value Added | daily

Class Schedule

Basics | sessions 01-03
  1. 13 Aug intro and clients | lecture | labs
  2. 20 Aug servers and command line | lecture | labs
  3. 27 Aug networks and protocols | lecture | labs
Web Development | sessions 04-07

  1. 03 Sep structural layer | lecture | labs
  2. 10 Sep presentational layer | lecture | labs
  3. 17 Sep using a structure | lecture | labs
  4. 24 Sep behavioral layer | lecture | labs
Dealing with Markup | sessions 08-09
  1. 01 Oct control objects and display | lecture | labs
  2. 08 Oct tools that read markup | lecture | labs
Working with Data | sessions 10-13
  1. 15 Oct formulas, functions, vectors | lecture | labs
  2. 22 Oct data display | lecture | labs
  3. 29 Oct manipulate data sets | lecture | labs
  4. 05 Nov relational data bases | lecture | labs
Presentation | session 14
  1. 12 Nov designing and delivering a presentation | lecture | labs


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

  1. Sort the data rows on the 13-sort NC ZIP codes worksheet by ZIP Code.
  2. Have the sort display from smallest to the largest.

back to top

Still using your downloaded workbook ...

Do a multi-level sort

  1. Sort the data rows on the 14-sort state, then year worksheet
  2. first by State from LARGEST to smallest,
  3. and then by Year completed from SMALLEST to largest.

back to top

week of 29 October labs | sorting | filtering | pivot tables