Grade 12 Computer Applications Technology

Types of computer systems for different uses (personal, SOHO, mobile and power users), role and use of data, information, knowledge, conclusion and decision in information management, reasons for using computers, and convergence.

Input, output, processing, storage and communication in the information processing cycle; reinforce hardware and software for uses and buying decisions. Input and output devices (multi-touch screen, HDMI, 3D printers, monitor response time), storage devices and media (SSD, card reader), and troubleshooting ordinary problems and new technologies.

Software that enhances accessibility, efficiency and productivity; uses of common applications; web-based versus installed applications; interpret system requirements; common software problems and upgrades; risks of using flawed software.

Environmental issues and user-centred design in software applications such as websites, database forms and presentations.

Reinforce Grade 11 content; revise forms and queries; reports and report design (grouping, headers and footers, calculations); calculations in queries and reports; data validation techniques; queries using AND, OR, NOT, wildcards (*), and IS NULL.

Reinforce content, concepts and skills; function vs formula; named ranges; complex functions (nested IF, vertical and horizontal LOOKUP and XLOOKUP), error indicator #N/A; variations such as ROUNDUP, ROUNDDOWN, COUNTIFS, SUMIFS; additional functions (RANDBETWEEN, UPPER, LOWER, AND, OR); SUBTOTAL (AVERAGE, COUNT, SUM); combinations of functions and formulae; date and time calculations (YEAR, MONTH, DAY, DAYS, HOUR, MINUTE, SECOND, TIME, TODAY, NOW); Find and Select; file management (extract a password-protected .exe file).

Reinforce Grade 10 and 11 skills; links (bookmark, hyperlink, cross-reference); referencing options (index and table of figures); reviewing, proofing and tracking changes; line breaks and pagination (widow and orphan control); electronic forms (legacy controls); import data from electronic forms (MS and Google forms); editing group options.

Set questionnaires, gather information and data, discuss professional formal reports, and the use of spreadsheets and databases in professional reports. Reinforce content from Grades 10 and 11. ATP notes inland/coastal timing differences.

Wide area networks (WAN) with the Internet as an example; internet services and government internet services and information; streaming; informed decisions about internet connection and access, broadband and bandwidth; throttling and shaping; fair use policy; communication devices and standards for wireless communication; modem, router and NFC; clarify blurred technologies.

Internet technologies (URL shortener, browser add-on, using browsers productively, IoT, wearables). Computer crimes related to hardware, software, information, identity, bandwidth theft, theft of time and services; internet-related fraud and scams (phishing, spoofing, pharming). Internet attacks (DDoS), bots and zombies, right to access vs right to privacy, misuse of personal information, security issues (clickjacking, ransomware), safeguards (VPN, firewall, screen lock pattern), and impact of technology on society (crowdfunding, BYOD, big data, Bitcoin, 4IR, 5IR, Blockchain).

Reinforce Grade 11 skills (underline tag, border around image, good web page design, use of colour). HTML tables and syntax; attributes (border, cell padding); links to target location; develop a web page for a specific scenario; tags from the HTML tag list.

Reinforce and consolidate content, concepts and skills with text functions such as LEFT, RIGHT, MID, CONCATENATE, LEN, VALUE and FIND (including position of text in a cell).

Reinforce and consolidate content, concepts and skills; mail merge with different data sources (database, Word table, spreadsheet, CSV); objects (tables, graphics), linking and embedding; reinforce tabs.

Reinforce and consolidate content; design a database for a specific scenario; interpret and deduce data and information (derive data types or validation rules without specific instructions).

Practical assessment task: reinforce information management skills and use data gathered for processing and analysing. Include transfer of skills between applications. HTML: use the Cite tag in PAT (not examinable).

Reinforce information management skills and use information and data gathered for processing and analysing.

Role of the operating system; manage programs; file management; operating system utilities; scheduling; updates; security features (access control, backup, anti-virus software); factors influencing performance; file management (extract password-protected .exe file).

Types of digital communications (video conferencing), typical web browser features, uses of computer communications, digital communications and communication devices.

Impact and use of social networking sites and technologies; legal and ethical issues; remote access (including VPN); e-commuting, e-working and e-learning; m-learning and blended learning; how technology can benefit or harm society; information overload; VR, AR, AI; geotagging.

Documents using styles; page layout with advanced word processing techniques; integration with other software including linking objects.

Date and time, maths, statistical, text, logical, lookup and reference functions; advanced combinations of functions and formulas; select an appropriate graph for a scenario.

Consolidate and reinforce content; create a database for given scenarios; integration techniques; multiple related tables while working with one table at a time.

Reinforce content, concepts and skills; good website and page design; transfer skills between applications.

Consolidation and preparatory exams; PAT completion.

Final NSC examinations and consolidation of content, concepts and skills previously covered, including document creation, integrated software use, layout and design, communication and information management, technology concepts, and informed decisions about hardware and software. Case study focus includes: [unclear].