General Instructions
Reading time
There is no reading time given for viewing this past exam. You will be given 10 minutes reading time in the sample and real exams. During reading time in the sample and real exams you will not be able to answer questions, and exiting the exam at this stage is not possible. You can move freely between the questions, and you can flag questions. Highlighting of text is also permitted.
Working time
There is no time limit to viewing this past exam. You will be given 2 hours 20 minutes to attempt the questions in the sample and real exams.
Permitted equipment
You must use headphones while viewing video content or listening to audio.
Pen and paper are permitted for planning. The supervisor will provide you with paper.
The number of words that is provided for each short-answer item gives an indication of the length of response.
Total marks: 80
There are 25 questions.
Some questions have multiple parts.
Objective-response items total 19 marks.
Short-answer items total 61 marks.
Question 1 (1 mark)
What is the primary purpose of data visualisation in enterprise systems?
Question 2 (1 mark)
Which of the following actions is most likely to introduce bias into a data visualisation?
Question 3 (1 mark)
Which of the following is an example of ordinal data?
Question 4 (1 mark)
A company wants to collect data on customer purchases.
Which method is an example of passive data collection?
Question 5 (1 mark)
Which of the following contributes to maintaining data integrity in data visualisations?
Question 6 (1 mark)
A global company is implementing a new enterprise computing system that will manage employee and customer data.
Which of the following is a potential ethical issue the company should consider when implementing this system?
Question 7 (1 mark)
An app needs to be tested by a large group of external testers prior to full release.
Which type of testing is this?
Question 8 (1 mark)
How could expert systems contribute to the efficiency of intelligent systems in autonomous vehicles?
Question 9 (1 mark)
Which of the following correctly describes the relationship between business analytic systems and expert systems?
Question 10 (1 mark)
Select the most appropriate tool for each situation.
| Situation | Survey | Interview |
|---|---|---|
| A user experience designer wants to collect anonymous responses. | ||
| A researcher wants to collect opinions on a proposed new policy from 400 people using a set of standardised questions. | ||
| A project manager wants to have a one-on-one discussion with each team member to explore their insights and experiences related to a recent project. |
Question 11 (2 marks)
Which of the following is TRUE about forward chaining?
Select all that apply.
Question 12 (2 marks)
This system flowchart describes the subject selection for a school.
.png)
Select each statement that is TRUE about this system flowchart.
Select all that apply.
Question 13 (3 marks)
A grocery store uses a stock management system. Stock details are kept in the Products table.
Complete the data dictionary for the Products table, with the appropriate type and format for each field.
| Field name | Data type | Data format | Field size | Description | Example |
| ProductID | 6 | Unique field of letters and digits | ABC123 | ||
| Name | 25 | Name of product | Bitez Sweets | ||
| UnitPrice | $##.## | 6 | Single unit price | $11.98 | |
| StockQuantity | 3 | Quantity of product in stock | 121 | ||
| StockedItem | 1 | Item is sold in store (Y or N) | Y |
Question 14 (3 marks)
A company wants to analyse memes on social media to assess the effectiveness of its advertising campaign.
Describe how memes can be analysed to provide insights into the effectiveness of the advertising campaign.
Question 15 (6 marks)
The following are three tables from an IT company‘s relational sales database.
Customers
.png)
Products
.png)
Sales
.png)
Use the dropdown lists provided to identify the correct key types, and the relationship types between tables. (2 marks)
PK = Primary key
FK = Foreign key
| Customers | Sales | Products | |||||||
| CustID |
|
SaleID |
|
ProdID | |||||
| FirstN | CustID | ProdN | |||||||
| LastN | ProdID | Category | |||||||
| SaleDate | Price | ||||||||
| Phone | Quantity | Quantity | |||||||
| TotalCost | |||||||||
Write an SQL query to display all sales from the electronics category prior to 17-01-2025 in ascending date order, including LastN, ProdN, SaleDate and TotalCost. (4 marks)
Question 16 (8 marks)
A TV manufacturer wants to improve the efficiency and reliability of its manufacturing system. It plans to incorporate an intelligent system into its manufacturing process to collect live data for analysis. Hardware devices will be installed to collect data on the system’s operations. The data is then sent to a server for processing.
The manufacturing processes include attaching the LCD panel to the motherboard and testing the brightness of the screen. The current system is controlled through manual processes and monitoring.
Describe the hardware that is needed for the intelligent system. Include examples of specific types of sensors in your answer. (4 marks)
Explain the potential benefits of introducing an expert system into the manufacturing process. Support your answer with reference to Industry 4.0. (4 marks)
Question 17 (6 marks)
A coffee shop chain has branches in all major cities in Australia. It collects a large volume of sales data as well as geographic and demographic data from each of its coffee shop branches.
The chain plans to use a cloud-based data warehouse for storage and for future analysis.
Explain how the use of data warehousing could benefit this coffee shop chain. (3 marks)
Explain how the advancement of hardware can affect the processing of data from the data warehouse for this coffee shop chain. (3 marks)
Question 18 (4 marks)
A small car rental business, with five vehicles, wants to use a spreadsheet to keep track of its bookings.
A staff member will enter the driver’s name, vehicle size selected (small, medium, large), and the number of days of rental for each vehicle.
The spreadsheet should automatically provide the following information:
- daily rate – small ($200), medium ($250), large ($300)
- discount – a discount of 20% is allowed if the booking is for at least 7 days
- rental cost – calculated by multiplying the daily rate and the number of days, and allowing for a discount if applicable.
Part of the spreadsheet has been set up. Complete the spreadsheet so that the required information will automatically be displayed when rentals are entered.
Question 19 (3 marks)
An education business intends to provide a subscription service to teachers and students for online resources. To register, the subscriber needs to provide their name, email address and date of birth, and indicate whether they are a teacher or student.
Design a user interface for registering an account. Clearly label all features.
Question 20 (3 marks)
A marine biologist uses a spreadsheet to analyse past data such as water temperature, pollution levels and availability of food to predict fish population trends.
Describe spreadsheet features that can assist the marine biologist to better understand the datasets visually.
Question 21 (5 marks)
An online booking system allows customers to purchase tickets to a concert. Once a customer specifies the number of tickets required, the system displays the seats available and allows the customer to make seat selections.
The selected seats are held for five minutes for the customer to proceed to payment. The system displays the total cost and allows the customer to pay using their credit card.
After payment is confirmed by the bank, a digital ticket is generated and sent to the customer. The seat booking database is also updated.
Construct a data flow diagram (DFD) to represent this system.
Question 22 (5 marks)
An insurance company hires a project team to develop a system that manages the personal information of customers and employees, customer claims and business contracts. The data will be stored and accessed on a cloud-based server and backed up locally.
Outline a tool that can be used by the project team to manage the project. (2 marks)
Justify TWO methods that the company can use to maintain the security of the data. (3 marks)
Question 23 (7 marks)
As a result of advancements in technology, a company now presents employee performance information on a dashboard that is updated using real-time data, rather than spreadsheets. The data dashboard is shown.
.png)
Describe how advancements in software have empowered data analytics. In your answer, refer to the scenario. (3 marks)
Explain how the visualisations used in the data dashboard provided could affect the management team’s user experience and understanding of employee productivity. (4 marks)
Question 24 (5 marks)
A food company is considering the use of freelance work and offshore development to support its packaging design.
Explain the advantages and disadvantages to the company in using freelance work and offshore development for packaging design.
Question 25 (8 marks)
View the slideshow about applications of decision support systems.
Navigate the slideshow by clicking the forward and back arrows, or clicking on the individual dots to view specific slides.
Explain how intelligent systems can assist the different categories of decision-making. Support your answer with some examples from the stimulus.