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

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

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

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