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