examly

Grade 12 Information Technology

Annual Teaching Plan (Terms 1-4)

The Grade 12 Information Technology (IT) CAPS syllabus for South Africa follows the annual teaching plan with database design, OOP, systems technologies, SQL, solution development, social implications and PAT milestones across Terms 1-4. Use the term topics below with Grade 12 IT past papers for NSC 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: PAT, alternative test, theory test (as listed).

Database: design and concepts

Logging in/passwords; relational database design; normalisation; transaction processing; characteristics of good database design; caring for and managing data; hacking through data. Database management and design concepts; split tables and create relations; key fields and relationships.

OOP

Reinforce programming skills: parameterised and non-parameterised constructors; correct use of private/public attributes; accessor, mutator and auxiliary methods; ToString and accessor methods for output; correct instantiation; use of methods as part of problem solving.

Hardware

Mobile technologies; factors influencing computer performance; motivate a typical computer system for user requirements.

SQL

Design and develop a solution incorporating SQL: SELECT fields, calculated fields (AS), ROUND/INT/LENGTH/LEFT/RIGHT/MID, concatenating fields, WHERE with operators, AND/OR/NOT, IS NULL/NULL, IN.

Social implications

Advantages and disadvantages of how mobile technology impacts privacy (personal and business). IoT technologies and impact on society.

PAT

PAT milestones including data collection overview and examples, location-based data, data warehousing and mining, database characteristics and problems, and analysis of requirements using an appropriate methodology.

Database: design and concepts

Logging in/passwords; relational database design; normalisation; transaction processing; characteristics of good database design; caring for and managing data; hacking through data. Database management and design concepts; split tables and create relations; key fields and relationships.

OOP

Reinforce programming skills: parameterised and non-parameterised constructors; correct use of private/public attributes; accessor, mutator and auxiliary methods; ToString and accessor methods for output; correct instantiation; use of methods as part of problem solving.

Hardware

Mobile technologies; factors influencing computer performance; motivate a typical computer system for user requirements.

SQL

Design and develop a solution incorporating SQL: SELECT fields, calculated fields (AS), ROUND/INT/LENGTH/LEFT/RIGHT/MID, concatenating fields, WHERE with operators, AND/OR/NOT, IS NULL/NULL, IN.

Social implications

Advantages and disadvantages of how mobile technology impacts privacy (personal and business). IoT technologies and impact on society.

PAT

PAT milestones including data collection overview and examples, location-based data, data warehousing and mining, database characteristics and problems, and analysis of requirements using an appropriate methodology.

Term 2 topics

Weeks 1-11

Assessment: Mid-year examination (Paper 1 and Paper 2, 150 marks each, 3 hours). SBA includes PAT and practical test.

Systems technologies

Factors influencing computer management; overview of cloud computing, virtual reality, augmented reality and virtualisation.

SQL

DISTINCT, ORDER BY; calculated fields; string functions; WHERE with operators; INSERT/DELETE/UPDATE; aggregate functions; join queries; date functions; parameter queries; modifying data in tables.

Solution development

Arrays as a data structure (2-dimensional); design and develop solutions using computational thinking and software engineering principles.

Social implications

Computer criminals and computer crime.

PAT

PAT milestones integrated across term.

Mid-year examination structure

Paper 1: programming skills, database, OOP, general problem-solving. Paper 2: systems technologies, communications and network technologies, data and information management, solution development, integrated scenario.

Systems technologies

Factors influencing computer management; overview of cloud computing, virtual reality, augmented reality and virtualisation.

SQL

DISTINCT, ORDER BY; calculated fields; string functions; WHERE with operators; INSERT/DELETE/UPDATE; aggregate functions; join queries; date functions; parameter queries; modifying data in tables.

Solution development

Arrays as a data structure (2-dimensional); design and develop solutions using computational thinking and software engineering principles.

Social implications

Computer criminals and computer crime.

PAT

PAT milestones integrated across term.

Mid-year examination structure

Paper 1: programming skills, database, OOP, general problem-solving. Paper 2: systems technologies, communications and network technologies, data and information management, solution development, integrated scenario.

Term 3 topics

Weeks 1-11

Assessment: Trial examination (Paper 1 and Paper 2, 150 marks each, 3 hours). SBA includes PAT, theory/practical test, practical exam.

Software engineering

Reinforce software engineering principles.

Internet services technologies

Improved searching, online applications, role of SQL and scripting languages, formatting output.

Communication technologies

Linking nodes, connecting to the internet, sharing concepts, online services, remote access, overview of security concepts.

Social implications

Explain how computers provide solutions to issues.

Solution development

Consolidate and reinforce content; design and develop solutions using computational thinking and software engineering principles.

PAT

PAT milestones integrated across term.

Trial examination structure

Paper 1: programming skills, database, OOP, general problem-solving. Paper 2: systems technologies, communications and network technologies, data and information management, solution development, integrated scenario.

Software engineering

Reinforce software engineering principles.

Internet services technologies

Improved searching, online applications, role of SQL and scripting languages, formatting output.

Communication technologies

Linking nodes, connecting to the internet, sharing concepts, online services, remote access, overview of security concepts.

Social implications

Explain how computers provide solutions to issues.

Solution development

Consolidate and reinforce content; design and develop solutions using computational thinking and software engineering principles.

PAT

PAT milestones integrated across term.

Trial examination structure

Paper 1: programming skills, database, OOP, general problem-solving. Paper 2: systems technologies, communications and network technologies, data and information management, solution development, integrated scenario.

Term 4 revision focus

Weeks 1-10

Assessment: Final NSC examination.

Content using case studies (all topics)

Revision using case studies across all topics (3-4 hours).

Final NSC examination

Final NSC examination.

Content using case studies (all topics)

Revision using case studies across all topics (3-4 hours).

Final NSC examination

Final NSC examination.