MAA204 Accounting Information Systems and Data Analytics
Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: daixieit
MAA204 Accounting Information Systems and Data Analytics
Past Exam Paper
Final Assessment Task – Open-book Proctored Online Exam
PERCENTAGE OF FINAL GRADE: 50%
HURDLE DETAILS: Achieve at least 50% of the marks available on the examination.
Exam Instructions
• The final assessment in the unit is an OPEN BOOK Proctored online exam using Proctorio.
• Use of on-screen calculator is ALLOWED (available in the quiz)
• Microsoft Excel for calculations is ALLOWED.
• You must complete the exam individually.
• The exam consists of FIVE (5) questions. Each question may have multiple parts. You must complete all parts of all questions.
• The dataset to be used for Question 5 has been made available 24 hours in advance under the examination folder.
• This is a 2-hour exam. You will have 2 hours 30 minutes to complete and submit your exam. The extra 30 minutes is for reading time (15 minutes) and technical time (covers any minor technical issues you may experience during the exam process, 15 minutes).
• DO NOT click ‘Submit Quiz’ until you have completed all questions within this quiz or until the exam period is over.
• Before you submit the quiz, if time permits, you will have the opportunity to return to questions that you may have missed or have not yet answered.
• Do not expect to have time to look up resources during the quiz as this will slow you down and may prevent you from responding to all questions.
• Keeping some paper and pen handy is also advisable for doing some tasks to facilitate your thinking on the exam questions.
• If you experience any technical difficulties during the exam period related to recording, contact Proctoriovia webchat.
• If you have any technical difficulties accessing CloudDeakin/the exam, contact the Deakin IT Service Desk– please ensure you record your ticket number the IT Service Desk will provide as evidence of technical difficulties.
o Australia 1800 463 888
o International +61 3 5227 8888
• In the unlikely event that you cannot upload your completed exam paper, email it as an attachment to your unit chair [a.[email protected]] within the submission time.
• The breakdown of marks in this exam is:
Question |
Marks |
Question |
Marks |
1 |
10 |
4 |
10 |
2 |
10 |
5 |
12 |
3 |
8 |
|
|
Total Available Marks |
50 |
All candidates MUST complete this section:
Type your student ID number here:
QUESTION 1 [This Question Has 3 Parts: 5 + 3 + 2 = 10 Marks]
The data flow diagram (DFD) below contains several errors which violate the rules for the preparation of DFDs.
(1a) Referring to the data flow diagram (DFD) above, identify five (5) errors in the DFD above and briefly explain those errors.
Write Your Answer Here:
# |
Identify the error |
Explain the error |
1 |
|
|
2 |
|
|
3 |
|
|
4 |
|
|
5 |
|
|
[5 x 1 = 5 marks]
(1b) Identify and explain the three (3) main types of systems documentation techniques. In your answer, discuss the purpose of these techniques and whether they are complementary or competing.
Write Your Answer Here:
# |
Identify the documentation type |
Explain the documentation type |
1 |
|
|
2 |
|
|
3 |
|
|
[3 marks]
(1c) You are the payroll processing manager at a major retail company in Melbourne. In a conversation with Adam, who is the accountant of the company, you understand that Adam believes that data and information are practically the same as more information leads to “information overload” . Adam also believes that it is difficult to determine the value of information. Using an example, explain to Adam the difference between data and information, and how the value of information is determined.
Write Your Answer Here:
# |
The difference between data and info |
How value of information is determined |
|
|
|
[2 marks]
QUESTION 2 [This Question Has 3 Parts: 6 + 2 + 2 = 10 Marks]
Fraud headline: Bank employee charged with stealing $3.5 million after 'high value transfer' discovered
Major Fraud Squad detectives have charged a 37-year-old Perth bank employee with stealing $3.5 million. The Belmont bank recently identified a high-value transfer, and following an audit a number of discrepancies were identified, police said. It is alleged the money was stolen while the man was employed by the bank between June 2016 and February 2018. The Mount Lawley man has been charged with one count of stealing as a servant and was set to appear in the Perth Magistrates Court today. On investigation other information came to light:
The 37 year-old joined the bank in 2016 with an excellent resume in the banking and investment sector in the Northern Territory. He was always complaining about the high cost of living in Perth compared to the NT. He was well groomed, had an extravagant life style and had recently bought an expensive mansion in Mount Lawley.
Source: ABC news, 1st March 2018:https://ab.co/3KzLlXu
(2a) Referring to the above fraud case, and relying on the fraud triangle, explain why the fraud
was able to occur.
Write Your Answer Here:
# |
The fraud triangle |
Conditions leading to the fraud |
|
|
|
|
|
|
|
|
|
[6 marks]
(2b) Based on the above case, identify and explain the type of fraud the bank employee committed.
Write Your Answer Here:
# |
Identify fraud type |
Explain the fraud type |
|
|
|
[2 marks]
(2c) Describe four (4) controls that increase the difficulty of committing fraud.
Write Your Answer Here:
# |
Identify the control |
Description |
1 |
|
|
2 |
|
|
3 |
|
|
4 |
|
|
[2 marks]
QUESTION 3 [This Question Has Only Part a: 8 Marks]
The Metro Trains provides rides on diesel and steam trains throughout the state. It owns 32 engines, each with a unique serial number consisting of 6 digits. Printed below are data for trips on September 10. Each trip lasts a minimum of 1.5 hours.
Serial # |
Trip Date |
Engine Type |
Departure time |
Return time |
173954 |
09/10 |
D |
09:15 |
11:46 |
624974 |
09/01 |
S |
10:25 |
10:23 |
13o856 |
09/10 |
E |
12:30 |
16:42 |
442751 |
09/11 |
D |
13:45 |
17:43 |
820451 |
09/10 |
DD |
15:00 |
18:32 |
003876 |
09/10 |
S |
15:30 |
15:45 |
• Table notes: Valid train codes (engine type column): D = Diesel, S = Steam
The above table has five data fields: (1) Serial Number, (2) Trip Date, (3) Engine Type, (4) Departure Time and (5) Return Time. A data analyst at Metro Trains identified errors in five of the six records in the data-table above. The errors are as follows:
1. 2nd row – Wrong date is used (09/01 instead of 09/10); also, return time is earlier than departure time (and thus, the duration is less than at least 1.5 hours)
2. 3rd row – serial number has the letter o instead of a zero; engine type (E) is invalid.
3. 4th row – Wrong date is used (09/11 instead of 09/10).
4. 5th row – Engine Type (DD) is invalid.
5. 6th row – Duration of trip is less than 1.5 hours.
(3a) For each of the five (5) data fields, identify and explain one input edit control that could be
used to detect the input errors identified above.
Write Your Answer Here:
# |
Identify the input edit control |
Explanation |
1 |
|
|
2 |
|
|
3 |
|
|
4 |
|
|
5 |
|
|
[8 marks]
QUESTION 4 [This Question Has 3 Parts: 4+3+3 = 10 Marks]
Burwood Tech is a growing manufacturing company that has patented several technologies and products in recent years. The Company has developed a signifi
2023-02-10