9618/12 · May/June 2026
Download PDFTick (✓) one box to identify the correct definition of a pixel in a bitmap image. a colour in an image a row of consecutive identical colours in an image the binary code for one colour in an image the smallest element of an image that can be one colour
Describe the difference between the terms image resolution and screen resolution.
Two items in a bitmap image file header are the resolution and colour depth. Identify one other item included in the file header of a bitmap image.
The following bitmap image is created. Each letter represents a colour: R is red, W is white, B is blue. R R W W W W B B R R W W W W W R R R W W W W R R W W R R R R R R R R R B B B B B B B Identify the smallest bit depth that can be used for the image shown.
Explain how the image shown can be compressed using lossless compression.
Personal data is entered into a computer using a keyboard. The data is validated and verified during data entry.
Describe two methods of data verification that can be used during data entry. 1 2
The personal data includes the date of birth, for example 05/07/2010. Complete the table by identifying two methods of validation that can be used on the date of birth. State how each validation method will be used for the date of birth.
The data needs to be kept secure whilst on the computer. A virus is a threat to data. Complete the table by describing what is meant by a virus. Identify and describe one method to restrict the risk posed by a virus.
A hacker is another threat to data. Complete the table by describing what is meant by a hacker. Identify and describe one method to restrict the risk posed by a hacker.
A computer game developer stores data about a computer game in a database. The database has three entities: • the users, who are called players • the characters that users can create • the groups that users can create and allow characters to join.
Describe the relationships between the three entities.
The database is created with four tables: PLAYER(PlayerID, PlayerName, DateJoined) CHARACTER(CharacterID, CharacterName, DateCreated, Level, NumberOfPoints, PlayerID) GROUP(GroupID, GroupName, Category) CHARACTER_GROUP(CharacterGroupID, CharacterID, GroupID, DateJoinedGroup) Sample data for the table CHARACTER is given: CharacterID CharacterName DateCreated Level NumberOfPoints PlayerID 00123 Crystal 05/05/2025 5 35687 85AD 00124 Diamond 06/06/2025 4 21055 69CD 00125 Ruby 07/10/2025 1 1002 85AD The given Structured Query Language (SQL) script is written to define the table CHARACTER. 01 CREATE TABLE CHARACTER( 02 CharacterID INT, 03 CharacterName VARCHAR, 04 DateCreated DATE, 05 TheLevel INT, 06 NumberOfPoints INT, 07 PlayerID VARCHAR, 08 PRIMARY KEY CharacterID, 09 FOREIGN KEY(PlayerID) 10 ); The SQL script contains four errors. Give the line number of each error and the corrected line.
Write an SQL script to return each player’s name and the number of characters each player has created. The result needs to include a suitable field name for the number of characters. Order the results in descending order of player ID.
Complete the description of database key terms by writing the missing words. The ....................................................... stores data about the data in the database. The table names, field names and relationships will be stored. Two other examples of data that will be stored are ....................................................... and ....................................................... . When designing a database, the ....................................................... schema is the design of the database tables, fields and relationships independent of any Database Management System (DBMS). A DBMS provides security features to protect the data. ....................................................... are used to give user accounts permission to read data, some to read and write data and others may be unable to read the data. When creating a database, a ....................................................... provides tools to create visual components for example forms and reports.
A sound file has a sampling rate of 44.1kHz.
Describe what is meant by a sampling rate of 44.1kHz.
A student creates a recording of a sound with a sampling resolution of 2 bytes. The student creates a second recording of the same sound but with a sampling resolution of 8 bits. Explain how the two sound recordings and the two sound files will be affected by the different sampling resolutions.
Complete the table by calculating the missing values.
Complete the table by writing the answer to each statement.
A health monitor attaches to a person’s arm and measures key health information, for example heart rate. The monitor transmits data to the user’s smartphone. The results are analysed by the phone, which displays information to the user about their health.
Explain the reasons why the health monitor is an example of an embedded system.
Tick (✓) one box to identify if the health monitor is an example of a monitoring system or a control system. Justify your choice.
The health monitor contains Random Access Memory (RAM) and Read Only Memory (ROM). Describe two differences between RAM and ROM. 1 2
The data from the health monitor is transmitted to the smartphone and stored in the cloud. Discuss the benefits and drawbacks of storing the data from the health monitor in the cloud.
A student is writing a computer program for a school project.
The student uses a computer that comes with an Operating System (OS) and utility software. Identify two tasks the OS performs as part of process management. 1 2
Identify two tasks the OS performs as part of memory management. 1 2
Explain the reasons why defragmentation software improves the performance of a computer.
The student is using an Integrated Development Environment (IDE). Explain how the student can use debugging tools in the IDE.
The high-level language the student is using can be partially compiled and partially interpreted. Explain the reasons why some high-level languages are partially compiled and partially interpreted.
Complete the truth table for the given logic circuit.
Write the logic statement for the given truth table. P = ......................................................................................................................................