Assignment task No. 1 NOTE THAT SOME PROBLEMS REQUIRE A SPREADSHEET SOLUTION. Marking guide Q1-1 to Q1-6 12% Q1-3 List five web sites relevant to accounting and their URLs. Explain how is each relevant to accounting? Q1-4 What is Second Life? What is it

Assignment task No. 1 

NOTE THAT SOME PROBLEMS REQUIRE A SPREADSHEET SOLUTION. 

Marking guide Q1-1 to Q1-6 12%

Q1-1 Go to http://student.csu.edu.au/study/plagiarism   Look on the left for a tab to take you to the quiz. Attempt the plagiarism quiz and a paste the results in your assignment including a paste of your name.  Q1-2 How can computer spreadsheets (eg. Excel) be pasted into a word document showing rows and column headings? Formula views? Describe two different pasting methods and paste simple examples in your assignment showing row and column headings, the normal view and the formula view.

Q1-3 List five web sites relevant to accounting and their URLs. Explain how is each relevant to accounting?

Q1-4 What is Second Life? What is its connection with accounting? Explain.

Q1-5 Work Integrated Assessment. Describe the computing environment in your current or previous workplace or home office workplace - equipment, software, processes etc. If this is a task you cannot undertake, explain why you cannot - and as an alternative task, describe the history and evolution of the Internet (about 300 words).

Q1-6 Play the CPA ABC Learning movies (from Interact Resources or the Internet), identify and briefly explain four (4) accounting issues raised by this case.

The above digital literacy questions can be answered from any source including the computer sections of magazines and newspapers or by access to the Internet. If using the Internet include the URL reference For the purposes of this subject we do not require the date of access.

Q1-7 Learning Objective: understanding the accounting equation. Marking guide Q1-7 4%

Explain the underlying rationale for the accounting equation. See the study guide. What are these symbols P A L E R? Relate them to sources and uses of funds.

Q1-8 Balance Sheet Equation. Marking guide Q1-8 8%

Note that Interact resources including Spreadsheet Advice and the worksheet video may assist in completing this assignment question

Check answer. In case 1, the figure for Total liabilities is 35.

When you get that number you know you are on the right track.

Q1-9 Marking guide Q1-9 4% Give 4 examples each of assets, liabilities and owners equity (Proprietorship) accounts.

Q1-10 Marking guide Q1-10 2% What is a chart of accounts? What is its purpose?

Q1-11 Marking guide Q1-11 5% List ten accounts with normal debit balances. List ten accounts with normal credit balances.

Q1-12 Learning Objective: understand and apply the Accounting Equation, Marking guide Q1-12 20%

A. Create a manual solution.

B. Create a spreadsheet solution. Paste normal and formula views.

C. Change 4 numbers such that the trial balance still balances. Paste this new normal view.

Note that Interact resources including Spreadsheet Advice and the worksheet video may assist in completing this assignment.

Q1-13 Marking guide Q1-13 2% Explain the difference between accrual and cash accounting?

Q1-14 Marking guide Q1-14 2% Why are adjusting entries needed?

Q1-15 Marking guide Q1-15 4% List five types of adjusting entries and give examples of each.

Q1-16 Marking guide Q1-16 2% You pay $120 for a magazine subscription for the next 12 months. How should the magazine company account for this transaction.?

Create a ten column worksheet and enter this data . Also your spreadsheet will create the financial reports.