Class Schedule
21 Aug | intro
23 Aug | clients
28 Aug | servers
30 Aug | networks
04 Sep | basics lab
06 Sep | structural layer
11 Sep | presentational layer
18 Sep | working with layers
20 Sep | behavior layer
25 Sep | images & design
27 Sep | website lab
02 Oct | object layers
02 Oct | graphics
09 Oct | document markup lab
11 Oct | spreadsheets, formulas & functions
16 Oct | thoughts about data display
18 Oct | Fall Break
23 Oct | database tools |
database practice exercises |
live database practice |
next session
25 Oct | spreadsheets lab
30 Oct | relational databases
01 Nov | tables
06 Nov | relationships
08 Nov | input & output
13 Nov | SQL
15 Nov | complex queries
20 Nov | databases lab
22 Nov | Thanksgiving
27 Nov | presentation design
29 Nov | presentation delivery
04 Dec | presentation lab
13 Dec | 0800-1100 | final in class presentation
This work
is licensed under a
Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported License.
home & schedule | class blog | syllabus | contact | grades
Practice with the sorting, filtering, & subtotals tools.
You will probably have to reformat the data to make your subtotal tool work for you.
Use the Subtotal tool and, at each change in date, have the automatic subtotal sum the numbers in columns B, C, D, F, & G
I would guess that it probably wasn't because it didn't subtotal at useful intervals, so let's set up a way to make the interval useful
select column B and insert a new column named Year and formatted for numbers with no decimal places
you now need to add the four digit year numbers in the relevant cells in column B
rename column A as Date and format it so that the date reads only as the month and day
this has broken up the data in the original column A into two columns, each of which can be subtotaled
now do the same subtotal task you did above
you can use your cut and paste tools to move the subtotal labels to better places on the row where they are displayed
you can format the cells in the subtotal rows to make them stand out more clearly
you can also hide unneeded columns if you want to control the display
try a few of the other subtotal types on this data
go to column DB and filter for top "Religion - none"
now add a filter for "Region - mountain"
now add a filter for "Res16 - farm"
create a few questions of your own and see how you can use the Custom Filter tool to create new data sets
try a custom sort
try another custom sort
one more time