examly

Grade 11 Computer Applications Technology

Annual Teaching Plan (Terms 1-4)

The Grade 11 Computer Applications Technology (CAT) CAPS syllabus in South Africa follows the annual teaching plan with systems technologies, network and internet technologies, solution development in word processing, spreadsheets, databases and HTML, plus information management and PAT phases across Terms 1-4. Use the term topics below with Grade 11 CAT past papers for exam preparation.

How to study using this page: Revise term topics attempt past papers mark with memos.

Term 1 topics

Weeks 1-11

Assessment: SBA: Task 1 Theory test (minimum marks: 50) and Task 2 Practical test (minimum marks: 50) to be completed by end of term.

Systems technologies: General concepts

Information processing cycle (input, output, processing, storage and communication); types of computing devices and typical features; categorise computing devices; role of ICTs in the workplace (extend from Grade 10).

Systems technologies: Hardware

Input and output concepts (purpose, when to use, advantages, disadvantages and limitations); multi-touch screen; input and output devices for physically challenged users; extend from Grade 10 with 3D printers, HDMI, wearable devices and wearable technologies; accessibility options. Primary storage (memory) vs secondary storage; online storage; SSD; memory card storage.

Social implications

Hardware theft and protection; power settings; saving and protection against power failure; factors influencing health and health risks; value of CAT, career options and further study.

Systems technologies: Computer management

Processing: role of basic components of the system unit; overview and basic concepts of the start-up process.

Solution development: Word processing

File management and working with different file formats (text files, csv, rtf, tables). Editing (paste special, find and replace with more options). Printing. Page layout (themes, document layout). Paragraph features (customise bullets and numbering, outline numbering/multi-level lists, spacing). Templates (agenda, memo, basic resume, CV). Electronic forms (legacy controls), Google forms and Microsoft forms, import/export data, online and offline help.

Solution development: Spreadsheets

Reinforce Grade 10 content; absolute cell referencing; autofill options; functions including SUMIF, POWER, RAND, SMALL, LARGE; rounding off numbers and the difference between rounding and formatting; conditional formatting; interpreting error indicators (circular reference, #NULL!). Simple IF function with relational operators (> < <= >= <>).

Solution development: Database

First look at objects (table, form, query, report). Tables: records and fields; field names; basic field properties (size, length, default value, decimal places, required).

Systems technologies: General concepts

Information processing cycle (input, output, processing, storage and communication); types of computing devices and typical features; categorise computing devices; role of ICTs in the workplace (extend from Grade 10).

Systems technologies: Hardware

Input and output concepts (purpose, when to use, advantages, disadvantages and limitations); multi-touch screen; input and output devices for physically challenged users; extend from Grade 10 with 3D printers, HDMI, wearable devices and wearable technologies; accessibility options. Primary storage (memory) vs secondary storage; online storage; SSD; memory card storage.

Social implications

Hardware theft and protection; power settings; saving and protection against power failure; factors influencing health and health risks; value of CAT, career options and further study.

Systems technologies: Computer management

Processing: role of basic components of the system unit; overview and basic concepts of the start-up process.

Solution development: Word processing

File management and working with different file formats (text files, csv, rtf, tables). Editing (paste special, find and replace with more options). Printing. Page layout (themes, document layout). Paragraph features (customise bullets and numbering, outline numbering/multi-level lists, spacing). Templates (agenda, memo, basic resume, CV). Electronic forms (legacy controls), Google forms and Microsoft forms, import/export data, online and offline help.

Solution development: Spreadsheets

Reinforce Grade 10 content; absolute cell referencing; autofill options; functions including SUMIF, POWER, RAND, SMALL, LARGE; rounding off numbers and the difference between rounding and formatting; conditional formatting; interpreting error indicators (circular reference, #NULL!). Simple IF function with relational operators (> < <= >= <>).

Solution development: Database

First look at objects (table, form, query, report). Tables: records and fields; field names; basic field properties (size, length, default value, decimal places, required).

Term 2 topics

Weeks 1-11

Assessment: SBA & PAT: PAT Phase 1 and Task 3 Mid-year examination to be completed by end of term (as listed in ATP). Includes a control test and consolidation of term work.

Solution development: Spreadsheets

Reinforce Grade 10 skills; spreadsheet functions including COUNTIF, COUNTA, COUNTBLANK, SUMIF; formatting and editing; sorting; basic data validation techniques; filters; working with different views.

Solution development: Database

Work with different views (design and table view). Design database tables and choose appropriate data types; reinforce and extend field properties; queries (basic queries using AND, OR, NOT, sorting, and selecting fields to display).

Network technologies: Networks

Local area networks (LAN and WLAN) and basic components; connection wired vs wireless; intranet definition and uses; basic network security; unauthorised access; ethical use of networks; network safety and security issues.

Internet technologies: Internet and WWW

Usability of web pages and websites; explore and evaluate websites; Internet of Things (IoT).

Social implications

Privacy issues; BYOD; big data; crypto currency vs normal currency; block chain.

Information management

Task definition; data and information gathering; quality control of information; evaluate questions, information and websites.

Solution development: Word processing (styles)

Styles: quick style gallery, style set, change and edit a style, create a new style.

Solution development: Spreadsheets (IF and charts)

Simple IF with relational operators; charts and graphs (create, format and edit) with meaningful titles and labels, gridlines and legends; choose options appropriate to the graph type.

Solution development: HTML and web design

Reinforce concepts of websites, web pages, hyperlinks and URLs; HTML syntax; basic HTML tags (opening and closing tag); comments; structure and design of a simple HTML page; consolidation and practice of HTML.

Control test and consolidation

Control test and consolidation of term work (as listed in ATP).

Solution development: Spreadsheets

Reinforce Grade 10 skills; spreadsheet functions including COUNTIF, COUNTA, COUNTBLANK, SUMIF; formatting and editing; sorting; basic data validation techniques; filters; working with different views.

Solution development: Database

Work with different views (design and table view). Design database tables and choose appropriate data types; reinforce and extend field properties; queries (basic queries using AND, OR, NOT, sorting, and selecting fields to display).

Network technologies: Networks

Local area networks (LAN and WLAN) and basic components; connection wired vs wireless; intranet definition and uses; basic network security; unauthorised access; ethical use of networks; network safety and security issues.

Internet technologies: Internet and WWW

Usability of web pages and websites; explore and evaluate websites; Internet of Things (IoT).

Social implications

Privacy issues; BYOD; big data; crypto currency vs normal currency; block chain.

Information management

Task definition; data and information gathering; quality control of information; evaluate questions, information and websites.

Solution development: Word processing (styles)

Styles: quick style gallery, style set, change and edit a style, create a new style.

Solution development: Spreadsheets (IF and charts)

Simple IF with relational operators; charts and graphs (create, format and edit) with meaningful titles and labels, gridlines and legends; choose options appropriate to the graph type.

Solution development: HTML and web design

Reinforce concepts of websites, web pages, hyperlinks and URLs; HTML syntax; basic HTML tags (opening and closing tag); comments; structure and design of a simple HTML page; consolidation and practice of HTML.

Control test and consolidation

Control test and consolidation of term work (as listed in ATP).

Term 3 topics

Weeks 1-11

Assessment: SBA & PAT: Task 4 Practical test (minimum marks: 50) and Task 5 Theory test/alternative test (minimum marks: 50) to be completed by end of term. PAT phases listed: finalise PAT Phase 1, start/continue PAT Phase 2, and PAT Phase 3.

Systems technologies: Software

Role of application software; compatibility issues; updating software; online and web applications; software for users with disabilities.

Internet technologies: Internet, WWW and communications

Web applications; authentication; types of digital communications; overview of online services; portable and mobile internet and cellular data service (cell phone as a modem); browser and e-mail software; website accessibility; LTE; 802.11 A, B, G, N; 4IR and 5IR.

Systems technologies: Hardware, software and computer management

Basic system requirements and links to software; software installation; portable storage medium; internet download; management of files.

Social implications

Effects of computer and human error; data types; verification and validation of data; software bugs; hardware failure; how ICTs impact the workplace and employment practices; introduction to e-learning and m-learning.

Information management and practical assessment task

Information management tasks and PAT work: finalise PAT Phase 1, start PAT Phase 2, and Phase 3 of PAT (as listed in ATP). Role of spreadsheets and databases to process and manipulate data to provide information.

Solution development: Database (reports)

Reports including basic calculations at end of report; page headers and footers; report headers and footers; import and export data.

Solution development: Spreadsheets (printing and integration)

Import/export data; work with sheets; different print options; integration techniques within the package.

Solution development: Word processing (advanced features)

Mail merge; reference; table of contents; footnotes; captions; citations and bibliography.

Solution development: HTML and web design

Good website and page design (including use of colour); HTML links (attributes target and name); images (attributes source and alternate text); lists.

Systems technologies: Software

Role of application software; compatibility issues; updating software; online and web applications; software for users with disabilities.

Internet technologies: Internet, WWW and communications

Web applications; authentication; types of digital communications; overview of online services; portable and mobile internet and cellular data service (cell phone as a modem); browser and e-mail software; website accessibility; LTE; 802.11 A, B, G, N; 4IR and 5IR.

Systems technologies: Hardware, software and computer management

Basic system requirements and links to software; software installation; portable storage medium; internet download; management of files.

Social implications

Effects of computer and human error; data types; verification and validation of data; software bugs; hardware failure; how ICTs impact the workplace and employment practices; introduction to e-learning and m-learning.

Information management and practical assessment task

Information management tasks and PAT work: finalise PAT Phase 1, start PAT Phase 2, and Phase 3 of PAT (as listed in ATP). Role of spreadsheets and databases to process and manipulate data to provide information.

Solution development: Database (reports)

Reports including basic calculations at end of report; page headers and footers; report headers and footers; import and export data.

Solution development: Spreadsheets (printing and integration)

Import/export data; work with sheets; different print options; integration techniques within the package.

Solution development: Word processing (advanced features)

Mail merge; reference; table of contents; footnotes; captions; citations and bibliography.

Solution development: HTML and web design

Good website and page design (including use of colour); HTML links (attributes target and name); images (attributes source and alternate text); lists.

Term 4 revision focus

Weeks 1-10

Assessment: Formal assessment: Practical assessment task Phase 3 to be completed before end-of-year examinations. Task 6 End-of-year examination: Practical paper 1 (150 marks) and Theory paper 2 (150 marks) (3 hours each) (as listed in ATP).

Internet technologies: Communications

Managing e-mail: organise with folders, sort by, flag and prioritise; distribution lists and message rules; register a web-based email address; URL shortener.

Social implications

Social engineering tricks; information accuracy; data protection; computer misuse; online harassment; malware and security software; e-commerce and e-banking; ransomware; clickjacking; screen lock patterns; introduction to AI.

Content using case studies and consolidation

Content using case studies and consolidation using case studies and final examination (as listed in ATP). Includes applying skills across word processor, spreadsheet, presentations and database, and finalising PAT.

Internet technologies: Communications

Managing e-mail: organise with folders, sort by, flag and prioritise; distribution lists and message rules; register a web-based email address; URL shortener.

Social implications

Social engineering tricks; information accuracy; data protection; computer misuse; online harassment; malware and security software; e-commerce and e-banking; ransomware; clickjacking; screen lock patterns; introduction to AI.

Content using case studies and consolidation

Content using case studies and consolidation using case studies and final examination (as listed in ATP). Includes applying skills across word processor, spreadsheet, presentations and database, and finalising PAT.