Conquer

The AcademyWelcome back

Skip to content

ConquerYOUR A LEVELS

Subjects

CCambridge EPearson Edexcel AQAAQA OCROCR

Competitive Study space Mistake Bank AI Marking

Log in Create free account

Study space Mistake Bank AI Marking

Subjects

CCambridge EPearson Edexcel AQAAQA OCROCR

Competitive Log in Create free account

Computer Science · 9618

Theory Fundamentals

01Information Representation

Data Representation7

Binary place values and conversion Hexadecimal and binary conversion Binary-coded decimal (BCD)Signed binary: one's and two's complement Binary addition, subtraction and overflow Bits, bytes and storage prefixes ASCII, extended ASCII and Unicode

Multimedia3

Bitmap images and file size Vector graphics and drawing lists Sound sampling and digital encoding

Compression2

Lossless and lossy compression Run-length encoding

02Communication

Networks Including the Internet10

Networks, clients and servers Bus, star, mesh and hybrid topologies Wired and wireless transmission media LAN hardware and routers Ethernet and CSMA/CD Bit streaming and buffering Public and private cloud computing The internet and the World Wide Web IP addresses and subnetting URLs and DNS lookup

03Hardware

Computers and Their Components10

Primary memory and secondary storage Magnetic, flash and optical storage Embedded systems Device buffers Laser printers 3D printers Microphones and speakers Touchscreens VR headsets Monitoring, control and feedback

Logic Gates and Circuits2

Logic gates and truth tables Logic circuits and Boolean expressions

04Processor Fundamentals

CPU Architecture6

Stored programs and processor registers System buses and bus width The fetch-execute cycle Processor performance USB, HDMI and VGA ports Interrupts and service routines

Assembly Language2

Assembly language and two-pass assemblers Assembly addressing and tracing

Bit Manipulation1

Binary shifts and bit masks

05System Software

Operating Systems3

Operating system management Operating system utilities Program libraries and DLLs

Language Translators2

Compilers, interpreters and assemblers Integrated development environments

06Security, Privacy and Data Integrity

Data Security5

Security, privacy and integrity Accounts and authentication Security threats and defences Data encryption Digital signatures

Data Integrity5

Data validation Check digits Data entry verification Byte and block parity checks Checksums

07Ethics and Ownership

Ethics and Ownership5

Professional ethics and ethical bodies Copyright and software permission Software licences and user freedoms AI and its applications Social, economic and environmental impacts of AI

08Databases

Database Concepts3

Relational tables, keys and integrity Database relationships and E-R diagrams Normalisation from 1NF to 3NF

Database Management Systems1

DBMS features and tools

Data Definition and Manipulation4

SQL data types, tables and constraints SQL selection, filtering and ordering SQL joins, groups and aggregates SQL insert, update and delete

Revision Notes Practice Questions Topical Past Paper Questions Past Papers

Resources

Revision Notes Practice Questions Topical Past Paper Questions Past Papers

Theory Fundamentals/Databases

SQL insert, update and delete

Practise Databases

Contents

Computer Science · 9618

Theory Fundamentals

01Information Representation

Data Representation7

Binary place values and conversion Hexadecimal and binary conversion Binary-coded decimal (BCD)Signed binary: one's and two's complement Binary addition, subtraction and overflow Bits, bytes and storage prefixes ASCII, extended ASCII and Unicode

Multimedia3

Bitmap images and file size Vector graphics and drawing lists Sound sampling and digital encoding

Compression2

Lossless and lossy compression Run-length encoding

02Communication

Networks Including the Internet10

Networks, clients and servers Bus, star, mesh and hybrid topologies Wired and wireless transmission media LAN hardware and routers Ethernet and CSMA/CD Bit streaming and buffering Public and private cloud computing The internet and the World Wide Web IP addresses and subnetting URLs and DNS lookup

03Hardware

Computers and Their Components10

Primary memory and secondary storage Magnetic, flash and optical storage Embedded systems Device buffers Laser printers 3D printers Microphones and speakers Touchscreens VR headsets Monitoring, control and feedback

Logic Gates and Circuits2

Logic gates and truth tables Logic circuits and Boolean expressions

04Processor Fundamentals

CPU Architecture6

Stored programs and processor registers System buses and bus width The fetch-execute cycle Processor performance USB, HDMI and VGA ports Interrupts and service routines

Assembly Language2

Assembly language and two-pass assemblers Assembly addressing and tracing

Bit Manipulation1

Binary shifts and bit masks

05System Software

Operating Systems3

Operating system management Operating system utilities Program libraries and DLLs

Language Translators2

Compilers, interpreters and assemblers Integrated development environments

06Security, Privacy and Data Integrity

Data Security5

Security, privacy and integrity Accounts and authentication Security threats and defences Data encryption Digital signatures

Data Integrity5

Data validation Check digits Data entry verification Byte and block parity checks Checksums

07Ethics and Ownership

Ethics and Ownership5

Professional ethics and ethical bodies Copyright and software permission Software licences and user freedoms AI and its applications Social, economic and environmental impacts of AI

08Databases

Database Concepts3

Relational tables, keys and integrity Database relationships and E-R diagrams Normalisation from 1NF to 3NF

Database Management Systems1

DBMS features and tools

Data Definition and Manipulation4

SQL data types, tables and constraints SQL selection, filtering and ordering SQL joins, groups and aggregates SQL insert, update and delete

Search resources