ACCT6001: Accounting Information Systems - Mark Richardson - Technical Knowledge and Skills - Accounting Assignment Help

Assignment Task:

Learning Outcomes 
(a) Apply technical knowledge and skills in creating information for the workplace using spreadsheets and relational databases
(b) Communicate with IT professionals, stakeholders and user groups of information systems.

Context:
A spreadsheet is a powerful tool that has become entrenched in business processes worldwide. Working knowledge of Excel is a crucial skill for accountants. This assignment aims to assess the student’s ability to create spreadsheets. Students will be using raw data and summarising them in a user-friendly format to aid decision making. Students will need to recommend additional excel-based analysis that facilitates business decision making.

The Flying Store

Mark Richardson has recently opened an online store named The Flying Store. He sells a very popular model of drone called the ‘Rocket Drone’. In an effort to widen his market, Mark has built a small website hosted by a web service provider. At the end of every week, the web service provider sends a data file to Mark that contains data about visitor traffic at his website. Mark would like to utilise this data to get insights on visitor usage of his website and he believes that the data would be valuable for business decision making. However, Mark lacks the technical knowledge to analyse and interpret this data and he is unsure how the results from the analyses can be used for making business decisions.

Requirements
(1) Open an Excel Workbook and name it as ‘Flying Store Analysis_your student ID’ (i.e. Flying Store_00568578T’). Create a worksheet labelled as ‘Visitor Data’. Make a table similar to the one above using hypothetical details for 50 visitors. In your hypothetical data, assume: 
(a) all visitors accessed Mark’s website from Australia, 
(b) at least 3 visitors accessed from each Australian states and territories (i.e. New South Wales, Queensland, South Australia, Victoria, Western Australia, Australian Capital Territory, Northern Territory), 
(c) All visits are made between 01/02/2020 and 28/02/2020. 
(d) Each visitor visits the website only once. So each row of data contains information about a specific visitor.
The table should include the following columns: Operating system, Browser, Site connection, Add to favourites, Date, Entry Time, Exist Time, Number of pages viewed,
City, States.
(2) In the ‘Visitor Data’ worksheet, add a column labelled as ‘Time Spent On Website’. This column should show the time that each visitor spends on Mark’s website. The
values for this column should be calculated by using the values of Entry Time and Exit Time columns. The values should be reported in the h:mm:ss format.
(3) Create a new worksheet in your workbook and label it as ‘Visit Duration’. Report the descriptive statistics (i.e. mean, median, maximum, minimum) for Time Spent On
Website and the Number of Pages Viewed using appropriate excel functions. The descriptive statistics should be linked to the ‘Visitor Data’ worksheet.

This ACCT6001: Accounting Assignment has been solved by our Accounting Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.