Add the binary numbers 01101101 and 00110110. Give your answer in binary.
1.62 marks
Apply a left binary shift of 2 places to 00010110 and state the effect.
1.72 marks
Explain why hexadecimal is often used instead of binary by programmers.
2.11 mark
The ASCII code for 'A' is 65. State the ASCII code for 'D'.
2.22 marks
Explain one advantage of Unicode over ASCII.
3.13 marks
An image is 800 pixels wide and 600 pixels high with a colour depth of 24 bits. Calculate the file size in bytes. Show your working.
3.22 marks
Explain the effect of increasing the colour depth of an image.
4.11 mark
Define 'sample resolution'.
4.23 marks
A 60-second mono sound is sampled at 44,100 Hz with a sample resolution of 16 bits. Calculate the file size in bytes.
5.12 marks
Show the run length encoding (RLE) of AAAABBBCCD.
5.22 marks
Explain how Huffman coding reduces file size.
6.11 mark
For the Boolean expression Q = (A AND B) OR NOT C, state Q when A = 1, B = 0 and C = 0.
6.22 marks
Complete the output column of a truth table for Q = A XOR B for inputs AB = 00, 01, 10, 11.
7.13 marks
Describe the purpose of the ALU, control unit and registers in a CPU.
7.24 marks
Describe the fetch–execute cycle.
7.36 marks
Discuss how clock speed, number of cores and cache size affect the performance of a CPU.
8.12 marks
State two differences between RAM and ROM.
8.23 marks
Compare solid-state drives with magnetic hard disks.
8.32 marks
Explain the purpose of virtual memory.
9.12 marks
State two differences between a LAN and a WAN.
9.22 marks
Give two advantages of a star topology.
9.34 marks
Describe the four layers of the TCP/IP model.
9.42 marks
Give one advantage and one disadvantage of wireless networks compared with wired.
10.12 marks
Explain what phishing is.
10.23 marks
Explain how SQL injection works and one way to prevent it.
10.32 marks
Explain the purpose of penetration testing.
10.46 marks
A school's network stores pupil data. Discuss the methods the school could use to protect its network from cyber attacks.
11.13 marks
Table Pupils:
PupilID
Name
Form
HousePoints
101
Ada
10A
34
102
Kofi
10B
51
103
Mei
10A
47
104
Rhys
10C
12
Write an SQL query to list the names and house points of pupils in form 10A.
11.22 marks
Write an SQL statement to add 5 house points to pupil 104.
11.32 marks
Write an SQL statement to insert a new pupil: 105, Zara, 10B, 0.
11.42 marks
Explain what is meant by a primary key and a foreign key.
129 marks
A company plans to use self-driving robots to deliver parcels in a city. Discuss the ethical, legal and environmental impacts of this plan.
Finished?
Answer every question to finish (36 left), or finish when the time’s up.
Score 0 / 90 · 0 of 36 marked
This paper is written by Plasmo in the style of the AQA GCSE Computer Science exam. It is not a past paper and is not produced or endorsed by the exam board.