SILS iSchool

week of 13 April 2021



Value Added | daily

Class Schedule

Basics | sessions 01-03
  1. 19 Jan intro and clients | lecture | labs
  2. 26 Jan servers and command line | lecture | labs
  3. 02 Feb networks and protocols | lecture | labs
Web Development | sessions 04-08

  1. 09 Feb structural layer | lecture | labs
  2. 16 Feb presentational layer | lecture | labs
  3. 23 Feb using a structure | lecture | labs
  4. 02 Mar behavioral layer | lecture | labs
  5. 09 Mar design thoughts | lecture | labs
Dealing with Markup | sessions 09-10
  1. 16 Mar control objects and display | lecture | labs
  2. 23 Mar tools that read markup | lecture | labs
Working with data | sessions 11-14
  1. 30 Mar formulas, functions, vectors | lecture | labs
  2. 06 Apr data display | lecture | labs
  3. 13 Apr manipulate data sets | lecture | labs
  4. 20 Apr relational data bases | lecture | labs
Presentations | sessions 15-16
  1. 27 Apr designing a presentation | lecture | labs
  2. 04 May 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 alphabetically (from A to Z),
  3. and then by Year completed from SMALLEST to largest.

back to top

week of 13 April labs | sorting | filtering | pivot tables