| Meeting |
Date |
Topic & Readings |
| 1 |
9/23
Wed. |
Lecture: Introduction to Course
1. Add your name to the on-line
class roster
2. Create an Aspen
Account (Aspen.csandvig.com) |
| 2 |
9/25
Fri. |
Lecture: Server-side
Scripting, Schematic,
Server-side includes
Reading:
Server Side Includes |
| 3 |
9/28
Mon. |
Lecture: Getting Started with PHP,
Reading: Sklar Ch. 1 & 2: Orientation, Working with Text and Numbers |
| 4 |
9/30
Wed. |
Lecture:
Working with Text and Numbers
Reading: Sklar Ch.2: Working with Text and Numbers
Assignment 1 due (SSI) |
| 5 |
10/2
Fri |
Lecture: Control Structures,
Arrays
Reading: Sklar Ch. 3: Making Decisions and Repeating Yourself, Ch. 4: Working with Arrays (to page 56 only) |
| 6 |
10/5
Mon. |
Lecture: Functions
Reading: Sklar Ch.5: Functions
Assignment 2 due (variables)
New! Aptana PHP
development environment |
| 7 |
10/7
Wed. |
Lecture: Working with Forms and Validation
Reading: Sklar Ch. 6: Making Web Forms
|
| 8 |
10/9
Fri. |
Lecture: Working with Forms & Validation (continued)
|
| 9 |
10/12
Mon |
Lecture: Working with Cookies and User Sessions
Reading: Sklar Ch. 8: Remembering Users with Cookies and Sessions
Assignment 3 due (control
structures, functions) |
| 10 |
10/14
Wed. |
Lecture: Using Relational Databases
Reading: Database
Basics: Part 1 |
| 11 |
10/16
Fri. |
Lecture: Creating & reading database records
Reading: Sklar Ch. 7: Storing Information with Databases, phpMyAdmin tutorial |
| 12 |
10/19
Mon. |
Guest speakers:
Matt Plude & Kylah Dolen from Clearwire.
WWU MIS graduates.
MISA resume workshop
Lecture: Using SQL
Statements to
Query Data
Reading: Forta Ch. 1-6, 12
Assignment 4 due (forms,
cookies, session) |
| 13 |
10/21
Wed. |
Lecture: SQL continued
Overview HW5
|
| 14 |
10/23
Fri. |
Lecture: Normalizing a Relational
Database
Reading: An
Introduction to Database Normalization |
| 15 |
10/26
Mon. |
Assignment 6 overview
ListCityZips.php (source)
Assignment 5 due (reading, adding, updating and deleting database records) |
| 16 |
10/28
Wed. |
Midterm |
| 17 |
10/30
Fri. |
Lecture: Review midterm results. Overview of final
project. |
| 18 |
11/2
Mon. |
Lecture: Overview of assignment 7: Bookstore home, search response & product pages
Assignment 6 due |
| 19 |
11/4
Wed. |
Lecture: Debugging &
Error Handling |
| 20 |
11/6
Fri. |
Work session in CF21 to work on bookstore project |
| 21 |
11/9
Mon. |
Lecture: Overview of project: shopping
cart, checkout01.php and checkout02.php.
Assignment 7 due (Bookstore: default, SearchBrowse,
Product and About pages) |
| 22 |
11/11
Wed. |
Veterans Day Holiday |
| 23 |
11/13
Fri. |
Bookstore enhancement ideas and coding tips. |
| 24 |
11/16
Mon. |
Lecture: Overview of project: Checkout03.php and OrderHistory.php
Assignment 8 due (Project - shopping cart, checkout01, checkout02) |
| 25 |
11/18
Wed. |
Lecture: Web Design
Introduction & Ch. 1
Ch. 2,
Reading: Krug Don't Make Me Think - Introduction and Ch. 1-3
WebPagesThatSuck.com |
| 26 |
11/20
Fri. |
Work session in CF21 to work on bookstore project |
| 27 |
11/23
Mon. |
Lecture: Web Design Krug Ch. 3, Ch.
4-6
Reading: Krug Ch. 3-6 |
| |
11/25 11/27 |
Thanksgiving Holiday |
| 28 |
11/30
Mon. |
Lecture: Web Design Krug
Krug's Trunk
Test, Ch. 7 Ch. 8-9,
What not to do
Reading: Krug Ch. 7-11. Look at The Need for Web
Design Standards, WebDesignPractices.com, Top
Ten Web Design Mistakes in 2005, Are
Users Stupid?, Test With 5 Users
Assignment 9 due (Checkout03.php, Order History)
|
| 29 |
12/2
Wed. |
Project day -- no lecture. Professor Sandvig will
have extra office hours.
Office hours: 9:00 am - noon and 1:00 pm.- 4:00 pm
|
| 30 |
12/4
Fri. |
Lecture: Review, What's
next: PHP and ASP.NET
Exam will
cover PHP and web design. |
| |
12/7
Mon. |
Projects due at 4 pm. |
Final
Exam |
12/8
Tu. |
Exam 10:30 - 12:30 pm. |