Computer Science | 0478

Add two positive 8-bit binary integers

Apply validation to fields in a database

Calculate the file size of an image file and a sound file, using information given

Complete a trace table to document a dry-run of an algorithm

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

Convert between positive denary and positive binary

Convert between positive denary and positive hexadecimal

Convert between positive hexadecimal and positive binary

Create and complete truth tables from logic expressions or circuits

Declare and use one-dimensional and two-dimensional arrays

Declare and use variables and constants

Define a single-table database from given requirements

Define and understand the functions of logic gates

Define and use procedures and functions with or without parameters

Define and use procedures and functions, with or without parameters

Describe compilers and interpreters and how they operate

Describe embedded systems and provide examples

Describe how a check digit is used and identify examples such as ISBN and bar codes

Describe how ARQ is used to confirm data was received correctly

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

Describe how web pages are located, retrieved and displayed on a device when a user enters a URL

Describe methods of data transmission

Describe parity check (odd and even), checksum and echo check

Describe the advantages and disadvantages of an automated system used for a given scenario

Describe the characteristics of a robot

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

Describe the fetch–decode–execute cycle

Describe the main characteristics of AI

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

Describe the process of packet switching

Describe the purpose and operation of HTTP and HTTPS

Describe the role and basic functions of an operating system

Describe the role and operation of interrupts

Describe the role of a router in a network

Describe the structure of a packet

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

Explain advantages and disadvantages of cloud storage compared to local storage

Explain advantages and disadvantages of compilers and interpreters

Explain high-level vs low-level languages, advantages and disadvantages

Explain the basic operation and components of AI systems

Explain the purpose and functions of a web browser

Explain the purpose of a given algorithm

Explain the role of IDEs and their common functions

Explain the suitability of each method for a scenario

Explain what is meant by cookies and how they are used

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

Identify and use the standard symbols for logic gates

Identify errors in given algorithms and suggest ways of correcting them

Identify fields and records in a single-table database

Open, close and use a file for reading and writing

Open, read, write and close files

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

Read, understand and complete SQL scripts to query data

Suggest and apply suitable test data

Suggest suitable basic data types

Test algorithms using trace tables and test data

Understand and apply standard search and sort algorithms (e.g. linear search, bubble sort)

Understand and identify suitable primary keys

Understand and use arithmetic, logical and Boolean operators

Understand and use basic data types

Understand and use input and output

Understand and use library routines

Understand and use local and global variables

Understand and use nested selection and iteration statements

Understand and use nested statements

Understand and use sequence, selection, and iteration

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

Understand cloud storage

Understand cores, cache and clock in a CPU

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

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

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

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

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

Understand how data storage is measured

Understand how files are compressed using lossy and lossless compression methods

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

Understand how to create a maintainable program

Understand how to create maintainable programs using comments and naming conventions

Understand input devices and their purposes

Understand IP addresses and differentiate between types

Understand local and global variable scope

Understand output devices and their purposes

Understand primary storage

Understand secondary storage

Understand sensors, data they capture and their appropriate use

Understand standard methods of solution

Understand symmetric and asymmetric encryption methods

Understand system decomposition

Understand system decomposition and sub-systems

Understand that assembly language uses mnemonics and requires an assembler

Understand that data is broken down into packets to be transmitted

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

Understand the denary, binary and hexadecimal number systems

Understand the difference between the internet and the world wide web

Understand the instruction set

Understand the need for and purpose of encryption when transmitting data

Understand the need for NICs and MAC addresses

Understand the need for validation and verification checks

Understand the need to check for errors after data transmission

Understand the program development life cycle

Understand the purpose of a primary key and identify one

Understand the purpose of and need for data compression

Understand the purpose of components in Von Neumann architecture

Understand the purpose of storing data in a file

Understand the role of the CPU and the meaning of microprocessor

Understand the roles that robots can perform and describe the advantages and disadvantages of their use

Understand the USB interface and how it is used to transmit data

Understand the use of arrays

Understand virtual memory and its role

Understand what is meant by a uniform resource locator (URL)

Understand what is meant by artificial intelligence (AI)

Understand what is meant by robotics

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

Use arrays to store multiple values of the same data type

Use different methods to design and construct a solution to a problem

Use flowcharts, structure diagrams and pseudocode to construct a solution

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

Use loops to process arrays

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

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

Write algorithms using pseudocode or flowcharts

Write and amend algorithms using pseudocode, program code and flowcharts

Write logic expressions from circuits or truth tables

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