1 mark for each correctly connected change box, max 3 marks

1 mark for 2 or 3 correct ticks Example of data Number of bits

1 mark per shaded area, max 2 marks A B C X 0 1 0 0 1 1 1 1 0 1 0 1 1 1 1 1

1 mark for a drawback • Can be less secure • Transmission speed can be slow • Interference is possible • The signal degrades quickly without repeaters/boosters 4(c) One mark for each correct row Description Memory Technology A read only memory where the contents can be erased using a voltage pulse. The contents can be changed multiple times without physically removing the memory. EEPROM A read only memory where the contents are erased using ultraviolet (UV) light. The memory must be physically removed to be reprogrammed. EPROM A read only memory where the contents can be written only once after manufacture. PROM

1 mark for each correct relationship, max 3 marks

1 mark per bullet point, max 5 marks • SELECT and the correct attributes • FROM and the correct tables • Tables joined correctly • Correct condition for the rating • Correct ORDER BY clause Example Answer 1 SELECT PRODUCT.ProductID, ProductName, ComplaintDetails FROM PRODUCT, COMPLAINT WHERE PRODUCT.ProductID = COMPLAINT.ProductID AND Rating <=5 ORDER BY Rating DESC; Example Answer 2 SELECT PRODUCT.ProductID, ProductName, ComplaintDetails FROM PRODUCT INNER JOIN COMPLAINT ON PRODUCT.ProductID = COMPLAINT.ProductID WHERE Rating <=5 ORDER BY Rating DESC;

1 mark for each correct row Current contents of the ACC Instruction Contents of the ACC after the execution of the instruction 0000 1111 AND 101 0000 1110 0000 0000 LDM #100 0110 0100 0000 0001 XOR &F1 1111 0000 0001 0001 CMP 101 0001 0001

1 mark per point, max 2 marks e.g. • The learning experience could be improved • … by identifying students who are struggling • …. and employing more personalised learning • There could be early Intervention • … to determine which students require extra support • • Teachers and students could understand the challenges better • …and identify optimal times for learning • There could be privacy concerns • …. students / teachers could be uncomfortable with constant surveillance • ... students might not want their data / actions passed to third parties • There could be Mental Health concerns • …. due to constant monitoring and pressure • …. contributing to student stress and anxiety

1 mark per reason, 1 mark for corresponding justification x2 max 4 marks • Lower cost per unit of storage • ... so the high capacity of storage required for large number of video files will be less costly • A large number of read/write operations are being performed continuously • ... and magnetic storage is likely to have a longer life span compared with solid state

2 1(c) 1 mark per bullet point, max 2 marks • ASCII uses 7 / 8 bits Unicode can use many more / up to 32 bits • Unicode can represent a wider range of characters including different languages increase the duration of the recording decrease the sampling resolution increase the sampling rate the file size gets bigger no change in the file size the file size gets smaller the accuracy of the sound file improves no change to the accuracy of the sound file the accuracy of the sound file worsens

2 mark for 4 or 5 correct ticks

2 3(b) 1 mark per bullet point, max 2 marks • A AND B OR C • C NOR D and final two gates Question Answer Marks 4(a) 1 mark for each benefit, max 3 • Devices can be more mobile as no physical connection is required • No cabling is needed so easier to set up • Easier to add additional devices • Multiple different device types can be connected

2 7(b) 1 mark for the working 1 mark for the correct answer Working: (4000*3000*30*16) / (8*1000*1000*1000) //(4000*3000*30*2) / (1000*1000*1000) Answer: 0.72 gigabytes 7(c) 1 mark for the name 2 marks for the matching description, max 3 marks • Parity Byte Check • a parity bit is added to each byte to make the number of 1s match the parity, odd or even • each byte can be checked on receipt and request to be resent if the byte does not match parity • Parity Block Check • a bit is added to each byte, but a parity byte is also set for each block • the location of an error can be found using vertical and horizontal parity • Checksum • A calculation is made from the data and transmitted with the data • The receiver performs the same calculation and compares with received checksum to see if they match

2 8(b) 1 mark per bullet point, max 3 marks • Programming time is saved as code does not have to written from scratch • Testing time is saved as code is already tested / documented • A library routine is more likely to work, as code is already tested • Library routines automatically update if they are changed / improved • The programmer can use library routines to perform complex functions / procedures that they may not be able to write themselves 8(c) 1 mark per bullet point, max 2 marks • Open Source (Initiative) • Free Software (Foundation) 8(d) 1 mark for each bullet point, max 3 marks • File management • Security management • Hardware / peripheral management // input / output management • Process management 3

3 1(b) 1 mark per bullet point, max 2 marks • Each character has a unique code • Each character in the text is replaced sequentially / in order by its code

3 marks for 6 correct ticks

3 5(b) 1 mark per bullet point, max 4 marks • Create table with opening and closing brackets and commas separating the attributes • Appropriate data types for StaffFirstName, StaffLastName and Department • Appropriate data types for StaffID and RemoteWorker • Primary key correctly defined Example Answer 1: CREATE TABLE STAFF( StaffID INTEGER, StaffFirstName VARCHAR, StaffLastName VARCHAR, Department CHAR, RemoteWorker BOOLEAN, PRIMARY KEY (StaffID) ); Example Answer 2: CREATE TABLE STAFF( StaffID INTEGER NOT NULL PRIMARY KEY, StaffFirstName VARCHAR, StaffLastName VARCHAR, Department CHAR, RemoteWorker BOOLEAN );

3 Question Answer Marks 8(a) 1 mark per bullet point, max 2 • Large amounts of source code take time to compile • It can be slower to produce the object code than an interpreter • The code must be recompiled when it is changed • The program cannot run if there are errors • It is not possible to correct errors in real-time • One error can cause false reporting of multiple further errors • Sections of code / unfinished code cannot easily be tested

4 6(b) 1 mark for each bullet point, max 4 marks • MAR stores the address of the next instruction / data to be read from / or written to memory • The address is received from the Program Counter (PC) • The MDR stores the data / instruction in the address stored in the MAR which has been read / written • The instruction passes to the CIR for decoding and executing 6(c) 1 mark for each bullet point, max 3 marks • Data movement • Arithmetic operations • Conditional and unconditional (jump) instructions

4 7(e) 1 mark for each validation check correctly identified, max 3 marks Range Check Existence Check Format Check

5 5(d) One mark for identification of method one mark for corresponding description max 4 marks • Authentication methods / passwords / biometrics / 2-factor authentication can be implemented • ... which prevents unauthorised access to the customer’s data • Access rights / privileges can be set • ... so that only those with correct permissions can read / edit customer’s data • Regular backups can be scheduled • ... so that a second copy of the customer’s data is available in case of loss/damage • The data can be encrypted • ... so that the customer’s data cannot be understood by anyone who gains unauthorized access • Different views can be created • ... so that not everyone can see the customer’s data

24 64 the hexadecimal value F139 ✓ 16 000 000 unique amplitude values ✓ an IPv4 address ✓ 256 unique colours ✓ an IPv6 address ✓ the denary value 65 000 ✓ 2(b) 1 mark 1111 1001 0100 2(c) 1 mark 1111 0010 2(d) 1 mark E33B 1