Scheme of Assessment 2016 Irene McCormack Catholic College Yr 10 Information Technology Scheme of Assessment & Teaching Program 2016 Assessment type Task weightings Task Due Date Outcome Practical 15% Task 1: Lego Robot C – Virtual Brick Week 9 Term 1 Design algorithms, represented diagrammatically and in structured English, and validate plans and programs through tracing (ACTDIP040) Create and critique briefs to solutions Analyse design processes and solutions against student developed criteria Theory 10% Task 2: Representation of Data Week 9 Term 1 Simple compression of data and how content data is separated from presentation data (ACTDIK035) Practical 15% Task 3: Access Database and SQL – Advanced creation and maintenance of a database system. Week 9 Term 2 Explore techniques for acquiring, storing and validating quantitative and qualitative data (ACTDIP036) Different methods of manipulation, storage and transmission of data (ACTDIK035) Implement and apply data storage and organisation techniques (ACTDIP041) Analyse, visualise and model processes and entities, and their relationships, using structured data (ACTDIP037) Analyse design processes and solutions against student developed criteria Theory 10% Task 4: Database Theory Week 9 Term 2 Explore techniques for acquiring, storing and validating quantitative and qualitative data (ACTDIP036) Different methods of manipulation, storage and transmission of data (ACTDIK035) Practical 15% Task 5: Javascript Programming Week 10 Term 3 Validate algorithms and programs using common acceptable methods (ACTDIP040) design thinking, creativity and enterprise skills. Implement data storage and organisation techniques within a programming environment (ACTDIP041) Identify the needs of the client/stakeholder to determine the basis for a solution Safely select, justify, implement and test appropriate technologies and processes, to make solutions Analyse design processes and solutions against student developed criteria
Theory 10% Task 6: Programming Theory Part A Week 9 Term 3 Investigate components/resources to develop increasingly sophisticated solutions, identifying and considering associated constraints Apply design thinking, creativity and enterprise skills. Implement data storage and organisation techniques within a programming environment (ACTDIP041) Practical 15% Task 7: Hardware & Software Week 6 Term 4 Role of hardware and software in managing, controlling and securing access to data, in networked digital systems (ACTDIK034) Create interactive solutions for sharing ideas and information online, taking into account social contexts and legal responsibilities (ACTDIP043) Theory 10% Task 8 : Programming Theory Part B Week 6 Term 4 Investigate components/resources to develop increasingly sophisticated solutions, identifying and considering associated constraints Apply design thinking, creativity and enterprise skills. Implement data storage and organisation techniques within a programming environment (ACTDIP041) Term 1 Weeks Practical Teaching Focus Theory Teaching Content Addressed Assessments 1 IT Expectations and Class rules. Introduction to Lego RobotC GUI Walkthrough Basic skills and purpose of Robot C 2-4 Introduction to Lego Robotics Programming (Lego RobotC) GUI walkthrough Moving Straight - Motors, Sequences of Commands, Settings, Downloading and Running Programs, Move Steering Block Turning - Turning, Types of Turns, Move Steering vs. Move Tank Block Move Until Touch - Sensors, Wait For Block, Touch Sensor, Move Until Behaviours Representation of Data/Databases http://www.cambridgegcsecomputing.org/ Definitions of units Binary format Converting positive denary numbers Adding 8-bit binary numbers Hexadecimal numbers Design algorithms, represented diagrammatically and in structured English, and validate plans and programs through tracing (ACTDIP040) Task 2 - Representation of Data/Databases 6-9 Advanced Lego RobotC programming Move Until Near - Ultrasonic Sensor, Thresholds Turn for Angle - Gyro Sensor, Compensating for Sensor Error Move until Colour - Colour Sensor Loops - Loops, Patterns of Behaviour Switches - Switches, Conditional Reasoning Switches, Conditional Reasoning Representation of Data/Databases Character sets Images Metadata in images Sound Instructions Design algorithms, represented diagrammatically and in structured English, and validate plans and programs through tracing (ACTDIP040) Task 1 – Lego Robot C Task 2 - Representation of Data/Databases
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
Terrific text Text and strings Variable and constraints validate and programs through tracing (ACTDIP040) Task 6: Programming Theory Part A 8-10 Advanced Javascript Functions Logic and If statements Debugging Looping Programming Data types Operations on numeric and Boolean data Analyse design processes and solutions against student developed criteria Task 5 – Javascript Programming Task 6: Programming Theory Part A Term 4 Weeks Practical Teaching Focus Theory Teaching Focus Content Addressed Assessment 1 Introduction to Hardware and Software Parts of a computer CPU, Motherboard, RAM 2-3 Buying PC components Clock cycle/Fetch-execute cycle Bus speeds RAM speeds What components work together and why Scenario Research Task Advanced Programming - http://www.cambridgegcsecomputing.org/ Arrays Syntax and logic errors Test data Role of hardware and software in managing, controlling and securing access to data, in networked digital systems (ACTDIK034) Create interactive solutions for sharing and information online, taking into account social contexts and legal responsibilities (ACTDIP043) Task 7: Hardware and Software Task 8: Programming Theory Part B 4-6 Building our own PC Demonstration of how to dismantle a PC Demonstration of how to assemble a PC Students to practice both in groups Student individually observed building the PC correctly. Demonstration of how to install an OS Students observed installing an OS Advanced Programming Basic string manipulation Basic file handling operations Role of hardware and software in managing, controlling and securing access to data, in networked digital systems (ACTDIK034) Create interactive solutions for sharing ideas and information online, taking into account social contexts and legal responsibilities (ACTDIP043) Task 7 : Hardware and Software Task 8: Programming Theory Part B