| Week | Tuesday | Homework |
Thursday | Homework |
| Jan --, 22 |
|
Course overview: whirlwind tour: DBs, system
models (ERD and DFD), Open Source. Middleware (ASP, PHP). Server side
versus Client side. BlackBoard orientation. Access exercise. Preview
MySql |
Confirm BlackBoard IDS. Review HTML. |
|
| Jan 27, 29 |
Basic HTML review. HTML forms. Get IDs for sharon computer. | Identify on-line source for help,
tutoring on JavaScript, ASP, PHP topics or problems. Make posting. It
must be UNIQUE source and/or question. |
Reprise server side vs client side: ASP or PHP file (mixture of scripting language & HTML) produces HTML. Start state/capitals. |
Review HTML forms, JavaScript. For examples, go to newmedia.purchase.edu/~Jeanine/jsexamples.html |
| Feb 3,5 |
Basic ASP & PHP examples. Handling forms.
Continue state/capitals. Make your own quiz. |
Review JavaScript. Check on-line
sources (add new ones and add comments) |
Continue basic scripting. Change your own quiz to be self-handler. | Download ws-ftp if you don't have it. |
| Feb 10, 12 | Validating form data using regular expressions. |
Confirm you can upload (regular)
HTML files to your sharon id. Regular expression homework (from classnotes) due next class. |
Go over regular expressions homework. Lab: implement regular expression examples. | |
| Feb 17, 19 |
More ASP & PHP examples. Arrays. Loops. Calculations. |
Complete class work examples. |
Interface design process. Systems analysis & design methodologies. Information model (ER diagrams.) Process model (data flow: data store, process, agents) for DB examples (e-commerce, quiz show) |
E-R & DFD homework: make charts for library.
Due next class. |
| Feb 24, 26 |
ASP & PHP examples: Create DB and code forms for inputting information. Connections. Recordsets. Review library homework. | E-R & DFD homework: library. |
Finish talk on php/asp database access. Catch-up. Questions. |
Prepare for quiz (see on-line guide/practice quiz) |
| Mar 2, 4 |
Midterm Quiz |
Optional (extra credit): research
& prepare for presentation an example of VBScript or CGI or Cold Fusion. |
Go over any questions from Midterm. Demonstrate already prepared ASP & PHP projects on quiz show & on-line store. May demonstrate some student projects from last year. Present team application change project. |
Look over demo projects, including code in preparation
for projects assignment. |
| Mar 9, 11 |
Data base normalization. Issues: integrity &
robustness. Assign teams for expositions on sample project code. |
Normalization problems. |
ASP & PHP examples: setting and using
cookies. |
Identify system owner/system user, gather requirements for enhancement to projects. |
| Mar |
Spring recess |
Spring recess |
||
| Mar 23, 25 |
Brief presentation on goals for application enhancement
project. Continue with Cookies, sessions, redirections. ASP: Application object. |
Work on projects. |
Time for teams to work together & ask questions. Schedule for next Monday or Wednesday. |
Complete presentations (prepare charts) |
| Mar 30, Apr 1 |
Teams present their explanations of enhanced quiz & store projects. | Teams that haven't presented must
prepare. |
Teams present their descriptions of enhanced quiz & store projects. | Decide on personal project. Teams of 2-3 are acceptable (but projects by larger teams must be bigger and better). Post description of project. Project must involve data entry, data validation, data query, data editing. At least 2 forms. We may make specific requirements for your project. |
| Apr 6, 8 |
Confirm projects. Paging. 3-tier design. (Page) design versus function/content. ASP application objects. |
Be prepared to work in class. |
Project time. Use server for code. Also individual/team help on diagrams. | Prepare E-R diagram of your database & process model to present & turn in. |
| Apr 13, 15 |
Presentations. | Post constructive feedback on
at least 2 other projects |
Making a table of SQL queries. Misc. topics. PHP for other DBMS. | Complete class examples at home/office. |
| Apr 20, 22 |
Work session. | Gather opinion & information
& make posting on Open Source versus Proprietary in general or ASP
versus PHP (vs Cold Fusion) performance. |
Discuss Open source issues. |
|
| Apr 27, 29 | Things to think about. Work session. Discuss
postings. |
Work session. | Work on projects. Review for final. |
|
| May 4, 6 |
Present projects. Review for Final |
Study for final |
No class. | Study for final |
| May 11, - |
FINAL |
Take on-line post-class survey |