This class schedule is tentative and is subject to change.
| Date | Class | Agenda | Deadlines |
|---|---|---|---|
| Week 1 | |||
| Tue 1/21 | Lecture | Introduction | Assigned: Lab Homework 0 |
| Thu 1/23 | Lecture | Dynamic Web Sites | Reading: p1-6 (Chapter 1) Due: Lab Homework 0, Part I, 11:59pm |
| Fri 1/24 | Lab | Lab 0: (optional) office hours | Attendance is optional. TAs will hold office hours to help with Lab 0. |
| Week 2 | |||
| Sun 1/26 | Due: Lab Homework 0, Parts II & III, 11:59pm | ||
| Tue 1/28 | Lecture | Partials | Assigned: 2300 pre-survey Reading: p19-25 (Chapter 3) |
| Thu 1/30 | Lecture | PHP Output | Due: 2300 pre-survey, 9:05am Reading: 33-36 (Chapter 3), 71-96 (Chapter 5) Assigned: Project 1 |
| Fri 1/31 | Lab | Lab 1: Partials | Assigned: Lab Homework 1 |
| Week 3 | |||
| Sun 2/2 | Due: Lab Homework 1, 11:59pm | ||
| Tue 2/4 | Lecture | Decisions (Conditionals) | Reading: p26-32 (Chapter 3), p39-53 (Chapter 4) |
| Thu 2/6 | Lecture | Sticky Forms | Reading: p109-124 (Chapter 6) Due: Project 1, Milestone 1, 4:00pm |
| Fri 2/7 | Lab | Lab 2: Sticky Forms | Assigned: Lab Homework 2 |
| Week 4 | |||
| Sun 2/9 | Due: Lab Homework 2, 11:59pm | ||
| Tue 2/11 | Lecture | Filter Input, Escape Output | Reading: p48-50, 56-59 (Chapter 4), Reading: http://us.php.net/manual/en/intro.filter.php |
| Thu 2/13 | Lecture | Filter Input, Escape Output (con’t) | Reading: none Due: Project 1, Milestone 2, 4:00pm |
| Fri 2/14 | Lab | Lab 3: Filter Input, Escape Output | Assigned: Lab Homework 3 |
| Week 5 | |||
| Sun 2/16 | Due: Lab Homework 3, 11:59pm | ||
| Tue 2/18 | Lecture | Functions | Reading: p59-65 (Chapter 4) |
| Thu 2/20 | Lecture | Relational Databases (RDBMS) | Reading: none Due: Project 1, Final, 4:00pm Deadline: Earned Slip Day 1, 4:00pm Assigned: Project 2 |
| Fri 2/21 | Lab | Lab 4: Exploring Familiar Design Patterns | Reading: https://www.nngroup.com/articles/match-system-real-world/ Assigned: Lab Homework 4 |
| Week 6 | |||
| Tue 2/25 | No Lecture - February Break | ||
| Wed 2/26 | Due: Lab Homework 4, 11:59pm | ||
| Thu 2/27 | Lecture | DB Schema & SQL | Reading: p325-329, 326-348 (Chapter 12), p362-366 (Chapter 13) Due: Project 2, Milestone 1, 4:00pm |
| Fri 2/28 | Lab | Lab 5: Component Library & SELECT |
Assigned: Lab Homework 5 |
| Week 7 | |||
| Sun 3/1 | Due: Lab Homework 5, 11:59pm | ||
| Tue 3/3 | Lecture | PDO Prepared Statements | Reading: p368, p378-385 (Chapter 13) |
| Thu 3/5 | Lecture | Organizing Table Relationships | Reading: none Due: Project 2, Milestone 2, 4:00pm |
| Fri 3/6 | Lab | Lab 6: INSERT & Basic Search |
Assigned: Lab Homework 6 |
| Week 8 | |||
| Sun 3/8 | Due: Lab Homework 6, 11:59pm | ||
| Tue 3/10 | Lecture | SQL JOINs | Reading: p469-471, p479-480 (Chapter 17) |
| Thu 3/12 | Lecture | Discussion: Virtual Instruction | |
| Fri 3/13 | Lab | Optional Office Hours | |
| Week 9 | |||
| 3/15-3/21 | Classes Suspended | ||
| Week 10 | |||
| 3/22-3/28 | Classes Suspended | ||
| Break | |||
| 3/29-4/4 | Spring Break | ||
| Week 11 | |||
| Mon 4/6 | Video Lecture | Scripting Database Initialization | Assigned: Project 3 Assigned: pre-virtual instruction survey |
| Tue 4/7 | Lecture Q&A | Q&A: Scripting Database Initialization | |
| Wed 4/8 | Video Lecture | Strategies for Dynamic Pages | Due: Project 2, Final, 11:59pm ET Due: pre-virtual instruction survey, 11:59pm ET |
| Thu 4/9 | Lecture Q&A | Q&A: Strategies for Dynamic Pages | Assigned: Lab Homework 7 |
| Fri 4/10 | Section Q&A | Q&A: Lab 7: init.sql & SQL JOINs | |
| Week 12 | |||
| Sun 4/12 | Due: Lab Homework 7, 11:59pm ET | ||
| Mon 4/13 | Video Lecture | File Uploads | |
| Tue 4/14 | Lecture Q&A | Q&A: File Uploads | |
| Wed 4/15 | Video Lecture | Asynchronous Requests (AJAX) | Due: Project 3, Milestone 1, 11:59pm ET |
| Thu 4/16 | Lecture Q&A | Q&A: Asynchronous Requests (AJAX) | Assigned: Lab Homework 8 |
| Fri 4/17 | Section Q&A | Q&A: Lab 8: file uploads | |
| Week 13 | |||
| Sun 4/19 | Due: Lab Homework 8, 11:59pm ET | ||
| Mon 4/20 | Video Lecture | Database Transactions | |
| Tue 4/21 | Lecture Q&A | Q&A: Database Transactions | |
| Wed 4/22 | Video Lecture | HTTP State, Cookies | Due: Project 3, Milestone 2, 11:59pm ET |
| Thu 4/23 | Lecture Q&A | Q&A: HTTP State, Cookies | Assigned: Lab Homework 9 |
| Fri 4/24 | Section Q&A | Q&A: Lab 9: database transactions | |
| Week 14 | |||
| Sun 4/26 | Due: Lab Homework 9, 11:59pm ET | ||
| Mon 4/27 | Video Lecture | Search Engine Optimization | |
| Tue 4/28 | Lecture Q&A | Q&A: Search Engine Optimization | |
| Wed 4/29 | Video Lecture | Search Engines, Caching | Due: Project 3, Final, 11:59pm ET |
| Thu 4/30 | Lecture Q&A | Q&A: Search Engines, Caching | Assigned: Lab Homework 10 |
| Fri 5/1 | Section Q&A | Q&A: Lab 10: Deploy | |
| Week 15 | |||
| Sun 5/3 | Due: Lab Homework 10, 11:59pm ET | ||
| Mon 5/4 | Video Lecture | Login, Logout, & Passwords | |
| Tue 5/5 | Lecture Q&A | Q&A: Login, Logout, & Passwords | |
| Wed 5/6 | Video Lecture | Sessions, User Access Controls | |
| Thu 5/7 | Lecture Q&A | Q&A: Sessions, User Access Controls | Assigned: Lab Homework 11 Assigned: 2300 post survey |
| Fri 5/8 | Section Q&A | Q&A: Lab 11: Login, Logout, & Cookies | |
| Week 16 | |||
| Sun 5/10 | Due: Lab Homework 11, 11:59pm ET Due: 2300 post survey, 11:59pm ET |
||
| Mon 5/11 | Video Lecture | Frameworks: Rails Demonstration | |
| Tue 5/12 | Lecture Q&A | Q&A: Frameworks: Rails Demonstration |