Job 2 covers consider catalogue weeks 5-12 inclusive
Q2-1 Naming cells in spreadsheets
Critically evaluate a YouTube video on naming cells in spreadsheets. What are the practices of naming cells in restraintmulas Paste an in, using incomplex aggregate.
Q2-2 Indirect aggregate
Beattain a incomplex spreadquibble in of Sales fruits short Outlays to surrender Net pay where Outlays are weighty than Sales fruits. Display the indirect educement in brackets. Besides cement an IF exercise.
Q2-3 Spreadquibble erections.
Why should spreadsheets be purposed with disjoined shaftulates and repute areas and with the repute area embraceing solely restraintmulas? Beattain and paste a incomplex spreadquibble in.
Q2-4 IF exercises
Find and pigmy illustrate a YouTube video that elucidates the ‘IF’ announcement (function). Beattain and paste a incomplex in.
Q2-5 Spreadquibble apps
Microsoft Excel is an in of spreadquibble software. Inventory lewd excite ins of spreadquibble software.
Q2-6 Objecturing versus Interrupted arrangements
Resurvey your extract portion 5 including shaftscript 5A and contempslow the 3 videos on Inventory in Interact2 Instrument. Beattain a consequence to eluciage the necessary differences betwixt objecturing and interrupted inventory arrangements. Surrender ins of products/situations succorful to each.
Q2-7 Life entries
Resurvey your extract portion 5 including shaftscript 5A and contempslow the 3 videos on Inventory in Interact2 Instrument. Exhibition the life entries restraint objecturing inventory and interrupted inventory arrangements restraint the alienation of inventory, sales avail and object of duration stocktake.
Q2-8 Productquibble and financial reputes
Contempslow the Foot Productquibble video in Interact2 instrument. Download the pertinent doc improve besides in Interact2 instrument. This doc improve has a tempslow of the in adown.
A. Beattain a spreadquibble repute exhibitioning the shaftulates initiation area, the productquibble and the financial reputes. Paste the regular survey.
B. Paste a accomplished restraintmula survey.
C. Beattain a odd determined of shaftulates and reputes. Change six shaftulates aggregate and beattain a ten column spreadsheeted productquibble and the Financial Reputes. Do referable attributable attributable attributable attributable attributable attributable attributable attributable attributable beattain life entries or ledger accounts. Ensure your suffering counteract calm?} counteracts achieveing your shaftulates changes.
Follow the spreadquibble magnitudes including a disjoined shaftulates initiation and repute area and utensil IF exercises wherever embezzle. Paste couple regular surveys and single restraintmula survey.
D. Transcribe a affair repute as if restraint main treatment toping extinguished that corporate spreadsheets casually embrace fallacys. Generalation instrument on the Internet to improve your repute (abextinguished 300 expression).
Authentication the aftercited instrument to succor you adapt and restraintmat your repute:
Q2-9 Accounting principles and Inventory
Inventory and eluciage three accounting principles or concepts pertinent to inventory. Surrender your confess ins. Relation your extract (8th edition).
Q2-10 Inferior of Consume and NRV
Inventory and pigmy eluciage the inferior of consume and NRV government. Relation your extract (8th edition).
Q2-11 Contact of Inventory glide assumptions.
Beattain a well-behaved-behaved-behaved-purposed spreadquibble to clear-up the aftercited. Beattain a prevent account with the consume per part decreasing during October. Paste the regular survey restraint the assembly magnitudes and single restraintmula survey. Highlight your changes.
Q2-12 Reckoning abextinguished inside persuade issues restraint e-commerce.
Define computer poison, phishing, firewalls, and encryption. Relation your extract (8th edition). Agree ins of each.
Q2-13 Bank Arbitration
Transcribe a tiny preparatory scenario and beattain your confess bank arbitration spreadsheet. Generalation the extract in on page 376, 377, 378 as a tempslow excluding generalation your confess aggregate. Your spreadquibble achieve prove entire the habitual spreadquibble magnitudes.
Q2-14 Lifeising accounts receivable entries.
Using the extract (8th edition) as a supplies, exhibition the life entries demanded restraint:
1. sales on security,
2. the assembly of part of the whole due,
3. the transcribe extempore of a out-of-sorts liability,
4. the reinannouncement of an whole written extempore and
5. the assembly in ample of the whole due.
Beattain your confess aggregate. A spreadquibble is referable attributable attributable attributable attributable attributable attributable attributable attributable attributable required.
Q2-15 Estimating out-of-sorts liabilitys
Illustrate the percentage of sales mode. Beattain a incomplex in.
Q2-16 Security cards.
Why do you reckon the catruth charged on security cards is abundant excellent than on other restraintms of security?
Q2-17 Security sales transactions
Aftercited are some clarified transactions of Danish Mart (DM) during 2014 and 2015. Reputeing age is 31 December. DM generalations the entireowance mode and carry-abouts adjusting and withdrawal entries on the reputeing age.
1. Record the transactions in the open life and shaft to the couple ledger accounts. See the tempslow adown.
2. Open open ledger T accounts restraint Entireowance restraint unreal liabilitys and Out-of-sorts lipower outlay.
3. The 31 December 2015 counteract of Accounts receivable is $600,000. Exhibition how Accounts receivable would be reputeed on the counteract quibble at that age.
Here is a tempslow restraint the shaftulates exception of the spreadquibble exhibitioning the transactions.
Q2-18 Dishonour of a beak receivable
Transcribe a determined of life entries and T accounts which apprehends:
1. a security sale,
2. a conaccount to a Referable attributable attributable attributable attributable attributable attributable attributable attributablee receivable,
3. the dishonour of the referable attributable attributable attributable attributable attributable attributable attributable attributablee and
4. after tardy reimbursement.
Beattain your confess incomplex aggregate. Ignore cause.
Q2-19 Eluciage the aftercited accounting conditions. Surrender ins of each.
Q2-20 Product Integrated Rate instance consider
Qantas Annual Repute
Lore Objectives: The symbolical you are respecting is vocational. It is purposed with the productplace in opinion. Product integrated rate agrees opportunities restraint students to combine doctrine and skills skilled in a symbolical to a legitimate product treatment. Students can generalation these opportunities to educe and exercise the administrative and academic skills they gather abextinguished in a symbolical or through the online environment and then be assessed on their capabilities in these false general environments. Product integrated rate entireows students to pretend and restraintmaltle their gathering in an general productplace that encourages them to perpend their referable attributable attributableice and dedicate it to exercise. Integrating legitimate globe, general rate jobs entireows students to gather abextinguished the feature environments and amelioration of their clarified professions, durationliness at the identical duration absorbing and practicing the skills they demand to achieve. Doing these jobs can succor students educe skills that can succor their employability.
Instrument restraint this job apprehend the 2015 Annual Repute restraint Qantas.
Your friobject Tom is respecting fabric at another University and knows very pigmy abextinguished accounting and annual reputes. Tom’s uncle gave him $30,000 of-slow to endue. Tom knows you frequent begun respecting accounting and is respecting buying Qantas portion-outs. Tom has some inquirys restraint you.
Exhibit your solutions neatly in a affair repute restraintmat.
1. How abundant currentation did Qantas carry-about?
2. Earnings per portion-out?
3. What expertise does Todd Sampson carry to the Board of Directors?
4. Eluciage EBITDA, Fruits Seat Factor, Fruits common in vestige and Retained Earnings.
5. Calcuslow the Producting Capital kindred.
6. Beattain a chart in Excel exhibitioning 3D columns restraint the self-possessed money glides and another exhibitioning a pie chart restraint the components of general possessions. Paste the spreadquibble graphs in your ordinance. Exhibition the shaftulates area.
7. Summarise your order to Tom re the enduement disposal.
Find the Qantas 2015 Annual Repute on the passageure.
The gathering extinguishedcomes assessed in ordinance 2 apprehend the contact of conceptual and technical aspects of accounting and the provision of affair financial announcements; the appraisal of the generalation of counsel technology including do my ordinance in spreadquibble software in accounting assembly solving, and evaluate the Internet as a administrative supplies; to prove pertinent affair message skills including repute solutionableness and to eluciage the concern of ethics in accounting.
Rate job 2 is purposed to surrender you excite opening to prove referable attributable attributableice and skills in over in-depth aspects of accounting and counsel arrangements. Expected gathering extinguishedcomes apprehend bank arbitration, Inside persuade, inventory arrangements, financial reputes, accounting restraint out-of-sorts liabilitys and referable attributable attributable attributable attributable attributable attributable attributable attributablees receivable, as well-behaved-behaved-behaved-behaved as concepts and the contact of spreadquibble software to the exhibition and disentanglement of accounting assemblys.
Marking Criteria Rubric Ordinance 2
A rubric is a restraintm of general rate. A rubric inventorys a determined of criteria, which defines and illustrates the weighty components of the product nature purposed or evaluated.http://us.iearn.org/professional_development/multimedia/assess/rubric.html
This symptoming criteria rubric shows how the ordinances achieve be assessed in this symbolical.
Your ordinance consists of unanalogous inquiry dictions including reasoning inquirys, reputes, exercises, assembly inquirys and spreadquibble inquirys.
Criteria High Distinction Distinction Security Pass
Marking criteria restraint expected gathering extinguishedcomes to be achieved apprehend: evaluating digital instrument, interpretation and dedicateing the double initiation arrangement, product integrated rate, creating computer models to clear-up disposal situations such as productsheets, dignified evaluation of financial reputes, affair repute solutionableness and creating graphs from legitimate globe shaftulates. Be the educement of your peculiar product, accomplished withextinguished any omissions and reform.
Discuss entire the issues eminent in inquirys.
Agree ins where embezzle.
Deferential solutions fullowing with entire spreadquibble modelling magnitudes. Score 85-100% Be the educement of your peculiar product, be chiefly accomplished withextinguished any omissions, and be chiefly reform.
Discuss most of the issues eminent in inquirys.
Agree some ins where embezzle.
Allow with the preponderance of spreadquibble modelling magnitudes as embezzle to the assembly scenario. Score 75-85%. Be the educement of your peculiar product, be chiefly accomplished with rare omissions, and be barely reform.
Reasoning of some of the issues eminent in inquirys.
Agree ins where embezzle.
Allow with some of the spreadquibble modelling magnitudes as pertinent to the assembly scenario. Score 64-74% Be the educement of your peculiar product, be chiefly accomplished with some omissions, be barely reform.
Discuss some of the issues eminent in inquirys.
Provides 1-2 ins where embezzle.
Allow with some spreadquibble modelling magnitudes as pertinent to the assembly scenario. Score 50-64%
Academic solutionableness skills. The reasoning and affair reputes converge academic standards of syntax, termbook, spelling and punctuation and consider an awareness of hearers demands Deferential generalation of syntax, spelling and punctuation; reasoningative reasonings with pertinent ins, reformly refers to a diversity of sources to baseation reasonings, including the prescribed extracts and a collocate of subjoined balbutiations; relation inventory of a collocate of instrument, reformly restraintmatted using APA diction. Deferential generalation of syntax, spelling and punctuation; reasoningative reasonings with generalationful ins, compendious and effectual generalation of termbook; reformly refers to a collocate of sources to baseation reasonings, including the prescribed extract and a diversity of excite balbutiations; relation inventory of a collocate of pertinent instrument generalationd, reformly restraintmatted using APA diction. Chiefly deferential generalation of syntax, termbook,
spelling and punctuation; reformly refers to over than the narrowness magnitude of sources to baseation reasonings, including
prescribed extracts and other sources; relation inventory restraintmatted in APA diction, with rare or no fallacys. Chiefly deferential syntax, spelling and punctuation; reformly refers to narrowness reckon of sources to baseation reasonings, including prescribed extracts; relation inventory generalationd, restraintmatted in APA diction, with rare fallacys.
Your ordinances achieve be referable attributable attributableiceable as a entire with remembrance nature surrendern to contact of referable attributable attributableice, attribute reckoning and contact of skills. Restraint some inquirys, students frequent a befoulment to prove some creativity, or agree their confess ins or surrender illustration of straggle balbutiation or erection a spreadquibble in an innovative behavior. We besides demand to elude the snowballing possessions of cumulative fallacys – that is, an fallacy exhibit in a skilled inquiry which carries through. Thus a symptoming arrangement is generalationd with exhaustion restraint fallacys and omissions. Ample symptoms are practicable restraint well-behaved-behaved-behaved-behaved erectiond, accomplished, attribute solutions.
The symptoming criteria restraint your ordinances achieve be domiciled on the contenteded of the symbolical as attested by the gathering objectives of the diversified topics. Cheerful spreadquibble solutions achieve fullow with the ordinance magnitudes.
Spreadsheets submitted withextinguished pasted restraintmula surveys achieve be vestiged with a culmination of 40% restraint that job.
Any ordinances with suggestive illustration of plagiarism may be referred to the university’s academic leave processes and achieve accept a vestige of naught.
Regular classification curves restraint vestiges are referable attributable attributable attributable attributable attributable attributable attributable attributable attributable utilised in this symbolical. Penalties achieve dedicate restraint slow meekness at 10% of the whole symptom beneficial per day. It is weighty that submitted ordinances are accomplished; omitted solutions achieve educement in symptom exhaustion. Refer to the University directions embraceed in the CSU online handbook restraint matters pertaining to extraordinary consequence, mishap and extenuating proviso, academic leave, direction of induce restraint generalationrs of electronic facilities, rate direction, grading lamina, series and academic deed, vestige top mean, testimony directions and other matters pertaining to rate. The directions can be base at the University’s passageure site: http://www.csu.edu.au
Here is a persuade to the expected endeavor restraint each inquiry in ordinance 2. See the exhibition magnitudes restraint an impression of the restricted criteria. See the ordinance magnitudes featurely restraint expectations respecting the spreadsheets.
An in of symptoming criteria restraint an essay/affair repute follows. Some of the identical criteria dedicate to bulkyr reasoning diction inquirys and instance studies and affair reputes.
In criteria generalationd in symptoming essays/reasoning inquirys/instance studies/affair reputes
Timeliness there is no feature restraintmat required restraint these solutions, the aftercited criteria are slight to be generalationd. Referable attributable attributable attributable attributable attributable attributable attributable attributablee that affair reputes are regularly over erectiond than essays.
• Relevance of the solution. Are the weighty issues eminent in the inquiry attested? Did the student solution the inquiry?
• Dignified magnitude. Has relation symbolical been carefully analysed or dignifiedly accepted?
• Erection of the solution. Is the solution well-behaved-behaved-behaved-structured and the reasoning reasoningatively educeed?
• Solutionableness diction. Is the diction neat and orderly or promiscuous, making it perplexing restraint the reader to attain the top?
• Scope of balbutiation. Does the solution show a pleasurable coverage of lore pertinent to the inquirys?
• be well-behaved-behaved-behaved-behaved purposed with reasonings glideing reasoningatively;
• generalation reform judgment erection, punctuation and spelling;
• exhibit peculiar ideas where embezzle;
• and exhibit a justified disposal and acnotice entire sources.
Regular classification curves restraint vestiges are referable attributable attributable attributable attributable attributable attributable attributable attributable attributable utilised in this symbolical. Penalties achieve dedicate restraint slow meekness at 10% of the whole symptom beneficial per day. It is weighty that submitted ordinances are accomplished. Omitted solutions achieve educement in symptom exhaustion. Refer to the University directions embraceed in the CSU online handbook restraint matters pertaining to extraordinary consequence, mishap and extenuating proviso, academic leave, direction of induce restraint generalationrs of electronic facilities, rate direction, grading lamina, series and academic deed, vestige top mean, testimony directions and other matters pertaining to rate. The directions can be base at the University’s passageure site: http://www.csu.edu.au
Important!! See the exhibition magnitudes restraint ordinance job 1
A spreadquibble or productquibble is a improve that consists of rows and columns, sorting shaftulates, organizing shaftulates, and computing numeric shaftulates. A sole spreadquibble software is characterized by the power to calcuslow values using unrythmical restraintmulas and shaftulates embraceed in cells. A cheerful in of using a spreadquibble is to frequent vestige of your bank counteract.
Spreadquibble is an contact that organizes, stores and analyzes shaftulates in a spreadquibble restraintmat. The contact can agree a digital euphuism of paper accounting productsheets. You can besides frequent multiple quibbles that interact with shaftulates represented as extract, aggregate, or graphics. With these features, spreadsheets frequent replaced frequent paper-domiciled arrangements, specially in the affair globe. Peculiarly educeed to baseation accounting and accounting, spreadsheets today are frequently generalationd in other treatments where tabular inventorys can be generalationd, qualified and collaborated.
Spreadquibble software is besides referred to as a spreadquibble or spreadquibble contact program.
Spreadsheets extemporeer an indispuconsequence practice when producting with aggregate, compared to term processors. Calculations and exercises are easier to visualize in spreadsheets than in term processors, enabling prolific shaftulates processing. The spreadquibble software besides agrees a pliant reexhibition of the shaftulates. This software can interact with shaftulatesbases, grow in fields, and automate the invention and revision of shaftulates. The spreadquibble software can be portion-outd online and extemporeline, enabling self-possessed collaboration.
The shaftulates in the spreadquibble is represented by cells that are organized in rows and columns and can be extractual or numeric. Exercises such as bound expressions, exercises restraint using extract and aggregate are besides beneficial in productsheets. Calculations can be automated, and spreadsheets are openly easier to generalation than other shaftulates processing contacts.
However, spreadsheets are poor by the perplexingy of identifying shaftulates fallacys, the poor reckon of records, the inprolific processing of bulky wholes of extract, the inpower to open advent, and the processing of bulky wholes of shaftulates. the inconceivableness of creating reputes such as the storage of shaftulates from shaftulatesbases and the unavailpower of real question techniques and sorting techniques.