英语论文网

REQUIREMENTS
You are required to complete and submit your accounting practice set in EXCEL using the template provided on Blackboard.

Your Practice Set Excel file must contain on the first page (Chart of Accounts) a footer which you create containing your name(s) and student number(s). Do not handwrite this – you must enter the details using Excel. (In Excel, Select “Insert” Footer)The signed declaration on the first page MUST be signed by each student or students if submitting as a pair (failure to sign will result in zero marks)
Please note that this practice set can be completed as an individual assignmentor with another student as a pair (a group of 2). Students can choose to work with any student enrolled in the unit. If students choose to work in a group, then the group will be allocated the same mark and students should make sure that the person they choose to work with completes their allocated tasks. No collaboration with students other than your group members is permitted. Please sign the declaration on page 1 of the Excel file that the set is your own work. If students choose to work in a group, hand in 1 assignment only.

The total mark for the Practice Setis 25%:
Total for practice set spreadsheet (including completion and formula sheets)15%.
Total for report: 10% to demonstrate your understanding and critical thinking

You will be able to start working on the practice set after the lecture for Topic 5 when we cover GST and Special Journals. Please ensure you have done all the topic 5 homework especially Problem 1 in your topic 5 homework before attempting this assignment

The pro forma spreadsheet structure provided should not be altered in any way. Do not insert or delete any rows or columns to the spreadsheet. Please follow the printing instructions precisely. Use only Microsoft Excel.

MARKING SCHEME—TOTAL WORTH 25%

Please complete the checklist on the bottom of page 1 of the Excel spreadsheet to assist you submit all that is required.

1. Complete Steps 1 to 8 and in the Print function, select Entire Workbook (there should be 13 pages from the Chart of Accounts to the Post Closing Balance).

2. Print the following 6 formulae pages with row and column headings (refer page 7) journals, subsidiary ledgers, general ledger, worksheet, Income Statement/Statement of Changes in Equity and Balance Sheet.

3. Print the completed 500 word report (refer separate Report Instructions and Report Structure Template at the end of this document which contain additional details).

4. Submit a hard copy of the 13 Excel spreadsheet pages, 6 formulae pages and your 500 word report to Assignment Minder with a cover sheet by the due date. Only hand in 1 per group.

5. Upload your report only online to Safe Assign. Please only upload 1 to Safe Assign if you are working in a pair but identify on it the names and student numbers of both students.

• 15% for completion of the Practice Set spreadsheet is assessed by checking off each page of the Practice Set. If you fully complete selected pages then you will receive allocated marks, part marks only will be awarded where the set is incomplete.

Fees Revenue Jou