Course Syllabus

INDE 498A : WEB ENABLING INVENTORY SYSTEMS (4 credits)

Class Home Page: http://www.cev.washington.edu/lc/CLWEBINV/

Class Syllabus: http://www.cev.washington.edu/lc/CLWEBINV/syllabus.html

DESCRIPTION

This course will explore the more practical aspects of enabling E-commerce through the World Wide Web. By investigating the most popular technologies used by organizations to track inventory on-line, students will get hands-on experience implementing a Web-enabled inventory system. Students will gain skills through rigorous use of four popular technical standards: HTML, XML, CGI, and SQL.

APPROACH

The course will consist of faculty and guest lectures, video presentations and in-class discussions.

PREREQUISITES

Active full-time student status

DAY/TIME/PLACE

Spring Quarter 2005
Mondays/Wednesdays, 2:30-4:20PM
SAV 241

CREDITS

4 credits will be given for this course upon the successful completion of:

GRADING

Grading will be calculated based on the percentages given above.

INSTRUCTOR

Bruce Campbell
http://www.hitl.washington.edu/people/bdc

Lecturer, Industrial Engineering

Research Scientist, Human Interface Technology Laboratory
Box 352142
Seattle, WA 98195

Office: 202 Ocean Sciences Building
Office Hours: Tuesdays/Thursdays 9:30AM-11:30AM (Fridays by appt)
Telephone: OSB Office: 685-5356
e-mail: bdc@hitl.washington.edu

RESOURCES

Books

1. XML FOR WORLD WIDE WEB VISUAL QUICKSTART GUIDE - Elizabeth Castro - $19.99 - required
2. HTML 4 FOR THE WORLD WIDE WEB - Elizabeth Castro - $19.99 - required

Course Handouts and On-Line Readings as identified below and in class

CLASS DATE SCHEDULE
Date
Topic
Assignment

28 Mar
Welcome to Class

30 Mar

Diving into the Web Opportunity:

  • The Class Project
  • Web versus Internet
  • Client versus Server
  • Scripting versus Programming versus Languages
  • Versions of HTML (2.0, 3.2, 4.0) and XHTML
  • Cascading Style Sheets
  • DHTML
  • XML
  • Read last year's Project 1 Requirements document on-line: http://www.cev.washington.edu/lc/CLWEBINV/proj1.html
  • Continue Reading Chapters 1-6 of HTML 4 For the World Wide Web (you can just skim chapter 5)
  • Begin your interactive exploration of HTML (or XHTML) using the book examples and pages you find on-line.
  • Investigate the examples from previous years' projects (from links on class Home Page)

4 Apr

HTML Boot Camp

  • Let's Do Some Basic HTML
  • Software for Creating Web Pages:
    • Browser
    • Text Editor
    • HTML Editor
    • (Go Live, Front Page, Dream Weaver)
  • The Standard Setting Organization:
    • The World Wide Web Consortium (w3.org)
  • Vocabulary
    • URL
    • TCP/IP
  • Continue interacting with chapters 1-6 of our HTML 4 book and use the Web to find more information on the topics to the left.

6 Apr

HTML Boot Camp Continued

  • Links and Images
  • Forms
  • Questions Regarding Your Attempts at HTML
  • Practice by doing chapters 1-6 of the HTML 4 book and use the Web to find more information on any HTML topic of interest.
  • Prepare to discuss the class project next Monday

11 Apr

Introduction to Course Project

  • Continuation of HTML Bootcamp
    • Table Layout
    • Area Maps
    • Cascading Style Sheets
    • Advanced Spacing and Padding
  • Edition 4 of HTML Book: Read Chapters 7, 8, 9, 10, 11
  • Edition 5 of HTML Book: Read Chapters 7, 13, 14, 15, 16

13 Apr

Introducing XHTML

  • Introduction to XHTML as an XML encoding of HTML
  • Clarity on the self-directed method and its applicability to the information age - how well do you do?
  • Frame sets
  • Study the on-line document outlining your project work responsibilities
  • Practice your HTML or XHTML skills in regards to the project goals

18 Apr

HTML/XHTML Examples

  • XHTML Examples
  • Question and Answer session on HTML and XHTML
  • Edition 4 of HTML Book: Read Chapters 13, 14, 15, 16
  • Edition 5 of HTML Book: Read Chapters 8, 9, 10, 11
  • Practice your HTML or XHTML skills in regards to the project goals

20 Apr
Introduction to XML
  • In-class Discussion
  • XML Syntax, Rules, and DTDs
  • Lightning Strike Markup Language
  • Dive into XML Readings
  • Investigate the case study on-line

22 Apr
XML Boot Camp
  • DTDs, XML Schema, XSLT
  • Project 1 Due Saturday Night 11:59PM
  • Turn in a link to your Project 1 (or floppy disk)
  • Review chapters 1-4 in XML Readings

25 Apr
XML Boot Camp II
  • XML Technologies Technical Review
    • XML, XML Schema, DTD, and XSLT continued
    • Case Studies in XML Use
  • Review chapters 5-7, and 10 in XML Readings
  • Project 1 Grading Comments

27 Apr
Database Modeling Day
  • Required Attendance Day
  • Relational Databases
  • Determining the Schema
  • Database Modeling Exercise
  • Review chapters 5-7, and 10 in XML Readings
  • Read about Project 2
  • Prepare for HTML/XHTML/XML Exam on Monday

2 May
HTML/XHTML/XML Exam Day
  • XML, XML Schema, DTD, and XSLT questions
  • HTML/XHTML/XML Exam
  • Study Project 2 Database Model

11 May
Adding the Database
  • Project 2 Discussion
  • Structured Query Language (SQL)
  • CGI in Action
  • Java Server Pages in Action

13 May
Optional Review Day
  • Makeup Day for May 9th Lecture

16 May
SQL Primer
  • SQL Keywords
  • Examples of SQL
  • Study the project relational database schema and ask questions for clarity

18 May
Web-Enabling Data
  • Dynamic Forms with JSP and SQL's INSERT INTO Command
  • Dynamic Reports with JSP and SQL's SELECT Command

23 May		 SQL Exam Day
  • Review of course technology integration
  • SQL Exam

25 May		 Tag Libraries
  • The Center for Environmental Visualization's (CEV) Information Services
  • Using Tag Libraries to Hide Java Code