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

A Level Computer Science Topic Workbooks · Book 1 of 2

A Level Computer Science Topic Workbook 1

Structure and Function of the Processor, Types of Software and Development Methodologies, Exchanging Data: Databases, Networks and Web Technologies and 7 more

Level
A Level · AQA 7517 · OCR H446
Series
A Level Computer Science Topic Workbooks, book 1 of 2
Suitable for
Years 12-13, AQA / OCR
FreePDF download · 2027 edition · 97 A4 pages
  • One file, prints straight to A4
  • No account, no password

Workbooks like this one, with 10 topics, 102 questions and mark schemes at the back, are usually printed and sold by publishers. This one is one of 558 free PDFs on the shelf.

Pages
97 A4 pages
Chapters
10 worksheet chapters
Questions
102 · 881 marks
Answers
From page 60
Working time
About 17h 35m

What is inside

10 chapters · answers from p60

Each chapter starts with a page showing its marks and a suggested time, followed by the questions. The mark schemes for all 10 chapters are at the back, so the book works for homework, a timed test or revision.

  1. 01Structure and Function of the Processor10 questions · 73 marks · about 85 min Topic guide: Structure and Function of the Processorp3
  2. 02Types of Software and Development Methodologies11 questions · 103 marks · about 125 min Topic guide: Types of Software and Development Methodologiesp8
  3. 03Exchanging Data: Databases, Networks and Web Technologies10 questions · 92 marks · about 110 min Topic guide: Exchanging Data: Databases, Networks and Web Technologiesp12
  4. 04Data Types, Data Structures and Boolean Algebra11 questions · 107 marks · about 130 min Topic guide: Data Types, Data Structures and Boolean Algebrap17
  5. 05Legal, Moral, Cultural and Ethical Issues9 questions · 84 marks · about 100 min Topic guide: Legal, Moral, Cultural and Ethical Issuesp24
  6. 06Computer Architecture, Assembly and the LMC9 questions · 74 marks · about 90 min Topic guide: Computer Architecture, Assembly and the LMCp29
  7. 07Boolean Algebra, Logic Gates and Karnaugh Maps9 questions · 65 marks · about 75 min Topic guide: Boolean Algebra, Logic Gates and Karnaugh Mapsp34
  8. 08Databases, SQL and Normalisation9 questions · 82 marks · about 100 min Topic guide: Databases, SQL and Normalisationp40
  9. 09Databases and SQL11 questions · 81 marks · about 95 min Topic guide: Databases and SQLp46
  10. 10Networking and the Internet13 questions · 120 marks · about 145 min Topic guide: Networking and the Internetp52
  11. AnswersMark schemes for every chapterp60

Each chapter is drawn from one of our worksheet packs. Follow a chapter title for the full pack on its own page, or browse every A Level Computer Science pack. Every book on the shelf is a complete printable workbook of up to 120 A4 pages.

Explore this volume

A Level Computer Science Topic Workbook 1 includes Structure and Function of the Processor (from page 3); Types of Software and Development Methodologies (from page 8); Exchanging Data: Databases, Networks and Web Technologies (from page 12); Data Types, Data Structures and Boolean Algebra (from page 17); Legal, Moral, Cultural and Ethical Issues (from page 24); Computer Architecture, Assembly and the LMC (from page 29); Boolean Algebra, Logic Gates and Karnaugh Maps (from page 34); Databases, SQL and Normalisation (from page 40); Databases and SQL (from page 46); Networking and the Internet (from page 52).

Worked question 9 - Legal, Moral, Cultural and Ethical Issues

Open the included worksheet

A cyber-security researcher, Ryan McAllister, discovers a vulnerability in the software used by a UK hospital trust's patient record system. Without permission, he accesses a live test copy of the system to confirm the vulnerability is real, then emails the hospital IT department describing the flaw. Two months later, having received no response, he publishes full technical details of the vulnerability, including working exploit code, on his personal blog. A criminal group then uses this exploit to access and copy 50,000 patients' medical records, which are later found for sale on the dark web.
(a)For each of the following actions, identify whether Ryan McAllister could be prosecuted under the Computer Misuse Act 1990, and if so, under which section: (i) accessing the test copy of the system without permission; (ii) publishing the exploit code online.(4)
(b)Identify which piece of legislation is relevant to the hospital trust's own responsibilities after 50,000 patient records are stolen, and explain what the trust may be required to do as a result.(4)
(c)Evaluate whether the ethical practice of 'responsible disclosure' (privately reporting vulnerabilities and giving organisations time to fix them before publishing details) is an adequate solution to balancing the interests of security researchers, organisations and the public. Using this scenario to support your answer, discuss whether current UK legislation, such as the Computer Misuse Act 1990, adequately supports ethical security research.(9)

Answer and mark scheme

Question 9

CreditAnswer or working
B1(a) (i) Section 1: unauthorised access to computer material applies
B1(a) (i) Valid justification, e.g. he accessed the system without the hospital's consent, regardless of his benign intent, which is sufficient for the Section 1 offence
B1(a) (ii) Recognises that publishing the exploit code is not itself an act of unauthorised access, so it does not directly commit the Section 1 or Section 3 offence
B1(a) (ii) Valid nuance, e.g. this could potentially fall under Section 3A (making, supplying or obtaining articles for use in a computer misuse offence) if the code is judged likely to be used for such offences, though this is a more complex legal question than (i)
B1(b) Data Protection Act 2018 / UK GDPR
B1(b) Explains the requirement to report the breach to the Information Commissioner's Office (ICO) without undue delay, and where feasible within 72 hours
B1(b) Explains the requirement to notify the affected patients directly if the breach is likely to result in a high risk to their rights and freedoms
B1(b) Explains a possible consequence for the trust, e.g. an ICO fine, reputational damage, a requirement to improve security measures
1-3(c) L1 Basic explanation of responsible disclosure or of a legal issue, with limited reference to the scenario and little evaluation.
4-6(c) L2 Clear explanation of responsible disclosure principles and of the limitations of current legislation, with reference to the scenario, and some evaluation, though it may be one-sided.
7-9(c) L3 Sustained, well-structured evaluation that draws directly on the scenario to weigh the interests of researchers, organisations and the public, considers the adequacy of current law, and reaches a well-justified overall conclusion.
  • (a) Answer: (i) Section 1 offence applies to the unauthorised access. (ii) Publishing alone is not a direct access/modification offence, but could potentially engage Section 3A depending on intent and likely use.
  • (b) Answer: Data Protection Act 2018/UK GDPR requires the trust to report the breach to the ICO within 72 hours where feasible, notify affected patients if the risk is high, and it may face a fine or enforcement action.
  • (c) Indicative content:
    • Responsible disclosure norms: report privately first, allow a reasonable fixed period (commonly around 90 days in industry practice) for the organisation to patch the flaw, only publish full technical details afterwards, and ideally withhold or delay publication of working exploit code even then.
    • In this scenario, Ryan followed part of the process (private report first) but the hospital trust failed to respond, and Ryan then published full working exploit code rather than a limited disclosure or an extended private escalation, which arguably went beyond responsible practice and directly enabled the criminal attack.
    • The Computer Misuse Act 1990 does not provide an explicit statutory defence or 'safe harbour' for good-faith security research; the Section 1 offence can technically apply even where access was for a benign purpose, unlike some other jurisdictions that provide specific protections for authorised or good-faith testing.
    • This creates a chilling effect: legitimate researchers may be deterred from testing real systems for fear of prosecution, meaning vulnerabilities may go undiscovered or unreported, reducing overall public benefit.
    • Counter-argument: without some deterrent, any unauthorised access could be excused as 'research', which would undermine legitimate prosecution of malicious actors, so the law cannot simply exempt all such access.
    • Possible reforms discussed by security professionals include an explicit public interest defence for authorised/ethical security research, wider adoption of formal bug bounty and vulnerability disclosure programmes by organisations, and clearer statutory response-time obligations on organisations receiving vulnerability reports.
    • A well-reasoned conclusion should recognise that the harm in this case arose from failures on both sides (the hospital's lack of response and the researcher's decision to publish working exploit code), and that legal reform alongside better organisational processes, rather than either the criminal law or individual ethics alone, is likely needed to properly balance these interests.
  • (c) Answer: N/A - levels-marked extended response.

Question 8 - Legal, Moral, Cultural and Ethical Issues

Open the included worksheet

AutoDrive Motors is trialling a self-driving car on UK roads. In an emergency where a collision is unavoidable, the car's control software must choose between braking hard (risking injury to the passenger) or swerving (risking injury to a pedestrian, Omar Farouk, who has stepped into the road).
(a)Identify who might bear legal and moral responsibility if the car's decision leads to injury, and explain why assigning responsibility is harder than with a human driver.(3)
(b)Evaluate the ethical challenges of programming a self-driving car to make decisions in unavoidable-collision scenarios, and discuss whether it is possible to create rules that are morally acceptable to everyone.(7)

Answer and mark scheme

Question 8

CreditAnswer or working
B1(a) Identifies at least two possible responsible parties, e.g. the manufacturer, the software developers, the vehicle owner/supervising 'driver', the insurer
B1(a) Explains the difficulty: the decision was made by a pre-programmed algorithm rather than a real-time human judgement, so it is unclear whose 'choice' actually caused the outcome
B1(a) Valid reference to relevant framework, e.g. the Automated and Electric Vehicles Act 2018 makes insurers primarily liable for incidents while a vehicle is driving itself
1-2(b) L1 Basic identification of the dilemma (e.g. 'the car has to choose who to hurt') with little explanation.
3-5(b) L2 Clear explanation of the ethical challenge using relevant ideas (e.g. utilitarian vs rule-based approaches, differing priorities between individuals/cultures) with some attempt at evaluation.
6-7(b) L3 Sustained, well-reasoned evaluation that considers multiple ethical perspectives and cultural variation, and reaches a justified conclusion about whether universally acceptable rules are achievable.
  • (a) Answer: Responsibility could fall on the manufacturer, developers, owner or insurer; assigning it is harder because the decision was embedded in code in advance rather than made by a human in the moment, though UK law (the Automated and Electric Vehicles Act 2018) assigns initial liability to the insurer.
  • (b) Indicative content:
    • This is a variant of the 'trolley problem': there is no action-free option, so the software must be pre-programmed with a rule for an unavoidable harm scenario.
    • A utilitarian approach (minimise total harm/number of injuries) may conflict with a rule-based approach (e.g. never deliberately steer towards a person) or with protecting the paying customer (the passenger) above all else.
    • Research such as the MIT 'Moral Machine' study has shown that people in different countries and cultures prioritise these dilemmas differently (e.g. some cultures prioritise the young over the old, or pedestrians over passengers, more strongly than others), suggesting a single universally 'moral' rule may not exist.
    • Manufacturers face a commercial tension: customers may be less willing to buy a car programmed to sacrifice its own passenger in some scenarios.
    • Possible mitigations: transparency about how decisions are made, independent regulation/certification of decision rules, and legal frameworks assigning liability rather than expecting a perfect moral answer.
    • A well-reasoned conclusion should recognise that full universal agreement is unlikely given cultural variation, so transparency, regulation and legal accountability may matter more than finding one 'correct' ethical rule.
  • (b) Answer: N/A - levels-marked extended response.

Question 7 - Legal, Moral, Cultural and Ethical Issues

Open the included worksheet

Leah Kowalski is a software engineer producing control software for railway level crossings. During testing, she finds a rare timing bug that could, in one specific circumstance, leave a barrier open for an extra two seconds after a train is detected. Her manager tells her to ignore it because the release deadline is in three days and fixing it would cause a delay.
(a)State the name of the UK professional body for IT that publishes a code of conduct for computing professionals, and identify one principle from a typical professional code of conduct relevant to this scenario.(2)
(b)Explain why Leah has an individual moral responsibility to act on this bug, even though her manager has told her to release the software as planned.(3)
(c)Discuss the options available to Leah and evaluate which course of action best balances her professional, ethical and legal responsibilities.(5)

Answer and mark scheme

Question 7

CreditAnswer or working
B1(a) BCS, The Chartered Institute for IT (oe)
B1(a) Valid principle, e.g. members must have due regard for the public health, privacy, security and wellbeing of others
B1(b) Explains the potential harm to public safety, given this is a life-critical/safety-critical system
B1(b) Explains that a professional's ethical duty of care can override a manager's commercial instruction when public safety is at risk
B1(b) Explains a consequence of not acting, e.g. legal/professional liability, loss of public trust, risk of prosecution if harm occurs
1-2(c) L1 States one or two options with little explanation or evaluation.
3-4(c) L2 Explains a range of options with some evaluation of which is most appropriate, but the argument may be one-sided or not fully developed.
5(c) L3 Sustained discussion of multiple options with a clear, reasoned evaluation leading to a justified recommendation.
  • (a) Answer: BCS, The Chartered Institute for IT; its code of conduct requires members to prioritise public safety and wellbeing.
  • (b) Answer: Because the system is safety-critical, Leah's professional duty of care to protect the public overrides commercial pressure to meet the deadline; failing to act could cause real harm and expose her and the company to liability.
  • (c) Indicative content:
    • Options: report the bug formally to senior management/quality assurance in writing; refuse to sign off the release; escalate to a safety regulator such as the Office of Rail and Road; delay release until the fix is made; as a last resort, disclose externally/whistleblow.
    • The Public Interest Disclosure Act 1998 offers UK employees legal protection against dismissal for whistleblowing on genuine safety concerns, but this is typically considered a last resort after internal routes are exhausted.
    • Documenting concerns in writing protects Leah professionally and creates a record that due diligence was carried out.
    • Evaluation: escalating internally first (formally, in writing, to a level above the immediate manager) is usually the most proportionate first step, reserving external whistleblowing for cases where internal escalation fails and the risk to the public is imminent.
  • (c) Answer: N/A - levels-marked extended response.

Question 13 - Networking and the Internet

Open the included worksheet

Networking case studies: college networks, file-sharing and online retail security

Original scenarios written for Revision Library.

Questions 1 and 2 follow Ravensmead Sixth Form College's network technician, Owen Fairweather, as he chooses a topology and identifies the hardware needed for a new ICT suite. Questions 5, 6, 7, 8, 9, 12 and 13 cover the core networking theory behind that design: client-server versus peer-to-peer architectures (via a file-sharing startup, SwiftShare), the TCP/IP protocol stack, IPv4 addressing and subnetting, DNS resolution, packet switching versus circuit switching, and the full sequence of events behind a single web request. Questions 3 and 10 look at how an online retailer, GreenLeaf Retail, defends its website and customer data against network security threats, including encryption and digital certificates. Questions 4 and 11 close with wireless networking standards and security, and the ongoing migration from IPv4 to IPv6.

Ravensmead's network uses a mixture of TCP and UDP for different types of traffic, and relies on standard port numbers to direct traffic to the correct application.
(a)State two differences between TCP and UDP.(2)
(b)State the standard port number normally used by each of the following protocols: (i) HTTP (ii) HTTPS (iii) FTP (control connection) (iv) SMTP.(4)
(c)A live video-streaming service transmits its video data using UDP rather than TCP. Explain why UDP is more suitable than TCP for this application, referring to the trade-off between reliability and speed.(3)
(d)Explain why a web browser uses TCP, rather than UDP, when requesting a webpage.(3)

Answer and mark scheme

Question 13

CreditAnswer or working
B1(a) TCP is connection-oriented, establishing a connection (e.g. via a three-way handshake) before sending data, whereas UDP is connectionless and sends data without first establishing a connection (oe)
B1(a) TCP provides reliable, ordered delivery using acknowledgements and retransmission of lost packets, whereas UDP gives no such guarantee but has lower overhead/latency (oe)
B1(b) HTTP: 80
B1(b) HTTPS: 443
B1(b) FTP (control): 21
B1(b) SMTP: 25
B1(c) live streaming needs data delivered with minimal delay, and can usually tolerate the occasional lost or corrupted packet (e.g. a brief glitch) without significantly affecting the viewer's experience (oe)
B1(c) UDP has lower overhead than TCP, because it does not perform a connection handshake, acknowledgements or retransmission, so data can be sent and displayed with less delay (oe)
B1(c) if TCP were used, a lost packet would need to be retransmitted and the stream would have to wait/buffer for it, introducing a delay more disruptive to a live broadcast than simply dropping that one packet (oe)
B1(d) a webpage's HTML and resources must arrive complete and in the correct order for the page to display and function correctly, so TCP's reliable delivery and correct sequencing are important (oe)
B1(d) a missing or corrupted packet in a webpage would produce a broken or incomplete page, which is generally far more disruptive/noticeable than the brief quality dip UDP-based streaming can tolerate (oe)
B1(d) loading a webpage does not usually require the strict real-time delivery that streaming/VoIP need, so the small extra delay caused by TCP's handshake and acknowledgements is an acceptable trade-off for guaranteed accuracy (oe)
  • (a) Answer: TCP is connection-oriented, establishing a connection (e.g. via a three-way handshake) before sending any data, whereas UDP is connectionless and simply sends data without first setting up a connection. TCP also guarantees reliable, ordered delivery, using acknowledgements and retransmitting any lost data, whereas UDP gives no such guarantee, but has lower overhead and therefore lower latency.
  • (b) Answer: HTTP: 80. HTTPS: 443. FTP (control connection): 21. SMTP: 25.
  • (c) Answer: Live video streaming needs data to arrive with minimal delay, and can usually tolerate the occasional lost or corrupted packet, such as a brief visual glitch, without significantly affecting the viewer's experience. UDP has lower overhead than TCP, since it performs no connection handshake, acknowledgements or retransmission, so packets can be sent and displayed with less delay. If TCP were used instead, a lost packet would have to be retransmitted, forcing the stream to wait or buffer for it, which introduces a delay far more disruptive to a live broadcast than simply dropping that one packet would be.
  • (d) Answer: A webpage's HTML and other resources must arrive complete, uncorrupted and in the correct order for the page to display and work correctly, so TCP's guarantees of reliable, ordered delivery (using acknowledgements and retransmission) are important. A missing or corrupted packet would produce a broken or incomplete page, which is far more disruptive to the user than the brief quality dip that UDP-based streaming can tolerate. Loading a webpage also does not need the strict real-time delivery that live streaming or VoIP require, so the small extra delay from TCP's handshake and acknowledgements is an acceptable trade-off for guaranteeing the page arrives correctly.

Question 12 - Networking and the Internet

Open the included worksheet

Networking case studies: college networks, file-sharing and online retail security

Original scenarios written for Revision Library.

Questions 1 and 2 follow Ravensmead Sixth Form College's network technician, Owen Fairweather, as he chooses a topology and identifies the hardware needed for a new ICT suite. Questions 5, 6, 7, 8, 9, 12 and 13 cover the core networking theory behind that design: client-server versus peer-to-peer architectures (via a file-sharing startup, SwiftShare), the TCP/IP protocol stack, IPv4 addressing and subnetting, DNS resolution, packet switching versus circuit switching, and the full sequence of events behind a single web request. Questions 3 and 10 look at how an online retailer, GreenLeaf Retail, defends its website and customer data against network security threats, including encryption and digital certificates. Questions 4 and 11 close with wireless networking standards and security, and the ongoing migration from IPv4 to IPv6.

Ravensmead's ICT suite is assigned IP addresses on its local network.
(a)Convert the IPv4 address 172.16.5.200 to its full 32-bit binary representation.(2)
(b)A subnet uses the mask 255.255.255.0. State how many bits are used for the host identifier in this subnet, and hence calculate the number of usable host addresses it provides.(3)
(c)Explain the difference between a public IP address and a private IP address.(2)
(d)A home router uses Network Address Translation (NAT) to allow several devices to share one public IP address. Explain how NAT achieves this.(3)

Answer and mark scheme

Question 12

CreditAnswer or working
M1(a) three of the four octets converted correctly
A1(a) 10101100.00010000.00000101.11001000 cao (allow without full stops)
M1(b) 8 host bits correctly identified
M1(b) 28 = 256 total addresses calculated
A1(b) 254 usable host addresses (256 minus 2 for the network and broadcast addresses) cao
B1(c) a public IP address is globally unique and directly routable/reachable over the Internet, assigned by an ISP or regional Internet registry (oe)
B1(c) a private IP address (e.g. from 192.168.x.x, 10.x.x.x or 172.16.x.x-172.31.x.x) is only unique within its own local network and is not routable directly over the Internet; separate private networks can reuse the same private ranges (oe)
B1(d) NAT is performed by the router at the boundary between the private local network and the Internet (oe)
B1(d) when outgoing data leaves the local network, the router translates each device's private IP address (and port number) into its own single public IP address (and a different port number), recording the mapping in a translation table (oe)
B1(d) when a reply arrives back at the public IP address, the router uses the translation table to determine which internal device/port the reply should be forwarded to (oe)
  • (a) Answer: 10101100.00010000.00000101.11001000
  • (b) Answer: 8 host bits; 254 usable host addresses.
  • (c) Answer: A public IP address is globally unique and can be reached directly over the Internet; it is assigned by an ISP or a regional Internet registry. A private IP address (from a reserved range such as 192.168.x.x, 10.x.x.x or 172.16.x.x to 172.31.x.x) is only unique within its own local network and cannot be routed directly over the Internet; separate private networks, such as different homes, can reuse the same private address ranges without conflict.
  • (d) Answer: NAT is carried out by the router at the boundary between the local network and the Internet. When a device on the local network sends data out to the Internet, the router translates that device's private IP address (and port number) into its own single public IP address (with a different port number), and records this mapping in a translation table. When a reply comes back addressed to the public IP address, the router looks up the translation table to work out which internal device (and port) the reply belongs to, and forwards it there.

A Level Computer Science Topic Workbooks runs to 2 volumes

Book 1 of 2 · 200 pages in the set

Each book is a separate free PDF.

Volume 1 · this book

97 pp · 102 Qs

Structure and Function of the Processor, Types of Software and Development Methodologies, Exchanging Data: Databases, Networks and Web Technologies and 7 more

Volume 2

103 pp · 89 Qs

Object-Oriented Programming, Recursion and Advanced Algorithms, Elements of Computational Thinking and 6 more

More A Level books

A Level Computer Science 10-Minute Tests

56 pp · 18 Qs

Structure and Function of the Processor, Types of Software and Development Methodologies, Exchanging Data: Databases, Networks and Web Technologies and 14 more