Switch-Loops - Obstacle Detection behaviour, Evaluate design processes Repeated Decisions Pattern and solutions against Line Follower (Mini-Unit) - Line Following (a student developed criteria Repeated Decisions Pattern behaviour) Final Challenge - Cumulative Application of Skills and Knowledge 10 Lego Robotics C Demonstration Demonstrate students’ robotics solutions and process. Term 2 Practical Teaching Focus Theory Teaching Content Assessment Weeks Addressed 1 Introduction to Databases Explore techniques for What is a database? acquiring, storing and How & where are databases used? validating quantitative The power of data collection and storage. and qualitative data Examples of Databases in our world (Digital and (ACTDIP036) Careers in Database Management Government metadata collection (Aust Law, NSA (America)) 2 Revision of Access Database structure (flat-file database) Databases Explore techniques for Fields and Records http://www.cambridgegcsecomputing.org/ acquiring, storing and Data entry Use of data handling software validating quantitative Data retrieval and qualitative data Data manipulation (ACTDIP036) 3-5 MS Access (relational database) Khan Academy Databases Safely select, implement Task 4 Database – – What is a relational database? Database Management Systems and test appropriate Theory How to create a relational database in MS Access Tables entities technologies and Data entry and Forms Logical operators processes, to make Aggregating data solutions 6-9 Advanced MS Access and SQL - Khan Academy Databases Evaluate design processes Task 3 Database – SQL Queries Querying in sub-queries Key fields and solutions against Practical – Joining related tables and self-joins Validating data student developed criteria Using SQL to update databases Task 4 Database – Changing rows with update and delete Theory
Switch-Loops - Obstacle Detection behaviour, Repeated Decisions Pattern Line Follower (Mini-Unit) - Line Following (a Repeated Decisions Pattern behaviour) Final Challenge - Cumulative Application of Skills and Knowledge Evaluate design processes and solutions against student developed criteria 10 Lego Robotics C Demonstration Demonstrate students’ robotics solutions and process. Term 2 Weeks Practical Teaching Focus Theory Teaching Content Addressed Assessment 1 Introduction to Databases What is a database? How & where are databases used? The power of data collection and storage. Examples of Databases in our world (Digital and Careers in Database Management Government metadata collection (Aust Law, NSA (America)) Explore techniques for acquiring, storing and validating quantitative and qualitative data (ACTDIP036) 2 Revision of Access Database structure (flat-file database) Fields and Records Data entry Data retrieval Data manipulation Databases http://www.cambridgegcsecomputing.org/ Use of data handling software Explore techniques for acquiring, storing and validating quantitative and qualitative data (ACTDIP036) 3-5 MS Access (relational database) – Khan Academy What is a relational database? How to create a relational database in MS Access Data entry and Forms Aggregating data Databases Database Management Systems Tables entities Logical operators Safely select, implement and test appropriate technologies and processes, to make solutions Task 4 – Database Theory 6-9 Advanced MS Access and SQL - Khan Academy SQL Queries – Querying in sub-queries Joining related tables and self-joins Using SQL to update databases Changing rows with update and delete Databases Key fields Validating data Evaluate design processes and solutions against student developed criteria Task 3 – Database Practical Task 4 – Database Theory
Y10_Information_Technology_2016_Assessment_Outline.docx