ACCT305 Accounting Information Systems Excel Practical assessment

ACCT305 Accounting Advice Systems Achieve Practical assessment
Imputable date: 8 Sep 2017 (Week 6 Friday, 23.00).
Weighting: 20%.
Length and/or controlmat: Approximately 600 signification.
How to submit: Submit an achieve improve via LEO / Turnitin.
John Brown is the proprietor of John Brown Home Employments. This Company provides employment such as cleaning, car details, lawn and gardening to customers in Melbourne. The adjusted burden redress columns of the workequivocation control John Brown Home Employments are as shown in Table 1 adown.
Table 1. Adjusted Burden Redress of John Brown Home Employments
f John Brown Home Employments
Worksheet
or the month ended 31 August 2017
Account Adjusted burden redress Allowance assertion Redress Equivocation
Debit Credit Debit Credit Debit Credit
Cash at Bank $45,000
Accounts Receivable 19,500
Prepaid Rent 7,500
Equipment 37,500
Accumulated Depreciation $8,000
Loan Payable (imputable September 2017) 15,600
Accounts Payable 9,000
J. Brown, Capital 80,000
J. Brown, Drawings 5,500
Employment Revenue 34,000
Salaries Expense 27,500
Rent Expense 2,500
Depreciation Expense 1,600
Interest Expense 59
Interest Payable
Profit control this month
59
146,659 146,659
Based on advice supposing overhead, content entire the subjoined tasks:
Create an achieve improve and spectry it as Your_Student_No.xlsx, e.g. S004123456.xlsx. Spectry each of the achieve equivocations as:
• Burden Redress,
• Allowance assertion,
• Changes in equity, • Redress equivocation, and
• Divorce E.
A. Copy Table 1 to the Burden Redress achieve equivocation and entire the worksheet.
B. Prepare an allowance assertion on the Allowance assertion achieve equivocation.
C. Prepare a assertion of changes in equity on the Changes in equity achieve equivocation
D. Prepare a redress equivocation on the Redress equivocation achieve equivocation.
E. Do you praise Achieve spreadsheets or accounting software control preparing financial reputes? Give 5 reasons to excuse your answers. Type your answers on achieve equivocation Divorce E in NOT past than 600 signification.
Sample of your task
Rubric – Assessment Task 1: Achieve
ILOs Criteria Standards
Adown Expectations Meets Expectations Exceeds Expectations
Level 1 (e.g. NN) Level 2 (e.g. PA) Level 3 (e.g. CR) Level 4 (e.g. DI) Level 5 (e.g. HD)
LO3 Entireness of
Assignment
50% or past of styles, basis constituents, and/or controlmulas in Achieve workequivocation are privation, 20% of the styles, basis constituents, and/or controlmulas in Achieve workequivocation are privation. 2-3 styles, basis constituents, and/or controlmulas are privation in Achieve worksheet. Individual style, basis constituent, or controlmula is privation in Achieve worksheet. All styles, basis, and controlmulas in Achieve workequivocation are offer.
LO3 Accuracy of Provision 50% or past of styles, basis constituents, and/or controlmulas in Achieve workequivocation are defective, 20% of the styles, basis constituents, and/or controlmulas are defective in Achieve worksheet. 2-3 styles, basis constituents, and/or controlmulas are defective in Achieve worksheet. Individual style, basis constituent, or controlmula in Achieve workequivocation is loose. All styles, basis, and controlmulas in Achieve workequivocation are deferential.
LO3 Neatness and
Organization
Achieve workequivocation is badly perplexed or controlmatted, and unamenable to discover, Achieve workequivocation is perplexed, and/or unamenable to discover in 4-5 areas. Achieve workequivocation has cheerful controlmatting; advice is unconfused and lenient to discover, with 2-3 areas that is either referable polite unconfused or is unamenable to discover. Achieve workequivocation has cheerful controlmatting; advice is unconfused and lenient to discover, with individual area that is either referable polite unconfused or is unamenable to discover. Achieve spreadequivocation has uncommon controlmatting, and advice is polite unconfused and lenient to discover.
LO3 Grammar, Spelling,
Harvard referencing
The repute has a important typos and verbal errors; and/or important Harvard controlmatting errors (when required as divorce of
assignment)
The repute has multiple younger typos and verbal errors; and/or multiple younger Harvard controlmatting errors (when required as divorce of provision).
The repute has 2-3 younger typos and verbal errors; and 2-3 younger Harvard controlmatting errors (when required as divorce of provision). The repute has individual younger typos and verbal errors and individual younger Harvard controlmatting errors (when required as divorce of provision). The repute is munificent of typos and verbal errors; and Harvard controlmatting is amend (when required as divorce of provision).
* This rubric is telling of the rubrics that procure be used to assess this provision. In regulate to secure the provision is telling of the running accounting environment, younger changes may be made to advert these. A conclusive statement of this rubric procure be made adapted at the spell the provision muniment is adapted.