CCEA GCSE · thinka-original Practice Paper

2022 CCEA GCSE Digital Technology 2650 Practice Paper with Answers

Thinka Jun 2022 CCEA GCSE-Style Mock — Digital Technology 2650

330 marks240 mins2022
An original Thinka practice paper modelled on the structure and difficulty of the Jun 2022 CCEA GCSE Digital Technology 2650 paper. Not affiliated with or reproduced from CCEA.

Section Unit 1: Core Digital Technology

Answer all twelve questions. Quality of written communication will be assessed in Questions 4 and 6.
21 Question · 93 marks
Question 1 · Multiple Choice (Q1)
1 marks
Which of the following is an example of a secondary storage device?
  1. A.RAM
  2. B.CPU
  3. C.Solid State Drive (SSD)
  4. D.Cache memory
Show answer & marking scheme

Worked solution

RAM and cache memory are volatile, temporary memory, and the CPU is the processor itself, not a storage device. A solid state drive (SSD) is a non-volatile secondary storage device used to store files and programs permanently.

Marking scheme

1 mark: C. [1]
Question 2 · Multiple Choice (Q1)
1 marks
Which term describes software that secretly gathers information about a user's activity without their consent?
  1. A.Firewall
  2. B.Spyware
  3. C.Antivirus
  4. D.Encryption
Show answer & marking scheme

Worked solution

A firewall and antivirus software are protective tools, and encryption scrambles data to keep it secure; spyware is malicious software that covertly monitors and collects user information without consent.

Marking scheme

1 mark: B. [1]
Question 3 · Multiple Choice (Q1)
1 marks
Which network topology connects every device to a central hub or switch?
  1. A.Bus
  2. B.Ring
  3. C.Star
  4. D.Mesh
Show answer & marking scheme

Worked solution

In a bus topology all devices share a single central cable; in a ring topology devices are connected in a closed loop; in a mesh topology devices are interconnected directly with many others. A star topology connects every device individually to a central hub or switch.

Marking scheme

1 mark: C. [1]
Question 4 · Multiple Choice (Q1)
1 marks
In a relational database, which term describes a field that uniquely identifies each record in a table?
  1. A.Foreign key
  2. B.Primary key
  3. C.Index
  4. D.Query
Show answer & marking scheme

Worked solution

A foreign key links to a primary key in another table, an index speeds up searches, and a query retrieves data; a primary key is the field (or combination of fields) that uniquely identifies each record in its own table.

Marking scheme

1 mark: B. [1]
Question 5 · Multiple Choice (Q1)
1 marks
Which spreadsheet function would return the total of the values in cells B2 to B10?
  1. A.=AVERAGE(B2:B10)
  2. B.=COUNT(B2:B10)
  3. C.=SUM(B2:B10)
  4. D.=MAX(B2:B10)
Show answer & marking scheme

Worked solution

AVERAGE returns the mean, COUNT returns the number of numeric cells, and MAX returns the largest value; SUM adds together all the values in the specified range.

Marking scheme

1 mark: C. [1]
Question 6 · Multiple Choice (Q1)
1 marks
How many distinct values can be represented using 4 bits?
  1. A.4
  2. B.8
  3. C.12
  4. D.16
Show answer & marking scheme

Worked solution

The number of values representable by n bits is 2^n. For 4 bits, 2^4 = 16 distinct values (0 to 15 in denary).

Marking scheme

1 mark: D. [1]
Question 7 · Multiple Choice (Q1)
1 marks
Which health condition is most commonly associated with prolonged, repetitive use of a computer mouse or keyboard?
  1. A.Repetitive Strain Injury (RSI)
  2. B.Asthma
  3. C.Hearing loss
  4. D.Food poisoning
Show answer & marking scheme

Worked solution

Asthma, hearing loss and food poisoning are not linked to repetitive computer use; Repetitive Strain Injury (RSI) is a condition caused by repeated movements and awkward postures, commonly affecting the hands, wrists and arms of frequent keyboard/mouse users.

Marking scheme

1 mark: A. [1]
Question 8 · Multiple Choice (Q1)
1 marks
Which of the following is an example of presentation software?
  1. A.Microsoft Excel
  2. B.Microsoft PowerPoint
  3. C.Microsoft Access
  4. D.Microsoft Outlook
Show answer & marking scheme

Worked solution

Excel is spreadsheet software, Access is database software, and Outlook is email/personal information management software; PowerPoint is presentation software, used to create slideshows.

Marking scheme

1 mark: B. [1]
Question 9 · Multiple Choice (Q1)
1 marks
Which of the following best describes the purpose of a firewall?
  1. A.To increase internet connection speed
  2. B.To monitor and control incoming and outgoing network traffic based on security rules
  3. C.To compress files for storage
  4. D.To back up data automatically
Show answer & marking scheme

Worked solution

A firewall does not affect connection speed, compress files, or perform backups; its purpose is to monitor and control incoming and outgoing network traffic according to a defined set of security rules, blocking unauthorised access.

Marking scheme

1 mark: B. [1]
Question 10 · Matching Terms (Q2, Q7c)
3 marks
From the list below, select the correct term that matches each statement. (Not all terms are required.)

Terms: Bandwidth, Protocol, Router, Bluetooth, Firewall

(i) A set of rules governing the exchange of data between devices on a network.
(ii) A device that forwards data packets between different computer networks.
(iii) A short-range wireless technology used to connect peripheral devices.
Show answer & marking scheme

Worked solution

(i) A protocol is a set of rules governing how data is formatted, transmitted and received between networked devices. (ii) A router forwards data packets between different networks, directing traffic towards its destination. (iii) Bluetooth is a short-range wireless technology commonly used to connect peripherals such as headphones or a mouse.

Marking scheme

1 mark each for (i) Protocol; (ii) Router; (iii) Bluetooth. [3]
Question 11 · Matching Terms (Q2, Q7c)
3 marks
From the list below, select the correct term that matches each statement. (Not all terms are required.)

Terms: Word processing software, Spreadsheet software, Database software, Web browser, Presentation software

(i) Software used to store, organise and query large sets of structured records.
(ii) Software used to create and edit documents containing formatted text.
(iii) Software used to display and navigate web pages.
Show answer & marking scheme

Worked solution

(i) Database software stores, organises and allows querying of large sets of structured records. (ii) Word processing software is used to create and format text documents. (iii) A web browser is used to display and navigate web pages on the internet.

Marking scheme

1 mark each for (i) Database software; (ii) Word processing software; (iii) Web browser. [3]
Question 12 · Application Structured (Q3, Q5, Q8, Q10)
10 marks
(a) State the function of the CPU (central processing unit) in a computer system. (b) Name two components found inside a typical desktop computer case, other than the CPU, and state the function of each. (c) A user is upgrading their computer's RAM from 8GB to 16GB. Explain how this upgrade is likely to affect the computer's performance.
Show answer & marking scheme

Worked solution

(a) The CPU is the 'brain' of the computer: it fetches, decodes and executes program instructions, carrying out the processing that runs all software (the fetch-decode-execute cycle). (b) Two examples: RAM (Random Access Memory), which temporarily holds the data and instructions currently in use by running programs; and a hard disk drive or solid state drive, which provides permanent (non-volatile) secondary storage for files and installed programs. (c) Increasing RAM from 8GB to 16GB allows more programs and data to be held in fast-access memory simultaneously, reducing how often the operating system needs to swap data out to much slower secondary storage (virtual memory/paging). This generally improves multitasking, reduces slowdown when many applications are open, and makes the computer feel more responsive overall.

Marking scheme

(a) 1 mark: CPU processes/executes instructions; 1 mark: reference to fetch-decode-execute cycle. (b) 1 mark each for two valid components named (max 2); 1 mark each for correct function of each (max 2). (c) 1 mark: more RAM allows more data/programs held in fast memory at once; 1 mark: reduces reliance on slower secondary storage/virtual memory (paging); 1 mark: improves multitasking; 1 mark: overall improved responsiveness/performance explained coherently. [10]
Question 13 · Application Structured (Q3, Q5, Q8, Q10)
10 marks
A small business connects its office computers to the internet via a single router. (a) State two security threats the business's network could face. (b) For each threat identified in (a), describe one method the business could use to protect against it. (c) Explain why encrypting sensitive data transmitted over the network is important, even if a firewall is in place.
Show answer & marking scheme

Worked solution

(a) Two valid threats: malware/viruses that could damage systems or steal data, and unauthorised access/hacking, where an attacker gains entry to the network without permission. (b) For malware, the business could install and regularly update antivirus/anti-malware software to detect and remove threats. For unauthorised access, the business could enforce strong, unique passwords and configure a firewall to block unauthorised incoming connections. (c) A firewall controls which traffic is allowed in and out of the network, but it does not alter the content of the data itself; if an attacker manages to intercept the data in transit (e.g. by eavesdropping on the network), unencrypted data could be read directly. Encryption scrambles the data so that even if it is intercepted, it cannot be understood without the correct decryption key, providing an additional, independent layer of protection for data confidentiality.

Marking scheme

(a) 1 mark each for two valid threats (max 2). (b) 1 mark each for a valid protection method matched to each threat (max 2). (c) 1 mark: firewall controls traffic flow but does not alter/protect data content itself; 1 mark: intercepted unencrypted data could still be read; 1 mark: encryption scrambles data so it cannot be understood without the key; 1 mark: coherent explanation that encryption provides an additional, independent layer of protection. [10]
Question 14 · Application Structured (Q3, Q5, Q8, Q10)
10 marks
A local library uses a database to manage book loans. The database includes tables for Members, Books, and Loans. (a) State what is meant by a 'foreign key' and give an example of how one might be used to link the Loans table to the Members table. (b) Explain one advantage of using a relational database, with multiple linked tables, over storing all the data in a single flat-file table. (c) The library wants to find all overdue loans. Describe, in general terms, how a database query could be used to achieve this.
Show answer & marking scheme

Worked solution

(a) A foreign key is a field in one table whose values match the primary key of another table, creating a link between the two tables. For example, a MemberID field could be included in the Loans table, matching the MemberID primary key in the Members table, so each loan record is linked to the correct borrower. (b) Using linked tables avoids storing repeated member and book details in every loan record; each member's details are stored once in the Members table and referenced by key, reducing data duplication (redundancy), saving storage space, and reducing the risk of inconsistent data if details need to be updated. (c) A query could be built to search the Loans table and select (filter) only those records where the due date field is earlier than the current date, and where the loan has not yet been marked as returned, producing a list of overdue loans.

Marking scheme

(a) 1 mark: correct definition of a foreign key (field referring to another table's primary key); 1 mark: valid example linking Loans to Members via a shared key field. (b) 1 mark: valid advantage identified (e.g. reduced duplication/redundancy); 1 mark: advantage explained/developed (e.g. saves storage, reduces inconsistency risk). (c) 1 mark: reference to searching/filtering the Loans table; 1 mark: correct criterion described (due date earlier than today, loan not returned). [10]
Question 15 · Application Structured (Q3, Q5, Q8, Q10)
10 marks
A small business uses a spreadsheet to record monthly sales figures for five products, with product names in cells A2:A6 and their sales figures in cells B2:B6. (a) Write a formula that could be entered in cell B7 to calculate the total sales for all five products. (b) Write a formula that could be entered in cell C2 to calculate what percentage of the total sales (in B7) product 1's sales (in B2) represent, ensuring the formula could be copied down to C3:C6 without needing to be rewritten. (c) State one advantage of using a spreadsheet, rather than a calculator and paper records, to manage this data. (d) The business wants to automatically highlight, in a different colour, any product whose sales fall below 500. Name the spreadsheet feature that could be used to do this.
Show answer & marking scheme

Worked solution

(a) The total can be calculated using =SUM(B2:B6), which adds together all five sales values. (b) To calculate each product's percentage of the total and allow the formula to be copied down correctly, the reference to the total in B7 must be made absolute (fixed) using dollar signs, while the reference to the individual product's sales remains relative: =B2/$B$7*100. When copied down to C3:C6, the relative reference (B2, B3, B4...) updates for each row, while the absolute reference ($B$7) stays fixed on the total. (c) A spreadsheet automatically recalculates all formulas whenever a value changes, avoiding the need to manually redo calculations by hand, which reduces the risk of calculation errors and saves time. (d) Conditional formatting can be used to automatically apply formatting, such as a different colour, to cells that meet a specified condition, such as a value being below 500.

Marking scheme

(a) 1 mark: correct SUM formula for B2:B6 (accept =B2+B3+B4+B5+B6). (b) 1 mark: correct relative reference to B2; 1 mark: correct absolute reference to $B$7 allowing the formula to be copied down correctly. (c) 1 mark: valid advantage stated (e.g. automatic recalculation, reduced errors, easier to update/analyse). (d) 1 mark: conditional formatting correctly named. [10]
Question 16 · Short Answer / Theory (Q7, Q9, Q11, Q12)
7 marks
(a) Convert the denary number 43 into an 8-bit binary number. (b) Convert the binary number 10110110 into denary. (c) State why binary (rather than denary) is used to represent data within a computer system.
Show answer & marking scheme

Worked solution

(a) 43 = 32 + 8 + 2 + 1, so in 8-bit binary this is 00101011. (b) 10110110 = 1x128 + 0x64 + 1x32 + 1x16 + 0x8 + 1x4 + 1x2 + 0x1 = 128+32+16+4+2 = 182. (c) The electronic circuits and transistors inside a computer naturally operate using two discrete states, such as on/off or high/low voltage, which map directly onto the two binary digits 1 and 0; denary, with ten possible digit values, cannot be represented this simply by a two-state electronic switch.

Marking scheme

(a) 2 marks: correct 8-bit binary 00101011 (1 mark for correct value if minor bit error, ecf). (b) 2 marks: correct denary value 182 (1 mark for correct method/partial working if final answer wrong). (c) 1 mark: reference to two-state (on/off) electronic circuits/transistors; 1 mark: correct link between binary digits and these two physical states; 1 mark: clear, coherent explanation overall. [7]
Question 17 · Short Answer / Theory (Q7, Q9, Q11, Q12)
7 marks
(a) State two advantages of connecting computers in a school via a wired Local Area Network (LAN), rather than each computer working as a standalone device. (b) A school is considering switching from a wired LAN to a wireless LAN (WLAN). State one advantage and one disadvantage of making this change.
Show answer & marking scheme

Worked solution

(a) Two advantages of a wired LAN over standalone computers: resources such as printers, an internet connection, and shared files/folders can be accessed by all computers on the network rather than needing to be duplicated at every machine; and data can be centrally stored, managed and backed up on a server, making administration and security easier. (b) An advantage of switching to a WLAN is that devices are no longer tied to a fixed cable connection, giving greater flexibility and mobility in where devices can be used within range of the network. A disadvantage is that wireless connections are generally slower and less reliable than a wired connection, and are more vulnerable to unauthorised access or interception if not properly secured (e.g. with strong encryption).

Marking scheme

(a) 1 mark each for identifying two valid advantages; 1 mark each for developing/explaining each (max 4). (b) 1 mark: valid advantage of WLAN; 1 mark: valid disadvantage identified; 1 mark: disadvantage explained/developed. [7]
Question 18 · Short Answer / Theory (Q7, Q9, Q11, Q12)
8 marks
A student uses a laptop computer for several hours a day for schoolwork. (a) State four health problems, other than Repetitive Strain Injury (RSI), that could result from extended, poor-posture computer use. (b) State one precaution the student could take to reduce the risk of poor-posture-related health problems. (c) Explain why taking regular breaks is recommended when using a computer for extended periods.
Show answer & marking scheme

Worked solution

(a) Four valid health problems: eye strain, caused by prolonged screen viewing and glare; back and neck pain, caused by poor posture and inadequate seating; headaches, which can result from eye strain or poor posture; and reduced physical activity/increased risk of obesity, from long periods of sitting. (b) A valid precaution is to use an adjustable chair that provides proper back support, and to position the screen at eye level to encourage good posture. (c) Regular breaks allow the eyes to rest and refocus on distant objects, reducing eye strain (following guidance such as the 20-20-20 rule); they also allow muscles and joints used in repetitive movements, such as typing, to rest, reducing the risk of muscle fatigue and repetitive strain injuries.

Marking scheme

(a) 1 mark each for four valid health problems (max 4). (b) 1 mark: valid precaution stated. (c) 1 mark: reduces eye strain by allowing eyes to rest/refocus; 1 mark: reduces risk of muscle fatigue/RSI by resting repetitive-movement muscles and joints. [8]
Question 19 · Short Answer / Theory (Q7, Q9, Q11, Q12)
8 marks
(a) Explain the difference between RAM and ROM in a computer system. (b) State one example of data or instructions typically stored in ROM. (c) A computer's secondary storage can be either a Hard Disk Drive (HDD) or a Solid State Drive (SSD). State two advantages of an SSD over a traditional HDD.
Show answer & marking scheme

Worked solution

(a) RAM (Random Access Memory) is volatile, temporary memory: its contents are lost when the power is switched off, and it can be both read from and written to as programs run. ROM (Read Only Memory) is non-volatile: its contents are retained even when the power is off, and it is generally read-only, storing fixed instructions that do not change during normal use. (b) ROM commonly stores the BIOS (or firmware), the low-level startup instructions the computer uses to begin the boot process before the operating system loads. (c) Two advantages of an SSD over an HDD: SSDs have significantly faster read and write (data access) speeds, since they use flash memory rather than a spinning disk; and SSDs are more durable and resistant to physical shock or damage, since they have no moving mechanical parts, unlike an HDD's spinning platters and moving read/write head.

Marking scheme

(a) 1 mark: correct description of RAM (volatile, temporary, read/write); 1 mark: correct description of ROM (non-volatile, generally read-only); 1 mark: clear comparative distinction made. (b) 1 mark: valid example (e.g. BIOS/firmware/startup instructions). (c) 1 mark each for two valid advantages of SSD over HDD (max 2). [8]
Question 20 · Extended Prose / QWC (Q4, Q6)
4 marks
In this question you will be assessed on the quality of your written communication skills. Describe the steps an individual should take to protect their personal data when using online banking, and explain why each step is important.
Show answer & marking scheme

Worked solution

A strong, unique password should be used for the banking account, making it harder for an attacker to guess or crack compared with a weak or reused password. Two-factor authentication should be enabled, requiring a second form of verification (such as a one-time code sent to a phone) in addition to the password, so that a stolen password alone is not enough to access the account. The individual should check that the website uses a secure, encrypted connection (indicated by 'https' and a padlock icon), ensuring data sent to and from the bank cannot easily be intercepted and read. Public Wi-Fi networks should be avoided for banking, since data sent over an unsecured public network can more easily be intercepted by an attacker on the same network.

Marking scheme

Level 2 (3-4 marks): at least two valid, well-explained steps given, each with a clear reason why it protects personal data; accurate use of specialist terms (e.g. 'encryption', 'two-factor authentication'). Level 1 (1-2 marks): one or two steps stated with limited or no explanation of why they are important, or limited use of specialist terminology. 0 marks: no creditable response. [4]
Question 21 · Extended Prose / QWC (Q4, Q6)
4 marks
In this question you will be assessed on the quality of your written communication skills. A student is choosing between using a word processor and a desktop publishing (DTP) package to create a school newsletter. Discuss which application is more suitable, giving reasons for your answer.
Show answer & marking scheme

Worked solution

A desktop publishing package is generally more suitable for creating a newsletter. DTP software is specifically designed for page layout, allowing text and images to be placed independently in separate frames and positioned precisely anywhere on the page, which makes it easy to create the multi-column layouts, varied headline sizes and image placement typical of a newsletter. A word processor, by contrast, is primarily designed for producing continuous, linear text documents, and while modern word processors do have some layout tools, they generally offer less precise control over complex page design and can be more awkward to use for combining several stories and images on one page. For a simple, text-heavy newsletter a word processor could be adequate, but for a professional-looking, visually varied newsletter a DTP package is the more suitable choice.

Marking scheme

Level 2 (3-4 marks): a clear recommendation is made and justified with at least two valid, well-explained reasons comparing the two application types; accurate use of specialist terms (e.g. 'frames', 'layout'). Level 1 (1-2 marks): a recommendation is made with limited or undeveloped justification, or only one valid reason given. 0 marks: no creditable response. [4]

Ready to test yourself?

Turn these notes into exam-style practice. Get unlimited AI questions on this topic with instant marking and explanations.

Practise This Topic

Section Unit 2: Digital Authoring Concepts

Answer all ten questions. Quality of written communication will be assessed in Question 3(d).
12 Question · 121 marks
Question 1 · Multiple Choice & Matching (Q1, Q2a, Q10)
5 marks
A school database table storing student contact details currently repeats a student's full name and address in every row for each subject they are enrolled in, causing significant data duplication. Which of the following database design techniques would MOST effectively solve this problem?
  1. A.Increasing the field size of the address field
  2. B.Adding a password to the database
  3. C.Normalising the data by splitting it into separate, linked tables
  4. D.Sorting the table alphabetically by student name
Show answer & marking scheme

Worked solution

Increasing a field's size, adding a password, or sorting the table do not address data duplication at all. Normalising the data by splitting the repeated student details into a separate, linked Students table directly removes the duplication, since each student's details are then stored only once.

Marking scheme

5 marks: full marks awarded for selecting option C (no partial credit for multiple choice). [5]
Question 2 · Multiple Choice & Matching (Q1, Q2a, Q10)
5 marks
A multimedia developer needs to include a short video clip in a webpage while keeping the file size as small as possible without a very noticeable loss of visual quality. Which of the following actions should they take?
  1. A.Save the video in an uncompressed format
  2. B.Apply lossy compression at a moderate compression ratio
  3. C.Increase the video's resolution
  4. D.Increase the video's frame rate
Show answer & marking scheme

Worked solution

Saving the video uncompressed keeps quality but gives a very large file size, and increasing resolution or frame rate would increase file size further. Applying lossy compression at a moderate compression ratio substantially reduces file size while keeping any quality loss largely unnoticeable, meeting the stated requirement.

Marking scheme

5 marks: full marks awarded for selecting option B (no partial credit for multiple choice). [5]
Question 3 · Multiple Choice & Matching (Q1, Q2a, Q10)
4 marks
When designing a solution using a top-down approach, which of the following best describes the first step a designer should take?
  1. A.Write the complete, detailed program code for every sub-task
  2. B.Break the overall problem down into its main, high-level sub-tasks
  3. C.Test each individual sub-task with test data
  4. D.Create the final user documentation
Show answer & marking scheme

Worked solution

Writing detailed code, testing sub-tasks, and creating documentation are all later stages of development. A top-down approach begins by breaking the overall problem down into its main, high-level sub-tasks, which are then progressively broken down further before coding and testing.

Marking scheme

4 marks: full marks awarded for selecting option B (no partial credit for multiple choice). [4]
Question 4 · Authoring Design & Interfaces (Q2b-e, Q3a-c, Q4)
9 marks
A company is developing a mobile app aimed at young children. (a) State two legal considerations the developer must take into account when designing an app used by children. (b) State two accessibility features that could be included in the app's interface design to make it usable by children with visual impairments. (c) Explain why user-testing the interface with real children, rather than only adult developers, is important before release.
Show answer & marking scheme

Worked solution

(a) Two valid legal considerations: data protection/privacy legislation, which places strict controls on collecting and storing personal data from children and may require verifiable parental consent; and copyright law, governing the use of any licensed images, music or other content included in the app. (b) Two valid accessibility features: large, clearly labelled buttons and icons that are easy to see and select; and a high-contrast colour scheme, or an adjustable text size and text-to-speech/audio narration, making content easier to perceive for children with visual impairments. (c) Children often interact with, understand and navigate interfaces very differently from adult developers, who may unconsciously design for their own level of digital literacy. Testing the interface with real children reveals genuine usability problems, such as confusing icons or navigation, that would likely be missed if the interface were only tested by adult developers, helping ensure the finished app is actually usable by its intended audience.

Marking scheme

(a) 1 mark each for two valid legal considerations (max 2); 1 mark for a brief development of one. (b) 1 mark each for two valid accessibility features (max 2); 1 mark each for a brief explanation of how each helps (max 2). (c) 1 mark: children interact with/understand interfaces differently from adult developers; 1 mark: coherent explanation that this reveals genuine usability problems adult-only testing would miss. [9]
Question 5 · Authoring Design & Interfaces (Q2b-e, Q3a-c, Q4)
9 marks
A software company is developing a new digital solution for a client. (a) State what is meant by the term 'digital divide'. (b) Explain one way in which the digital divide could affect the design decisions made when developing a public-facing digital service, such as a council's online bin-collection booking system. (c) State two environmental considerations a company should take into account when developing and distributing digital solutions.
Show answer & marking scheme

Worked solution

(a) The digital divide refers to the gap between people who have ready access to digital technology and the internet, and the skills and confidence to use them, and those who do not, due to factors such as cost, location, age or disability. (b) Because not every resident will have reliable internet access or strong digital skills, the council should ensure that a non-digital alternative, such as a telephone booking line, remains available alongside the online service, and should design the digital interface to be as simple and accessible as possible for less experienced users, so that the digital divide does not exclude some residents from the service entirely. (c) Two valid environmental considerations: the energy consumption of the servers and data centres needed to host and run the solution, contributing to its overall carbon footprint; and the e-waste generated by the hardware needed to run or access the software, which can be reduced by writing efficient code and avoiding unnecessary hardware upgrades.

Marking scheme

(a) 1 mark: reference to unequal access to digital technology/internet; 1 mark: reference to unequal skills/confidence to use them. (b) 1 mark: valid design implication identified (e.g. keeping a non-digital alternative); 1 mark: clearly linked to reduced access/skills among some users; 1 mark: coherent overall explanation. (c) 1 mark each for two valid environmental considerations (max 2); 1 mark each for a brief development of each (max 2). [9]
Question 6 · Authoring Design & Interfaces (Q2b-e, Q3a-c, Q4)
8 marks
A developer is designing the user interface for a new till system to be used by shop staff. (a) State four design features that would make the interface easy and quick for staff to use accurately under time pressure. (b) Explain why a prototype of the interface should be created and reviewed with actual shop staff before the full system is built.
Show answer & marking scheme

Worked solution

(a) Four valid design features: large, clearly labelled touch-screen buttons, which reduce mis-taps under time pressure; consistent colour-coding or grouping of product categories, which speeds up locating an item; a minimal number of steps/clicks required to complete a typical transaction, reducing serving time; and a clear confirmation screen before finalising a sale, reducing costly transaction errors. (b) Shop staff are the real end users of the system and may interact with the interface, or make different assumptions about how it should work, than the developers who designed it. Reviewing a prototype with actual staff reveals genuine usability problems, such as confusing icons or awkward button placement, early in development, when such issues are far cheaper and easier to correct than if they were only discovered after the full system had already been built and deployed.

Marking scheme

(a) 1 mark each for four valid design features (max 4). (b) 1 mark: staff are the real end users and may interact with the system differently than expected; 1 mark: prototype testing reveals usability problems early; 1 mark: correcting problems early is cheaper/easier than after the full system is built; 1 mark: coherent, well-structured explanation overall. [8]
Question 7 · Extended Prose / QWC (Q3d)
6 marks
In this question you will be assessed on the quality of your written communication skills. Discuss the ethical issues a company should consider when collecting and storing customer data through a digital loyalty card app.
Show answer & marking scheme

Worked solution

The company should obtain clear, informed consent from customers before collecting their personal data, ensuring customers understand what data is being collected and why, rather than collecting it without their knowledge or genuine agreement. The company should also practise data minimisation, only collecting data that is actually necessary for the loyalty scheme to function, rather than gathering excessive personal information 'just in case' it might be useful later. Customer data must be kept securely, for example using encryption and restricted access, to protect it from unauthorised access or data breaches, which could cause real harm to customers if sensitive information were exposed. Finally, the company should be transparent about how the data will be used, for example in a clear privacy policy, and should not sell or share customer data with third parties without the customer's explicit consent, respecting customers' ongoing control over their own personal information.

Marking scheme

Level 3 (5-6 marks): a clear discussion covering at least three distinct ethical issues (e.g. informed consent, data minimisation, data security, transparency/third-party sharing), each explained with a valid reason why it matters; fluent, accurate use of specialist terms. Level 2 (3-4 marks): at least two ethical issues identified with some explanation, but coverage is narrower or less developed; reasonable use of specialist terms. Level 1 (1-2 marks): one ethical issue stated with little or no explanation, or a very generalised, undeveloped response. 0 marks: no creditable response. [6]
Question 8 · Relational Database Design & SQL (Q5)
24 marks
A veterinary clinic uses a relational database with two linked tables: Pets (fields: PetID, PetName, Species, OwnerID) and Owners (fields: OwnerID, OwnerName, PhoneNumber). PetID is the primary key of Pets, OwnerID is the primary key of Owners, and OwnerID also appears in Pets as a foreign key linking each pet to its owner. (a) Explain why OwnerID is included in the Pets table, rather than repeating the owner's name and phone number in every row of the Pets table. (b) Write an SQL statement to select the PetName and Species of all pets whose Species is 'Dog'. (c) Write an SQL statement to select the PetName from the Pets table and the OwnerName from the Owners table, for all pets, by joining the two tables on OwnerID. (d) Write an SQL statement to insert a new record into the Owners table for an owner named 'J Smith' with OwnerID 105 and PhoneNumber '07700900123'. (e) Explain what would happen to the database's integrity if a pet's OwnerID value did not match any OwnerID in the Owners table, and suggest one way this could be prevented.
Show answer & marking scheme

Worked solution

(a) Including OwnerID as a foreign key, rather than repeating the owner's name and phone number in every pet record, means each owner's details are stored only once, in the Owners table, and simply referenced by key from each of their pets' records in the Pets table. This reduces data duplication (redundancy), saves storage space, and avoids the risk of inconsistent data arising if an owner's phone number changes but is only updated in some of their pets' repeated records. (b) SELECT PetName, Species FROM Pets WHERE Species = 'Dog'; this selects the PetName and Species fields from the Pets table, filtering to only rows where Species equals 'Dog'. (c) SELECT Pets.PetName, Owners.OwnerName FROM Pets, Owners WHERE Pets.OwnerID = Owners.OwnerID; this selects the PetName field from Pets and the OwnerName field from Owners, joining the two tables together wherever their OwnerID values match, so each pet is listed alongside its correct owner's name. (d) INSERT INTO Owners (OwnerID, OwnerName, PhoneNumber) VALUES (105, 'J Smith', '07700900123'); this adds a new record to the Owners table with the specified field values. (e) If a pet's OwnerID did not match any OwnerID in the Owners table, this would break referential integrity: the pet record would be 'orphaned', referring to an owner that does not exist in the database, which could cause errors or missing information when the tables are queried together. This can be prevented by enforcing a referential integrity constraint on the foreign key, so that the database management system only permits an OwnerID value in Pets if that value already exists as a primary key in the Owners table.

Marking scheme

(a) 1 mark: correctly identifies reduced duplication/redundancy; 1 mark: correctly explains the consequence (saves storage and/or avoids inconsistency if details change). (b) 1 mark: correct SELECT clause with both fields; 1 mark: correct FROM clause; 1 mark: correct WHERE clause filtering Species = 'Dog'. (c) 1 mark: correct SELECT clause referencing fields from both tables; 1 mark: correct FROM clause listing both tables; 1 mark: correct join condition in WHERE clause (Pets.OwnerID = Owners.OwnerID). (d) 1 mark: correct INSERT INTO clause naming the table and fields; 1 mark: correct VALUES clause with correctly ordered/typed values (numeric OwnerID, quoted text for OwnerName and PhoneNumber). (e) 1 mark: correctly identifies this as a breach of referential integrity / an 'orphaned' record; 1 mark: correctly explains the consequence (errors/missing data when tables are queried together); 1 mark: valid prevention method described (referential integrity constraint restricting foreign key values to existing primary keys). Award up to 24 marks total across all parts, distributing marks as guided above. [24]
Question 9 · Web Technologies & HTML (Q6, Q7)
15 marks
A student is creating a simple webpage for a school club using HTML. (a) Write the HTML code needed to create a webpage with the title 'Chess Club' shown in the browser tab, a main heading 'Welcome to Chess Club', a paragraph of introductory text, and a hyperlink to an external website called 'World Chess Federation' linking to https://www.fide.com. (b) State the purpose of the and sections of an HTML document. (c) Explain the difference between an internal and an external hyperlink, giving an example of each.
Show answer & marking scheme

Worked solution

(a)


Chess Club


Welcome to Chess Club

Welcome to our school Chess Club webpage! Here you can find out about meeting times, upcoming tournaments and how to join.


World Chess Federation


(b) The section contains meta-information about the page that is not displayed directly as page content, such as the page title shown in the browser tab and links to external stylesheets; the section contains the actual visible content of the webpage, such as headings, paragraphs, images and links, that is rendered in the browser window. (c) An internal hyperlink links to another page or section within the same website, for example About Us; an external hyperlink links to a page on a different website altogether, for example World Chess Federation, which links out to an entirely separate site.

Marking scheme

(a) 1 mark: correct tag with 'Chess Club' inside <head>; 1 mark: <head> and <body> sections both correctly used; 2 marks: correct <h1> heading with the specified text; 1 mark: paragraph correctly wrapped in <p> tags; 2 marks: correct hyperlink with href="https://www.fide.com" and visible link text 'World Chess Federation'. (b) 1 mark each for correct description of <head> and <body> (max 2); 1 mark for a valid example of head content (e.g. title, stylesheet link); 1 mark for a valid example of body content. (c) 1 mark: correct distinction between internal and external hyperlinks; 1 mark: valid example of an internal hyperlink; 1 mark: valid example of an external hyperlink; 1 mark: correct syntax used in at least one example. [15]
Question 10 · Web Technologies & HTML (Q6, Q7)
16 marks
A webpage displays a table of chess club meeting times using HTML. (a) Write the HTML code for a table with two columns ('Day' and 'Time') and two data rows: Monday 4:00pm, and Wednesday 4:00pm. (b) Explain the purpose of Cascading Style Sheets (CSS) in web design, and state one advantage of using an external CSS file rather than inline styles. (c) Write a CSS rule that would make all headings on a webpage display in the colour blue and in a font size of 24 pixels. (d) State two factors a web developer should consider to ensure a webpage is accessible to users with visual impairments.
Show answer & marking scheme

Worked solution

(a)
DayTime
Monday4:00pm
Wednesday4:00pm

(b) CSS (Cascading Style Sheets) separates the visual presentation and styling of a webpage, such as colours, fonts and layout, from its HTML content and structure, allowing consistent styling to be defined once and applied across a page or site. An advantage of using an external CSS file, rather than inline styles written into each HTML element, is that a single external stylesheet can be linked to many different pages, so a style change only needs to be made once in the stylesheet and it automatically updates every page that links to it, rather than having to edit inline styles individually on every page. (c) h1 { color: blue; font-size: 24px; } (d) Two valid factors: ensuring sufficient colour contrast between text and its background so text remains readable for users with low vision or colour vision deficiency; and using scalable, resizable text (avoiding small fixed font sizes) so users can increase text size as needed; other valid answers include providing descriptive alt text on images for screen readers, and not relying on colour alone to convey important information.

Marking scheme

(a) 2 marks: correct tags used; 2 marks: correct header row using for 'Day' and 'Time'; 2 marks: both correct data rows using and tags. (b) 2 marks: correct explanation of CSS's purpose (separating styling from content); 2 marks: valid advantage of an external stylesheet correctly explained (single point of update for many pages). (c) 1 mark: correct selector h1; 1 mark: correct color:blue property; 1 mark: correct font-size:24px property (accept minor syntax variation if the intent is clear). (d) 1 mark each for two valid accessibility factors (max 2); 1 mark for a brief development of one. [16]
Question 11 · Testing & Evaluation (Q8, Q9)
10 marks
A developer has created a data entry form for an online membership application, which includes a field for the applicant's date of birth. (a) State what is meant by 'normal', 'extreme' and 'erroneous' test data, and give an example of each that could be used to test the date of birth field. (b) Explain why it is important to use all three types of test data when testing a solution, rather than normal data alone.
Show answer & marking scheme

Worked solution

(a) Normal test data is a valid, typical value that the system should accept and process correctly, for example a date of birth of 15/06/2005. Extreme test data is a valid value at the very boundary of what the system is designed to accept, for example the earliest or latest acceptable date, such as 01/01/1900 or today's date. Erroneous test data is invalid data that the system should recognise and reject, for example an impossible date such as 31/02/2005, or non-date text such as 'abcd'. (b) Testing with normal data alone only confirms that the system works under typical, expected conditions; it does not reveal whether the system correctly handles values at the limits of what should be accepted, or whether validation correctly identifies and rejects invalid input rather than crashing or silently accepting bad data. Using extreme data checks the system behaves correctly at these boundaries, and using erroneous data checks that validation works as intended; together, testing with all three types gives far greater confidence that the finished system is robust and reliable under a full range of real-world conditions.

Marking scheme

(a) 1 mark: correct definition of normal data + valid example; 1 mark: correct definition of extreme data + valid example; 1 mark: correct definition of erroneous data + valid example (3 marks for definitions, up to 3 further marks for correct matching examples: max 6). (b) 1 mark: normal data alone only confirms typical-case behaviour; 1 mark: extreme data checks boundary behaviour; 1 mark: erroneous data checks validation correctly rejects invalid input; 1 mark: coherent overall conclusion that all three types together give greater confidence in robustness. [10]
Question 12 · Testing & Evaluation (Q8, Q9)
10 marks
After completing a digital multimedia project, a developer carries out an evaluation of the finished product. (a) State what is meant by 'fitness for purpose' in the context of evaluating a digital solution. (b) Describe two methods a developer could use to gather feedback from users about the finished product. (c) Explain why comparing the finished product against the original design specification is an important part of evaluation.
Show answer & marking scheme

Worked solution

(a) 'Fitness for purpose' refers to whether the finished digital solution successfully meets the needs and requirements it was originally designed to satisfy, for its intended users and intended use. (b) Two valid methods: distributing user questionnaires or surveys, asking users to rate ease of use, appearance and overall satisfaction with the product; and directly observing users as they attempt to complete typical tasks using the product, noting any difficulties, hesitations or errors they encounter. (c) Comparing the finished product against the original design specification provides an objective way of checking whether every requirement that was originally agreed with the client has actually been implemented and works correctly, rather than relying only on subjective opinion about whether the product 'feels' finished. This process also helps identify any requirements that were missed, misunderstood, or not fully implemented, which is valuable information for any further development or refinement of the product.

Marking scheme

(a) 1 mark: correct definition referencing meeting original needs/requirements; 1 mark: reference to the intended users/purpose. (b) 1 mark each for two valid feedback methods (max 2); 1 mark each for a brief development of each (max 2). (c) 1 mark: comparison gives an objective check against agreed requirements; 1 mark: contrasted with relying on subjective opinion alone; 1 mark: helps identify missed/incomplete requirements; 1 mark: coherent overall explanation. [10]

Section Unit 4: Digital Development Concepts

Answer all eleven questions. Quality of written communication will be assessed in Question 5.
11 Question · 116 marks
Question 1 · Logic & Objective Tracing (Q1)
8 marks
Study the following pseudocode algorithm:

SET total TO 0
SET count TO 1
WHILE count <= 5
SET total TO total + count
SET count TO count + 1
ENDWHILE
OUTPUT total

(a) Complete a trace table showing the value of 'total' and 'count' after each pass through the loop. (b) State the final value output by the algorithm. (c) State the purpose of this algorithm, in general terms.
Show answer & marking scheme

Worked solution

Tracing through the loop: before the loop, total=0 and count=1. Pass 1: total=0+1=1, count becomes 2. Pass 2: total=1+2=3, count becomes 3. Pass 3: total=3+3=6, count becomes 4. Pass 4: total=6+4=10, count becomes 5. Pass 5: total=10+5=15, count becomes 6. Since 6 > 5, the loop condition (count <= 5) is now false, so the loop ends and 15 is output. In general terms, this algorithm calculates the sum of the whole numbers from 1 to 5.

Marking scheme

(a) 1 mark for each correctly traced pass (up to 5 marks) showing the correct running values of total and count. (b) 1 mark: correct final output 15. (c) 2 marks: correct general description that the algorithm sums the integers from 1 to 5 (1 mark for 'sums a sequence of numbers', 1 mark for the specific range 1 to 5). [8]
Question 2 · Data Representation & Binary Maths (Q6)
16 marks
(a) Convert the denary number 218 into an 8-bit binary number. (b) Convert the binary number 11010110 into hexadecimal. (c) A greyscale image is stored using 8 bits per pixel. State how many distinct shades of grey can be represented per pixel, and calculate the file size, in bytes, of an uncompressed image measuring 200 x 150 pixels. (d) Explain why lossy compression, rather than lossless compression, might be used to reduce the file size of a photograph intended for a website, and state one disadvantage of this choice.
Show answer & marking scheme

Worked solution

(a) 218 = 128+64+16+8+2, so in 8-bit binary this is 11011010. (b) Splitting 11010110 into two 4-bit nibbles gives 1101 and 0110; 1101 = 13 = D in hexadecimal, and 0110 = 6, so the hexadecimal value is D6. (c) With 8 bits per pixel, the number of distinct shades representable is 2^8 = 256. The image has 200 x 150 = 30,000 pixels; at 8 bits (1 byte) per pixel, the uncompressed file size is 30,000 x 1 = 30,000 bytes. (d) Lossy compression achieves a much greater reduction in file size than lossless compression, which is important for a website photograph, since smaller files load faster and use less bandwidth and storage, improving the user's browsing experience. The disadvantage is that lossy compression permanently discards some image data/detail in order to achieve this smaller file size, resulting in a reduction in image quality that cannot be recovered, unlike lossless compression which preserves the image perfectly.

Marking scheme

(a) 2 marks: correct binary value 11011010 (1 mark for correct working/partial value if a minor bit error is made). (b) 2 marks: correct hexadecimal value D6 (1 mark for correctly splitting into nibbles/showing working). (c) 1 mark: correct number of shades (256); 2 marks: correct calculation of total pixels (30,000); 2 marks: correct final file size (30,000 bytes), with working shown. (d) 2 marks: correct explanation of the advantage of lossy compression (much smaller file size for faster loading/less bandwidth); 2 marks: correct disadvantage explained (permanent loss of image data/quality); 1 mark: coherent overall comparison to lossless compression. [16]
Question 3 · Algorithm & Pseudocode Implementation (Q2, Q4, Q7)
15 marks
Write an algorithm, using pseudocode, that:
- repeatedly asks the user to enter a password
- only accepts passwords that are at least 8 characters long
- outputs an error message and asks again if the password is too short
- outputs 'Password accepted' once a valid password has been entered.
Show answer & marking scheme

Worked solution

DO
OUTPUT "Enter password (at least 8 characters):"
INPUT password
IF LENGTH(password) < 8 THEN
OUTPUT "Error: password too short. Try again."
ENDIF
WHILE LENGTH(password) < 8
OUTPUT "Password accepted"

The algorithm uses a post-condition loop (DO...WHILE) so that the user is always asked for a password at least once. Inside the loop, the password is input and its length checked using the LENGTH function; if it is too short, an error message is displayed and the loop repeats, asking again. The loop condition re-checks the password length each time, so the loop only ends once a password of 8 or more characters has been entered, at which point 'Password accepted' is output.

Marking scheme

3 marks: correct input statement for the password inside a repeating structure; 4 marks: correct use of a suitable loop construct (e.g. DO...WHILE / REPEAT...UNTIL / WHILE with correct condition) that repeats until a valid password is entered; 4 marks: correct IF/condition correctly checking password length against 8 characters; 2 marks: correct error message output when the password is too short; 2 marks: correct final output 'Password accepted' once a valid password is entered, placed outside/after the loop. [15]
Question 4 · Algorithm & Pseudocode Implementation (Q2, Q4, Q7)
15 marks
An array Scores[1:10] contains the test scores of 10 students. Write an algorithm, using pseudocode, that finds and outputs the highest score in the array, and also outputs the position (index) of that score within the array.
Show answer & marking scheme

Worked solution

SET highest TO Scores[1]
SET position TO 1
FOR i = 2 TO 10
IF Scores[i] > highest THEN
SET highest TO Scores[i]
SET position TO i
ENDIF
ENDFOR
OUTPUT "Highest score: ", highest
OUTPUT "Position: ", position

The algorithm first assumes the first element, Scores[1], is the highest, storing its value and position (index 1). It then loops through the remaining elements, from index 2 to 10, using a FOR loop. Each time a score greater than the current highest is found, both the highest value and its position are updated to the new score and its index. Once the loop has checked every element, the highest score and its position are output.

Marking scheme

2 marks: correct initialisation of highest and position using the first array element; 3 marks: correct FOR loop iterating over the remaining array indices (2 to 10); 3 marks: correct IF statement comparing Scores[i] to highest; 3 marks: correct update of both highest and position inside the IF; 2 marks: correct final output of both highest score and its position; 2 marks: correct, valid pseudocode array indexing syntax used throughout. [15]
Question 5 · Algorithm & Pseudocode Implementation (Q2, Q4, Q7)
16 marks
Write an algorithm, using pseudocode and a subroutine, that:
- contains a subroutine called IsEven, which accepts one integer parameter and returns TRUE if the number is even and FALSE if it is odd
- uses a main program that inputs 5 integers from the user, calls the IsEven subroutine for each one, and outputs how many of the 5 numbers were even.
Show answer & marking scheme

Worked solution

SUBROUTINE IsEven(number)
IF number MOD 2 = 0 THEN
RETURN TRUE
ELSE
RETURN FALSE
ENDIF
ENDSUBROUTINE

SET evenCount TO 0
FOR i = 1 TO 5
OUTPUT "Enter number ", i
INPUT num
IF IsEven(num) = TRUE THEN
SET evenCount TO evenCount + 1
ENDIF
ENDFOR
OUTPUT "Number of even numbers: ", evenCount

The IsEven subroutine takes one integer parameter and uses the MOD operator to test whether it divides exactly by 2 (remainder 0), returning TRUE if so and FALSE otherwise. The main program uses a FOR loop to repeat exactly 5 times, each time inputting a number from the user and calling IsEven to test it; a counter, evenCount, is incremented every time the subroutine returns TRUE. After the loop has run 5 times, the final count of even numbers entered is output.

Marking scheme

4 marks: correct subroutine definition (1 mark: correct header/parameter; 1 mark: correct MOD condition; 1 mark: correct RETURN TRUE branch; 1 mark: correct RETURN FALSE branch). 3 marks: correct main-program loop inputting 5 numbers (1 mark: correct loop construct; 1 mark: correct loop range of exactly 5; 1 mark: correct input statement). 3 marks: correct subroutine call and use of its return value in a condition. 3 marks: correct counter initialised to 0 and correctly incremented only when IsEven returns TRUE. 2 marks: correct final output of the count after the loop. 1 mark: valid, consistent pseudocode syntax used throughout. [16]
Question 6 · Extended Response / QWC (Q5)
6 marks
In this question you will be assessed on the quality of your written communication skills. Discuss how the growth of artificial intelligence (AI) is changing the way software is developed and used, including at least one benefit and one risk/concern.
Show answer & marking scheme

Worked solution

AI is changing software development in several ways. AI coding assistants can suggest, generate and help debug code, speeding up development and allowing developers to focus more time on complex design decisions rather than routine, repetitive coding tasks. AI is also increasingly built directly into finished software as a feature, for example through personalised recommendations, intelligent chatbots or automated data analysis, giving end users new capabilities that were previously impractical to build. However, this growth also raises risks and concerns. Over-reliance on AI-generated code can introduce bugs, inefficient code or security vulnerabilities that go undetected if developers do not carefully review AI suggestions before using them, since AI tools do not guarantee correct or secure output. There are also concerns about job displacement, particularly for entry-level developers whose routine tasks may increasingly be automated, changing the skills the software industry now demands from new developers.

Marking scheme

Level 3 (5-6 marks): a clear discussion including at least one well-explained benefit and one well-explained risk/concern, both clearly linked to how AI is changing software development or its use; fluent, accurate use of specialist terms. Level 2 (3-4 marks): at least one benefit and one risk identified, but with limited development or a narrower range of points; reasonable use of specialist terms. Level 1 (1-2 marks): only a benefit or a risk stated, with little explanation, or a very generalised, undeveloped response. 0 marks: no creditable response. [6]
Question 7 · Development Concepts & Flowcharts (Q3, Q8, Q9)
7 marks
A flowchart for a simple program is described as follows: Start -> Input a number N -> Decision: Is N negative? -> (Yes) Output 'Invalid: negative number' then Stop -> (No) Decision: Is N even? -> (Yes) Output 'N is even' then Stop -> (No) Output 'N is odd' then Stop. (a) State the output of this flowchart if the user enters -4. (b) State the output of this flowchart if the user enters 7. (c) Convert this flowchart into pseudocode using IF statements.
Show answer & marking scheme

Worked solution

(a) Since -4 is negative, the first decision routes straight to the 'Invalid: negative number' output. (b) Since 7 is not negative, the flow moves to the second decision; 7 is odd (not even), so the output is 'N is odd'. (c) INPUT N
IF N < 0 THEN
OUTPUT "Invalid: negative number"
ELSE
IF N MOD 2 = 0 THEN
OUTPUT "N is even"
ELSE
OUTPUT "N is odd"
ENDIF
ENDIF

Marking scheme

(a) 1 mark: correct output 'Invalid: negative number'. (b) 1 mark: correct output 'N is odd'. (c) 1 mark: correct INPUT statement; 1 mark: correct first IF testing N < 0; 1 mark: correct nested IF testing N MOD 2 = 0 inside the ELSE branch; 2 marks: correct outputs matched to each branch. [7]
Question 8 · Development Concepts & Flowcharts (Q3, Q8, Q9)
7 marks
A program asks the user to input their age as a whole number. (a) State two types of run-time error that could occur if the program does not include any error handling for this input. (b) Describe how input validation could be used to handle invalid input (such as text being entered instead of a number) without the program crashing.
Show answer & marking scheme

Worked solution

(a) Two valid run-time errors: a type mismatch/data type error, which could occur if text is entered where a whole number is expected, causing the program to crash if the error is not handled; and an out-of-range error, which could occur if a negative number or an unrealistically large age is entered, which is technically a valid number but not a sensible age. (b) Input validation checks the entered data before it is used elsewhere in the program. This can be implemented using a validation loop that repeatedly checks whether the input is of the correct data type (e.g. a whole number) and, if a range is also relevant, whether it falls within a sensible range; if the check fails, an error message is displayed to the user and they are asked to re-enter the value, and the loop repeats until valid input is received, so the program never proceeds to use invalid data and therefore does not crash.

Marking scheme

(a) 1 mark each for two valid run-time error types (max 2). (b) 1 mark: reference to checking the input before it is used; 1 mark: correct reference to a validation loop/repeated check; 1 mark: correct reference to displaying an error message on invalid input; 1 mark: correct reference to re-prompting the user until valid input is received; 1 mark: coherent overall explanation of how this avoids a crash. [7]
Question 9 · Development Concepts & Flowcharts (Q3, Q8, Q9)
7 marks
A developer is designing the on-screen interface for a new mobile app. (a) State three digital design principles that should be applied to make the interface clear and easy to use. (b) Explain why maintaining a consistent layout and style across every screen of the app is good design practice.
Show answer & marking scheme

Worked solution

(a) Three valid design principles: consistency, applying the same layout, colours and fonts throughout the app; simplicity, avoiding unnecessary clutter so the interface is not overwhelming; and appropriate use of colour and contrast, ensuring text and important controls remain clearly legible. Other valid answers include clear labelling/icons for controls and an appropriate, legible font size. (b) Maintaining a consistent layout and style across every screen means users only need to learn how the interface works once, and can then apply that same understanding to navigate every other screen in the app, rather than having to relearn controls and navigation patterns on each new screen. This reduces user confusion and the likelihood of errors, and makes the finished app feel more intuitive, coherent and professional overall.

Marking scheme

(a) 1 mark each for three valid digital design principles (max 3). (b) 1 mark: users only need to learn the interface once; 1 mark: this reduces confusion/errors when navigating between screens; 1 mark: reference to the app feeling more intuitive/professional as a result; 1 mark: coherent, well-developed overall explanation. [7]
Question 10 · Testing & Evaluation (Q10, Q11)
10 marks
A developer is testing a program that calculates the area of a rectangle from two user-entered dimensions (length and width, both positive numbers). (a) Construct a test plan table with three columns (Test data, Type of test data, Expected result) containing three rows of suitable test data for this program: one normal, one extreme, and one erroneous. (b) Explain why testing should take place throughout development (iterative testing), rather than only once at the very end of the project.
Show answer & marking scheme

Worked solution

(a) Test data: length=5, width=4; Type: Normal; Expected result: area of 20 output correctly, no error. Test data: length=0.01, width=0.01; Type: Extreme; Expected result: a very small but valid area (0.0001) output correctly, without rounding errors or a crash. Test data: length=-5, width=4; Type: Erroneous; Expected result: an error message is displayed and the input is rejected, since a negative dimension is not valid for a rectangle. (b) Testing throughout development, rather than only in one large phase at the end, allows errors and bugs to be identified and fixed early, while the relevant code is still fresh in the developer's mind and before later sections of code have been built on top of, or come to depend on, the faulty section. If testing is left until the very end of the project, bugs found at that late stage are typically far more time-consuming, complex and costly to trace back to their source and fix, since the error may now be entangled with a large amount of dependent code.

Marking scheme

(a) 2 marks each for a correctly completed row (correct test data, correct type, correct expected result) for normal, extreme and erroneous data (max 6). (b) 1 mark: errors are identified and fixed earlier; 1 mark: code is still fresh in the developer's mind/easier to trace at that point; 1 mark: avoids later code depending on/being built on top of the faulty section; 1 mark: coherent conclusion that this makes bugs cheaper/easier to fix than finding them only at the end. [10]
Question 11 · Testing & Evaluation (Q10, Q11)
9 marks
Once a digital solution has been fully developed and tested, a formal evaluation is carried out. (a) State four criteria that could be used to evaluate whether the finished solution is successful. (b) Explain why gathering feedback from the original client, as well as from end users, is important during evaluation.
Show answer & marking scheme

Worked solution

(a) Four valid evaluation criteria: fitness for purpose, whether the solution meets the requirements it was originally designed to satisfy; efficiency/performance, whether it runs quickly and without excessive use of system resources; reliability, whether it operates with few bugs or crashes; and usability, whether it is easy for its intended users to use effectively. (b) The client commissioned the solution and is best placed to confirm whether it meets the original business requirements and specification that were agreed at the start of the project, from a functional and commercial perspective. End users, however, interact with the solution directly on a day-to-day basis and can provide practical feedback on its usability, ease of use and any real-world problems they encounter, which the client, who may not use the system themselves, would not necessarily be aware of. Gathering feedback from both groups therefore gives a far more complete and balanced picture of the solution's overall success than relying on either group's feedback alone.

Marking scheme

(a) 1 mark each for four valid evaluation criteria (max 4). (b) 1 mark: client feedback confirms the solution meets originally agreed requirements; 1 mark: end-user feedback gives practical usability/real-world insight the client may lack; 1 mark: coherent explanation that combining both gives a more complete/balanced picture of success. [9]

Wondering how well you actually know this?

thinka is an AI practice app for DSE students: unlimited questions, instant auto-marking, and detailed step-by-step solutions. 100,000+ students use it to confirm they actually know it, not just think they do.

Want more questions like this? Practise unlimited on thinka, instant answers included.

Start Practising Free