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 |