SILS iSchool

21 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
21 Mar | spreadsheets lab | next session

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





We will be turning to relational databases in the next session,
so do these readings to prepare yourselves.

Preparations for relational database session

Access 2007: The Missing Manual, 1st Edition

Read

In Access 2007: The Missing Manual, 1st Edition,
read 1. Creating Your First Database.

It wouldn't hurt to read

Read this linked article twice

  1. Read it prior to the first relational database session so you will have an idea about why relational databases are useful.
  2. Then read it again after the tables session and prior to the session about relationships

Although we will not get into relationships until the third relational database session, an understanding of how to decompose your task into related tables will help you decide how to create the tables you will later need to relate.

back to top

If you use a Mac, you have two choices to be able to use Access

Best choice: virtualization software

Good choice: virtual server support

Pick one choice and be ready with it by the next class session.

back to top