Revision Library
Choose a subject
Menu
Computer Science
Need a new topic?
Missing a topic, found a bug, or want something added?
Free diagnostic quiz

Computer Science diagnostic quiz

A short multiple-choice quiz. Each wrong answer is built around a named misconception, so you see why you went wrong as well as where. Then turn the gaps into a printable practice pack.

The quiz is marked entirely in this browser. There is no account, and your answers are not stored. Building a gap pack afterwards is the only step that reports anything about them: the topics you missed go in that link, and if you have accepted analytics cookies, the click reports your score too.

Sample question

Which SQL clause would list the students in a table sorted from the highest score to the lowest?

  1. WHERE Score DESC
  2. ORDER BY Score DESC
  3. ORDER BY Score ASC
  4. GROUP BY Score DESC

Answer: ORDER BY Score DESC

ORDER BY sorts the results by a column, and DESC sorts from highest to lowest.

What each wrong answer shows

WHERE Score DESC
Attaches the sorting keyword DESC to a WHERE clause, which filters rows, instead of an ORDER BY clause, which sorts them
ORDER BY Score ASC
Uses ASC, which sorts from lowest to highest, instead of DESC for highest to lowest
GROUP BY Score DESC
Confuses grouping rows by score with sorting them into descending order

The mistakes each Computer Science quiz is built to catch

Every wrong answer in these quizzes stands for one specific misunderstanding, so each mistake points to its cause.

GCSE Computer Science - 48 questions, 8 strands

Binary and Data Representation

Topics: Data Representation: Number Systems, Trace Tables and Binary/Hex Conversions, Data Representation: Images, Sound and Compression

Mistakes it looks for:

  • Forgets to multiply by the bits per sample, only multiplying the duration by the sample rate

Computer Hardware and Architecture

Topics: Systems Architecture, Memory and Primary Storage, Secondary Storage

Mistakes it looks for:

  • Confuses the MAR, which holds the address to fetch, with the component that decodes the instruction
  • Confuses increasing RAM, which affects how much can be held in memory, with increasing the speed of the CPU
  • Swaps the volatility of RAM and ROM around

System Software

Topics: System Software, Translators and Integrated Development Environments (IDEs)

Mistakes it looks for:

  • Confuses the operating system's job with a translator's job of compiling source code
  • Confuses utility software with application software used to create documents
  • Confuses managing input/output devices with sharing CPU time between programs

Networks and Protocols

Topics: Networks and Topologies, Network Protocols and Layers

Mistakes it looks for:

  • Confuses a WAN, which spans multiple sites often over public infrastructure, with a network confined to one building
  • Describes what happens in a bus topology, where a single cable break can take down the network
  • Confuses a router with a file server

Security, Legal and Ethical Impact

Topics: Network Security, Ethical, Legal, Cultural and Environmental Impact

Mistakes it looks for:

  • Confuses a worm, which spreads itself automatically, with a trojan, which relies on a user being tricked into running it
  • Confuses phishing, which tricks a user into giving up information, with a brute-force attack, which guesses passwords automatically
  • Confuses an attack on unchecked input to a database with phishing, which targets the user rather than the system

Algorithms and Robust Programs

Topics: Algorithms, Producing Robust Programs

Mistakes it looks for:

  • Confuses binary search, which halves the search space, with linear search, which checks each item in turn
  • Confuses linear search, which checks items in order, with binary search, which repeatedly halves the search space
  • Stops after only the first comparison and swap, missing the second comparison in the same pass

Programming Constructs

Topics: Programming Fundamentals, Programming Practice: Writing and Refining Programs, 1D and 2D Array Processing: Writing and Tracing Programs

Mistakes it looks for:

  • Confuses a real/float number, which can hold a decimal point, with an integer, which can only hold whole numbers
  • Stops after the first iteration instead of repeating the loop three times
  • Returns the argument unchanged instead of applying the function's calculation to it

Logic and Databases

Topics: Boolean Logic, SQL and Data Handling

Mistakes it looks for:

  • Treats AND like OR, which only needs one input to be true, instead of requiring both
  • Confuses OR with AND, which requires both inputs to be true, instead of just one
  • Assumes combining two logic operations means the expression cannot be evaluated to a single output
A Level Computer Science - 36 questions, 6 strands

Computer Systems and Architecture

Topics: Structure and Function of the Processor, Computer Architecture, Assembly and the LMC

Mistakes it looks for:

  • Confuses Von Neumann with Harvard architecture, which uses separate memory and buses for instructions and data
  • Confuses the PC with the CIR; the PC's address is copied into the MAR, and it is the fetched instruction that is later copied into the CIR
  • Confuses the PC, which holds the address of the next instruction, with the register that holds data read from or written to memory

Data Representation and Boolean Logic

Topics: Data Types, Data Structures and Boolean Algebra, Data Structures and Their Operations, Boolean Algebra, Logic Gates and Karnaugh Maps, Data Representation and Theory of Computation

Mistakes it looks for:

  • Reads the byte as an unsigned binary number instead of applying two's complement
  • Applies FIFO order, as used by a queue, instead of the LIFO order a stack uses
  • Applies De Morgan's law but keeps the AND instead of switching it to OR when the NOT is distributed

Networks and Databases

Topics: Databases and SQL, Databases, SQL and Normalisation, Networking and the Internet, Exchanging Data: Databases, Networks and Web Technologies

Mistakes it looks for:

  • Splits the statement into two clauses with a semicolon instead of writing WHERE as part of the same SELECT statement
  • Confuses first normal form, which bans repeating groups, with second normal form, which is about partial dependency on part of a composite key
  • Describes a primary key, which uniquely identifies rows in its own table, rather than a foreign key

Software Development and Object-Oriented Programming

Topics: Types of Software and Development Methodologies, Object-Oriented Programming, Programming Paradigms and OOP

Mistakes it looks for:

  • Confuses an iterative methodology with the Waterfall model, which completes each stage in a fixed sequence before the next begins, with no return to earlier stages
  • Confuses utility software, which performs specific maintenance tasks such as disk defragmentation, with the operating system, which manages hardware directly
  • Describes inheritance, not encapsulation

Algorithms and Computational Thinking

Topics: Elements of Computational Thinking, Problem Solving and Programming, Algorithms: Complexity, Searching and Sorting, Advanced Algorithms: Searching, Sorting and Path-Finding, Recursion and Advanced Algorithms

Mistakes it looks for:

  • Confuses decomposition, breaking a problem into smaller parts, with abstraction, which is removing unnecessary detail to focus on what matters
  • Confuses a pre-condition loop, which may not execute at all, with a post-condition loop, which always executes at least once
  • Confuses checking the middle item first with the search finishing in constant time; most searches need several halvings, not just the first comparison

Legal, Moral, Cultural and Ethical Issues

Topics: Legal, Moral, Cultural and Ethical Issues

Mistakes it looks for:

  • Confuses data minimisation, which limits what is collected, with storage limitation, which limits how long data is kept
  • Confuses lawful personal use of one's own data with unauthorised access, which is what the Act criminalises
  • Confuses open source, which concerns access to the source code, with freeware, which concerns price; open source software can still be sold

Want the full toolkit?

This same quiz lives inside the Computer Science workspace, alongside past papers, flashcards, revision formats and the Pack Builder.

Build a free practice pack.

Pick the topics, add the student's name and print one PDF.