Week

Topic

Reading

1 (Aug. 28)

• Course Overview 
• Examples of simple data-driven web sites 
• Online data-driven quiz (Larry Chavez)
• Online course availability (Cheng-Yi Yu)
• Login verification and new user signup (Bill Pegram) 
• Databases - Tables, Queries
• Relational (Multiple Table) Databases
• Creating a Single Table Database in Microsoft Access
• Creating Select Queries in Design Mode for Single Table Databases
• Creating Relationships in Access
• Creating Select Queries in Design Mode in Access for Relational Databases Where Relationship Exists

Chapter 1,2

2 (Sept. 4)

• registration database
• Forms, Reports in Access (briefly)
• SELECT, UPDATE, INSERT, AND DELETE Queries in SQL
• SQL Mode in Access
• Update, Insert, and Delete Queries in Access (briefly)
• Microsoft Query

Chapter 3, Create Database Assignment

3 (Sept. 11)

• HTML text formatting
• Insertion of images in web pages
• HTML tables
• HTML links
• HTML forms

Chapter 4; Chapter 7 (pp. 227-237);

4 (Sept. 18)

• Microsoft Personal Web Server - Installation
• ASP - Connecting to a Database, Executing SQL commands
• Displaying All Records of a Table in an ASP (pp. 274-279) VBScript code, JavaScript code

(skip client-side scripting section of Chapter 7)

Chapter 5, 8 Project Clarification Assignment

5 (Sept. 25)

• Display all Records of a Table, Creating Links from each row to the same file but Passing URL Parameters to an ASP (pp. 279-282) ("summary page")
• Retrieving URL Parameters into an ASP and Using These to Display More Information About a Given Record (pp. 282-285) -- ("details") page

Recreate Data-Driven Page Assignment

6 (Oct. 2)

• Debugging ASP (pp. 286-290)
• Help with Error Messages
• JavaScript - VBScript Differences
• Connecting to an Excel Spreadsheet
• Using Includes
• Using IF statements to control which HTML is outputted (pp. 290-293)
• Creating a Search Form that Creates URL Parameters -- use "details" page to display search results  (pp. 296-306 example) - Form and Action code sample
• Creating Form and Action pages to add a record to a Table - Form and Action code sample
• Suppressing Form Values in URLs (pp. 332-335) - METHOD="POST" and Request.Form

Chapter 8

7 (Oct. 9)

• Dynamic SQL statements

• Creating Form and Action pages to modify a record in a Table FeedForm, Form, and Action code sample

• Changing Several Tables from a Single Set of Pages 

8 (Oct. 16)

• Creating Action page to delete a record in a Table - Action code sample

• Writing and Reading Cookies with ASP (pp. 308-309, 328-331) - Form, Write, and Read code sample

9 (Oct. 23)

• Converting Single Quotes into 2 Single Quotes in Form Input
• Using NetMeeting
• Designing a Database Driven Discussion Tool Using a Relational Database - Design

10 (Oct. 30)

• Use the Database Driven Discussion Tool
• Evaluate it