SILS iSchool

week of 29 October 2020

sorting | filtering | pivot tables



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


Creative Commons License
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

Use filters to temporarily hide some of the data in a table, so you can focus on the data you want to see.

back to top

Still using your downloaded workbook ...

Demonstrate facility with a number filter

  1. Filter the data on the 15-Filter Disabled Workers worksheet  to find the bottom three Congressional Districts in terms of Disabled Workers
  2. Do not sort the results. Simply show the results of filtering out all but the bottom three districts.

back to top

Still using your downloaded workbook ...

Demonstrate facility with a number filter, after having used an exclusion filter to show only one subset of data 

  1. Use a multilevel filter on the 16-Filter Language Preferences worksheet to find out which of the languages whose names start with the letter A only
  2. had Receipt Count (excluding 53rd week) between 1000 and 4000

back to top

Still using your downloaded workbook ...

Again, demonstrate facility with a number filter, after having used an exclusion filter to show only one subset of data 

  1. Use a multilevel filter on the 17-Filter Year&ResidentialCust worksheet to find out which of the Month of PeriodEndDate only in March
  2. had an above average ResidentialCustomerCount

back to top

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