代做ACW2420 Accounting Information Systems帮做R程序

Assignment Sheet

Unit Name	Accounting Information Systems
Unit Code	ACW2420
Assignment Name	Financial Modelling / Excel Assignment
Assignment Number/Reference	FinModel-Sem2-2024

Learning Outcomes

This assignment assesses the following learning outcomes:

Learning  Outcome Number	Learning Outcome Description
2	Explain the design of accounting information systems and financial models.
3	Develop financial models to assist in decision making.
4	Apply critical thinking, problem-solving and presentation skills to individual and/or group activities dealing with accounting information systems.

Weighting

This assignment is worth [15%] of your overall grade for this unit. Please see the assignment marking guide for the weightings of each assessment criterion.

Case study information

This assignment has a total of 15 marks and is an individual assessment.

Assignment Instructions

Download the required files from Moodle. Using the excel spreadsheet, Pivot Tables and Pivot Charts, answer the following questions.

Questions

1. How long does it take to sell a property? Does the location, property type, and garden size make a difference in the duration? Justify your answer by showing this using pivot tables. [4 marks]

2. Using pivot tables and pivot charts, provide insights into the types of properties (both sold and unsold) by Company XYZ. In your pivot table, group the table by urban vs. rural properties, number of rooms, and garden size. [4 marks]

3. In the Word document, please explain, using no more than 500 words, any other insights you could gain from the Pivot Table and Pivot Chart. [7 marks]

Additional instructions

● You can assign labels to your pivot tables and charts (e.g., Table 1.1, Table 1.2, Figure 1.1) in a new Excel file. These labelled tables and charts can then be referenced in your Word document. You can keep the pivot tables and charts in the new Excel file.

● To obtain the answer to the questions listed, you can include extra columns in your data file.