| Estimated Timeframes Week(s) | Topic and Notes | Activities and Resources | 
|---|---|---|
| Week 1 |  Recap on HTML, CSS and Tables Mr Chuang trying to cure memory loss. | Warmup Task - Making HTML tables and pages | 
| Week 2-3 |  Intro to SQL Importing Data to PHPMyAdmin. Queries with SELECT, INSERT | Exercises + McDonalds Mac Data File Remember we just need 8 columns for the MacDonalds Table. Not EVERY Column! Editable copies will be assigned on Google Classroom (Classwork Tab) | 
| Week 4-5 |  Making a PHP Website Querying with PHP Forms for Searching. Extension: Advanced Search | McDonalds & Recipes Instructions on Text-Search, Quick Queries and Combined Nav bars | 
| Week 6-8 Note: Large Difficulty Spike here. |  Multiple Tables JOINs Inserting Data with a Form | Extra Curricular + MTG Instructions on adding with a HTML form MTG Task - Implementing Adding and Editing | 
| Week 9-10 | Assessment Start | Assessment Instructions | 
| Term 2: | Term 1 Holidays Work on Assessment if needed | |
| Week 1-2 | Assessment Continues + Feedback/Checkpoint | |
| Week 3 | Assessments Hand-ins | |
| Week 4 | Start Java |