meets Tuesday and Thursday from 0800-0915
office hours in Manning 112
Class Schedule
10 Jan | intro
15 Jan | clients
17 Jan | servers
22 Jan | networks
24 Jan | basics lab
29 Jan | structural layer
31 Jan | presentational layer
05 Feb | working with layers
07 Feb | behavior layer |
12 Feb | images & design
14 Feb | website lab
19 Feb | document markup
21 Feb | graphics
26 Feb | document markup lab
28 Feb | spreadsheets
05 Mar | formulas & functions
07 Mar | data display
19 Mar |
database tools |
database practice exercises |
live database practice |
next session
21 Mar | spreadsheets lab
26 Mar | relational databases
28 Mar | tables
02 Apr | relationships
04 Apr | input & output
09 Apr | SQL
11 Apr | complex queries
16 Apr | databases lab
18 Apr | presentation design
23 Apr | presentation delivery
25 Apr | presentation lab
30 Apr | 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