[Past Paper] May/June 2023 Paper 11 A-Level 9618

A full walkthrough with explanations to paper 11 of the May/June 2023 9618 Cambridge computer science paper

00:20 Question 1: image, bitmap, vector, drawing list, pixel, colour depth, shape, element, picture element, resolution, file header, metadata, compression, magic bytes, file type, file size, megabytes,
MB, web server, download, bandwidth, speed, storage space, run-length encoding, RLE

19:58 Question 2: database, database management system, DBMS, data dictionary, table, relation, primary key, foreign key, index, data type, integrity, referential integrity, validation, cascade, delete, update, SQL, structured query language, normalisation, first normal form, second, third, CREATE TABLE, SELECT, FROM, WHERE, GROUP BY

41:08 Question 3: operating system, OS, peripheral hardware, device ID, drivers, firmware, data transfer, communication, CPU, file management, memory management, defragmentation, contigous, read write head, actuator, arm, binary, kibibyte, kilobyte, binary coded decimal, hexadecimal, signed, unsigned, binary addition, right logical shift

59:12 Question 4: CCTV, sensor, read only memory, ROM, random access memory, RAM, BIOS, firmware, bootstrap, dynamic RAM, DRAM, static RAM, DRAM, secondary storage, magnetic, solid-state storage, artificial intelligence, AI, image recognition, machine learning model, wireless, IP address, IPv4, IPv6, subnet

1:21:56 Question 5: logic circuit, logic expression, NOT, OR, XOR, NAND

1:24:44 Question 6: status register, interrupt flag, interrupt priority, fetch-decode-execute cycle, register, PC, MAR, MDR, CIR, RAM, stack, interrupt service route, ISR
Note: syntax used in the videos and the following websites follows the Cambridge IGCSE (0478) and A-Level (9618) qualifications

full, solved, past, papers, paper 1, 9618, summer, winter, AS, AS-Level