Gr 12 Comp App Tech ATP 2023 24

2023/24 ANNUAL TEACHING PLANS: COMPUTER APPLICATIONS TECHNOLOGY: GRADE 12 2023/24 ANNUAL TEACHING PLANS: COMPUTER APPLICATIONS 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 Systems technologies: Systems Systems technologies: Systems technologies: Solution Solutions Solution Solution Solution Solution Information General Concepts technologies: Hardware Social Implications development: development: development: development development: development: Management & PAT (theory) Hardware (theory) (theory) Databases Databases Spreadsheets Spreadsheets Word processing Word processing ½ week, 2 hours ± ½ week, 2 hours (theory) ± ½ week, 2 hours ± ½ week, 2 hours (practical & (practical & theory) (practical and theory) (practical and theory) (practical and theory) (practical and theory) (Both Inland & Coastal) ± 1 week, 4 hours Systems technologies: Solution development: theory) 1 week, 4 hours 1 week, 4 hours 1 week, 4 hours 1 week, 4 hours ½ week, 2 hours Information Software Databases 1 week, 4 hours (Both inland & management & PAT (theory) (practical & theory) coastal) 1 week, 4 hours ± ½ week, 2 hours ½ week, 2 hours Information (Coastal only) management & PAT ½ week, 2 hours (Inland only) CORE • Types of computer • Input, output, Hardware continued Social issues: Database: Spreadsheets: File management: Word processing: Information CONCEPTS, systems for different uses: processing, • Storage devices and • Environmental issues • Revise forms and queries (e.g., p7) • Reinforce content, concepts, and skills Extract a password • Select options in Management & PAT: SKILLS, AND Personal, SOHO, mobile storage, and media: SSD, card • User-centred design • Reports • Function vs formula (e.g., p7) protected .exe file the editing group • Setting questionnaires, VALUES and power users communication reader (e.g., p10) in software (e.g., p6) (e.g., p7) gather information and • Design reports – grouped, group • Named ranges (e.g., p7) • Role and use of data, as part of the • Troubleshooting: Fix applications such as: • Completion of Word data, discuss the headers and footers, calculations in • More complex functions: Nested IF, vertical information, knowledge, information ordinary problems, • Website processing work writing of professional, groups such as sum, average, and horizontal LOOKUP also XLOOKUP Word processing conclusion, decision as processing new technologies • Database form from the previous formal reports, discuss counting, maximum, minimum, add (e.g., p7), including error indicator #N,A, • Reinforce content, part of information cycle, • Presentations week the use of spreadsheet fields with calculations in queries, variations of known functions ROUNDUP, concepts, and skills management consolidate and database in • Software that reports, data validation techniques, ROUNDOWN, COUNTIFS, SUMIFS, from Grade 10 and (Both inland & • Reasons for using and reinforce professional reports enhances Database: queries using and, or, not, wildcards • Additional functions: RANDBETWEEN, 11 coastal) computers hardware and (Inland only) accessibility, • Reinforce content, (*), IS null operator UPPER, LOWER, AND, OR (e.g., p7) • Links (bookmark, • Convergence – software efficiency, productivity concepts, and skills from • SUBTOTAL feature (AVERAGE, COUNT, hyperlink, cross- what is it? regarding uses, Information • Information • Uses of common Grade 11 SUM) reference) making buying management & PAT: management & PAT: applications • Combination of functions, formulae to solve • Referencing decisions • Reinforce content, • Web-based problems options: Index and • Reinforce content, • Input & output concepts and skills concepts and skills applications vs • Basic date and time calculations (YEAR, table of figures devices: Multi- from Grade 10 and from Grade 10 and installed applications MONTH, DAY, DAYS, HOUR, MINUTE, (e.g., p6) touch screen, Grade 11 Grade 11, setting HDMI, 3D • Interpret system SECOND, TIME, TODAY, NOW) – • Reviewing, proofing, (Inland only) questionnaires, gather printers, requirements, (reference, e.g., p7) and tracking information and data, monitor – common software • Edit group on the Home tab: Find and select changes discuss the writing of response time problems and (e.g., p7) • Line breaks professional, formal of display upgrades (pagination issues reports, discuss the devices (e.g., p • Risks of using flawed such as widow, use of spreadsheet 10) software orphan control), and database in • Electronic forms: professional reports Legacy controls (Coastal only) (e.g., p6) • Import data collected via electronic forms, incl. MS & Google forms (e.g., p6) INFORMAL 2 x Tasks: Theory 4 x Tasks: Theory 2 x Tasks: Theory (HW) 2 x Tasks: Theory 4 Tasks: Practical 4 Tasks: Practical 4 Tasks: Practical 4 Tasks: Practical 4 Tasks: Practical 2 Tasks: Practical ASSESSMENT 2 x Tasks: Theory (SW) 2 x Tasks: Practical (MINIMUM) SBA (FORMAL TASK 1: Theory test Date completed: TASK 2: Practical test Date completed: PAT Phase 1 ASSESSMENT) min 50 marks By end of term min 50 marks By end of term To be completed before the end of term COMPLETED BEFORE END OF TERM Downloaded from hlayiso.com 1

2023/24 ANNUAL TEACHING PLANS: COMPUTER APPLICATIONS TECHNOLOGY: GRADE 12 2023/24 ANNUAL TEACHING PLANS: COMPUTER APPLICATIONS 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 Network technologies: Network Technologies: Solution development: Solution development: Solution development: Solution development: Solution development: Information Information June exams networks networks HTML, web Design HTML, web design Spreadsheets Spreadsheets Word processing Management and Management and (theory) (theory) (practical & theory) (practical & theory) (practical & theory) (practical & theory) (Practical & Theory) PAT PAT ± ½ week, 2 hours ± ½ week, 2 hours ± ½ week, 2 hours ± 1 week, 4 hours ± 1 week, 4 hours ± ½ week, 2 hours ± ½ Week, 2 hours (Practical & Theory) (Practical & Theory) Social Implications Solution development: Solution development: ± 1 week, 4 hours ± 1 week, 4 hours (theory) Word processing Database ± ½ week, 2 hours (Practical & Theory) (Practical & Theory) ± ½ Week, 2 hours ± ½ Week, 2 hours CORE • Wide area networks • Completion of network • Reinforce content • HTML tables • Reinforce and • Completion of • Objects: Reinforce • Practical assessment task: Reinforce • June exams CONCEPTS, (WAN): Internet as an tech. from previous from Grade 11: • Syntax: Table tags consolidate content, spreadsheet, Word manipulation (tables, information management skills, use • Include transfer of SKILLS, AND example of a WAN, week • Underline tag, border • Attributes: Border, cell concepts, and skills, from previous week graphics), linking and information and data gathered: Processing skills from one VALUES Internet services, • Social implications: around an image padding text functions such as: embedding and analysing application to government internet • Computer crimes in (e.g., p7) • Create links to target Left, right, mid, • Reinforce tabs • HTML: Use the Cite tag in PAT (not another (e.g., p7) • Reinforce and services and relation to hardware, • Good website, page location (e.g., p7) concatenate, len, • Reinforce and examinable) (e.g., p7) consolidate content, information, Streaming, software, information, design - consider • Develop a web page value, find (also to find consolidate content, concepts, and skills • Make buying and identity, bandwidth theft, • Use of colour (basic) for a specific scenario the position of text in a concepts, and skills, • Mail merge - different informed decisions theft of time and • All tags on the HTML cell) design a database for a data sources regarding internet services, Internet-related tag list [See Grade 12 specific scenario • E.g., database, Word connection and access, fraud & scams – NSC CAT P1 QP • Interpret and deduce table, spreadsheet, concept of broadband phishing, spoofing, Addendum] data and information, CSV and bandwidth pharming (e.g., p11) e.g., derive data type or • Throttling & shaping • Internet attacks - DDoS validation rule of certain • Fair use policy attacks, taking over PCs fields without specific • Communication and – bots and zombies, right instructions (e.g., p7) communication devices to access vs. right to – standards for privacy, misuse of wireless personal information, communication, security issues – modem & router, NFC clickjacking, ransomware (e.g., p10) and (e.g. p11) avoiding clarification of blurred security threats (include technologies (e.g., p13) security technologies such as VPN, firewall, screen lock pattern (e.g. • Internet technologies p11) etc., safeguards • URL shortener, against criminals, viruses browser add-on, using and threats, the impact browsers productively, of technology on the IoT, wearables, global community, • (e.g., p10-11) distributed computing cyber security issues, how technology benefits society – crowdfunding, BYOD, big data, Bitcoin, 4IR, 5IR, Blockchain (e.g. p12) INFORMAL 2 x Tasks: Theory 4 Tasks: Theory 2 x Tasks: Practical 4 Tasks: Practical 4 Tasks: Practical 4 Tasks: Practical 4 Tasks: Practical ASSESSMENT (MINIMUM) SBA (FORMAL TASK 3: Alternative task, test PAT Phase 2 MID-YEAR EXAM ASSESSMENT) Min 50 marks To be completed before the end of term TASK 4: Paper 1 (practical) – 150 marks, and: Paper 2 (theory) – 150 COMPLETED marks BEFORE END OF TERM Downloaded from hlayiso.com 2

2023/24 ANNUAL TEACHING PLANS: COMPUTER APPLICATIONS TECHNOLOGY: GRADE 12 2023/24 ANNUAL TEACHING PLAN: COMPUTER APPLICATIONS 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 Practical assessment task: Practical assessment Systems technologies: Internet technologies: Social implications Solution development: Solution development: Information management & Prelim examination, Reinforce information management task: Reinforce information System software and Communications (Practical & theory) Spreadsheets Database PAT completion PAT completion skills, use information and data management skills, use computer management (Practical & theory) ± ½ week, 2 hours (Practical & theory) (Practical & theory) Consolidation gathered: Processing and analysing information and data (Practical & theory) ± 1 week, 4 hours ± ½ week, 2 hours (Practical & theory) ± 1 week, 4 hours Solution development: (Practical & theory) gathered: Processing and ± 1 week, 4 hours Word processing Solution development: ± 1 week, 4 hours analysing (Practical & theory) HTML, web design (Practical & theory) ± ½ week, 2 hours (Practical & theory) ± 1 week, 4 hours ± ½ week, 2 hours CORE • Practical assessment task • Practical assessment • Role of the operating • Types of digital • Social implications • Spreadsheets • Database • Practical assessment • Preparatory exams CONCEPTS, • Reinforce information management task system, manage communications – • Impact and use of • Date and time, maths, • Consolidate and task SKILLS, AND skills • Reinforce information programs, management video conferencing, social networking sites statistical, text, logical, reinforce content, • Reinforce information • Include transfer of VALUES • Use information and data gathered: management skills of files: Operating typical features of and technologies, legal lookup and reference, concepts, and skills management skills skills from one Processing and analysing • Use information and data system utilities, web browsers, uses and ethical issues on use more advanced • Create a database for a • Use information and data application to another gathered: Processing schedule, update, of computer the use of social combinations of given scenarios gathered: Processing and (e.g., p7) and analysing security features such as communications, media, remote access functions and formulas, • Techniques of analysing access control, backup, digital (incl. VPN), creating appropriate graph for a integration with other anti-virus software, communications opportunity for e- given scenario software factors that influence • Communication commuting, e-working • Multiple related tables performance devices and e-learning, m- but work with only one • File management: learning, blended table at a time (e.g., p7) Extract a password learning (e.g. p12), protected .exe file (e.g., how technology can p6) benefit or harm society, • Web development • Consolidation information overload, Reinforce content, Consolidated concepts virtual reality (VR) and concepts, and skills as skills and values augmented reality well as good website, (AR), artificial page design intelligence (AI) (e.g. p12), (geotagging (e.g. p12) • Word processing Documents using style focusing: Page layout that includes advanced Word processing techniques, techniques of integration with other software including linking objects INFORMAL 3 Tasks: Theory 2 Tasks: Practical 2 Tasks: Theory 4 Tasks: Practical 4 Tasks: Practical ASSESSMENT 1 Task: Practical 2 Tasks: Theory 2 Tasks: Practical (MINIMUM) SBA (FORMAL PAT Phase 3 TRIAL EXAM ASSESSMENT) To be completed before the end of term TASK 5: Paper 1 (practical) – 150 marks, and: Paper 2 (theory) – 150 marks COMPLETED BEFORE END OF TERM Downloaded from hlayiso.com 3

2023/24 ANNUAL TEACHING PLANS: COMPUTER APPLICATIONS TECHNOLOGY: GRADE 12 2023/24 ANNUAL TEACHING PLAN: COMPUTER APPLICATIONS TECHNOLOGY: GRADE 12 (TERM 4) TERM 4 WEEK 1 WEEK 2 CORE • Reproduce and create documents that incorporate text, graphics, and data • Consolidate content, concepts and skills previously covered using case studies to: ♣ or CONCEPTS, • Manipulate graphics and text within documents software and make informed decisions SKILLS, AND • Use integrated software to create and design documents for specific purposes • Identify general hardware configuration VALUES • Apply general principles of layout and design to a document process • Understand computers and their uses • Emphasise information using techniques such as placement and colour • ICTs as tools to access information and to communicate with others around the world • Create documents by customising templates • Make better buying decisions interpret advertisements and make judgements about • Use media, visual literacy, and technology skills to create products that express quality and usefulness when buying equipment and software understanding • Know how to fix ordinary computer problems and deal with challenges that arise from utilising computers • Know the appropriate use the Internet and e-mail, Appropriate use application packages • Make informed decisions and choices in selecting communication devices and modes of communications for a given scenario Final NSC examinations • Know what kind of computer uses benefit and advance work and career path opportunities • Know how to protect oneself against online villains and threats • Understand technology concepts, systems, and operations and how it operates efficiently, effectively, and accurately • Know how to apply digital tools to: Communicate, gather, analyse, use information, solve problems • Understand technology concepts, systems, and operations and how it operates efficiently, effectively, and accurately • Recommend specific hardware, software for a specific scenario • Know about upgrading and how to integrate equipment with new products, technology • Understand when to upgrade, when to buy new equipment or software and make informed decisions Downloaded from hlayiso.com 4

2023/24 ANNUAL TEACHING PLANS: COMPUTER APPLICATIONS TECHNOLOGY: GRADE 12 ADDITIONAL INFORMATION TEACHING TIME PER 4 hours per week required WEEK • If contact time is lost a recovery plan must be in place • Your recovery plan and remediation plan must be reflected in your subject improvement plan – update it throughout the year • Indicate on the teaching plan 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 (OTHER THAN TEXTBOOK) • Data projector TO ENHANCE LEARNING • 1 Learner per computer • Entry level computers networked • Multifunction printer • Internet connectivity Software • Notepad ++ • Office 2016 or later version (Word, Excel, Access, PowerPoint) • Windows 10 or later version Maintenance plan General • Slide presentations - summarised content • Notebook for summaries and activities • Online content, resources • Video clips • Posters with new concepts, formulas, functions • Previous question papers EXAMPLES OF FORMATIVE • Concept maps for summaries • Competitions, gaming (fun activities) ASSESSMENTS, • Brainstorm sessions • Peer assessment RETRIEVAL PRACTICE • Quizzes (Google Forms, MS Forms, Kahoots!, etc.) for retrieval practice • Extended opportunities, activities, etc. IMPORTANT DOCUMENTS • Updated CAPS for 2023 with updated CAT Grade 10 content TO USE WITH THE ATP • Introduction to HTML booklet, Grade 11 DBE textbook Chapter 15 page 216 • Chapter 4 – latest Assessment Instructions • Gr 12 Exam Guidelines with new concepts (new technologies where applicable) Downloaded from hlayiso.com 5