Computer Science | 0478

Data representation - Understand how and why computers use binary to represent all forms of data

Data representation - Understand the denary, binary and hexadecimal number systems

Data representation - Convert between positive denary and positive binary

Data representation - Convert between positive denary and positive hexadecimal

Data representation - Convert between positive hexadecimal and positive binary

Data representation - Understand how and why hexadecimal is used as a beneficial method of data representation

Data representation - Add two positive 8-bit binary integers

Data representation - Understand the concept of overflow and why it occurs in binary addition

Data representation - Perform a logical binary shift on a positive 8-bit binary integer and understand the effect

Data representation - Use the two’s complement number system to represent positive and negative 8-bit binary integers

Text, sound and images - Understand how and why a computer represents text and the use of character sets, including ASCII and Unicode

Text, sound and images - Understand how and why a computer represents sound, including the effects of the sample rate and sample resolution

Text, sound and images - Understand how and why a computer represents an image, including the effects of the resolution and colour depth

Data storage and compression - Understand how data storage is measured

Data storage and compression - Calculate the file size of an image file and a sound file, using information given

Data storage and compression - Understand the purpose of and need for data compression

Data storage and compression - Understand how files are compressed using lossy and lossless compression methods

Software - Describe the difference between system software and application software and provide examples of each

Software - Describe the role and basic functions of an operating system

Software - Understand how hardware, firmware and an operating system are required to run applications software

Software - Describe the role and operation of interrupts

The internet and its uses - Understand the difference between the internet and the world wide web

The internet and its uses - Understand what is meant by a uniform resource locator (URL)

The internet and its uses - Describe the purpose and operation of HTTP and HTTPS

The internet and its uses - Explain the purpose and functions of a web browser

The internet and its uses - Describe how web pages are located, retrieved and displayed on a device when a user enters a URL

The internet and its uses - Explain what is meant by cookies and how they are used

Automated and emerging technologies - Describe how sensors, microprocessors and actuators can be used in collaboration to create automated systems

Automated and emerging technologies - Describe the advantages and disadvantages of an automated system used for a given scenario

Automated and emerging technologies - Understand what is meant by robotics

Automated and emerging technologies - Describe the characteristics of a robot

Automated and emerging technologies - Understand the roles that robots can perform and describe the advantages and disadvantages of their use

Automated and emerging technologies - Understand what is meant by artificial intelligence (AI)

Automated and emerging technologies - Describe the main characteristics of AI

Automated and emerging technologies - Explain the basic operation and components of AI systems

Algorithm design and problem-solving - Understand the program development life cycle

Algorithm design and problem-solving - Understand system decomposition

Algorithm design and problem-solving - Use different methods to design and construct a solution to a problem

Algorithm design and problem-solving - Explain the purpose of a given algorithm

Algorithm design and problem-solving - Understand standard methods of solution

Algorithm design and problem-solving - Understand the need for validation and verification checks

Algorithm design and problem-solving - Suggest and apply suitable test data

Algorithm design and problem-solving - Complete a trace table to document a dry-run of an algorithm

Algorithm design and problem-solving - Identify errors in given algorithms and suggest ways of correcting them

Algorithm design and problem-solving - Write and amend algorithms using pseudocode, program code and flowcharts

Programming - Declare and use variables and constants

Programming - Understand and use basic data types

Programming - Understand and use input and output

Programming - Understand and use sequence, selection, and iteration

Programming - Understand and use arithmetic, logical and Boolean operators

Programming - Understand and use nested statements

Programming - Define and use procedures and functions, with or without parameters

Programming - Understand and use local and global variables

Programming - Understand and use library routines

Programming - Understand how to create a maintainable program

Programming - Declare and use one-dimensional and two-dimensional arrays

Programming - Understand the use of arrays

Programming - Write values into, and read values from, an array using iteration

Programming - Understand the purpose of storing data in a file

Programming - Open, close and use a file for reading and writing

Databases - Define a single-table database from given requirements

Databases - Suggest suitable basic data types

Databases - Understand the purpose of a primary key and identify one

Databases - Read, understand and complete SQL scripts to query data

Boolean logic - Identify and use the standard symbols for logic gates

Boolean logic - Define and understand the functions of logic gates

Boolean logic - Use logic gates to create logic circuits from a problem statement, logic expression or truth table

Boolean logic - Complete a truth table from a problem statement, logic expression or logic circuit

Boolean logic - Write a logic expression from a problem statement, logic circuit or truth table

Types and methods of data transmission - Understand that data is broken down into packets to be transmitted

Types and methods of data transmission - Describe the structure of a packet

Types and methods of data transmission - Describe the process of packet switching

Types and methods of data transmission - Describe methods of data transmission

Types and methods of data transmission - Explain the suitability of each method for a scenario

Types and methods of data transmission - Understand the USB interface and how it is used to transmit data

Methods of error detection - Understand the need to check for errors after data transmission

Methods of error detection - Describe parity check (odd and even), checksum and echo check

Methods of error detection - Describe how a check digit is used and identify examples such as ISBN and bar codes

Methods of error detection - Describe how ARQ is used to confirm data was received correctly

Encryption - Understand the need for and purpose of encryption when transmitting data

Encryption - Understand symmetric and asymmetric encryption methods

Computer architecture - Understand the role of the CPU and the meaning of microprocessor

Computer architecture - Understand the purpose of components in Von Neumann architecture

Computer architecture - Describe the fetch–decode–execute cycle

Computer architecture - Understand cores, cache and clock in a CPU

Computer architecture - Understand the instruction set

Computer architecture - Describe embedded systems and provide examples

Input and output devices - Understand input devices and their purposes

Input and output devices - Understand output devices and their purposes

Input and output devices - Understand sensors, data they capture and their appropriate use

Data storage - Understand primary storage

Data storage - Understand secondary storage

Data storage - Describe the operation of magnetic, optical and solid-state storage with examples

Data storage - Understand virtual memory and its role

Data storage - Understand cloud storage

Data storage - Explain advantages and disadvantages of cloud storage compared to local storage

Network hardware - Understand the need for NICs and MAC addresses

Network hardware - Understand IP addresses and differentiate between types

Network hardware - Describe the role of a router in a network

Types of programming languages - Explain high-level vs low-level languages, advantages and disadvantages

Types of programming languages - Understand that assembly language uses mnemonics and requires an assembler

Types of programming languages - Describe compilers and interpreters and how they operate

Types of programming languages - Explain advantages and disadvantages of compilers and interpreters

Types of programming languages - Explain the role of IDEs and their common functions

Databases - Identify fields and records in a single-table database

Databases - Apply validation to fields in a database

Databases - Understand and identify suitable primary keys

Databases - Understand and write basic SQL queries including SELECT, WHERE, AND, OR, ORDER BY

Algorithm design and problem-solving - Understand system decomposition and sub-systems

Algorithm design and problem-solving - Use flowcharts, structure diagrams and pseudocode to construct a solution

Algorithm design and problem-solving - Write algorithms using pseudocode or flowcharts

Algorithm design and problem-solving - Test algorithms using trace tables and test data

Algorithm design and problem-solving - Understand and apply standard search and sort algorithms (e.g. linear search, bubble sort)

Programming concepts - Understand and use nested selection and iteration statements

Programming concepts - Define and use procedures and functions with or without parameters

Programming concepts - Understand local and global variable scope

Programming concepts - Understand how to create maintainable programs using comments and naming conventions

Arrays - Use arrays to store multiple values of the same data type

Arrays - Use loops to process arrays

File handling - Open, read, write and close files

File handling - Understand why data is stored in external files and how programs can access them

Boolean logic - Identify and use standard logic gate symbols: AND, OR, NOT, NAND, NOR, XOR

Boolean logic - Draw logic circuits based on problem statements, logic expressions or truth tables

Boolean logic - Write logic expressions from circuits or truth tables

Boolean logic - Create and complete truth tables from logic expressions or circuits