Gr 12 Info Tech ATP 2023 24

2023/24 ANNUAL TEACHING PLANS: INFORMATION TECHNOLOGY: GRADE 12 2023/24 ANNUAL TEACHING PLANS: INFORMATION TECHNOLOGY: GRADE 12 (TERM 1) TERM 1 WEEK 1 WEEK 2 WEEK 3 WEEK 4 WEEK 5 WEEK 6 WEEK 7 WEEK 8 WEEK 9 WEEK 10 WEEK 11 CAPS TOPIC Database: design OOP OOP Hardware Database Database design Database design SQL Social implications PAT PAT and concept PAT management concepts concepts PAT PAT CONCEPTS, - Logging in / Reinforce past - The use of the - Mobile - Data collection – - Characteristics of Example of basic Design and develop a - Discuss the PAT: Analysis of PAT: Analysis of SKILLS AND passwords programming skills ToString method technologies overview and a good database relationship enabled solution incorporating advantages and requirements using an requirements using an VALUES - Explain and (methods) and accessor - Overview of examples - Problems with by the utilisation of SQL disadvantages appropriate appropriate motivate - OOP methods to factors - Location-based databases key fields how mobile methodology methodology relational Parameterised provide output influencing data - Split tables and technology - SELECT all or some database design and non- - Correct performance of a - Data create relations impacts on PAT fields (FROM) - Normalisation parameterised instantiation of computer warehousing + privacy – - Transaction constructors objects - Motivate a mining personal and processing - Correct use of - Correct use of typical computer - Caring for and business - Characteristics of private and public methods of system in managing data - IoT – a good database attributes, various objects as respect of user technologies design accessor, part of problem requirements enabling the IoT - Caring for and mutator and solving and their impact managing data auxiliary methods PAT on society - Hacking through PAT data DATE COMPLETED (TEACHER FILE) TERM 7.8% 18.4% 28.9% 39.4% 50% 60.5% 71% 81.6% 92% 100% 100% COVERAGE YEAR 3.2% 7.4% 11.6% 15.8% 20% 24.2% 28.4% 32.6% 36.8% 40% 40% COVERAGE REQUISITE Gr 11: Database Previous programming Previous programming Gr 11: Database Gr 11 PAT Gr 11: Database Gr 11: Knowledge Gr 11: Database Gr 11 PAT Gr 11 PAT Gr 11 PAT PRE- design skills and knowledge skills and knowledge design development skills design and networking database design and design and knowledge development skills development skills development skills KNOWLEDGE knowledge e-communication INFORMAL 2 informal assessment 2 informal assessment 2 informal assessment 2 informal assessment 2 informal assessment 2 informal assessment 2 informal assessment 2 informal assessment 2 informal assessment ASSESS, tasks tasks tasks tasks tasks tasks tasks tasks tasks REMEDIATION SBA (FORMAL PAT ALTERNATIVE TEST PAT THEORY TEST PAT PAT PAT ASSESSMENT) Downloaded from hlayiso.com 1

2023/24 ANNUAL TEACHING PLANS: INFORMATION TECHNOLOGY: GRADE 12 2023/24 ANNUAL TEACHING PLANS: INFORMATION TECHNOLOGY: GRADE 12: TERM 2 TERM 2 WEEK 1 WEEK 2 WEEK 3 WEEK 4 WEEK 5 WEEK 6 WEEK 7 WEEK 8 WEEK 9 WEEK 10-11 CAPS TOPIC Systems technologies SQL Systems technology SQL Systems technology Solution development Solution development TASK: MID-YEAR EXAMINATION SQL PAT SQL PAT SQL PAT Social implications PAPER 1 PAPER 2 CONCEPTS, Factors influencing LEFT, RIGHT, MID Overview of cloud Functions and aggregate Overview of augmented Arrays as a data structure Consolidate and reinforce Marks: 150 – Time: 3 hours Marks: 150 – Time: 3 hours SKILLS AND computer management Concatenating fields computing functions reality (2-dimensional) content, concepts and Question 1 Section A: Question 1 VALUES DISTINCT and ORDER WHERE Overview of virtual reality, Create a join query Overview of virtualisation PAT skills Basic, general programming skills Short questions (± 20 marks) BY >, >=, <, <=, =, LIKE, Wild cards (single joins) using Date functions (day, Design and develop Question 2 Section B: Question 2 SELECT with calculated BETWEEN #date# ‘Where’ month, year, date) solutions for a variety of problems that include Database Systems technologies (± 25 fields (AS) AND, OR, NOT, Insert, delete, update – Queries with parameters computational thinking Question 3 marks) ROUND, INT, LENGTH IS NULL, NULL, IN ONE and then multiple PAT where the user input is and applying software Object-oriented programming Section C: Question 3 records given: engineering principles (OOP) Communications and network to modify data in a table " PAT Computer criminals & Question 4 technologies (± 25 marks) computer crime General problem-solving Section D: Question 4 DATE Data and information management COMPLETED (± 25 marks) (TEACHER Section E: Question 5 FILE) Solution development (± 25 marks) TERM 12% 28% 40% 52% 68% 84% 100% Section F: Question 6 COVERAGE Integrated scenario (± 30 marks) YEAR 43% 47 % 51 % 55% 59% 63% 70% COVERAGE Cognitive levels: Lower order – 30%, Middle order – 40%, Higher order – 30% REQUISITE Previous programming Previous programming Previous programming Previous programming Previous theory and Application of all Application of all PRE- skills skills and knowledge skills and knowledge skills and knowledge programming knowledge knowledge knowledge KNOWLEDGE and skills INFORMAL 2 informal assessment 2 informal assessment 2 informal assessment 2 informal assessment 2 informal assessment 2 informal assessment 2 informal assessment ASSESS, tasks tasks tasks tasks tasks tasks tasks REMEDIATION SBA (FORMAL PAT PAT PRACTICAL TEST PAT PAT ASSESSMENT Downloaded from hlayiso.com 2

2023/24 ANNUAL TEACHING PLANS: INFORMATION TECHNOLOGY: GRADE 12 NATIONAL ANNUAL TEACHING PLANS: INFORMATION TECHNOLOGY: GRADE 12: TERM 3 TERM 3 WEEK 1 WEEK 2 WEEK 3 WEEK 4 WEEK 5 WEEK 6 WEEK 7 WEEK 8 WEEK 9-11 CAPS TOPIC Software engineering Software engineering Internet services Communication Social implications Solution development Solution development Solution development TASK: TRIAL EXAMINATION PAT PAT technologies technologies Solution development PAT PAT PAPER 1 PAPER 2 PAT PAT Marks: 150 – Time: 3 Marks: 150 – Time: 3 CONCEPTS, Reinforce software Reinforce software - Improve searching - Essential parts to Explain how computers - Consolidate and - Consolidate and - Consolidate and hours hours SKILLS AND engineering principles engineering principles - Online applications link nodes provide solutions to issues reinforce content, reinforce content, reinforce content, Question 1 Section A: Question 1 VALUES PAT PAT - Role of SQL, - Connecting to the - Consolidate and concepts, and skills concepts, and skills concepts, and Design and develop Basic, general Short questions (± 20 scripting languages Internet reinforce content, - - Design and develop skills solutions for a programming skills marks) - Formatting output - Sharing concepts concepts, and skills solutions for a - Design and Online services variety of problems variety of problems develop solutions Question 2 Section B: QUESTION PAT - - Design and develop Remote access that include that include for a variety of Database 2 - solutions for a variety - Overview of security of problems that computational computational problems that Question 3 Systems technologies (± concepts include thinking and thinking and include Object-oriented 25 marks) PAT computational applying software applying software computational programming (OOP) Section C: Question 3 thinking and applying engineering engineering thinking and Communications and Question 4 software engineering principles principles applying software network technologies (± General problem- principles PAT PAT engineering 25 marks) solving principles Section D: Question 4 DATE Data and information COMPLETED management (± 25 (TEACHER marks) FILE) Section E: Question 5 TERM Solution development (± 12.9% 25.8% 38.7% 48.3% 61.2%% 74.1% 87.1% 100% 25 marks) COVERAGE Section F: Question 6 YEAR 74% 78% 81 % 84% 88% 92% 96% 100% Integrated scenario (± 30 COVERAGE marks) REQUISITE Previous programming Previous programming Previous theory Previous theory Previous theory Previous programming Previous programming Previous programming Cognitive levels: PRE- skills and knowledge skills and knowledge knowledge knowledge knowledge skills skills and knowledge skills and knowledge KNOWLEDGE Lower order – 30%, Middle order – 40%, Higher order – 30% INFORMAL 1 informal assessment 1 informal assessment 1 informal assessment 1 informal assessment 1 informal assessment 2 informal assessment 2 informal assessment ASSESS, tasks tasks tasks tasks tasks tasks tasks REMEDIATION SBA (FORMAL PAT PAT PAT PAT THEORY/PRACTICAL PAT PAT PRACTICAL EXAM ASSESSMENT TEST Downloaded from hlayiso.com 3

2023/24 ANNUAL TEACHING PLANS: INFORMATION TECHNOLOGY: GRADE 12 2023/24 ANNUAL TEACHING PLANS: INFORMATION TECHNOLOGY: GRADE 12: TERM 4 TERM 4 WEEK 1 WEEK 2 WEEK 3 WEEK 4 WEEK 5 WEEK 7-10 CAPS TOPIC Content using case Content using case studies - all topics studies - all topics FINAL NSC EXAMINATION (3 hours) (4 hours) TEACHING 4 hours per week required TIME PER • If contact time is lost a recovery plan must be in place WEEK • Your recovery plan and remediation plan must be reflected in your Subject Improvement Plan – update it throughout the year • Indicate on the teaching plan (ATP) what has been competed to track your progress • Application packages share common features (formatting, editing, page layout, illustrations, etc.) reinforced these when teaching different packages • Use the guideline documents to complete PAT RESOURCES Hardware Software Maintenance plan General (OTHER THAN • Data projector • Windows 10 or later version • Slide presentations - summarised content TEXTBOOK) • 1 learner per computer • Delphi programming software (Version 10, 10.3, 10.4) • Notebook for summaries and activities TO ENHANCE LEARNING • Entry-level computers networked • Office 2016 or later version (Word, Excel, Access, PowerPoint • Online content, resources • Multifunction printer • Video clips • Internet connectivity • Posters with new concepts, formulas, functions • Previous question papers EXAMPLES OF • Concept maps for summaries • Competitions, gaming (fun activities) FORMATIVE • Brainstorm sessions • Peer assessment ASSESSMENTS/ • Quizzes (Google Forms, MS Forms, Kahoots!, etc.) for retrieval practice • Extended opportunities, activities, etc. RETRIEVAL PRACTICE IMPORTANT • Updated CAPS for IT DOCUMENTS • Chapter 4 – latest assessment instructions TO USE WITH • Gr 12 exam guidelines with new concepts (new technologies where applicable) THE ATP Downloaded from hlayiso.com 4