General Instructions
• Reading time – 10 minutes
• Working time – 2 hours and 20 minutes
Total marks: 80
• Attempt Questions 1-28
• Allow 2 hours and 20 minutes to attempt the questions
Question 1 (1 mark)
Which strategy is most effective in reducing the impact of unconscious bias in data visualisation?
Question 2 (1 mark)
An enterprise dashboard includes summary charts, trend lines, and highlighted anomalies in red.
Which combination of purposes is being achieved?
Question 3 (1 mark)
What is the key difference between interval and ratio data?
Question 4 (1 mark)
Which of the following is a major ethical concern associated with intelligent surveillance systems?
Question 5 (1 mark)
A large enterprise implements a rule-based expert system to provide IT support to staff. While the system successfully resolves standard software issues, employees report that complex problems often require assistance from human technicians.
Which limitation of expert systems is BEST demonstrated in this scenario?
Question 6 (1 mark)
A development team introduces a new system in only one store before deploying it company-wide throughout an enterprise.
Which implementation method is being used?
Question 7 (1 mark)
A team tests an online booking system using thousands of simultaneous users to determine whether performance degrades under heavy demand.
Identify which method of testing is being used.
Question 8 (1 mark)
A video streaming service collects personal data from their subscribers for their records. They’re looking to share the information to another video streaming company without the informed consent from each subscriber or appropriate security measures.
Which of the following issues are demonstrated in this scenario?
Question 9 (1 mark)
Which methods can be used to restrict access to sensitive financial data?
Question 10 (1 mark)
A bank introduces a machine learning system that continually refines its fraud detection by analysing customer transaction data and identifying unusual spending patterns.
Which characteristics of machine learning are demonstrated by this system?
Question 11 (1 mark)
Select the primary thinking skill demonstrated by each activity during the design and development of an enterprise system.
| Computational Thinking | Design Thinking | Systems Thinking | |
|---|---|---|---|
| Analysing customer data to identify purchasing patterns. | |||
| Interviewing users and refining a prototype based on their feedback | |||
| Evaluating how a new CRM system will affect workflows across the organisation. | |||
| Comparing several interface designs before selecting the most appropriate solution. | |||
| Mapping how information flows between departments in an enterprise system. | |||
| Designing an formulas to automate invoice processing. |
Question 12 (2 marks)
Match each definition with the correct term.
| Data Science | Expert System | Informatics | Machine Learning | Python | Qualitative Data | Quantative Data | Simulation | SQL | What-if Analysis | |
|---|---|---|---|---|---|---|---|---|---|---|
| The process of exploring different scenarios by changing variables in a model to predict possible outcomes and support decision-making. | ||||||||||
| The discipline of collecting, managing, analysing and interpreting data to solve problems, support decision-making and gain insights. | ||||||||||
| A programming language commonly used to manage, query and manipulate data which is stored in relational databases. | ||||||||||
| Data that is descriptive and non-numerical, often collected through observations, interviews, opinions or open-ended responses. | ||||||||||
| A field of artificial intelligence in which computer systems learn from data to improve their performance or predictions without being explicitly programmed for every task. |
Question 13 (2 marks)
Match each scenario with the most appropriate chart.
| Bar chart | Heat map | Line graph | Pie chart | Scatter plot | Stacked bar chart | |
|---|---|---|---|---|---|---|
| Showing sales growth over 12 months | ||||||
| Comparing revenue across regions | ||||||
| Highlighting underperforming stores using colour intensity | ||||||
| Exploring the relationship between advertising spend and sales | ||||||
| Showing percentage of sales by product category | ||||||
| Comparing category contributions across regions |
Question 14 (2 marks)
Match each ability with the most appropriate characteristic.
| Adaptability | Autonomous operation | Communication ability | Environmental awareness | Goal-oriented behaviour | Learning capability | |
|---|---|---|---|---|---|---|
| The ability to improve performance using previous data or experiences | ||||||
| The ability to send and receive information from other systems | ||||||
| The ability to make decisions to achieve a specific objective | ||||||
| The ability to operate independently without constant human control | ||||||
| The ability to collect and respond to information from the environment | ||||||
| The ability to modify behaviour in response to changing conditions |
Question 15 (2 marks)
A large fitness centre is developing a new membership management system to improve the efficiency of member check-ins and class bookings. The team has developed a system flowchart to represent their new system.
Match each process with the most appropriate symbols on the above system flowchart.
| Cloud | Direct access storage | Online display | Online input | Paper document | Telecommunication link | |
|---|---|---|---|---|---|---|
| Members scan card | ||||||
| Member database | ||||||
| Booking information displayed on screen | ||||||
| Connection to online server | ||||||
| Online server | ||||||
| Printed receipts of class bookings |
Question 16 (2 marks)
A company introduces a new hybrid work policy and, after three months, asks employees to complete an online survey about their experience. The survey link is included in the company’s weekly office newsletter. At the end of the survey period, management reviews the responses and concludes that employees are highly satisfied with the new arrangement. When preparing a report, the manager gives greater emphasis to comments that support the decision to introduce hybrid work and regards a small number of critical responses as isolated opinions.
Identify TWO examples of bias present in the scenario.
Question 17 (2 marks)
Outline how the use of colour in a data visualisation can improve its effectiveness.
Question 18 (2 marks)
An enterprise is developing a machine learning model to automate customer support requests.
Describe how the model could be trained.
Question 19 (3 marks)
The following diagram illustrates how a manufacturing enterprise uses AI systems to monitor machinery and predict equipment failures before breakdowns occur.
Describe how the AI system improves enterprise operations in this scenario.
Question 20 (7 marks)
Refer to the following Retail Enterprise Performance Dashboard.
Explain how aggregation is used in the Retail Enterprise Performance Dashboard to help users identify overall patterns and trends in the data. (3 marks)
Analyse how filtering on the Retail Enterprise Performance Dashboard helps managers identify business insights and make informed decisions. (4 marks)
Question 21 (4 marks)
A retail store manager records the total sales for each day of the week. Data for the current week has already been entered.
Complete the spreadsheet by entering formulas to:
- Calculate the total sales for the week in cell B10
- Calculate the average sales per day in cell B11
- Display the day with the highest sales for the week in cell B12
- Display “Busy Day” in cells C2 to C8 if the sales on that day are above average
Question 22 (2 marks)
Explain how a Gantt chart can assist in managing an enterprise computing project.
Question 23 (4 marks)
Explain how testing and evaluation processes can be used to finalise and improve the effectiveness of a newly developed enterprise computing system.
In your answer, refer to:
- Evaluating test data
- Trialling operation and maintenance documentation
- Modifying the system to improve functionality
Question 24 (4 marks)
A smart city traffic management system collects live traffic data from sensors and displays congestion information on digital dashboards used by transport authorities.
Explain how the communication of real-time data improves decision-making in this enterprise system.
Question 25 (5 marks)
A farming enterprise is considering an intelligent irrigation system capable of automatically monitoring soil moisture and weather conditions. The system aims to optimise the operation of sprinklers to maximise crop yields.
Recommend and justify the design of a suitable intelligent irrigation system solution.
Question 26 (10 marks)
A regional medical centre is developing a new enterprise computing system to manage patient appointments and prescription requests.
- Patients can book appointments, request prescriptions and update personal details through an online portal.
- Reception staff confirm appointments and update doctor schedules.
- Doctors approve prescription requests.
The system stores information within appointment and prescription databases and communicates information back to patients.
For the new medical centre system, identify examples of:
- participants
- data
- other system components. (3 marks)
Recommend a suitable tool to inform and refine the requirements for the regional medical centre’s new system. (2 marks)
Construct a Level 1 data flow diagram (DFD) for the proposed patient appointments and prescription requests system. (5 marks)
Question 27 (13 marks)
Shopping Centre Parking System
A shopping centre uses a ticketless parking system that automatically recognises vehicle registration plates using cameras at the entry and exit gates. When a vehicle enters, its registration plate and entry time are recorded in the database. Customers receive the first 2 hours of parking free. After the free period, parking costs $5 per hour (or part thereof).
When a vehicle leaves, the exit camera records the registration plate and exit time. If the vehicle has parked for two hours or less, the gate opens automatically. Otherwise, payment must be made using Credit Card, Debit Card or Apple Pay at either an exit gate or a payment terminal located within the shopping centre. Once payment has been verified, the exit gate opens automatically.
The system stores information about parking sessions, payments and payment locations in a relational database to support parking management and reporting.
Some sample data is as follows.
ParkingSession
| SessionID | RegistrationPlate | EntryTime | ExitTime |
|---|---|---|---|
| 101 | YXE950 | 2026-07-12 12:45:00 | 2026-07-12 15:04:00 |
| 102 | SHA619 | 2026-07-12 12:45:00 | 2026-07-12 17:05:00 |
| 103 | WWX644 | 2026-07-12 14:30:00 | 2026-07-12 15:14:00 |
| 104 | YNR478 | 2026-07-12 15:00:00 | |
| 105 | YUT409 | 2026-07-12 15:30:00 | |
| 106 | GKF832 | 2026-07-12 16:20:00 | 2026-07-12 19:11:00 |
| 107 | SHA619 | 2026-07-12 16:20:00 | |
| 108 | LFO086 | 2026-07-12 17:20:00 |
PaymentLocation
| LocationID | Location |
|---|---|
| 1 | Exit Gate 1 |
| 2 | Exit Gate 2 |
| 3 | Supermarket Terminal |
| 4 | Escalator |
Payment
| PaymentID | SessionID | ReceiptNumber | PaymentTime | AmountPaid | PaymentMethod | LocationID |
|---|---|---|---|---|---|---|
| 67 | 98 | Z0TXIUTR | 2026-07-12 12:19:00 | $5 | Apple Pay | 3 |
| 68 | 99 | V65CBKGP | 2026-07-12 13:36:00 | $5 | Apple Pay | 2 |
| 69 | 100 | AH26FNB2 | 2026-07-12 14:46:00 | $5 | Credit Card | 4 |
| 70 | 101 | 688EVKRW | 2026-07-12 15:04:00 | $5 | Debit Card | 2 |
| 71 | 102 | NL8OUYWU | 2026-07-12 17:05:00 | $15 | Debit Card | 2 |
| 72 | 106 | V0UUSQCI | 2026-07-12 19:11:00 | $5 | Debit Card | 1 |
Construct a database schema (or entity relationship diagram) for the Shopping Centre Parking System relational database.
Show all entities, attributes, keys and relationships between entities. (5 marks)
Write an SQL statement to return the registration plate, number of times each vehicle has been in the carpark along with their total spend. The results should be sorted in descending order by total spend. (4 marks)
The shopping centre wishes to extend the system so that staff and customers can book a parking space in advance using an online form.
Analyse this new requirement, including how the system could ensure that a parking space is available at the time of each booking and what modifications would be required to the relational database. (4 marks)
Question 28 (3 marks)
A retail chain collects sales, inventory and customer data from all of its stores into a central data warehouse each night.
Explain how the data warehouse improves business intelligence for the retail chain.