SILS iSchool

week of 13 April 2021

sorting | filtering | pivot tables



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


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 13 April labs | sorting | filtering | pivot tables