SILS iSchool

19 Mar 2019

meets Tuesday and Thursday from 0800-0915

in Carolina Hall 220

Contact options

office hours in Manning 112


Value Added | daily

Class Schedule

Basics | sessions 01-05

10 Jan | intro
15 Jan | clients
17 Jan | servers
22 Jan | networks
24 Jan | basics lab

Web Development | sessions 06-11

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

Document Markup | sessions 12-14

19 Feb | document markup
21 Feb | graphics
26 Feb | document markup lab

Spreadsheets | sessions 15-19

28 Feb | spreadsheets
05 Mar | formulas & functions
07 Mar | data display

 09-17 Mar | Spring Break 

19 Mar | database tools | database practice exercises | live database practice | next session
21 Mar | spreadsheets lab

Relational Database | sessions 20-26

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

Presentation | sessions 27-30

18 Apr | presentation design
23 Apr | presentation delivery
25 Apr | presentation lab
30 Apr | 0800-1100 | final in class presentation





The Department of Defense reports casualty data using downloadable Excel spreadsheets.

Practice with the some current data

The Department of Defense reports casualty data in spreadsheets form.

Download a spreadsheet and try out your database tools with it.

You might try sorting the data first by service, then by component, then occupation code prefix, and then by occupation code.

You might also try different filters

  • since the header row is not in the first row, be certain to select the actual header row so the filter tool knows where to apply the filter
  • do a simple filter by state
  • do a combined filter by service and then by state
  • do a custom filter to see how many of the names of are people between 18 and 22 years old
  • do a custom filter to see Hispanic names
    • this isn't a precise filter, but you might do a Boolean "or" filter looking for names that end in either "A" or "Z"
    • on second thought, that won't work? Can you see why not?
      • the data isn't arrayed so that you can easily filter on the last letter of the name.
      • were the data arrayed so that the last name was a field unto itself, one could apply this filter
      • or one can filter on Column T

so create some custom filters of your own, looking for record fields that respond to an "or" or an "and" combination of values

back to top