DS Unit 2 - TLAP

Data rich solutions are explored here, integrated with the algorithmic/programming work covered earlier, allowing more complex and interesting problem to be tackled. Understanding data retrieval, manipulation, storage is handled first, then structure, system and UI considerations are considered after students have an understanding of the underlying command structures. It is thought that this approach makes more sense and gives students practical experience with processes before exploring higher level design and meta. Students will explore database interactions with given systems, and generate modules that bridge database-interface gaps using database and programming languages.
2020: Term 1 = 10 weeks, Term 2 = 9 Weeks (unit handover Week 5), term 3 = 10 weeks (Unit handover end Term 3), Term 4 = 8weeks

Unit 2: Application and Data Solutions - Sequence (mouse-over codes for details) Vid Link Doc Download
Time allocation	Unit Objectives	Subject matter	Learning Experiences	Resources
Yr 11, Term 2 Week 5		1i.3 2b.3	Intro to relational databases, tables (records, fields etc), interfaces SQL - DML queries, filters, row ordering Keys: uniquennesses, PK/FK
Week 6		1a 1d 1f.2 2f.1 2h 2i 2j.1 2k 3b	PHP/MySQL bridging, simple result table handling DB Scripts, intro to data flow	MeekroDB
Week 7	3 5 6	1b 1c.1 1c.2.1 1c.2.2 2b.4 2b.5	DDL queries (create, drop, insert, alter, update) Table management using PHP, interaction, introduction to security.
Week 8	4 7 8	1d 1e 1g 1i.1 1i.2 1i.4 3a 3g 3h.1 3h.2	Submit fIA3 - Folio Exam block?
Week 9			Exam block?
Yr 11, Term 3 Week 1	3 4 8	1c.1 1c.2.1 1c.2.2 1g 2a 2b.2 2b.3 3a 3d.1 3d.2 3e.1 3e.2 3e.3 3e.4	SQL SELECT statements, including WHERE, GROUP BY, HAVING, ORDER BY, COUNT, MIN, MAX, AVG, IN, inner-joins and sub-queries SQL CREATE, INSERT, UPDATE and DELETE statements Introduce Digital Solution. Identification of scope, requirements for system development, evaluation criteria	sql engines
Week 2	8	1a 1e 2b.1 2d 2e.3 2e.4 2j.1 2k	Data principles, system architecture of data-driven application PHP/MySQL scripting - DDL and DML
Week 3	2 8	1b 1d 1i.3 2b.5 2b.6 2c 2e.1 2e.2 3b 3c	Normalisation, db architecture data validation
Week 4	2	1f.1 1i.3 2f.2 2g 2h 2j.2	Data management, flow, security data validation	dfds
Week 5	5 6	1f.2 2b.4 2f.1	system generation and documentation
Week 6	5 6	1h.1 1h.2 2i	system generation and documentation
Week 7	5 6	1i.4 2j.2 3f 3g	system generation and documentation
Week 8	7	1i.1 1i.2 3a 3e.2 3e.3 3e.4 3h.1 3h.2	Submit fIA2 - Digital Solution
Week 9			Exam Block?
Week 10			Exam Block?

Digital Solutions - St. Joseph's College, Gregory Terrace

UNIT 2 - APPLICATION AND DATA SOLUTIONS - TLAP

Overview:

Database Languages

Database Structure

Database System Development

Assessment Plan:

Specifics: