Reference no: EM133710082
Information Systems in Accounting
Assessment: Portfolio Activities
Assessment Type: Individual Excel Worksheets and Report
Case - COMPLETE CAR CARE
Your Task
You are required to assist the proprietors of a small business by preparing appropriate reports that will support the evaluation of data.
Assessment Description
This assessment requires an Excel data file (provided) and case study background (provided). All requirements are to be completed by adding to and adapting the Excel data file.
Assessment Instructions
You are required to access supplied data sets (provided in a single Excel file) and complete the assigned tasks by adding additional worksheets to the workbook.
Detailed instructions:
PHASE 1
Prepare appropriate reports that will support the evaluation of data in Phase 1.
There are many reports that may be produced from the data provided. You are to select reports that will help address the proprietor's concerns.
This is to be completed in Excel.
For one of your reports, outline the steps taken to select, prepare and format the report. This should be presented in dot point format.
Prepare a brief written summary of your evaluation of the data in Phase 1. Each of the reports that you have prepared should be used as the basis for an expanded summary note including:
A statement explaining the information in your report (i.e., numerical)
Why the information is important to the business
A description and explanation of a suggested improvement to the data collected (may relate to inputs, processes, or outputs)
Parts b & c are to be completed in Word or PDF.
Note - these sections must contain your own original text, Images will not be accepted
PHASE 2
Prepare appropriate reports that will support the evaluation of data in Phase 2.
With additional data provided, you are to select reports that will help address the proprietor's concerns.
This is to be completed in Excel.
For one of your reports (that is different from reports produced for Phase 1), outline the steps taken to select, prepare and format the report. This should be brief and presented in dot point format.
Prepare a brief written summary of your evaluation of the data in Phase 2.
Each of the reports that you have prepared should be used as the basis for an expanded summary note including:
A statement explaining the information in your report (i.e., numerical)
Why the information is important to the business
A description and explanation of a suggested improvement to the data collected (may relate to inputs, processes, or outputs)
Attachment:- Case_Study_Background.rar