Course Title: Develop and use complex spreadsheets

Part B: Course Detail

Teaching Period: Term1 2015

Course Code: COSC5946C

Course Title: Develop and use complex spreadsheets

School: 650T Vocational Business Education

Campus: City Campus

Program: C5260 - Diploma of Accounting

Course Contact : Angelo Sellan

Course Contact Phone: +61 3 99255460

Course Contact Email:angelo.sellan@rmit.edu.au


Name and Contact Details of All Other Relevant Staff

The instructors shown below have previously or are currently facilitaing the delivery of this cluster of units. Including the coordinator, it is probable that your instructor will be one of the following, this will be clarified in your first class meeting.

Ian Nash ian.nash@rmit.edu.au

Claudio Marasco claudio.marasco@rmit.edu.au

Meetu Aggarwal meetu.aggarwal@rmit.edu.au

Helen Mustafa helen.mustafa@rmit.edu.au

Nominal Hours: 50

Regardless of the mode of delivery, represent a guide to the relative teaching time and student effort required to successfully achieve a particular competency/module. This may include not only scheduled classes or workplace visits but also the amount of effort required to undertake, evaluate and complete all assessment requirements, including any non-classroom activities.

Pre-requisites and Co-requisites

None

Course Description

This unit describes the performance outcomes, skills and knowledge required to use spreadsheet software to complete business tasks and to produce complex documents. No licensing, legislative, regulatory or certification requirements apply to this unit at the time of endorsement.




 


National Codes, Titles, Elements and Performance Criteria

National Element Code & Title:

BSBITU402A Develop and use complex spreadsheets

Element:

1.Prepare to develop spreadsheet
2. Develop a linked spreadsheet solution
3. Automate and standardise spreadsheet operation
4. Use spreadsheets
5. Represent numerical data in graphic form

Performance Criteria:

1.1. Organise personal work environment in accordance with ergonomic requirements
1.2. Analyse task and determine specifications for spreadsheets
1.3. Identify organisational and task requirements in relation to data entry, storage, output, reporting and presentation requirements
1.4. Apply work organisation strategies and energy and resource conservation techniques to plan work activities
2.1. Utilise spreadsheet design software functions and formulae to meet identified requirements
2.2. Link spreadsheets in accordance with software procedures
2.3. Format cells and use data attributes assigned with relative and/or absolute cell references, in accordance with the task specifications
2.4. Test formulae to confirm output meets task requirements
3.1. Evaluate tasks to identify those where automation would increase efficiency
3.2. Create, use and edit macros to fulfil the requirements of the task and automate spreadsheet operation
3.3. Develop, edit and use templates to ensure consistency of design and layout for forms and reports, in accordance with organisational requirements
4.1. Enter, check and amend data in accordance with organisational and task requirements
4.2. Import and export data between compatible spreadsheets and adjust host documents, in accordance with software and system procedures
4.3. Use manuals, user documentation and online help to overcome problems with spreadsheet design and production
4.4. Preview, adjust and print spreadsheet in accordance with organisational and task requirements
4.5. Name and store spreadsheet in accordance with organisational requirements and exit the application without data loss or damage
5.1. Determine style of graph to meet specified requirements and manipulate spreadsheet data if necessary to suit graph requirements
5.2. Create graphs with labels and titles from numerical data contained in a spreadsheet file
5.3. Save, view and print graph within designated time lines
 


Learning Outcomes



Details of Learning Activities

 

This course is co-delivered as part of a cluster which includes ACCT 5310 Provide Financial & Business Performance Information, ACCT5315C Prepare Financial Forecasts & Projections and COSC5946C Develop and Use Complex Spread Sheets. As a result, three course guides will be prepared but only the Elements, Performance Criteria, Critical Aspects, Knowledge and Skills requirements for each course will be specific to each course (guide). The remainder of the information such as "Teaching Activities" "Teaching Schedule" "Resources" and "Assessments Tasks" will be identical on all three course guides
Importantly, the attached information is consistent with the unit mapping document for this cluster
Using various materials along with facilitator led discussion, students will be progressively introduced to the key aspects to creating a business plan for a specific client. This will involve outlining a time line which will serve as a plan of action providing key dates for monitoring of progress and meetings with clients for progressive briefings / feedback. Various forecasting methodologies along with identification of relevant assumptions and compliance with legislative requirements at local, state, and federal level will also be covered and incorporated into the business plan. The completed business plan will serve as a template document providing financial and business performance information for the specific users needs. Spread sheets will be incorporated specifically in the financials section of the business plan, clients needs together with business plan requirements will be analysed to allow development of spread sheet solutions designed to enhance decision making. This course will involve both theory and practical learning activities.
 

FULL TIME STUDENTS: As part of this cluster , in-class activities will account for 80 of the 180 nominal hours allocated to these co-delivered cluster/courses and will include class work on theory, practical and computer work, together with work on assessment tasks. Please note that in-class activities includes assessment. This will involve observation and one on one questioning of prescribed task execution. The remaining 100 of the 180 nominal hours are for self directed learning and should be taken up with work on any course, study activity and the assignment outside of scheduled class time. Please note that the format of the classes will be a total of five hours per week over a 16 week period.
 

FLEXED (Part time) Students
As part of this cluster , in-class activities will account for 18 of the 180 nominal hours allocated to these co-delivered cluster/courses and will include class work on theory, practical and computer work, together with work on assessment tasks. Please note that in-class activities includes assessment. This will involve observation and one on one questioning of prescribed task execution. The remaining 162 nominal hours are for self directed learning and should be taken up with work on any course, study activity and the assignment outside of scheduled class time. Please note that the format of the classes will be a total of two hours each second week (flexed comprising a total of eight weeks face to face delivery over a 16 week period.
A further two collaboration sessions are planned to be held during two of the non class weeks. These sessions will be of one hour duration and will be held at the facilitators discretion. Although the collaborate sessions are included in your weekly guide the date and time of these sessions will be confirmed on Blackboard during the semester. It is the responsibility of the student to have the necessary technology available to access these sessions.
 

Critical Aspects of assessment:

• Identify, interpret and comply with organisation policies and procedures regarding preparing financial forecasts and projections
• Apply standard accounting principles and techniques
• Accurately identify assumptions and parameters of forecasts
• Collect, consolidate, model and analyse data in a timely manner, document results and obtain approval where required. 

 

Skills
• developing complex spreadsheets
• developing graphical representations of data contained in spreadsheets.
 

Required Knowledge:

• advanced functions of spread sheet software applications
• impact of formatting and design on the presentation and readability of data
• key provisions of relevant legislation from all forms of government, standards and codes that may affect aspects of business operations, such as:

• anti-discrimination legislation

• ethical principles

• codes of practice

• privacy laws

• occupational health and safety

• organisational policies and procedures.


Teaching Schedule

The total number of scheduled hours of teaching, learning and assessment involved in this course will include all planned activities. This will incorporate face to face classes online learning and other forms of structured teaching and learning. The total scheduled hours includes the amount of effort required to undertake, evaluate and complete all assessments requirements, including observation of work performance, discussion with Facilitators and one on one sessions with students.
The nominal hours associated with this cluster are a guide only and represent the total teaching time and student effort required to successfully complete the course. This may include not only scheduled classes but also the amount of effort required to undertake, evaluate and complete all assessment requirements, including any non classroom activities.
 

The teaching schedule below incorporates the three clustered or co delivered units, and is relevant to FULL TIME students. Please refer to the bottom table for FLEXED teaching schedule.
 

WeekDateContent / ActivityAssessment
109/02

• Course requirements
• Course support documents
• Blackboard
• Overview of assessment requirements including Recognition of Prior Learning and Credit Transfers
• Grading
• Plagiarism
• Appeals
• Extensions
• Feedback
• Privacy
• Submission requirements
• Resubmission policy
• Where to get support
• Student responsibilities
Revision Excel: Cell referencing.

Ergonomic principles

Time Plan: incorporating review dates (pitstop assessments) Setting milestones. Establish criteria for gauging progress e.g. number of meetings, minimum attendance, meeting agreed dates.
Organising meeting times for review and feedback to/from client.
 

 Online test (not used for competency)

TASK 1TL: Time plan to be submitted to facilitator in class by second class of the week for facilitator approval. You will receive feedback on this assessment in class at the time you meet the assessor for the approval of the plan. The plan will need to be uploaded into Blackboard by end of week. If the plan was not approved in class, you will receive feedback via Blackboard (gradebook) in week 3.

216/02

 

Absolute Vs Relative cell referencing. Model Building using budget exercise as illustration.
Simple model building using PMT CUMPIT and PV functions

 

 
323/02

 

Model building to produce forecast (Pro Forma) statements using % of sales method. Income Statement and Balance Sheet only.


 

 
402/03

Model building to produce forecast (Pro Forma) statements using % of sales method. Income Statement, Balance Sheet and Cashflow Statement

 
509/03Quantitative forecasting using excel linear time series. Determining a forecast growth rate. 

Qualitative forecasting: Environmental Analysis. Adjusting the quantitative outcome

Macros

Assessment consultation and feedback.

Pit stop review of Major Assignment Part A 
616/03

Business Plan related compliance matters; incorporating GST in the financial model.
Ratios: Profitability / Efficiency / Stability
Assessment consultation and feedback.

Pit stop review of Major Assignment Part A
7

23/03

Assessment task consultation and feedback 

Pit stop review of Major Assignment Part A
830/03 & 06/04

 

Assessment task consultation and feedback.

 

Pit stop review of Major Assignment Part A

ONLINE TEST 1. IN CLASS SUPERVISED TEST

913/04Concept of Gearing / Leverage
Sources of Finance 
 
Submission of Major Assignment Part A: Both business plan document and spreadsheet model need to be uploaded into Blackboard gradebook by COB Monday of this week. Feedback will be provided over the weeks 10, 11 & 12, resubmission will need to occur by end of week 14
1020/04Assessmet consultation and feedbackPit stop review of Major Assignment Part B
1127/04Assessment consultation and feedback.Pit stop review of Major Assignment Part B
1204/05Assessment consultation and feedbackPit stop review of Major Assignment Part B
1311/05Assessment consultation and feedback. 
 
Submission of Major Assignment Part B: Both the Report document and the Spreadsheet financials need to be submitted onto the Blackboard gradebook by COB Friday of this week. Feedback will be provided by week 14, resubmission will need to occur by end of week 15.
 
1418/05Assessment consultation and feedback.
 

Re-submission (if applicable) of Major Assignment Part A: Both business plan document and spreadsheet model need to be uploaded into Blackboard gradebook by COB Friday of this week

CHECK YOUR "MY GRADES" ROUTINELY FOR FEEDBACK AND RESUBMISSION REQUIREMENTS

1525/05Assessment consultation and feedback

Re-Submission of Major Assignment Part A: Both the Report document and the Spreadsheet financials need to be submitted onto the Blackboard gradebook by COB Friday of this week.

CHECK YOUR "MY GRADES" ROUTINELY FOR FEEDBACK AND RESUBMISSION REQUIREMENTS

1601/06

Relevant facets of financial services legislation. Ethics. Materials provided online (Blackboard)

Deferred and resubmitted assessments

ONLINE TEST 2: unsupervised with unlimited attempts. Must be completed by COB Friday of this week.

CHECK YOUR "MY GRADES" ROUTINELY FOR FEEDBACK AND RESUBMISSION REQUIREMENTS

The teaching schedule below incorporates the three clustered or co delivered units, and is relevant to FLEXED students.

WeekDateContentAssessment / ActivityStudent Directed Learning (SDL)
109/02

Class 1

Course requirements
• Course support documents
• Blackboard
• Overview of assessment requirements including Recognition of Prior Learning and Credit Transfers
• Grading
• Plagiarism
• Appeals
• Extensions
• Feedback
• Privacy
• Submission requirements
• Resubmission policy
• Where to get support
• Student responsibilities 

In Blackboard (Bb) see Excel Revision Exercise  “Cell referencing.doc” This exercise will be used to introduce / review Excel basics. Please refer to series of Lectopia recordings available in the Bb.
Ergonomic principles (SDL)

Covering requirements for Time Plan: TASK 1TL, incorporating review dates (pitstop assessments) Setting milestones. Establish criteria for gauging progress e.g. number of meetings, minimum attendance, meeting agreed dates. Please see “Assessments tasks” folder in Blackboard for detailed requirements for this task. Detailed explanation / demonstration of assessment submission into Blackboard.
 

TASK 1TL: Time plan to be done in class and approved by facilitator. You will receive feedback on this assessment in class at the time you meet the assessor for the approval of the plan. The plan will need to be uploaded into Blackboard by end of week. If the plan was not approved in class, you will receive feedback via Blackboard (gradebook) in week 2.Work through materials provided on week one of the learning resources in Blackboard:
Ergonomic and Sustainability Notes, then complete QUICK QUIZ Ergonomics and Sustainability(not for competency purposes; only for feedback purposes)
If you have not attended the class please ensure that you cover the class material as per content in Black board Week 1.
 
216/02

Absolute Vs Relative cell referencing. Model Building using budget exercise as illustration.
Simple model building using PMT CUMPIT and PV functions

 

In Model Building Notes The power point slides Model Building ppt point out the main elements of an effective spread sheet model along with efficient spread sheet design and building. Many of these elements will be demonstrated in this weeks class using the file case "Model Building illustrative example" You will note that a solution spread sheet Suggested Solution has already been provided, but please remember that this solution is of very little use, much of what is important is not shown in the spread sheet solution; I am talking about the process by which the solution was reached. The demonstration will be via Blackboard Collaborate. Keep tuned in for precise day and time. Your major assignment will use the same approach, simply on a larger scale.

 

Work through materials provided on Blackboard
Excel basics: Relative Vs Absolute cell referencing; ensure you have completed “Cell referencing” doc exercises (see week one of Blackboard)
 

Work through materials provided on Blackboard
View Notes/Power Point Slides for Labels.ppt, PMT.ppt, CUMIPMT.ppt, PresentValue.ppt 

In Practice Exercise complete Practice Exercise One, Two and Three. 

Work on major assignment; enter inputs; phase one.
Read assessment case brief in assessments folder. Identify client objectives and potential input variables

 

323/02


 

CLASS 2.

Model building to produce forecast (Pro Forma) statements using % of sales method. Income Statement and Balance Sheet only.

See Bb for Percentage of Sales Method; Pro forma Statements, Income statement and Balance Sheet only: NOTES. We will be working through the Power point notes. Relevant ingredients required for pro forma statements using this method, and how to put them all together. 

We will be investigating Sales linked items, Management determined items, Fixed Asset Utilisation; cases where capacity is fully utilised and cases where there is under utilisation. Capital intensity ratio, Determining required finance to achieve a forecast rate of growth; internal vs external finance. Internal growth rate and Sustainable growth rate.

 

Complete exercises provided in EXERCISES / SOLUTIONS: Pro forma statements; Income Statement and Balance Sheet, folder of Bb

All exercises should be aimed to be completed by this week.

See Illustration Spread Sheet for Internal and Sustainable Growth Rates for spread sheet demonstration of Internal and Sustainable Growth Rate in operation.

402/03

Model building to produce forecast (Pro Forma) statements using % of sales method. Income Statement, Balance Sheet and Cashflow Statement 
The facilitator will be demonstrating the process by which to complete a set of Pro forma statements including Cash flow. The notes applicable to this lesson are in this week Bb Pro forma with Cash flow notes / illustration the relevant file is Notes/Power point slides Pro forma with cash flow instructor.ppt

 

Work through materials provided on Blackboard
See Pro forma with cash flow exercise / solution in wk 4 of Bb.

Complete PRACTICE TEST, (this is for progress and feedback purposes only)

Commence phase 2 of Major Assignment. 

519/03

CLASS 3.

Quantitative forecasting using excel linear time series. Determining a forecast growth rate. See Forecasting in Bb relevant file; Forecasting.ppt 
Qualitative forecasting: Environmental Analysis, adjusting the quantitative outcome. See relevant file Forecasting2.ppt

Macros

Assessment consultation and feedback.

Pit stop review of MAJOR ASSIGNMENT Part A. Completed to Phase One. All items relative to sales, using arbitrary growth rate.

Complete Forecasting Exercise in Bb

View Macros web link video demonstrating a macro

Using relevant data from UDSC brief of information, include forecasting techniques in spread sheet of Major Assignment part A.

Apply a macro to your Major Assignment Part A Spread sheet.
 

616/03

 

Business Plan related compliance matters; incorporating GST in the financial model.
 

Ratios: Profitability / Efficiency / Stability
Assessment consultation and feedback.
 

 

View Weblinks to RATIOS, in Bb. You are encouraged to visit these links if you require further clarification / understanding of the ratios we cover; how they are calculated, what they purport to reveal and how to analyse them.

Complete PRACTICE TEST; RATIOS


Work on completing your assignment  spread sheet model; incorporate GST into your model.
 

Complete legislative requirements section of Business Plan Template
 

723/03

CLASS 4.

Assessment task consultation and feedback
 

Pitstop reivew of MAJOR ASSIGNMENT Part A Your Business Plan document should be largely completed with the exception of the financials section. Your spread sheet model should be completed to Phase 2 and have aspects of Phase 3 commenced. Forecasting, Macros and Ratios related criteria should be completed. 
830/03 & 06/04

BLACKBOARD COLLABORATE SESSION

Assessment task consultation and feedback.

 

 ONLINE TEST 1.

You are to complete the online test. You will need to do this on the week night in which you have your normal scheduled class and at the normal scheduled time. You are required to remotely access the test at this time.
 

913/04

CLASS 5.

Concept of Gearing / Leverage
Sources of Finance
Financing in business and sources of finance
See: “Sources of finance”.ppt with emphasis on FOPPI illustration therein.
 

PITSTOP REVIEW of Major Assignment Part A. You are to have your Business Plan Document and Spread sheet Model largely completed by this meeting.

Submission of Major Assignment Part A. 

Business Plan and Spread sheet Model: Both business plan document and spread sheet model need to be uploaded into Blackboard grade book by COB Friday of this week. Feedback will be provided over the weeks 10, 11 & 12, resubmission will need to occur by end of week 14

Submission of Business Plan and Spreadsheet Model: Both business plan document and spreadsheet model need to be uploaded into Blackboard gradebook by COB Friday of this week. Feedback will be provided over the weeks 10, 11 & 12, resubmission will need to occur by end of week 14
 

1020/04Assignment feedback.provided via Blackboard Gradebook; take note of feedback and make necessary changes if required.

Finance plan and report consultation and feedback
 
 

Work on assessments

CHECK YOUR "MY GRADES" ROUTINELY FOR FEEDBACK AND RESUBMISSION REQUIREMENTS
 

1127/04

CLASS 6.

Assessment consultation and feedback

Assignment feedback provided via Blackboard Gradebook; take note of feedback and make necessary changes to Financial model and or business plan document

Pit stop review of Major Assignment Part B

The spread sheet workings showing funds available vs funds required with the requisite shortfall or surplus over the life of the redevelopment should be completed. Repayments on any borrowing required should also be completed by this meeting.

Work on assessments

CHECK YOUR "MY GRADES" ROUTINELY FOR FEEDBACK AND RESUBMISSION REQUIREMENTS
 

1204/05

BLACKBOARD COLLABORATE SESSION
 

Assignment consultation and feedback
 

 

Work through materials provided on Blackboard
Work on assessments
 

CHECK YOUR "MY GRADES" ROUTINELY FOR FEEDBACK AND RESUBMISSION REQUIREMENTS
 

1311/05

CLASS 7.

Assessment consultation and feedback

Submission of Major Assignment Part B:

Both the Report document and the Spread sheet financials need to be submitted onto the Blackboard grade book by COB Friday of this week. Feedback will be provided in weeks 14 & 15 resubmission will need to occur by end of week 16.

Work on assessments

CHECK YOUR "MY GRADES" ROUTINELY FOR FEEDBACK AND RESUBMISSION REQUIREMENTS
 

1418/05

Assessment Consultation & Feedback
Assignment feedback provided via Blackboard Gradebook; take note of feedback and make necessary changes to Finance plan and / or Report if required.
 

Deadline for resubmission of Major Assignment Part A

Work on assessments

CHECK YOUR "MY GRADES" ROUTINELY FOR FEEDBACK AND RESUBMISSION REQUIREMENTS
 

1525/05

 CLASS 8.

Assessment consultation and feedback

Spill over pit stop assessments. Feedback / Consultation

Work on assessments

CHECK YOUR "MY GRADES" ROUTINELY FOR FEEDBACK AND RESUBMISSION REQUIREMENTS
 

1601/06

CLASS 9.

Assessment consultation and feedback

ONLINE TEST 2. unsupervised with unlimited attempts. Must be completed by COB Friday of this week.
Deadline for resubmission of Major Assignment Part B

CHECK YOUR "MY GRADES" ROUTINELY FOR FEEDBACK AND RESUBMISSION REQUIREMENTS
 

Please note, it is anticipated that two collaboration sessions will be provided during the course for flexed students. Two sessions have been allocated to your weekly guide above but may be subject to change at the facilitators discretion. In the event that a change is made this will be communicated with students via a Blackboard Announcement at least one week prior to the session. It is the responsibility of the student to have the required technical hardware necessary to participate in these sessions.


Learning Resources

Prescribed Texts


References


Other Resources

No Text has been prescribed for this cluster. All materials will be supplied through Blackboard. PLEASE NOTE: ALL materials for this cluster should be accessed in the ACC5310C Provide Financial & Business Performance Information Blackboard shell only. This shell will serve as the carrier for all three units, you will not need to access the blackboard shells of the other two units making up the cluster.

FOR ONLINE COLLABORATE SESSION, PLEASE ENSURE YOU HAVE JAVE INSTALLED ON YOUR COMPUTER https://java.com/en/download/index.jsp AND A HEADSET AND MICROPHO


Overview of Assessment

Assessment may incorporate a variety of methods including technical requirements documentation, homework, assignments, group and/or individual projects, in class exercises, written and practical tests, problem solving exercises, presentations, direct observation of actual and simulated work practice, presentation of a portfolio of evidence which may comprise documents, and/or photographs and/or video and audio files, review of products produced through work-based or course activities.

Students are advised that they are likely to be asked to personally demonstrate their assessment work to their teacher to ensure that the relevant competency standards are being met. Students will be provided with feedback throughout the course to check their progress
 


Assessment Tasks

1. Time Line

2. Major Assignment Parts A and B

3. Online test 1

4. Online test 2

1. Time Line

A group task, 2 members per group same group members as Major Assignment Part A (below).
When you work in the financial services industry you will be required to complete work within a deadline. In this task learners are required to prepare an action plan related to the Major Assignment Parts A and B assessment tasks (see below) The learner will need to prepare a schedule outlining proposed key dates covering task stage completion and task final completion / submission and report to client. Proposed team and client meeting dates, these will be your pit stops (see below) must also be included in the time plan. The time line will need to allow for contingencies and review of work. This time plan will be used to monitor the learners progress towards completion of the above tasks.
The Pit Stops together with the Time Line prepared by the learner (see above) will be used to formally monitor the learners progress throughout the semester. They will also serve as proxy meetings between service provider (learner) and client (facilitator) These meetings will be used to establish clarification and or modification of relevant client objectives. They will also be used to assess progress vis a vis time plan. Learners are expected to discuss various financial options / processes open to the client, and briefly outline relevant local state and federal regulations particularly salient to the client business.

Part A of the Major Assignment will have two (2) pit stop reviews

Part B of the Major Assignment will have one (1) pit stop review.

To be deemed competent in this task you must do the following:

With due regard to firm policies and client requirements organise a time plan showing the following:
a. Meeting dates (client and team member) are clearly indicated in the time plan
b. Actions / processes along with stage and final completion / submission dates are shown in the time plan
c. Time plan incorporates scheduled review of tasks.
d. The time plan is to be completed using an excel spread sheet

Where required a time plan is adjusted during the semester to cater for client requirement or other contingencies.


2. Major Assignment

Part A

Part A requires students to work in groups of two (2) only.

Part A comprises the completion of a summarised Business Plan and Financials Spread Sheet Model

In the financial services industry you will frequently be approached by various clientele groups requesting information on a wide range of financial / business issues. You will need to provide the client with information which will meet the client’s needs; information which will assist the client in achieving a desired objective.

This task involves completing a Business Plan. Upside Down Ski Club (UDSC) an incorporated association (the client) will provide you, with detailed information of the UDSC ownership / management structure, objectives and operations, together with past financials and an outline of the market segments together with relevant strengths, weaknesses, opportunities and threats. You are to take this information and incorporate it into a business plan.

A significant section of any business plan is the financials. The financials include a forecast Income Statement, Cash Flow Statement and Balance Sheet. You will be creating a spreadsheet model which will generate the forecast financials, which will then be imported into the business plan.

The Business Plan will involve the following.
• Identifying client objectives and incorporate them into the business plan.
• Legislation / regulations local, state or federal applicable to the client / case is incorporated into the business plan.
• Accessing information from the relevant authorities (e.g. Client. Statutory bodies; ATO, ASIC. Financial Institutions; Banks) in order to verify reliability and accuracy of data and correct treatment of that data.
• Complete the financials section of the business plan. This will involve generating an Income Statement (monthly for the year), Balance Sheet, and Cash Flow Statement (monthly for the year) which needs to comply with standard generally accepted accounting principles, practice, and relevant legislative requirements.
• Forecast Income Statement, Balance Sheet, and Cash Flow Statements which comply with client reporting policies.
• Forecast Income Statement, Balance Sheet, and Cash Flow Statements comply with standard generally accepted accounting principles and practice.
• Ensure that where assumptions / parameters are provided by the client, you apply these assumptions to the forecast / financials
• Where no assumptions are provided, you must, on an item needs basis, provide an appropriate assumption to generate a forecast (output).
• Use the spreadsheet to conduct a quantitative trend analysis
• Build an appropriately designed excel spreadsheet model to generate the forecast financial statements for the club
• The spreadsheet must meet client requirements
• Apply the information provided from the client into the business plan and complete the business plan together with the spreadsheet model within the required time frame

Part B

To be completed individually.

Part B continues the dealings with the above client in Part A, and comprises the completion of a spread sheet model (finance plan) and a client report.

This task involves providing the management of UDSC with a plan to finance the proposed refurbishment / capital expansion. The management of UDSC has proposed a multi stage refurbishment of current facilities together with expansion of current building structure over the next five years. The details of the works together with the associated cost and planned stage of works and completion are provided. Given specific objectives you are required to provide the management with a tailored way of financing this venture. Where is the money coming from?

The finance plan and accompanying report will involve the following:

• Identify clearly the clients objectives
• Identify all relevant sources of finance available and limits on those finances
• Provide a recommended funding arrangement for the works which meets the client’s objectives
• Identify and inform on any legislative / contractual restrictions which may apply with relation to funding options
• Inform clients of any legislative / contractual obligations with regard to reporting any changes in funding arrangements to the relevant party / authority.
• Inform client of financing arrangements impact on entity financial stability and profitability.
• Development of a financial model to perform the relevant financial calculations.

3. Online test 1.

The online test will cover the process of completing a workable spread sheet model which abides by best practice principles. The model will then be used to generate a complete set of Pro forma statements (Income Statement, Balance Sheet, and Cash Flow Statement) The model must be capable of utilising client offered objectives and assumptions. The model output will then be used to provide accurate and timely information to the client, this is demonstrated by selection of correct multiple choice option. This is a supervised test.

4. Online test 2.

UDSC is an incorporated association but it could easily also have selected registering as a company limited by guarantee. This online multiple choice short answer test is required to be completed within a designated time through the Black Board, but may be accessed remotely.

The test will cover differences / similarities related to the two entity types, with regards to management; structure; role and duties, member’s liability, applicable legislation relevant overriding statutory authority (to whom is UDSC answerable) under what circumstance would either option be selected, and related obligations with emphasis on Corporations and Consumer Law.



2. Marking Guide for each assessment task

Competency

The assessments have been designed to provide an opportunity for the candidate to demonstrate the required skills and knowledge listed above along with completing the requisite performance criteria. The assessments therefore will provide the vehicle through which evidence will be collected so as to allow the instructor to make a judgement relating to the candidates competency. Competency therefore simply means you are able to apply the the necessary skills and knowledge required and can perform the tasks along with their embedded criteria as outlined by the unit of competency. To put it simply; we are establishing whether you are able to do the job.

All the skills / knowledge and performance criteria espoused by the unit of competency must therefore be covered successfully to achieve competency. It is obligatory that ALL the criteria related to the separate assessment pieces should be completed satisfactorily, but on occasion where not all criteria have been successfully completed in all assessment pieces, as far as specific unit requirements are included in more than one assessment piece then satisfactory completion of a unit requirement in one of the assessment pieces may be adequate. You will receive feedback on each assessment task that will inform you whether you are competent or not and how well you are performing. Once competent in all elements of the unit you receive a competency grading.

Grading

Grading will only apply after a candidate has been able to successfully demonstrate competency. Your grade will be determined by the following formula; 80% of your grade will be determined by the score you achieve in the FIRST attempt of ONLINE TEST 1 the remaining 20% of grading will be based on the application of employability skills, with higher levels of employability skills demonstrated; a higher grade will be awarded, this will largely be determined by your Major Assignment Part A & B.

The employability grading is according to the following criteria:

1. LEVEL OF INDEPENDENCE, INITIATIVE, ENTERPRISE AND PERFORMANCE OF WORK TASK

We are looking for a high level of ability to complete all tasks independently as per the specifications as well as demonstrating a high level of initiative in your approach to your tasks

2. DEMONSTRATED BREADTH OF UNDERPINNING KNOWLEDGE AND A WILLINGNESS TO CONTINUE LEARNING

We are looking for depth of understanding of the key concepts and knowledge required in completing your tasks. You should be able to demonstrate a thorough understanding of all applicable requirements in all the assessment tasks.

3. TECHNIQUES & PROCESSES, TECHNOLOGY SKILLS AND PROBLEM SOLVING

We are looking for appropriate use of technology to assist in presenting all tasks clearly and suitable for the intended audience.
4. WORK ORGANISATION, PLANNING AND SELF MANAGEMENT

We expect to see timely submission of all required assessment tasks.

3. Submission Requirements

Assessment tasks need to be submitted via Blackboard.

You should:

• Ensure that you submit assessments on or before the due date. If your performance in the assessment is affected by unexpected circumstances, you should consider applying for Special Consideration. Information on the process and application forms is available at http://rmit.edu.au/browse;ID=ls0ydfokry9rz website.
• Always retain a copy of your assessment tasks. (hard copy and soft copy)
• When you submit work for assessment at RMIT University you need to use a cover sheet that includes a declaration and statement of authorship. You must complete, sign and submit a cover sheet with all work you submit for assessment, whether individual or group work. On the cover sheet you declare that the work you are presenting for assessment is your own work. An assignment cover sheet for submission of work for assessment is available from the Student forms website.
• Each page of your assessment should include footer with your name, student number, the title of the assessment, unit code and title and page numbers. For example, Julie Macpherson, 324567, Task 2, OHS2345C Ensure safe workplace, Page 1 of 10.

4. Resubmission Arrangements
Candidates will be able to resubmit tasks as required. Unlimited number of resubmissions are allowed up to and including week 16 of the semester unless further weeks are permitted via negotiation with your facilitator. All resubmissions must be uploaded into Blackboard.

5. Feedback Arrangements
Feedback will be provided progressively throughout the semester within the designated pitstop weeks. Assessment will further be provided through the Assessment Evidence Sheet, which will be uploaded onto Blackboard (gradebook) for student perusal
 


Assessment Matrix

Late Submission Procedures
You are required to submit assessment items and/or ensure performance based assessment is completed by the due dates.
If you are prevented from submitting an assessment item on time, by circumstances outside your control, you may apply in advance to your teacher for an extension to the due date of up to seven calendar days.
More Information: http://www.rmit.edu.au/students/assessment/extension
Form to use: http://mams.rmit.edu.au/seca86tti4g4z.pdf
Where an extension of greater than seven days is needed, you must apply for special consideration. Applications for special consideration must be submitted no later than two working days after the assessment task deadline or scheduled examination.
More Information: http://www.rmit.edu.au/browse;ID=g43abm17hc9w
Form to use: http://mams.rmit.edu.au/8a5dgcaqvaes1.pdf

Resubmissions (VET Programs):
If you are found to be Not Yet Competent in a Course Assessment Task you will be allowed one resubmission only. Your teacher will provide feedback regarding what you need to do to improve and will set a new deadline for the resubmission. The highest grade you will receive if your resubmission is successful is “CAG”.
If you are still not meeting the assessment requirements you must apply to your Program Manager in writing outlining the steps you will take to demonstrate competence in your course. Your submission will be considered by the Program Team and you will be advised of the outcome as soon as possible.

Adjustments to Assessment
In certain circumstances students may be eligible for an assessment adjustment. For more information about the circumstances under which the assessment arrangements might be granted please access the following website:
More Information: http://rmit.edu.au/browse;ID=7usdbki1fjf31

Course Overview: Access Course Overview