working as an internal auditor | My Assignment Tutor

THE UNIVERSITY OF SUSSEX [BSC] EXAMINATION 2020/21 N1550 Accounting Information Systems Assessment Period: May 2021 (A2) [Section A: All students must answer this question (Total 40 Marks)] [Section B: Students must choose 2 out of 3 questions (Total 60 Marks)] Maximum word count is 4,000 words in total SECTION A (Total 40 Marks) QUESTION 1. You have recently started working as an internal auditor for a company that sells dairy products. You decide to focus on the procure-to-pay process, and you have asked the IT department for an extract of transaction data covering purchase orders, goods received documents and invoices. The IT department has put this dataset on Github, and it is accessible through a link that has this format: Replace XX in student-XX with the last TWO digits of your candidate number. For example, if your candidate number ends with 51, download the following file: You decide to use Python to verify if the three-way match internal control has been properly implemented in the company. Explain the principle of the three-way match control in your own words. Include the ways in which the control may fail and the possible reasons. [5 Marks] Carry out a three-way-match using Python on the dataset. Make a full screenshot of your program. You are required to put your candidate number in the screenshot. [15 Marks] Your dataset contains at least one unusual transaction that fails the three-way match. Identify the transaction using Python and write a brief commentary on what you have found. (If there are several transactions, select just the first). [10 Marks] Discuss at least two other internal controls that you could apply to this dataset. (You do not have to code these in Python). Explain the control, the way it may fail and possible reasons. [10 Marks] SECTION B (Total 60 Marks) QUESTION 2. Databases You have started working at a local radio station and have been provided with the following data model. The model is designed to help with accounting for royalties when artists have their songs played on the radio. Normalise the model to remove the many-to-many relationships. Provide a brief commentary on the decisions you took during normalisation. [10 Marks] Implement the normalised model in Excel. Identify a few relevant property names for each concept in the model and add a few imaginary rows of data. Add screenshots of your work to the TAP. Include your candidate number in the screenshots without further identifying yourself. [10 Marks] Critically discuss the use of spreadsheet software such as Excel for the purposes of holding a database such as the one you have just created. [10 Marks] QUESTION 3. Ethics and AI The following news item has appeared in the press. “LAST FALL, UNIVERSITY of Virginia computer science professor Vicente Ordóñez noticed a pattern in some of the guesses made by image-recognition software he was building. “It would see a picture of a kitchen and more often than not associate it with women, not men,” he says. That got Ordóñez wondering whether he and other researchers were unconsciously injecting biases into their software. So he teamed up with colleagues to test two large collections of labeled photos used to “train” image-recognition software. Their results are illuminating. Two prominent research-image collections—including one supported by Microsoft and Facebook—display a predictable gender bias in their depiction of activities such as cooking and sports. Images of shopping and washing are linked to women, for example, while coaching and shooting are tied to men”. The above news item gives an example of supervised AI. Explain this concept in your own words, using the algorithm above as an example. [10 Marks] b. Explain how the gender bias occurs in the model, and how this bias can be detected. [10 Marks] Critically discuss how you would address, and potentially resolve, any potential biases in an AI algorithm. [10 Marks] QUESTION 4. Enterprise Systems Your manager is keen for income to appear on the income statement and has asked you (their accountant) to clarify the order-to-cash process, and at which step of this process the income is booked. Explain the order-to-cash process, emphasising the book-keeping processes that that take place at each step. Pinpoint at which step income is typically accounted for. [10 Points] Discuss the main characteristics of enterprise resource planning systems and explain how they are different from customer relationship management (CRM) systems. [10 Points] In Section A we looked at the procure-to-pay process and the three-way match control. Describe a similar control for the order-to-cash process, explain how it may fail and possible reasons. [10 Points] END OF PAPER


Leave a Reply

Your email address will not be published. Required fields are marked *