9618/13 · Oct/Nov 2025
Download PDF
A student creates sound recordings. Making changes to a sound recording may impact the accuracy of the resulting sound file or the size of the file. Draw two lines from each change to the impacts it has on the sound file.
The file names of the sound recordings are stored using the ASCII character set. Explain how text is represented by the ASCII character set.
Give two differences between the ASCII and UNICODE character sets.
Data in a computer system is represented in binary. Put one tick (✓) in each row to identify the minimum number of bits used to store each example of data.
Convert the denary number –108 into a 12-bit two's complement binary number.
A three-place arithmetic shift to the right is performed on the following two's complement negative integer. Show the result of this arithmetic shift. 10010011
Convert the following positive binary integer into hexadecimal. 1110001100111011
Complete the truth table for the following logic expression:
Draw a logic circuit for the logic expression:
A network engineer is setting up a Local Area Network (LAN) in an office. The network uses both wired and wireless connectivity.
Give three advantages of a wireless network compared to a wired network.
Give one drawback of using a wireless network.
Complete the table by writing the name of the type of memory technology for each description.
A company creates a relational database to store data about its customers. The database, REVIEWS, stores data about the customers, products, complaints and staff. The database has four tables: CUSTOMER(CustomerID, CustomerFirstName, CustomerLastName, CustomerEmail) PRODUCT(ProductID, ProductName, ProductDetail, Price, Rating) COMPLAINT(ComplaintID, ProductID, CustomerID, ComplaintDetails, StaffID) STAFF(StaffID, StaffFirstName, StaffLastName, Department, RemoteWorker)
Complete the entity-relationship (E-R) diagram for the database REVIEWS.
Some example data from the STAFF table is shown. Write a Structured Query Language (SQL) script to define the table STAFF.
Products are given a rating between 1 and 10 inclusive. Write an SQL script to return only the ProductID, ProductName and ComplaintDetails for all products with a rating of 5 or less. The results need to be displayed in descending order of rating.
A Database Management System (DBMS) is used to maintain and manage the database. Describe two ways in which the DBMS can be used to ensure the security of the customer data.
The following table shows part of the instruction set for a processor. The processor has two registers: the Accumulator (ACC) and the Index Register (IX). <address> can be an absolute or symbolic address # denotes a denary number, e.g. #127 B denotes a binary number, e.g. B10010001 & denotes a hexadecimal number, e.g. &4A The current contents of main memory are shown: Address Data 100 0000 0011 101 1010 1110 102 1100 1100 103 1111 1111 104 1100 1100
Complete the table by writing the contents of the ACC after the execution of each instruction.
The Von Neumann model for a computer system uses registers. Describe the role of the Memory Address Register (MAR) and Memory Data Register (MDR) in the fetch-execute (F-E) cycle.
Assembly language instructions are grouped. Complete each statement by writing the name of the appropriate instruction group. Loading data into the accumulator is an example of an instruction in the ............................................................... group. Incrementing the index register is an example of an instruction in the ............................................................... group. Branching to another address is an example of an instruction in the ............................................................... group.
A digital video camera records students in a classroom. The data is transferred from the digital video camera over the internet to a server. Artificial Intelligence (AI) is used to analyse the video on the server to identify when students are interacting with the lesson and the teacher.
Describe one ethical impact of this use of AI in the classroom.
A video is made of many bitmap images called frames. 30 frames are recorded every second. Each frame is 4000 pixels wide by 3000 pixels high. The video records using 16-bit colour depth. Calculate an estimate for the file size for one second of the video in gigabytes. Show your working. File size ................................ gigabytes
Identify and describe one method of data verification that can be used when transferring data from the digital video camera to the server.
Describe two reasons why the server that stores the videos uses magnetic hard disks instead of solid state (flash) memory.
The table contains three algorithms that perform data validation. The third algorithm uses the functions MID and LENGTH. The functions MID and LENGTH are defined as follows: • MID(ThisString : STRING, x : INTEGER, y : INTEGER) RETURNS STRING returns a string of length y starting at position x from ThisString • LENGTH(ThisString : STRING) RETURNS INTEGER returns the integer value representing the length of ThisString Complete the table to identify the method of data validation for each algorithm. Each method of data validation must be different.
Compilers and interpreters are used to translate programs written in a high-level language into a low-level language.
State two disadvantages of using a compiler compared to an interpreter during program development.
Explain how a programmer benefits from using program libraries during program development.
A programmer is developing an Operating System (OS). Identify two types of software licence the programmer can use to allow other people to edit and redistribute the OS.
Memory management is one key management task performed by an OS. Give three other key management tasks that are performed by an OS.