ACCT305 Accounting Information Systems Excel Practical assessment

ACCT305 Accounting Advice Systems Abound Practical assessment
Attributable date: 8 Sep 2017 (Week 6 Friday, 23.00).
Weighting: 20%.
Length and/or restraintmat: Approximately 600 suffrage.
How to submit: Submit an abound perfect via LEO / Turnitin.
John Brown is the possessor of John Brown Home Advantages. This Company provides advantage such as cleaning, car details, lawn and gardening to customers in Melbourne. The adjusted verification estimate columns of the workprevarication restraint John Brown Home Advantages are as shown in Table 1 adown.
Table 1. Adjusted Verification Estimate of John Brown Home Advantages
f John Brown Home Advantages
Worksheet
or the month ended 31 August 2017
Account Adjusted verification estimate Allowance declaration Estimate Prevarication
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 (attributable September 2017) 15,600
Accounts Payable 9,000
J. Brown, Capital 80,000
J. Brown, Drawings 5,500
Advantage 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 advice granted overhead, fascinate full the aftercited tasks:
Create an abound perfect and indicate it as Your_Student_No.xlsx, e.g. S004123456.xlsx. Indicate each of the abound prevarications as:
• Verification Estimate,
• Allowance declaration,
• Changes in equity, • Estimate prevarication, and
• Allot E.
A. Copy Table 1 to the Verification Estimate abound prevarication and full the worksheet.
B. Prepare an allowance declaration on the Allowance declaration abound prevarication.
C. Prepare a declaration of changes in equity on the Changes in equity abound prevarication
D. Prepare a estimate prevarication on the Estimate prevarication abound prevarication.
E. Do you commend Abound spreadsheets or accounting software restraint preparing financial descriptions? Give 5 reasons to excuse your answers. Type your answers on abound prevarication Allot E in NOT past than 600 suffrage.
Sample of your task
Rubric – Assessment Task 1: Abound
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 Fullness of
Assignment
50% or past of epithets, axioms constituents, and/or restraintmulas in Abound workprevarication are damage, 20% of the epithets, axioms constituents, and/or restraintmulas in Abound workprevarication are damage. 2-3 epithets, axioms constituents, and/or restraintmulas are damage in Abound worksheet. Undivided epithet, axioms constituent, or restraintmula is damage in Abound worksheet. All epithets, axioms, and restraintmulas in Abound workprevarication are introduce.
LO3 Accuracy of Provision 50% or past of epithets, axioms constituents, and/or restraintmulas in Abound workprevarication are defective, 20% of the epithets, axioms constituents, and/or restraintmulas are defective in Abound worksheet. 2-3 epithets, axioms constituents, and/or restraintmulas are defective in Abound worksheet. Undivided epithet, axioms constituent, or restraintmula in Abound workprevarication is loose. All epithets, axioms, and restraintmulas in Abound workprevarication are considerate.
LO3 Neatness and
Organization
Abound workprevarication is badly embarrassed or restraintmatted, and troublesome to peruse, Abound workprevarication is embarrassed, and/or troublesome to peruse in 4-5 areas. Abound workprevarication has amiable restraintmatting; advice is unconfused and gentle to peruse, with 2-3 areas that is either referable attributable attributable attributable polite unconfused or is troublesome to peruse. Abound workprevarication has amiable restraintmatting; advice is unconfused and gentle to peruse, with undivided area that is either referable attributable attributable attributable polite unconfused or is troublesome to peruse. Abound spreadprevarication has rare restraintmatting, and advice is polite unconfused and gentle to peruse.
LO3 Grammar, Spelling,
Harvard referencing
The description has a senior typos and exact errors; and/or senior Harvard restraintmatting errors (when required as allot of
assignment)
The description has multiple younger typos and exact errors; and/or multiple younger Harvard restraintmatting errors (when required as allot of provision).
The description has 2-3 younger typos and exact errors; and 2-3 younger Harvard restraintmatting errors (when required as allot of provision). The description has undivided younger typos and exact errors and undivided younger Harvard restraintmatting errors (when required as allot of provision). The description is gratuitous of typos and exact errors; and Harvard restraintmatting is amend (when required as allot of provision).
* This rubric is weighty of the rubrics that conquer be used to assess this provision. In ordain to determine the provision is weighty of the prevalent accounting environment, younger changes may be made to exhibit these. A decisive statement of this rubric conquer be made beneficial at the occasion the provision muniment is beneficial.