ACCT305 Accounting Information Systems Excel Practical assessment

ACCT305 Accounting Referableification Systems Achieve Practical assessment
Imputable date: 8 Sep 2017 (Week 6 Friday, 23.00).
Weighting: 20%.
Length and/or restraintmat: Approximately 600 opinion.
How to submit: Submit an achieve refine via LEO / Turnitin.
John Brown is the proprietor of John Brown Home Uses. This Company provides use such as cleaning, car details, lawn and gardening to customers in Melbourne. The adjusted attempt pit columns of the workquibble restraint John Brown Home Uses are as shown in Table 1 under.
Table 1. Adjusted Attempt Pit of John Brown Home Uses
f John Brown Home Uses
Worksheet
or the month ended 31 August 2017
Account Adjusted attempt pit Allowance proposition Pit Quibble
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
Use Revenue 34,000
Salaries Expense 27,500
Rent Expense 2,500
Depreciation Expense 1,600
Interest Expense 59
Interest Payable
Profit restraint this month
59
146,659 146,659
Based on referableification supposing overhead, delight consummate the subjoined tasks:
Create an achieve refine and indicate it as Your_Student_No.xlsx, e.g. S004123456.xlsx. Indicate each of the achieve quibbles as:
• Attempt Pit,
• Allowance proposition,
• Changes in equity, • Pit quibble, and
• Divorce E.
A. Copy Table 1 to the Attempt Pit achieve quibble and consummate the worksheet.
B. Prepare an allowance proposition on the Allowance proposition achieve quibble.
C. Prepare a proposition of changes in equity on the Changes in equity achieve quibble
D. Prepare a pit quibble on the Pit quibble achieve quibble.
E. Do you applaud Achieve spreadsheets or accounting software restraint preparing financial noises? Give 5 reasons to defend your answers. Type your answers on achieve quibble Divorce E in NOT past than 600 opinion.
Sample of your task
Rubric – Assessment Task 1: Achieve
ILOs Criteria Standards
Under 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 Consummateness of
Assignment
50% or past of denominations, postulates elements, and/or restraintmulas in Achieve workquibble are dropping, 20% of the denominations, postulates elements, and/or restraintmulas in Achieve workquibble are dropping. 2-3 denominations, postulates elements, and/or restraintmulas are dropping in Achieve worksheet. Individual denomination, postulates element, or restraintmula is dropping in Achieve worksheet. All denominations, postulates, and restraintmulas in Achieve workquibble are confer-upon.
LO3 Accuracy of Provision 50% or past of denominations, postulates elements, and/or restraintmulas in Achieve workquibble are faulty, 20% of the denominations, postulates elements, and/or restraintmulas are faulty in Achieve worksheet. 2-3 denominations, postulates elements, and/or restraintmulas are faulty in Achieve worksheet. Individual denomination, postulates element, or restraintmula in Achieve workquibble is faulty. All denominations, postulates, and restraintmulas in Achieve workquibble are respectful.
LO3 Neatness and
Organization
Achieve workquibble is badly chaotic or restraintmatted, and obscure to learn, Achieve workquibble is chaotic, and/or obscure to learn in 4-5 areas. Achieve workquibble has amiable-natured-natured restraintmatting; referableification is arranged and indulgent to learn, with 2-3 areas that is either referable well-mannered-behaved-behaved-behaved arranged or is obscure to learn. Achieve workquibble has amiable-natured-natured restraintmatting; referableification is arranged and indulgent to learn, with individual area that is either referable well-mannered-behaved-behaved-behaved arranged or is obscure to learn. Achieve spreadquibble has rare restraintmatting, and referableification is well-mannered-behaved-behaved-behaved arranged and indulgent to learn.
LO3 Grammar, Spelling,
Harvard referencing
The noise has a senior typos and actual errors; and/or senior Harvard restraintmatting errors (when required as divorce of
assignment)
The noise has multiple inferior typos and actual errors; and/or multiple inferior Harvard restraintmatting errors (when required as divorce of provision).
The noise has 2-3 inferior typos and actual errors; and 2-3 inferior Harvard restraintmatting errors (when required as divorce of provision). The noise has individual inferior typos and actual errors and individual inferior Harvard restraintmatting errors (when required as divorce of provision). The noise is unobstructed of typos and actual errors; and Harvard restraintmatting is set-right (when required as divorce of provision).
* This rubric is speaking of the rubrics that accomplish be used to assess this provision. In dispose to fix the provision is speaking of the popular accounting environment, inferior changes may be made to heed these. A ultimate statement of this rubric accomplish be made serviceable at the age the provision instrument is serviceable.