Sample Notes: Data Representation

Sample Notes: Algorithms

Sample Quizzes For Preparation: Data Representation

Sample Quizzes For Preparation: Algorithms

Schedule For Live Classes

Zoom Details

Course Breakup

Data Representation: Show Understanding Of Binary Magnitudes And The Difference Between Binary Prefixes And Decimal Prefixes

Data Representation: Show Understanding Of Different Number Systems

Data Representation: Show Understanding Of How Overflow Can Occur

Data Representation: Show Understanding Of How Overflow Can Occur

Data Representation: Show Understanding Of And Be Able To Represent Character Data In Its Internal Binary Form, Depending On The Character Set Used

Multimedia – Graphics: Show Understanding Of How Data For A Bitmapped Image Are Encoded

Multimedia – Graphics: Perform Calculations To Estimate The File Size For A Bitmap Image

Multimedia – Graphics: Show Understanding Of The Effects Of Changing Elements Of A Bitmap Image On The Image Quality And File Size

Multimedia – Graphics: Show Understanding Of How Data For A Vector Graphic Are Encoded

Multimedia – Graphics: Justify The Use Of A Bitmap Image Or A Vector Graphic For A Given Task

Multimedia – Sound: Show Understanding Of How Sound Is Represented And Encoded

Multimedia – Sound: Show Understanding Of The Impact Of Changing The Sampling Rate And Resolution

Compression: Show Understanding Of The Need For And Examples Of The Use Of Compression

Compression: Show Understanding Of Lossy And Lossless Compression And Justify The Use Of A Method In A Given Situation

Compression: Show Understanding Of How A Text File, Bitmap Image, Vector Graphic And Sound File Can Be Compressed

Networks Including The Internet: Show Understanding Of The Purpose And Benefits Of Networking Devices

Networks Including The Internet: Show Understanding Of The Characteristics Of A LAN (Local Area Network) And A WAN (Wide Area Network)

Networks Including The Internet: Explain The Client-Server And Peer-To-Peer Models Of Networked Computers

Networks Including The Internet: Show Understanding Of Thin-Client And Thick-Client And The Differences Between Them

Networks Including The Internet: Show Understanding Of The Bus, Star, Mesh And Hybrid Topologies

Networks Including The Internet: Understand How Packets Are Transmitted Between Two Hosts For A Given Topology

Networks Including The Internet: Justify The Use Of A Topology For A Given Situation

Networks Including The Internet: Show Understanding Of Cloud Computing

Networks Including The Internet: Show Understanding Of The Differences Between And Implications Of The Use Of Wireless And Wired Networks

Networks Including The Internet: Describe The Characteristics Of Copper Cable, Fibre-Optic Cable, Radio Waves (Including WiFi), Microwaves, Satellites

Networks Including The Internet: Describe The Hardware That Is Used To Support A LAN

Networks Including The Internet: Describe The Role And Function Of A Router In A Network

Networks Including The Internet: Show Understanding Of Ethernet And How Collisions Are Detected And Avoided

Networks Including The Internet: Show Understanding Of Bit Streaming

Networks Including The Internet: Show Understanding Of The Differences Between The World Wide Web (WWW) And The Internet

Networks Including The Internet: Describe The Hardware That Is Used To Support The Internet

Networks Including The Internet: Explain The Use Of IP Addresses In The Transmission Of Data Over The Internet

Networks Including The Internet: Explain How A Uniform Resource Locator (URL) Is Used To Locate A Resource On The World Wide Web (WWW) And The Role Of The Domain Name Service (DNS)

Computers And Their Components: Show Understanding Of The Need For Input, Output, Primary Memory And Secondary (Including Removable) Storage

Computers And Their Components: Show Understanding Of Embedded Systems

Computers And Their Components: Describe The Principal Operations Of Hardware Devices

Computers And Their Components: Show Understanding Of The Use Of Buffers

Computers And Their Components: Explain The Differences Between Random Access Memory (RAM) And Read Only Memory (ROM)

Computers And Their Components: Explain The Differences Between Static RAM (SRAM) And Dynamic RAM (DRAM)

Computers And Their Components: Explain The Difference Between Programmable ROM (PROM), Erasable Programmable ROM (EPROM) And Electrically Erasable Programmable ROM (EEPROM)

Computers And Their Components: Show An Understanding Of Monitoring And Control Systems

Logic Gates And Logic Circuits: Understand And Define The Functions Of NOT, AND, OR, NAND, NOR And XOR (EOR) Gates

Logic Gates And Logic Circuits: Construct The Truth Table For Each Of The Logic Gates Above

Logic Gates And Logic Circuits: Construct A Logic Circuit From A Problem Statement, A Logic Expression, Or A Truth Table

Logic Gates And Logic Circuits: Construct A Truth Table From A Problem Statement, A Logic Circuit, Or A Logic Expression

Logic Gates And Logic Circuits: Construct A Logic Expression From A Problem Statement, A Logic Circuit, Or A Truth Table

Central Processing Unit (CPU) Architecture: Show Understanding Of The Basic Von Neumann Model For A Computer System And The Stored Program Concept

Central Processing Unit (CPU) Architecture: Show Understanding Of The Purpose And Role Of Registers, Including The Difference Between General Purpose And Special Purpose Registers

Central Processing Unit (CPU) Architecture: Show Understanding Of The Purpose And Roles Of The Arithmetic And Logic Unit (ALU), Control Unit (CU) And System Clock, Immediate Access Store (IAS)

Central Processing Unit (CPU) Architecture: Show Understanding Of How Data Are Transferred Between Various Components Of The Computer System Using The Address Bus, Data Bus And Control Bus

Central Processing Unit (CPU) Architecture: Show Understanding Of How Factors Contribute To The Performance Of The Computer System

Central Processing Unit (CPU) Architecture: nderstand How Different Ports Provide Connection To Peripheral Devices

Central Processing Unit (CPU) Architecture: Describe The Stages Of The Fetch-Execute (F-E) Cycle

Central Processing Unit (CPU) Architecture: Show Understanding Of The Purpose Of Interrupts

Assembly Language: Show Understanding Of The Relationship Between Assembly Language And Machine Code

Assembly Language: Describe The Different Stages Of The Assembly Process For A Two-Pass Assembler

Assembly Language: Describe The Different Stages Of The Assembly Process For A Two-Pass Assembler

Assembly Language: Show Understanding That A Set Of Instructions Are Grouped

Assembly Language: Show Understanding Of And Be Able To Use Different Modes Of Addressing

Bit Manipulation: Show Understanding Of And Perform Binary Shifts

Bit Manipulation: Show Understanding Of How Bit Manipulation Can Be Used To Monitor/Control A Device

Operating Systems: Explain Why A Computer System Requires An Operating System (OS)

Operating Systems: Explain The Key Management Tasks Carried Out By The Operating System

Operating Systems: Show Understanding Of The Need For Typical Utility Software Provided With An Operating System

Operating Systems: how Understanding Of Program Libraries

Language Translators: Show Understanding Of The Need For Assembler Software, Compiler And Interpreter

Language Translators: Explain The Benefits And Drawbacks Of Using Either A Compiler Or Interpreter And Justify The Use Of Each

Language Translators: Show Awareness That High-Level Language Programs May Be Partially Compiled And Partially Interpreted

Language Translators: Describe Features Found In A Typical Integrated Development Environment (IDE)

Data Security: Explain The Difference Between The Terms Security, Privacy And Integrity Of Data

Data Security: Show Appreciation Of The Need For Both The Security Of Data And The Security Of The Computer System

Data Security: Describe Security Measures Designed To Protect Computer Systems

Data Security: Show Understanding Of The Threats To Computer And Data Security Posed By Networks And The Internet

Data Security: Describe Methods That Can Be Used To Restrict The Risks Posed By Threats

Data Security: Describe Security Methods Designed To Protect The Security Of Data

Data Integrity: Describe How Data Validation And Data Verification Help Protect The Integrity Of Data

Data Integrity: Describe and Use Methods of Data Validation

Data Integrity: Describe and Use Methods of Data Verification During Data Entry and Data Transfer

Ethics And Ownership: Show Understanding Of The Need For And Purpose Of Ethics As A Computing Professional

Ethics And Ownership: Show Understanding Of The Need To Act Ethically And The Impact Of Acting Ethically Or Unethically For A Given Situation

Ethics And Ownership: Show Understanding Of The Need For Copyright Legislation

Ethics And Ownership: Show Understanding Of The Different Types Of Software Licencing And Justify The Use Of A Licence For A Given Situation

Ethics And Ownership: Show Understanding Of Artificial Intelligence (AI)

Database Concepts: Show Understanding Of The Limitations Of Using A File-Based Approach For The Storage And Retrieval Of Data

Database Concepts: Describe The Features Of A Relational Database That Address The Limitations Of A File-Based Approach

Database Concepts: Show Understanding Of And Use The Terminology Associated With A Relational Database Model

Database Concepts: Use An Entity-Relationship (E-R) Diagram To Document A Database Design

Database Concepts: Show Understanding Of The Normalisation Process

Database Concepts: Explain Why A Given Set Of Database Tables Are, Or Are Not, In 3NF

Database Concepts: Produce A Normalised Database Design For A Description of a Database, a Given Set of Data, or A Given Set of Tables

Database Management Systems (DBMS): Show Understanding Of The Features Provided By A Database Management System (DBMS) That Address The Issues Of A File Based Approach

Database Management Systems (DBMS): Show Understanding Of How Software Tools Found Within A DBMS Are Used In Practice

Show Understanding Of How Software Tools Found Within A DBMS Are Used In Practice: Show Understanding That The DBMS Carries Out All Creation/Modification Of The Database Structure Using Its Data Definition Language (DDL)

Show Understanding Of How Software Tools Found Within A DBMS Are Used In Practice: Show Understanding That The DBMS Carries Out All Queries And Maintenance Of Data Using Its DML

Show Understanding Of How Software Tools Found Within A DBMS Are Used In Practice: Show Understanding That The Industry Standard For Both DDL And DML Is Structured Query Language (SQL)

Show Understanding Of How Software Tools Found Within A DBMS Are Used In Practice: Understand given SQL (DDL) statements and Be Able To Write Simple SQL (DDL) Statements Using A Sub-Set of Statements

Show Understanding Of How Software Tools Found Within A DBMS Are Used In Practice: Write An SQL Script To Query Or Modify Data (DML) Which Are Stored In (At Most Two) Database Tables

Computational Thinking Skills: Computational Thinking Skills:

Computational Thinking Skills: Describe And Use Decomposition

Algorithms: Show Understanding That An Algorithm Is A Solution To A Problem Expressed As A Sequence Of Defined Steps

Algorithms: Write Pseudocode That Contains Input, Process And Output

Algorithms: Write Pseudocode Using The Three Basic Constructs Of Sequence, Selection And Iteration

Algorithms: Document A Simple Algorithm Using A Structured English Description, A Flowchart Or Pseudocode

Algorithms: Write Pseudocode From A Structured English Description Or A Flowchart

Algorithms: Draw A Flowchart From A Structured English Description Or Pseudocode

Algorithms: Describe And Use The Process Of Stepwise Refinement To Express An Algorithm To A Level Of Detail From Which The Task May Be Programmed

Algorithms: Use Logic Statements To Define Parts Of An Algorithm Solution

Data Types And Records: Select And Use Appropriate Data Types For A Problem Solution

Data Types And Records: Show Understanding Of The Purpose Of A Record Structure To Hold A Set Of Data Of Different Data Types Under One Identifier

Arrays: Use The Technical Terms Associated With Arrays

Arrays: Select A Suitable Data Structure (1D Or 2D Array) To Use For A Given Task

Arrays: Write Pseudocode For 1D And 2D Arrays

Arrays: Write Pseudocode To Process Array Data

Files: Show Understanding Of Why Files Are Needed

Files: Write Pseudocode To Handle Text Files That Consist Of One Or More Lines

Introduction To Abstract Data Types (ADT): Show Understanding That An ADT Is A Collection Of Data And A Set Of Operations On Those Data

Introduction To Abstract Data Types (ADT): Show Understanding That A Stack, Queue And Linked List Are Examples Of ADTs

Introduction To Abstract Data Types (ADT): Use A Stack, Queue And Linked List To Store Data

Introduction To Abstract Data Types (ADT): Describe How A Queue, Stack And Linked List Can Be Implemented Using Arrays

Programming Basics: Implement And Write Pseudocode From A Given Design Presented As Either A Program Flowchart Or Structured English

Programming Basics: Write Pseudocode Statements

Programming Basics: Use Built-in Functions and Library Routines

Constructs: Use Pseudocode To Write IF Statements, CASE Structures, Count-Controlled Loops, Post-Condition Loops, And Pre-Condition Loops

Constructs: Justify Why One Loop Structure May Be Better Suited To Solve A Problem Than The Others

Structured Programming: Define And Use A Procedure

Structured Programming: Explain Where In The Construction Of An Algorithm It Would Be Appropriate To Use A Procedure

Structured Programming: Use Parameters (By Value Or By Reference)

Structured Programming: Define And Use A Function

Structured Programming: Explain Where In The Construction Of An Algorithm It Is Appropriate To Use A Function

Structured Programming: Use The Terminology Associated With Procedures And Functions

Structured Programming: Write Efficient Pseudocode

Write Efficient Pseudocode: Show Understanding Of The Purpose Of A Development Life Cycle

Write Efficient Pseudocode: Show Understanding Of The Need For Different Development Life Cycles Depending On The Program Being Developed

Write Efficient Pseudocode: Describe The Principles, Benefits And Drawbacks Of Each Type Of Life Cycle

Write Efficient Pseudocode: Show Understanding Of The Analysis, Design, Coding, Testing And Maintenance Stages In The Program Development Life Cycle

Program Design: Use A Structure Chart To Decompose A Problem Into Sub-Tasks

Program Design: Show Understanding Of The Purpose Of State-Transition Diagrams To Document An Algorithm

Program Testing And Maintenance: Show Understanding Of Ways Of Exposing And Avoiding Faults In Programs

Program Testing And Maintenance: Locate And Identify Different Types Of Errors

Program Testing And Maintenance: Correct Identified Errors

Program Testing And Maintenance: Show Understanding Of The Methods Of Testing Available And Select Appropriate Data For A Given Method

Program Testing And Maintenance: Show Understanding Of The Need For A Test Strategy And Test Plan And Their Likely Contents

Program Testing And Maintenance: Choose Appropriate Test Data For A Test Plan

Program Testing And Maintenance: Show Understanding Of The Need For Continuing Maintenance Of A System And The Differences Between Each Type Of Maintenance

Program Testing And Maintenance: Analyse An Existing Program And Make Amendments To Enhance Functionality

Data Representation

Multimedia: Graphics, Sound

Compression

Network Including The Internet

Central Processing Unit (CPU) Architecture

Logic Gates and Logic Circuits

Assembly Language

Bit Manipulation

Operating Systems

Language Translators

Data Security

Data Integrity

Database Concepts

Database Management Systems (DMBS)

Data Definition Language (DDL) And Data Manipulation Language (DML)

Ethics And Ownership

Computer And Their Components

Logic Gates And Logic Circuits

Computational Thinking Skills

Algorithms

Data Types And Records

Arrays

Files

Introduction To Abstract Data Types (ADT)

Programming Basics

Constructs

Structured Programming

Program Development Life Cycle

Program Design

Program Testing And Maintenance

Data Representation

Multimedia: Graphics, Sound

Compression

Networks Including The Internet

Computer And Their Components

Logic Gates And Logic Circuits

Central Processing Unit (CPU) Architecture

Assembly Language

Bit Manipulation

Operating Systems

Language Translators

Data Security

Data Integrity

Ethics And Ownership

Database Concepts

Database Management Systems (DMBS)

Data Definition Language (DDL) And Data Manipulation Language (DML)

Computational Thinking Skills

Algorithms

Data Types And Records

Arrays

Files

Introduction To Abstract Data Types (ADT)

Programming Basics

Constructs

Structured Programming

Program Development Life Cycle

Program Design

Program Testing And Maintenance

Data Representation: Show Understanding Of Binary Magnitudes And The Difference Between Binary Prefixes And Decimal Prefixes

Data Representation: Show Understanding Of Different Number Systems

Data Representation: Show Understanding Of How Overflow Can Occur

Data Representation: Show Understanding Of How Overflow Can Occur

Data Representation: Show Understanding Of And Be Able To Represent Character Data In Its Internal Binary Form, Depending On The Character Set Used

Multimedia – Graphics: Show Understanding Of How Data For A Bitmapped Image Are Encoded

Multimedia – Graphics: Perform Calculations To Estimate The File Size For A Bitmap Image

Multimedia – Graphics: Show Understanding Of The Effects Of Changing Elements Of A Bitmap Image On The Image Quality And File Size

Multimedia – Graphics: Show Understanding Of How Data For A Vector Graphic Are Encoded

Multimedia – Graphics: Justify The Use Of A Bitmap Image Or A Vector Graphic For A Given Task

Multimedia – Sound: Show Understanding Of How Sound Is Represented And Encoded

Multimedia – Sound: Show Understanding Of The Impact Of Changing The Sampling Rate And Resolution

Compression: Show Understanding Of The Need For And Examples Of The Use Of Compression

Compression: Show Understanding Of Lossy And Lossless Compression And Justify The Use Of A Method In A Given Situation

Compression: Show Understanding Of How A Text File, Bitmap Image, Vector Graphic And Sound File Can Be Compressed

Networks Including The Internet: Show Understanding Of The Purpose And Benefits Of Networking Devices

Networks Including The Internet: Show Understanding Of The Characteristics Of A LAN (Local Area Network) And A WAN (Wide Area Network)

Networks Including The Internet: Explain The Client-Server And Peer-To-Peer Models Of Networked Computers

Networks Including The Internet: Show Understanding Of Thin-Client And Thick-Client And The Differences Between Them

Networks Including The Internet: Show Understanding Of The Bus, Star, Mesh And Hybrid Topologies

Networks Including The Internet: Understand How Packets Are Transmitted Between Two Hosts For A Given Topology

Networks Including The Internet: Justify The Use Of A Topology For A Given Situation

Networks Including The Internet: Show Understanding Of Cloud Computing

Networks Including The Internet: Show Understanding Of The Differences Between And Implications Of The Use Of Wireless And Wired Networks

Networks Including The Internet: Describe The Characteristics Of Copper Cable, Fibre-Optic Cable, Radio Waves (Including WiFi), Microwaves, Satellites

Networks Including The Internet: Describe The Hardware That Is Used To Support A LAN

Networks Including The Internet: Describe The Role And Function Of A Router In A Network

Networks Including The Internet: Show Understanding Of Ethernet And How Collisions Are Detected And Avoided

Networks Including The Internet: Show Understanding Of Bit Streaming

Networks Including The Internet: Show Understanding Of The Differences Between The World Wide Web (WWW) And The Internet

Networks Including The Internet: Describe The Hardware That Is Used To Support The Internet

Networks Including The Internet: Explain The Use Of IP Addresses In The Transmission Of Data Over The Internet

Networks Including The Internet: Explain How A Uniform Resource Locator (URL) Is Used To Locate A Resource On The World Wide Web (WWW) And The Role Of The Domain Name Service (DNS)

Computers And Their Components: Show Understanding Of The Need For Input, Output, Primary Memory And Secondary (Including Removable) Storage

Computers And Their Components: Show Understanding Of Embedded Systems

Computers And Their Components: Describe The Principal Operations Of Hardware Devices

Computers And Their Components: Show Understanding Of The Use Of Buffers

Computers And Their Components: Explain The Differences Between Random Access Memory (RAM) And Read Only Memory (ROM)

Computers And Their Components: Explain The Differences Between Static RAM (SRAM) And Dynamic RAM (DRAM)

Computers And Their Components: Explain The Difference Between Programmable ROM (PROM), Erasable Programmable ROM (EPROM) And Electrically Erasable Programmable ROM (EEPROM)

Computers And Their Components: Show An Understanding Of Monitoring And Control Systems

Logic Gates And Logic Circuits: Understand And Define The Functions Of NOT, AND, OR, NAND, NOR And XOR (EOR) Gates

Logic Gates And Logic Circuits: Construct The Truth Table For Each Of The Logic Gates Above

Logic Gates And Logic Circuits: Construct A Logic Circuit From A Problem Statement, A Logic Expression, Or A Truth Table

Logic Gates And Logic Circuits: Construct A Truth Table From A Problem Statement, A Logic Circuit, Or A Logic Expression

Logic Gates And Logic Circuits: Construct A Logic Expression From A Problem Statement, A Logic Circuit, Or A Truth Table

Central Processing Unit (CPU) Architecture: Show Understanding Of The Basic Von Neumann Model For A Computer System And The Stored Program Concept

Central Processing Unit (CPU) Architecture: Show Understanding Of The Purpose And Role Of Registers, Including The Difference Between General Purpose And Special Purpose Registers

Central Processing Unit (CPU) Architecture: Show Understanding Of The Purpose And Roles Of The Arithmetic And Logic Unit (ALU), Control Unit (CU) And System Clock, Immediate Access Store (IAS)

Central Processing Unit (CPU) Architecture: Show Understanding Of How Data Are Transferred Between Various Components Of The Computer System Using The Address Bus, Data Bus And Control Bus

Central Processing Unit (CPU) Architecture: Show Understanding Of How Factors Contribute To The Performance Of The Computer System

Central Processing Unit (CPU) Architecture: nderstand How Different Ports Provide Connection To Peripheral Devices

Central Processing Unit (CPU) Architecture: Describe The Stages Of The Fetch-Execute (F-E) Cycle

Central Processing Unit (CPU) Architecture: Show Understanding Of The Purpose Of Interrupts

Assembly Language: Show Understanding Of The Relationship Between Assembly Language And Machine Code

Assembly Language: Describe The Different Stages Of The Assembly Process For A Two-Pass Assembler

Assembly Language: Describe The Different Stages Of The Assembly Process For A Two-Pass Assembler

Assembly Language: Show Understanding That A Set Of Instructions Are Grouped

Assembly Language: Show Understanding Of And Be Able To Use Different Modes Of Addressing

Bit Manipulation: Show Understanding Of And Perform Binary Shifts

Bit Manipulation: Show Understanding Of How Bit Manipulation Can Be Used To Monitor/Control A Device

Operating Systems: Explain Why A Computer System Requires An Operating System (OS)

Operating Systems: Explain The Key Management Tasks Carried Out By The Operating System

Operating Systems: Show Understanding Of The Need For Typical Utility Software Provided With An Operating System

Operating Systems: how Understanding Of Program Libraries

Language Translators: Show Understanding Of The Need For Assembler Software, Compiler And Interpreter

Language Translators: Explain The Benefits And Drawbacks Of Using Either A Compiler Or Interpreter And Justify The Use Of Each

Language Translators: Show Awareness That High-Level Language Programs May Be Partially Compiled And Partially Interpreted

Language Translators: Describe Features Found In A Typical Integrated Development Environment (IDE)

Data Security: Explain The Difference Between The Terms Security, Privacy And Integrity Of Data

Data Security: Show Appreciation Of The Need For Both The Security Of Data And The Security Of The Computer System

Data Security: Describe Security Measures Designed To Protect Computer Systems

Data Security: Show Understanding Of The Threats To Computer And Data Security Posed By Networks And The Internet

Data Security: Describe Methods That Can Be Used To Restrict The Risks Posed By Threats

Data Security: Describe Security Methods Designed To Protect The Security Of Data

Data Integrity: Describe How Data Validation And Data Verification Help Protect The Integrity Of Data

Data Integrity: Describe and Use Methods of Data Validation

Data Integrity: Describe and Use Methods of Data Verification During Data Entry and Data Transfer

Ethics And Ownership: Show Understanding Of The Need For And Purpose Of Ethics As A Computing Professional

Ethics And Ownership: Show Understanding Of The Need To Act Ethically And The Impact Of Acting Ethically Or Unethically For A Given Situation

Ethics And Ownership: Show Understanding Of The Need For Copyright Legislation

Ethics And Ownership: Show Understanding Of The Different Types Of Software Licencing And Justify The Use Of A Licence For A Given Situation

Ethics And Ownership: Show Understanding Of Artificial Intelligence (AI)

Database Concepts: Show Understanding Of The Limitations Of Using A File-Based Approach For The Storage And Retrieval Of Data

Database Concepts: Describe The Features Of A Relational Database That Address The Limitations Of A File-Based Approach

Database Concepts: Show Understanding Of And Use The Terminology Associated With A Relational Database Model

Database Concepts: Use An Entity-Relationship (E-R) Diagram To Document A Database Design

Database Concepts: Show Understanding Of The Normalisation Process

Database Concepts: Explain Why A Given Set Of Database Tables Are, Or Are Not, In 3NF

Database Concepts: Produce A Normalised Database Design For A Description of a Database, a Given Set of Data, or A Given Set of Tables

Database Management Systems (DBMS): Show Understanding Of The Features Provided By A Database Management System (DBMS) That Address The Issues Of A File Based Approach

Database Management Systems (DBMS): Show Understanding Of How Software Tools Found Within A DBMS Are Used In Practice

Show Understanding Of How Software Tools Found Within A DBMS Are Used In Practice: Show Understanding That The DBMS Carries Out All Creation/Modification Of The Database Structure Using Its Data Definition Language (DDL)

Show Understanding Of How Software Tools Found Within A DBMS Are Used In Practice: Show Understanding That The DBMS Carries Out All Queries And Maintenance Of Data Using Its DML

Show Understanding Of How Software Tools Found Within A DBMS Are Used In Practice: Show Understanding That The Industry Standard For Both DDL And DML Is Structured Query Language (SQL)

Show Understanding Of How Software Tools Found Within A DBMS Are Used In Practice: Understand given SQL (DDL) statements and Be Able To Write Simple SQL (DDL) Statements Using A Sub-Set of Statements

Show Understanding Of How Software Tools Found Within A DBMS Are Used In Practice: Write An SQL Script To Query Or Modify Data (DML) Which Are Stored In (At Most Two) Database Tables

Computational Thinking Skills: Computational Thinking Skills:

Computational Thinking Skills: Describe And Use Decomposition

Algorithms: Show Understanding That An Algorithm Is A Solution To A Problem Expressed As A Sequence Of Defined Steps

Algorithms: Write Pseudocode That Contains Input, Process And Output

Algorithms: Write Pseudocode Using The Three Basic Constructs Of Sequence, Selection And Iteration

Algorithms: Document A Simple Algorithm Using A Structured English Description, A Flowchart Or Pseudocode

Algorithms: Write Pseudocode From A Structured English Description Or A Flowchart

Algorithms: Draw A Flowchart From A Structured English Description Or Pseudocode

Algorithms: Describe And Use The Process Of Stepwise Refinement To Express An Algorithm To A Level Of Detail From Which The Task May Be Programmed

Algorithms: Use Logic Statements To Define Parts Of An Algorithm Solution

Data Types And Records: Select And Use Appropriate Data Types For A Problem Solution

Data Types And Records: Show Understanding Of The Purpose Of A Record Structure To Hold A Set Of Data Of Different Data Types Under One Identifier

Arrays: Use The Technical Terms Associated With Arrays

Arrays: Select A Suitable Data Structure (1D Or 2D Array) To Use For A Given Task

Arrays: Write Pseudocode For 1D And 2D Arrays

Arrays: Write Pseudocode To Process Array Data

Files: Show Understanding Of Why Files Are Needed

Files: Write Pseudocode To Handle Text Files That Consist Of One Or More Lines

Introduction To Abstract Data Types (ADT): Show Understanding That An ADT Is A Collection Of Data And A Set Of Operations On Those Data

Introduction To Abstract Data Types (ADT): Show Understanding That A Stack, Queue And Linked List Are Examples Of ADTs

Introduction To Abstract Data Types (ADT): Use A Stack, Queue And Linked List To Store Data

Introduction To Abstract Data Types (ADT): Describe How A Queue, Stack And Linked List Can Be Implemented Using Arrays

Programming Basics: Implement And Write Pseudocode From A Given Design Presented As Either A Program Flowchart Or Structured English

Programming Basics: Write Pseudocode Statements

Programming Basics: Use Built-in Functions and Library Routines

Constructs: Use Pseudocode To Write IF Statements, CASE Structures, Count-Controlled Loops, Post-Condition Loops, And Pre-Condition Loops

Constructs: Justify Why One Loop Structure May Be Better Suited To Solve A Problem Than The Others

Structured Programming: Define And Use A Procedure

Structured Programming: Explain Where In The Construction Of An Algorithm It Would Be Appropriate To Use A Procedure

Structured Programming: Use Parameters (By Value Or By Reference)

Structured Programming: Define And Use A Function

Structured Programming: Explain Where In The Construction Of An Algorithm It Is Appropriate To Use A Function

Structured Programming: Use The Terminology Associated With Procedures And Functions

Structured Programming: Write Efficient Pseudocode

Write Efficient Pseudocode: Show Understanding Of The Purpose Of A Development Life Cycle

Write Efficient Pseudocode: Show Understanding Of The Need For Different Development Life Cycles Depending On The Program Being Developed

Write Efficient Pseudocode: Describe The Principles, Benefits And Drawbacks Of Each Type Of Life Cycle

Write Efficient Pseudocode: Show Understanding Of The Analysis, Design, Coding, Testing And Maintenance Stages In The Program Development Life Cycle

Program Design: Use A Structure Chart To Decompose A Problem Into Sub-Tasks

Program Design: Show Understanding Of The Purpose Of State-Transition Diagrams To Document An Algorithm

Program Testing And Maintenance: Show Understanding Of Ways Of Exposing And Avoiding Faults In Programs

Program Testing And Maintenance: Locate And Identify Different Types Of Errors

Program Testing And Maintenance: Correct Identified Errors

Program Testing And Maintenance: Show Understanding Of The Methods Of Testing Available And Select Appropriate Data For A Given Method

Program Testing And Maintenance: Show Understanding Of The Need For A Test Strategy And Test Plan And Their Likely Contents

Program Testing And Maintenance: Choose Appropriate Test Data For A Test Plan

Program Testing And Maintenance: Show Understanding Of The Need For Continuing Maintenance Of A System And The Differences Between Each Type Of Maintenance

Program Testing And Maintenance: Analyse An Existing Program And Make Amendments To Enhance Functionality

Data Representation

Multimedia – Graphics, Sound

Compression

Networks Including The Internet

Computer And Their Components

Logic Gates And Logic Circuits

Central Processing Unit (CPU) Architecture

Assembly Language

Bit Manipulation

Operating Systems

Language Translators

Data Security

Data Integrity

Ethics And Ownership

Database Concepts

Database Management Systems (DMBS)

Data Definition Language (DDL) And Data Manipulation Language (DML)

Computational Thinking Skills

Algorithms

Data Types And Records

Arrays

Files

Introduction To Abstract Data Types (ADT)

Programming Basics

Constructs

Structured Programming

Program Development Life Cycle

Program Design

Program Testing And Maintenance

AS Level Computer Science Paper Structure & Assessment Design: Overview Of AS Level Computer Science Assessment Structure

AS Level Computer Science Paper Structure & Assessment Design: Purpose And Role Of Paper 1 In AS Level Computer Science

AS Level Computer Science Paper Structure & Assessment Design: Purpose And Role Of Paper 2 In AS Level Computer Science

AS Level Computer Science Paper Structure & Assessment Design: Marks Distribution Across Papers And Question Types

AS Level Computer Science Paper Structure & Assessment Design: Time Duration Analysis And Ideal Time Per Mark

AS Level Computer Science Paper Structure & Assessment Design: How Assessment Objectives Affect Question Style

AS Level Computer Science Paper Structure & Assessment Design: Difference Between Knowledge, Application And Problem-Solving Marks

AS Level Computer Science Paper Structure & Assessment Design: Understanding Structured Questions Vs Short Response Questions

AS Level Computer Science Paper Structure & Assessment Design: How Insert Material Is Used In Paper 2

AS Level Computer Science Paper Structure & Assessment Design: Examiner Expectations At AS Level Compared To IGCSE

Paper Preparation Strategy (Before The Exam): Smart Past Paper Selection Strategy For AS Computer Science

Paper Preparation Strategy (Before The Exam): Using Mark Schemes To Predict Examiner Thinking

Paper Preparation Strategy (Before The Exam): Identifying High-Frequency Question Patterns

Paper Preparation Strategy (Before The Exam): Topic Weightage Awareness Without Spotting

Paper Preparation Strategy (Before The Exam): Building A Personal Mistake Log From Past Papers

Paper Preparation Strategy (Before The Exam): Timed Practice Vs Untimed Practice: When To Use Each

Paper Preparation Strategy (Before The Exam): How To Revise Pseudocode Without Memorising

Paper Preparation Strategy (Before The Exam): Algorithm Practice Strategy For Exam Conditions

Paper Preparation Strategy (Before The Exam): Effective Use Of Examiner Reports

Paper Preparation Strategy (Before The Exam): Last 30 Days Revision Structure For AS Computer Science

Paper Preparation Strategy (Before The Exam): Last 7 Days High-Yield Revision Plan

Paper Preparation Strategy (Before The Exam): Pre-Exam Night Preparation Do’s And Don’ts

Techniques To Attempt Paper 1 (Theory & Short Response): Reading Questions Precisely To Avoid Misinterpretation

Techniques To Attempt Paper 1 (Theory & Short Response): Handling Multiple Choice Questions Strategically

Techniques To Attempt Paper 1 (Theory & Short Response): Keyword-Based Answer Writing Technique

Techniques To Attempt Paper 1 (Theory & Short Response): How Much To Write For 1, 2, 3 And 4 Mark Questions

Techniques To Attempt Paper 1 (Theory & Short Response): Avoiding Overwriting In Theory Questions

Techniques To Attempt Paper 1 (Theory & Short Response): Diagram-Based Answers: When They Help And When They Hurt

Techniques To Attempt Paper 1 (Theory & Short Response): Managing Definitions Without Losing Precision

Techniques To Attempt Paper 1 (Theory & Short Response): Tackling Explain Vs Describe Questions Correctly

Techniques To Attempt Paper 1 (Theory & Short Response): Logical Guessing Techniques When Unsure

Techniques To Attempt Paper 1 (Theory & Short Response): Common Theory Traps Used By Examiners

Techniques To Attempt Paper 2 (Problem-Solving & Programming): Question Order Strategy For Paper 2

Techniques To Attempt Paper 2 (Problem-Solving & Programming): Planning Pseudocode Before Writing Final Answers

Techniques To Attempt Paper 2 (Problem-Solving & Programming): Step-By-Step Tracing Technique For Logic Questions

Techniques To Attempt Paper 2 (Problem-Solving & Programming): How To Secure Method Marks Even With Errors

Techniques To Attempt Paper 2 (Problem-Solving & Programming): Handling Nested Logic Without Confusion

Techniques To Attempt Paper 2 (Problem-Solving & Programming): Writing Clear And Examiner-Friendly Pseudocode

Techniques To Attempt Paper 2 (Problem-Solving & Programming): Using Insert Material Effectively Without Copying

Techniques To Attempt Paper 2 (Problem-Solving & Programming): Managing Long Algorithm Questions Under Time Pressure

Techniques To Attempt Paper 2 (Problem-Solving & Programming): When To Abandon A Question And Move On

Techniques To Attempt Paper 2 (Problem-Solving & Programming): Checking Logic Errors Quickly At The End

Common Mistakes & How To Avoid Them: Misreading Command Words And Losing Easy Marks

Common Mistakes & How To Avoid Them: Writing Correct Logic In The Wrong Context

Common Mistakes & How To Avoid Them: Ignoring Given Constraints In Questions

Common Mistakes & How To Avoid Them: Mixing Programming Language Syntax With Pseudocode

Common Mistakes & How To Avoid Them: Arithmetic And Trace Errors That Snowball

Common Mistakes & How To Avoid Them: Losing Marks Due To Poor Presentation

Common Mistakes & How To Avoid Them: Repeating The Question Instead Of Answering It

Common Mistakes & How To Avoid Them: Final Paper Checking Mistakes That Cost Grades

Data Representation

Multimedia – Graphics, Sound

Compression

Networks Including The Internet

Computer And Their Components

Logic Gates And Logic Circuits

Central Processing Unit (CPU) Architecture

Assembly Language

Bit Manipulation

Operating Systems

Language Translators

Data Security

Data Integrity

Ethics And Ownership

Database Concepts

Database Management Systems (DMBS)

Data Definition Language (DDL) And Data Manipulation Language (DML)

Computational Thinking Skills

Algorithms

Data Types And Records

Arrays

Files

Introduction To Abstract Data Types (ADT)

Programming Basics

Constructs

Structured Programming

Program Development Life Cycle

Program Design

Program Testing And Maintenance

Pseudocode Foundations & Conventions: Cambridge AS Level Pseudocode Rules And Conventions

Pseudocode Foundations & Conventions: Writing Clear And Examiner-Friendly Pseudocode

Pseudocode Foundations & Conventions: Common Pseudocode Keywords And Their Correct Usage

Pseudocode Foundations & Conventions: Indentation And Structure In Pseudocode

Pseudocode Foundations & Conventions: Input, Output And Assignment Statements

Pseudocode Foundations & Conventions: Variables, Constants And Identifiers In Pseudocode

Pseudocode Foundations & Conventions: Data Types Used In AS Level Pseudocode

Pseudocode Foundations & Conventions: Common Syntax Mistakes Students Make In Pseudocode

Selection And Iteration Code Guides: IF, ELSE IF And ELSE Structures Explained

Selection And Iteration Code Guides: Nested Selection Logic With Worked Examples

Selection And Iteration Code Guides: FOR Loops: Structure, Use Cases And Pitfalls

Selection And Iteration Code Guides: WHILE Loops: Entry-Controlled Iteration

Selection And Iteration Code Guides: REPEAT UNTIL Loops: Exit-Controlled Iteration

Selection And Iteration Code Guides: Choosing The Correct Loop For A Problem

Selection And Iteration Code Guides: Loop Tracing And Dry-Run Techniques

Selection And Iteration Code Guides: Avoiding Infinite Loops In Exam Questions

Selection And Iteration Code Guides: Combining Selection And Iteration Correctly

Selection And Iteration Code Guides: Common Logic Errors In Conditional Statements

Arrays, Strings And Data Handling: One-Dimensional Arrays: Declaration And Use

Arrays, Strings And Data Handling: Two-Dimensional Arrays: Table-Based Problems

Arrays, Strings And Data Handling: Traversing Arrays Using Loops

Arrays, Strings And Data Handling: Searching Through Arrays Step By Step

Arrays, Strings And Data Handling: Updating And Modifying Array Elements

Arrays, Strings And Data Handling: String Handling Operations In Pseudocode

Arrays, Strings And Data Handling: Character-By-Character String Processing

Arrays, Strings And Data Handling: Common Array And String Mistakes In Exams

Algorithmic Problem-Solving Guides: Designing Algorithms From Problem Statements

Algorithmic Problem-Solving Guides: Converting Worded Problems Into Pseudocode

Algorithmic Problem-Solving Guides: Stepwise Refinement For Algorithm Design

Algorithmic Problem-Solving Guides: Input-Process-Output Model In Algorithms

Algorithmic Problem-Solving Guides: Writing Algorithms For Real-World Scenarios

Algorithmic Problem-Solving Guides: Tracing Algorithms Using Trace Tables

Algorithmic Problem-Solving Guides: Debugging Algorithms Using Logical Reasoning

Algorithmic Problem-Solving Guides: Identifying And Fixing Logical Errors

Algorithmic Problem-Solving Guides: Efficiency Awareness Without Big-O Notation

Algorithmic Problem-Solving Guides: Breaking Complex Problems Into Smaller Steps

Standard Algorithm & Logic Patterns: Linear Search Algorithm Guide

Standard Algorithm & Logic Patterns: Bubble Sort Algorithm Explained Step By Step

Standard Algorithm & Logic Patterns: Counting And Accumulation Algorithms

Standard Algorithm & Logic Patterns: Maximum, Minimum And Average Finding Algorithms

Standard Algorithm & Logic Patterns: Validation Algorithms For Input Data

Standard Algorithm & Logic Patterns: Flag Variables And Their Applications

Standard Algorithm & Logic Patterns: Sentinel Values In Algorithms

Standard Algorithm & Logic Patterns: Common Algorithm Templates Used In Exams

Coding Sheets, Practice & Learning Support: Quick Reference Pseudocode Sheet For AS Level

Coding Sheets, Practice & Learning Support: Common Exam Algorithm Patterns Summary Sheet

Coding Sheets, Practice & Learning Support: Mistake-Based Coding Practice Sheets

Coding Sheets, Practice & Learning Support: Algorithm Tracing Practice Worksheets

Coding Sheets, Practice & Learning Support: Translating Between Flowcharts And Pseudocode

Coding Sheets, Practice & Learning Support: Revision-Friendly Coding Examples Collection

Code Guide: Input, Output And Variable Assignment Programs

Code Guide: Basic Arithmetic Operations And Calculations

Code Guide: IF, ELSE IF And ELSE Decision-Making Programs

Code Guide: Nested Selection Programs With Multiple Conditions

Code Guide: FOR Loop Programs With Fixed Iterations

Code Guide: WHILE Loop Programs With Conditions

Code Guide: REPEAT UNTIL Loop Programs With Validation

Code Guide: Combining Selection And Iteration In One Program

Code Guide: One-Dimensional Array Programs With Traversal

Code Guide: Two-Dimensional Array Programs Using Nested Loops

Code Guide: Searching Algorithms Using Arrays

Code Guide: Sorting Algorithms Using Simple Methods

Code Guide: String Processing And Character Manipulation Programs

Code Guide: Algorithm Tracing And Debugging Examples

Code Guide: Full Exam-Style Programs Covering Mixed Concepts

Data Representation: Show Understanding Of Binary Magnitudes And The Difference Between Binary Prefixes And Decimal Prefixes

Data Representation: Show Understanding Of Different Number Systems

Data Representation: Show Understanding Of How Overflow Can Occur

Data Representation: Show Understanding Of How Overflow Can Occur

Data Representation: Show Understanding Of And Be Able To Represent Character Data In Its Internal Binary Form, Depending On The Character Set Used

Multimedia – Graphics: Show Understanding Of How Data For A Bitmapped Image Are Encoded

Multimedia – Graphics: Perform Calculations To Estimate The File Size For A Bitmap Image

Multimedia – Graphics: Show Understanding Of The Effects Of Changing Elements Of A Bitmap Image On The Image Quality And File Size

Multimedia – Graphics: Show Understanding Of How Data For A Vector Graphic Are Encoded

Multimedia – Graphics: Justify The Use Of A Bitmap Image Or A Vector Graphic For A Given Task

Multimedia – Sound: Show Understanding Of How Sound Is Represented And Encoded

Multimedia – Sound: Show Understanding Of The Impact Of Changing The Sampling Rate And Resolution

Compression: Show Understanding Of The Need For And Examples Of The Use Of Compression

Compression: Show Understanding Of Lossy And Lossless Compression And Justify The Use Of A Method In A Given Situation

Compression: Show Understanding Of How A Text File, Bitmap Image, Vector Graphic And Sound File Can Be Compressed

Networks Including The Internet: Show Understanding Of The Purpose And Benefits Of Networking Devices

Networks Including The Internet: Show Understanding Of The Characteristics Of A LAN (Local Area Network) And A WAN (Wide Area Network)

Networks Including The Internet: Explain The Client-Server And Peer-To-Peer Models Of Networked Computers

Networks Including The Internet: Show Understanding Of Thin-Client And Thick-Client And The Differences Between Them

Networks Including The Internet: Show Understanding Of The Bus, Star, Mesh And Hybrid Topologies

Networks Including The Internet: Understand How Packets Are Transmitted Between Two Hosts For A Given Topology

Networks Including The Internet: Justify The Use Of A Topology For A Given Situation

Networks Including The Internet: Show Understanding Of Cloud Computing

Networks Including The Internet: Show Understanding Of The Differences Between And Implications Of The Use Of Wireless And Wired Networks

Networks Including The Internet: Describe The Characteristics Of Copper Cable, Fibre-Optic Cable, Radio Waves (Including WiFi), Microwaves, Satellites

Networks Including The Internet: Describe The Hardware That Is Used To Support A LAN

Networks Including The Internet: Describe The Role And Function Of A Router In A Network

Networks Including The Internet: Show Understanding Of Ethernet And How Collisions Are Detected And Avoided

Networks Including The Internet: Show Understanding Of Bit Streaming

Networks Including The Internet: Show Understanding Of The Differences Between The World Wide Web (WWW) And The Internet

Networks Including The Internet: Describe The Hardware That Is Used To Support The Internet

Networks Including The Internet: Explain The Use Of IP Addresses In The Transmission Of Data Over The Internet

Networks Including The Internet: Explain How A Uniform Resource Locator (URL) Is Used To Locate A Resource On The World Wide Web (WWW) And The Role Of The Domain Name Service (DNS)

Computers And Their Components: Show Understanding Of The Need For Input, Output, Primary Memory And Secondary (Including Removable) Storage

Computers And Their Components: Show Understanding Of Embedded Systems

Computers And Their Components: Describe The Principal Operations Of Hardware Devices

Computers And Their Components: Show Understanding Of The Use Of Buffers

Computers And Their Components: Explain The Differences Between Random Access Memory (RAM) And Read Only Memory (ROM)

Computers And Their Components: Explain The Differences Between Static RAM (SRAM) And Dynamic RAM (DRAM)

Computers And Their Components: Explain The Difference Between Programmable ROM (PROM), Erasable Programmable ROM (EPROM) And Electrically Erasable Programmable ROM (EEPROM)

Computers And Their Components: Show An Understanding Of Monitoring And Control Systems

Logic Gates And Logic Circuits: Understand And Define The Functions Of NOT, AND, OR, NAND, NOR And XOR (EOR) Gates

Logic Gates And Logic Circuits: Construct The Truth Table For Each Of The Logic Gates Above

Logic Gates And Logic Circuits: Construct A Logic Circuit From A Problem Statement, A Logic Expression, Or A Truth Table

Logic Gates And Logic Circuits: Construct A Truth Table From A Problem Statement, A Logic Circuit, Or A Logic Expression

Logic Gates And Logic Circuits: Construct A Logic Expression From A Problem Statement, A Logic Circuit, Or A Truth Table

Central Processing Unit (CPU) Architecture: Show Understanding Of The Basic Von Neumann Model For A Computer System And The Stored Program Concept

Central Processing Unit (CPU) Architecture: Show Understanding Of The Purpose And Role Of Registers, Including The Difference Between General Purpose And Special Purpose Registers

Central Processing Unit (CPU) Architecture: Show Understanding Of The Purpose And Roles Of The Arithmetic And Logic Unit (ALU), Control Unit (CU) And System Clock, Immediate Access Store (IAS)

Central Processing Unit (CPU) Architecture: Show Understanding Of How Data Are Transferred Between Various Components Of The Computer System Using The Address Bus, Data Bus And Control Bus

Central Processing Unit (CPU) Architecture: Show Understanding Of How Factors Contribute To The Performance Of The Computer System

Central Processing Unit (CPU) Architecture: nderstand How Different Ports Provide Connection To Peripheral Devices

Central Processing Unit (CPU) Architecture: Describe The Stages Of The Fetch-Execute (F-E) Cycle

Central Processing Unit (CPU) Architecture: Show Understanding Of The Purpose Of Interrupts

Assembly Language: Show Understanding Of The Relationship Between Assembly Language And Machine Code

Assembly Language: Describe The Different Stages Of The Assembly Process For A Two-Pass Assembler

Assembly Language: Describe The Different Stages Of The Assembly Process For A Two-Pass Assembler

Assembly Language: Show Understanding That A Set Of Instructions Are Grouped

Assembly Language: Show Understanding Of And Be Able To Use Different Modes Of Addressing

Bit Manipulation: Show Understanding Of And Perform Binary Shifts

Bit Manipulation: Show Understanding Of How Bit Manipulation Can Be Used To Monitor/Control A Device

Operating Systems: Explain Why A Computer System Requires An Operating System (OS)

Operating Systems: Explain The Key Management Tasks Carried Out By The Operating System

Operating Systems: Show Understanding Of The Need For Typical Utility Software Provided With An Operating System

Operating Systems: how Understanding Of Program Libraries

Language Translators: Show Understanding Of The Need For Assembler Software, Compiler And Interpreter

Language Translators: Explain The Benefits And Drawbacks Of Using Either A Compiler Or Interpreter And Justify The Use Of Each

Language Translators: Show Awareness That High-Level Language Programs May Be Partially Compiled And Partially Interpreted

Language Translators: Describe Features Found In A Typical Integrated Development Environment (IDE)

Data Security: Explain The Difference Between The Terms Security, Privacy And Integrity Of Data

Data Security: Show Appreciation Of The Need For Both The Security Of Data And The Security Of The Computer System

Data Security: Describe Security Measures Designed To Protect Computer Systems

Data Security: Show Understanding Of The Threats To Computer And Data Security Posed By Networks And The Internet

Data Security: Describe Methods That Can Be Used To Restrict The Risks Posed By Threats

Data Security: Describe Security Methods Designed To Protect The Security Of Data

Data Integrity: Describe How Data Validation And Data Verification Help Protect The Integrity Of Data

Data Integrity: Describe and Use Methods of Data Validation

Data Integrity: Describe and Use Methods of Data Verification During Data Entry and Data Transfer

Ethics And Ownership: Show Understanding Of The Need For And Purpose Of Ethics As A Computing Professional

Ethics And Ownership: Show Understanding Of The Need To Act Ethically And The Impact Of Acting Ethically Or Unethically For A Given Situation

Ethics And Ownership: Show Understanding Of The Need For Copyright Legislation

Ethics And Ownership: Show Understanding Of The Different Types Of Software Licencing And Justify The Use Of A Licence For A Given Situation

Ethics And Ownership: Show Understanding Of Artificial Intelligence (AI)

Database Concepts: Show Understanding Of The Limitations Of Using A File-Based Approach For The Storage And Retrieval Of Data

Database Concepts: Describe The Features Of A Relational Database That Address The Limitations Of A File-Based Approach

Database Concepts: Show Understanding Of And Use The Terminology Associated With A Relational Database Model

Database Concepts: Use An Entity-Relationship (E-R) Diagram To Document A Database Design

Database Concepts: Show Understanding Of The Normalisation Process

Database Concepts: Explain Why A Given Set Of Database Tables Are, Or Are Not, In 3NF

Database Concepts: Produce A Normalised Database Design For A Description of a Database, a Given Set of Data, or A Given Set of Tables

Database Management Systems (DBMS): Show Understanding Of The Features Provided By A Database Management System (DBMS) That Address The Issues Of A File Based Approach

Database Management Systems (DBMS): Show Understanding Of How Software Tools Found Within A DBMS Are Used In Practice

Show Understanding Of How Software Tools Found Within A DBMS Are Used In Practice: Show Understanding That The DBMS Carries Out All Creation/Modification Of The Database Structure Using Its Data Definition Language (DDL)

Show Understanding Of How Software Tools Found Within A DBMS Are Used In Practice: Show Understanding That The DBMS Carries Out All Queries And Maintenance Of Data Using Its DML

Show Understanding Of How Software Tools Found Within A DBMS Are Used In Practice: Show Understanding That The Industry Standard For Both DDL And DML Is Structured Query Language (SQL)

Show Understanding Of How Software Tools Found Within A DBMS Are Used In Practice: Understand given SQL (DDL) statements and Be Able To Write Simple SQL (DDL) Statements Using A Sub-Set of Statements

Show Understanding Of How Software Tools Found Within A DBMS Are Used In Practice: Write An SQL Script To Query Or Modify Data (DML) Which Are Stored In (At Most Two) Database Tables

Computational Thinking Skills: Computational Thinking Skills:

Computational Thinking Skills: Describe And Use Decomposition

Algorithms: Show Understanding That An Algorithm Is A Solution To A Problem Expressed As A Sequence Of Defined Steps

Algorithms: Write Pseudocode That Contains Input, Process And Output

Algorithms: Write Pseudocode Using The Three Basic Constructs Of Sequence, Selection And Iteration

Algorithms: Document A Simple Algorithm Using A Structured English Description, A Flowchart Or Pseudocode

Algorithms: Write Pseudocode From A Structured English Description Or A Flowchart

Algorithms: Draw A Flowchart From A Structured English Description Or Pseudocode

Algorithms: Describe And Use The Process Of Stepwise Refinement To Express An Algorithm To A Level Of Detail From Which The Task May Be Programmed

Algorithms: Use Logic Statements To Define Parts Of An Algorithm Solution

Data Types And Records: Select And Use Appropriate Data Types For A Problem Solution

Data Types And Records: Show Understanding Of The Purpose Of A Record Structure To Hold A Set Of Data Of Different Data Types Under One Identifier

Arrays: Use The Technical Terms Associated With Arrays

Arrays: Select A Suitable Data Structure (1D Or 2D Array) To Use For A Given Task

Arrays: Write Pseudocode For 1D And 2D Arrays

Arrays: Write Pseudocode To Process Array Data

Files: Show Understanding Of Why Files Are Needed

Files: Write Pseudocode To Handle Text Files That Consist Of One Or More Lines

Introduction To Abstract Data Types (ADT): Show Understanding That An ADT Is A Collection Of Data And A Set Of Operations On Those Data

Introduction To Abstract Data Types (ADT): Show Understanding That A Stack, Queue And Linked List Are Examples Of ADTs

Introduction To Abstract Data Types (ADT): Use A Stack, Queue And Linked List To Store Data

Introduction To Abstract Data Types (ADT): Describe How A Queue, Stack And Linked List Can Be Implemented Using Arrays

Programming Basics: Implement And Write Pseudocode From A Given Design Presented As Either A Program Flowchart Or Structured English

Programming Basics: Write Pseudocode Statements

Programming Basics: Use Built-in Functions and Library Routines

Constructs: Use Pseudocode To Write IF Statements, CASE Structures, Count-Controlled Loops, Post-Condition Loops, And Pre-Condition Loops

Constructs: Justify Why One Loop Structure May Be Better Suited To Solve A Problem Than The Others

Structured Programming: Define And Use A Procedure

Structured Programming: Explain Where In The Construction Of An Algorithm It Would Be Appropriate To Use A Procedure

Structured Programming: Use Parameters (By Value Or By Reference)

Structured Programming: Define And Use A Function

Structured Programming: Explain Where In The Construction Of An Algorithm It Is Appropriate To Use A Function

Structured Programming: Use The Terminology Associated With Procedures And Functions

Structured Programming: Write Efficient Pseudocode

Write Efficient Pseudocode: Show Understanding Of The Purpose Of A Development Life Cycle

Write Efficient Pseudocode: Show Understanding Of The Need For Different Development Life Cycles Depending On The Program Being Developed

Write Efficient Pseudocode: Describe The Principles, Benefits And Drawbacks Of Each Type Of Life Cycle

Write Efficient Pseudocode: Show Understanding Of The Analysis, Design, Coding, Testing And Maintenance Stages In The Program Development Life Cycle

Program Design: Use A Structure Chart To Decompose A Problem Into Sub-Tasks

Program Design: Show Understanding Of The Purpose Of State-Transition Diagrams To Document An Algorithm

Program Testing And Maintenance: Show Understanding Of Ways Of Exposing And Avoiding Faults In Programs

Program Testing And Maintenance: Locate And Identify Different Types Of Errors

Program Testing And Maintenance: Correct Identified Errors

Program Testing And Maintenance: Show Understanding Of The Methods Of Testing Available And Select Appropriate Data For A Given Method

Program Testing And Maintenance: Show Understanding Of The Need For A Test Strategy And Test Plan And Their Likely Contents

Program Testing And Maintenance: Choose Appropriate Test Data For A Test Plan

Program Testing And Maintenance: Show Understanding Of The Need For Continuing Maintenance Of A System And The Differences Between Each Type Of Maintenance

Program Testing And Maintenance: Analyse An Existing Program And Make Amendments To Enhance Functionality