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
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
- Filter the data on the 13-Filter Disabled Workers worksheet to find the bottom three Congressional Districts in terms of Disabled Workers
- 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
- Use a multilevel filter on the 14-Language Preferences worksheet to find out which of the languages whose names start with the letter A only
- 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
- Use a multilevel filter on the 15-Year&ResidentialCustomer worksheet to find out which of the Month of PeriodEndDate only in March
- had an above average ResidentialCustomerCount
back to top
week of 09 April labs | sorting | filtering | pivot tables