| Subject Code : | ACCT6001 | Country : | Australia |
|---|
Assignment Task -
1 -Apply technical knowledge and skills in creating information for the workplace using spreadsheets and relational databases.
2 -Communicate with IT professionals, stakeholders, and user groups of information systems.
Eljay School
A large Australian School has recently opened an online education division called Eljay. The school provides online education services to students from around the world. In an effort to improve the services offered to students, a job management system was developed to improve the responses provided to student queries. At the end of every week, a manager from the administration team archives an excel file that contains data about student queries for that week. The manager of the administration team believes that the data within this spreadsheet would be valuable for business decision making. However, employees within the team lack the technical knowledge to analyze and interpret this data. Subsequently, the manager is unsure how to utilize this data to gain insights on how to improve response times and outcomes for students.
The administration team manager decided to hire you to assist in analyzing and interpreting the data. The table below shows a data file that was archived containing information on student queries for one week.
Team Reduction in “Hours charged” (%)
Charge per “Closed” job
Assessment 60% $1.20
IT 30% $2.20
Teaching 20%
While only a small number of queries were received from students in the first week of the month, student queries are expected to go up over the remainder of the month. However, before getting actual data from the job management system in the coming weeks, Eljay school has asked you to explore the possible analyses that can be performed if using the current output. Eljay provided you with a document listing specific instructions on what you are expected to do in Excel. The instructions are listed below.
Requirements
(1) Open an Excel Workbook and name it as ‘Student ID_ Student Name_ ACCT6001 Assessment 3’ (i.e. 0009989t_Adam Smith_ACCT6001 Assessment 3). Create a worksheet labelled as ‘Job Data’. Make a table similar to the one above using hypothetical details for 50 students. The table should include the following columns: Job Code, Student ID, Student Name, Date Opened, Date Closed, Job Type, Job Priority, Job Status.
In your hypothetical data, assume:
a) all student queries were made by students located in Australia,
b) at least 30 jobs that have a job status of “closed”
c) at least one of each Job Status is included in the data set for each Job Type. For example, include at least:
“open”, “in process”, “reprocess”, and “closed” entries for “IT”,
“open”, “in process”, “reprocess”, and “closed” entries for “Teaching”, and ? “open”, “in process”, “reprocess”, and “closed” entries for “Assessment” d)
All queries are made between 01/08/2020 and 28/08/2020.
e) Each student lodges a query in the job management system only once. So, each row of data contains information about a specific student.
(2) In the ‘Job Data’ worksheet, add a column labeled as ‘Time is taken to close a job. This column should show the time spent resolving each job (e.g. student query). The values for this column should be reported using the “number” format and calculated using a:
a) combination of the date opened and date closed columns.
b) formula that only includes entries with a “Job Type” equal to “Closed”.
(3) Create a new worksheet in your workbook and label it as ‘Job Duration’. In this worksheet:
a) Report the descriptive statistics (i.e. mean, median, maximum, minimum) for both the “Time taken to close job” column added to the ‘Job Data’ worksheet and the “Hours Charged” column. A brief commentary on the results should be provided (between 50 and 100 words).
b) Include another table in this worksheet showing for each week the:
- Total number of jobs,
- Total number of jobs “Closed”,
- Total number of “Important” jobs “Open”, and
- The average time is taken to close “Important” jobs.
This ACCT6001 - Accounting Assignment has been solved by our Accounting Experts at onlineassignmentbank. 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.
