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)
Place the following processes for developing an enterprise system in the correct order by dragging them into position.
- ≡ Testing and evaluating
- ≡ Researching and planning
- ≡ Identifying and defining
- ≡ Producing and implementing
Question 2 (1 mark)
What is the function of a pivot table?
Question 3 (1 mark)
Why is data integrity important when developing a data visualisation?
Question 4 (1 mark)
What is online analytical processing (OLAP) used for?
Question 5 (1 mark)
What is the function of fuzzy logic in an intelligent system?
Question 6 (1 mark)
Which of the following are examples of qualitative data?
(More than one may be selected.)
Question 7 (1 mark)
Which of the following are examples of using data to tell a story?
Question 8 (1 mark)
Which of the following should be considered when evaluating bias in data during the development of visualisations?
(More than one may be selected.)
Question 9 (1 mark)
Determine if each of the following features is related to a sensor or actuator.
| Sensor | Actuator | |
|---|---|---|
| Travels in a linear motion | ||
| Measures biometric data | ||
| Detects temperature variation | ||
| Uses compressed air to initiate an operation |
Question 10 (2 marks)
A data flow diagram modelling an online store is shown.
Classify the following components as external entity, process, data flow or data store.
| External entity | Process | Data flow | Data store | |
|---|---|---|---|---|
| Bank | ||||
| Confirmation | ||||
| Orders | ||||
| Payment |
Question 11 (2 marks)
The diagram shows a portion of the Gantt chart for a project.
Complete the following to show the progress of the ‘Testing the system’ task.
Question 12 (3 marks)
A business is implementing a ride-share service that allows customers to make a booking online using a mobile device. To make a booking, the customer provides pickup and destination addresses, and a preferred pickup time.
Data is stored in a database.
Part of the data dictionary for the ‘Booking’ table is shown.
Complete the entries for Data type, Field size and Key.
| Field name | Data type | Data format | Field size | Key | Description |
| BookingID | XXXNNN | Unique identifier for each booking | |||
| CustomerID | XXXNNN | ID of the customer in the Customer table | |||
| PickupLocation | Address of pickup location | ||||
| PickupTime | hh:mm | Preferred pickup time | |||
| Fare | ###.## | Fare amount for the ride | |||
| PaidFare | Y/N | Indicate if fair is paid |
Question 13 (2 marks)
A database has been designed for an online bookstore. The following diagram shows tables identified in the database.
Complete the following to describe the organisational structure of the database.
A particular PublisherID can appear in the Book table.
The Book_Author and Author tables have a relationship.
The Book and Publisher tables have a relationship.
Question 14 (2 marks)
Categorise each decision below as structured, semi-structured or unstructured, and give a reason for your choice of category.
| Category of decision | Reason | |
| Approving a car loan | ||
| Calculating the cost for carpeting a room |
Question 15 (3 marks)
A project team consists of employees who work remotely.
Explain how this may affect the development of the project.
Question 16 (4 marks)
A medical centre wants to develop a new patient information system.
Discuss the use of outsourcing for developing this system.
Question 17 (6 marks)
A mobile phone app allows users to resell or purchase tickets for events. Buyers can use the app's search function to find events and tickets.
Explain how blockchain technology can be used to verify whether a ticket is genuine. (3 marks)
Explain how intelligent agents could be used in this app. (3 marks)
Question 18 (4 marks)
A company wants to develop an intelligent system to help manage the process of hiring new employees. The system must be able to:
- analyse applicants' résumés
- assess applicants' suitability for various roles within the company
- access interviewers' and applicants' available days and times.
Discuss the social and ethical issues that need to be considered when developing this intelligent system.
Question 19 (4 marks)
A school wishes to replace its online learning system. It wants teachers to be able to give input to refine the requirements during the development of the new system.
Compare the suitability of using the agile and waterfall development approaches in this scenario.
Question 20 (8 marks)
A retail company wishes to expand its range of clothing and homewares. It has data on customer browsing history, purchasing patterns and product returns.
The company wants to create visualisations of the data to help it analyse customers' shopping habits and to make decisions on new products to offer.
Justify a software tool that could be used to develop the data visualisations. (2 marks)
Outline the steps that should be taken to create the data visualisations. (3 marks)
Describe the risks to the company of using data mining to decide which new products to offer. (3 marks)
Question 21 (7 marks)
A car rental company is introducing a loyalty program which will allow members to access discounts and special offers.
To qualify for the loyalty program, a driver must have:
- an unrestricted licence
- been a customer for more than 10 years
- rented a car since 1 January 2022.
An extract of the information stored in the company's database tables is shown.
Customers
Rentals
The company has selected a small group of customers to trial the program before implementing it for all customers who qualify.
Which implementation method is being used? (1 mark)
Draw a decision tree showing the rules used to determine if a customer is eligible for the loyalty program. (3 marks)
Construct an SQL statement to identify the customers who qualify for the loyalty program. List the names of the customers ascending in alphabetical order by last name, the years of membership and the last time they rented a car. (3 marks)
Question 22 (6 marks)
A bank requires a new system to analyse its customers' banking history in order to recommend financial products to them. The system will automatically recommend products to a customer when they log into the bank's website. Customers will be able to use the autofill feature on their web browser to complete acceptance forms if they are interested in the products.
How does the autofill feature affect the privacy of customers? (3 marks)
Explain the benefits of using a neural network rather than an expert system for this new system. (3 marks)
Question 23 (6 marks)
A company wishes to improve its processes. It wants to use an intelligent system to explore ways that this may be achieved. It also wants to survey its customers for ideas.
For the survey, customers will submit their responses using an online form. The data will be saved to local hard drive storage as well as to a cloud-based backup. An email will be sent to each customer to thank them. At the end of the survey, a report will be printed.
Describe how the application of simulations may be useful for the company to improve its processes. (3 marks)
Draw a system flowchart to represent the process to be used to survey customers. (3 marks)
Question 24 (4 marks)
The spreadsheet shows the January inventory for a technology shop.
Formulas are needed for:
- cells D3 to D7 to calculate the product value for each product. Product Value is calculated by multiplying Price Per Unit by Quantity in Stock. If a product has no stock, Product Value will display ‘Out of Stock’.
- cell E3, to determine the Price Category (Low, Mid or High). This formula will be used to fill down to cells E4 to E7.
Construct formulas for cells D3 to D7, and E3.
Scroll down or click ‘Full screen’ to view the full spreadsheet.
Question 25 (8 marks)
An ice-cream company has stores across all states in Australia. Over the past five years, the company has collected sales data on the flavour of ice-cream purchased and the cost of each order for each store.
An interactive dashboard has been created to assist management in analysing sales information and trends.
Watch the following video demonstrating the interactive dashboard.
Assess the effectiveness of the interactive dashboard, considering user experience (UX) and the dashboard's ability to assist management to track trends and forecast sales.