Assignment 2 Questions ACC539 2014 60 UPDATED
(Note: the total marks of 35 will be adjusted to a final result of 15 marks)
Q 1:
Cloud based Accounting (“Saasu”) – practical task (15 marks)
Details of tasks and input data are provided in Resources in Interact.
Q 2:
Systems Planning & Implementation (10 marks) (word limit guide – 300 words)
The Queensland Health Payroll System project (2007 2011) has received adverse media attention relating to significant issues and failures during the project. Undertake some research and of this information systems project to undertake the following task:
Using the Systems Development Lifecycle process (figure 19.1 on page 612 of the Romney text) as a guide, identify 5 deficiencies in the Queensland Health Payroll System project, and provide recommendations on how these deficiencies may be overcome in future projects. Structure your answer using headings and subheadings to address each of the issues and recommendations that you identify. Ensure you provide referencing where appropriate.
Q 3:
Rickard’s Rural – Prepare a Dashboard / Pivot Tables (5 marks)
Q 4:
Rickard’s Rural – Prepare a 3D Bar Chart (5 marks)
Dashboards for Rickard’s Rural, an agricultural supply chain in the Central West of New South Wales
Using the data in the Agricultural Sales spreadsheet provided in the Resources section prepare the following Pivot Tables and Pivot Charts. Each Pivot Chart and its related pivot table should be on a worksheet together. Each worksheet tab should be labelled identifying the contents of the worksheet. The initial data should be labelled Data.
- The sales in total for each product type for the quarter by each type of customer. Use a pie chart to show the percentage of each product type that is sold by cash for the quarter. Copy the results into a word document. Briefly state your findings from looking at the dashboard. (5 Marks)
- The sales by cash and account for each month for each product type. Use a 3D bar chart to show the sales by cash for each month for each product type and the sales by account for each month for each product type. Copy the results into a word document. Briefly state your findings from looking at the dashboard. (5 Marks)
When submitting this part of the assignment, submit both the word file and the spreadsheet file.
| Task specific outcome | HD | D | CR | P |
| Q1. Accurate entry of data using a tool to do accounting practices using correct accounting classifications | · Accurate entry · Correct accounting classifications ·Appropriate coding applied to new accounts |
·Accurate entry ·Mostly correct accounting classifications ·Appropriate coding applied to new accounts |
·Accurate entry ·Several incorrect accounting classifications ·Appropriate coding not applied to all new accounts |
·Inaccurate entry ·Incorrectaccounting classifications ·Appropriate coding not applied to all new accounts |
| Q2. Use the SDLC to identify deficiencies in a system project and provide appropriate recommendations | · 5 relevant deficiencies are identified and thoroughly discussed · 5 appropriate recommendations are provided to overcome the identified deficiencies · Correct use of APA referencing |
· 5 relevant deficiencies are identified and discussed · 5 appropriate recommendations are provided to overcome the identified deficiencies · Correct use of APA referencing |
· 5 deficiencies are identified · 5 recommendations are provided · Mostly correct use of APA referencing |
· less than 5 relevant deficiencies are identified · less than 5 recommendations are provided ·APA referencing not applied correctly |
| Task specific outcome | HD | D | CR | P | F |
| Q 3 In your submission you: | In your submission you: | In your submission you: | In your submission you: | In your submission you: | |
| Effectively use Pivot Tables and Pivot Chart to prepare a dashboard for a business Weighting50% |
Provide a Dashboard which clearly, effectively and logically displays the information required: Columns and Rows are clearly labelled and differentiated with excellent table design. Pie chart segments clearly differentiated by colour with percentages included in segments Logical, clear and well expressed statement of findings from the dashboard |
Provide a Dashboard which logically displays the information required: a. Columns and Rows are clearly labelled and differentiated. b. Pie chart segments clearly differentiated. c. Logical and clear statement of findings from the dashboard. |
Provide a Dashboard which displays the information: a. Columns and Rows are clearly labelled b. Pie chart segments clearly differentiated c. Some attempt at statement of findings from the dashboard. |
Make little attempt to provide a coherent Dashboard | |
| Use Pivot Tables and Pivot Charts to extract information from corporate data Weighting 50% |
Accurately included the data in the Pivot Table Totalled columns and rows Accurately included data in the Pivot Chart |
Had some difficulty in including all data in the Pivot Table Provided a Pivot Chart but not with the data required |
Had difficulty in including data in the Pivot Table Provided a Pivot Chart but not with the data required |
Make little attempt to provide a Pivot Chart and Table from the data provided | |
| Q 4.In your submission you: | In your submission you: | In your submission you: | In your submission you: | In your submission you: | |
| Effectively use Pivot Tables and Pivot Chart to prepare a dashboard for a business | Provide a Dashboard which clearly, effectively and logically displays the information required: Columns and Rows are clearly labelled and differentiated with excellent table design. Bar chart columns clearly differentiated by colour and labelled in a legend. Logical, clear and well expressed statement of findings from the dashboard |
Provide a Dashboard which logically displays the information required: a. Columns and Rows are clearly labelled and differentiated. b. Bar chart columns clearly differentiated. c. Logical and clear statement of findings from the dashboard. |
Provide a Dashboard which displays the information: a. Columns and Rows are clearly labelled b. Bar chart columns clearly differentiated c. Some attempt at statement of findings from the dashboard. |
Make little attempt to provide a coherent Dashboard | |
| Use Pivot Tables and Pivot Charts to extract information from corporate data | Accurately included the data in the Pivot Table Totalled columns and rows Accurately included data in the Pivot Chart |
Had some difficulty in including all data in the Pivot Table Provided a Pivot Chart but not with the data required |
Had difficulty in including data in the Pivot Table Provided a Pivot Chart but not with the data required |
Make little attempt to provide a Pivot Chart and Table from the data provided | |
ACC539 Assign….doc
ACC539 Saasu ….ppt
Rickards Rura….xlsx