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 | tools that read markup
26 Feb | document markup lab
28 Feb | spreadsheets
05 Mar | formulas & functions
07 Mar | data display
19 Mar | database tools
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
You will be called upon to demonstrate specific relational database skills.
The task will be released as five parts,
one a day,
as we practice Access components.
Everything in this task is something we will have demonstrated and/or tried in class.
You are to create a book database for a private client, not too unlike Mr. Pitt on Seinfeld. The client has his own library and needs you to organize his holdings and be able to order new books for his library when he wants them.
You may work on task 03, 04, and 05 in groups. You may, if you choose to, also do task 06 as a group project. These are some rules of thumb to follow for group work in INLS161.
Note who your work group members are and be sure you know them by face and by email address. As you work together, I would like you to follow this process for your work:
Though there are several different commercial relational database software applications, we will use Microsoft Access for this purpose because it will provide an appreciation for relational databases. Additionally, other database classes in SILS assume a working knowledge of Access as a baseline skill.
We will build this database step by step in class. The exercises you will have after each class will be part of the task.
You have a gradesheet to provide guidance. Everything on that gradesheet will be analogous to something we will have done in class.
Save the finished product using the standard file name structure for this class
An example of a standard file name might be johnson.pat.20190417.task05.database.accdb
Add a hyperlink to your task 05 page to the completed task file which will be stored in your Sakai dropbox location for INLS161..