| Wk ## |
Date |
Lesson |
Reading |
Event |
Due Date |
| 1 |
02/08/10 |
1. Information and Introductions |
Syllabus |
|
|
| 2 |
02/15/10 |
Washington's birthday (No Class) |
-- |
|
|
| 3 |
02/22/10 |
2. Databases and Queries |
SQL 1-7 |
A1-Exploring Database-driven Web Sites Quiz 1 and Discussion 1 |
02/22/10 02/22/10 |
| 4 |
03/01/10 |
3. Columns, Tables and Rows |
SQL 15-17 |
A2-SQL Queries Quiz 2 and Discussion 2 |
03/01/10 03/01/10 |
| 5 |
03/08/10 |
4. Designing Databases |
SQL 8-14 |
A3-Project Proposal Quiz 3 and Discussion 3 |
03/08/10 03/08/10 |
| 6 |
03/15/10 |
5. More MySQL |
-- |
A4-Project Database Design Quiz 4 and Discussion 4 |
03/15/10 03/15/10 |
| 7 |
03/22/10 |
6. PHP and MySQL |
PHP 1,2,5,19 |
A5-Load Data and Index Tables Quiz 5 and Discussion 5 |
03/22/10 03/22/10 |
| 8 |
03/29/10 |
Spring Break (No Class) |
-- |
|
|
| 9 |
04/05/10 |
7. Forms and Webapps |
PHP 11 |
A6-PHP Connections Quiz 6 and Discussion 6 |
04/05/10 04/05/10 |
| 10 |
04/12/10 |
8. Control-Flow and Arrays |
PHP 3,7 |
A7-Collecting User Input Quiz 7 and Discussion 7 |
04/12/10 04/12/10 |
| 11 |
04/19/10 |
9. Increasing Functionality |
PHP 4, 9, 13 |
A8-Query and Report Quiz 8 and Discussion 8 |
04/19/10 04/19/10 |
| 12 |
04/26/10 |
10. OOP and Forms |
PHP 10 |
A9-Single-Page Form Quiz 9 and Discussion 9 |
04/26/10 04/26/10 |
| 13 |
05/03/10 |
11. Keeping Data Across Pages |
PHP 14, 15 |
A10-Classy Forms Quiz 10 and Discussion 10 |
05/03/10 05/03/10 |
| 14 |
05/10/10 |
12. Databases and Shopping Carts |
-- |
A11-Authenticating Users Quiz 11 and Discussion 11 |
05/10/10 05/10/10 |
| 15 |
05/17/10 |
13. Improving Security |
-- |
Discussion 12 |
05/17/10 |
| 16 |
05/24/10 |
14. Networking and Other Topics |
PHP 8 |
|
|
| 17 |
05/31/10 06/01/10 |
Memorial Day (No Class) Final Exam |
-- -- |
Final Project Report and Presentation |
06/01/10 |