BSBITU402: Develop and Use Complex Spreadsheets | Assignment
47 Pages8218 Words95 Views
Added on 2019-09-27
BSBITU402: Develop and Use Complex Spreadsheets | Assignment
Added on 2019-09-27
ShareRelated Documents
ContentASSESSMENT TOOL OUTLINECourse Name:Certificate IV in Business AdministrationCourse Code:BSB40515Unit Name:Develop and Use Complex SpreadsheetsUnit Code:BSBITU402BSBITU402–Develop and Use Complex Spreadsheets Version 2:0 updated 17/06/2016 Page 1 of 47
BSBITU402–Develop and Use Complex Spreadsheets Version 2:0 updated 17/06/2016 Page 2 of 47ContentsSection 1 - Student’s Information..............................................................................................................................2Section 2 - Assessment Matrix...................................................................................................................................7Section 3 : Assessment Cover Sheet........................................................................................................................13Assessment Instructions...........................................................................................................................................15Section 4: Assessment Task......................................................................................................................................16Part A – Written Questions.......................................................................................................................................16Part B – Project Activity............................................................................................................................................25Part C – Project Activity............................................................................................................................................34Section 5: Student Feedback on unit.......................................................................................................................44
Zenith Business AcademyLevel 7, 399 Lonsdale Street, Melbourne VIC 3000Telephone: 03 9603 5300 www.zba.nsw.edu.au, email: studentservices@zba.edu.auCRICOS Provider Code 02997MSection 1 - Student’s InformationIntroductionThis assessment tool relates to the following unit of competency of BSBITU402 Develop and UseComplex Spreadsheets. The delivery and assessment of this unit will be conducted over a period of 40hours face to face training. Unit descriptorsBSBITU402: Develop and Use Complex Spreadsheets’This unit describes the performance outcomes, skills and knowledge required to use spreadsheet softwareto complete business tasks and to produce complex documents.This unit applies to individuals employed in a range of work environments that require skills in the creationof complex spreadsheets to store and retrieve data. They may work as individuals providing administrativesupport within an enterprise, or may be independently responsible for designing and working withspreadsheets relevant to their own work roles.Licensing/Regulatory InformationNot applicable.Pre-RequisitesNot applicable.BSBITU402–Develop and Use Complex Spreadsheets Version 2:0 updated 17/06/2016 Page 3 of 47
Zenith Business AcademyLevel 7, 399 Lonsdale Street, Melbourne VIC 3000Telephone: 03 9603 5300 www.zba.nsw.edu.au, email: studentservices@zba.edu.auCRICOS Provider Code 02997MInstructions to studentsThe strategies used in gathering evidence for these units in the qualifications including a clusteredassessment for BSBITU402 – Develop and Use Complex Spreadsheets:DemonstrationProject/ActivitiesKnowledge TestOutcomes of the Assessment:After completion of this assessment tool student will be able to:1.Prepare to develop spreadsheet2.Develop a linked spreadsheet solution3.Automate and standardize spreadsheet operation4.Use spreadsheets5.Represent numerical data in graphic formInstruction for Assessments Submission:If you do not understand any part of the unit or the assessments you are required to undertake, please talkwith your trainer or with the course coordinator. It is important that you understand all of the critical aspectsof the learning and assessment process that you will be undertaking. This will make it easier for you tolearn and successfully progress in your studies.To be able to be marked competent (pass) in any unit you must:Submit all pieces of assessable work. If you do not submit any work, you will be unable to gaincompetency (pass)Submit all work on or before the due date. Any work submitted after the due date, without anapproved extension will be unable to gain competencyAny work submitted after term will not be marked and you will be assessed as not yet competent(not passed).All work is to be done to a high quality in terms of both presentation and content. This includescorrect referencing, grammar, punctuation and name/student number placed in either header orfooter.If you hand in your work to your trainer and it is not yet competent (not passed) you have one furtheropportunity to resubmit. Your trainer will advise you of new submission date and the areas of improvementto be made.If you are found cheating, you will automatically get a not yet competent on your assessment. If you arefound to have cheated, copied work from others either in class or during assessment, you will either toBSBITU402–Develop and Use Complex Spreadsheets Version 2:0 updated 17/06/2016 Page 4 of 47
Zenith Business AcademyLevel 7, 399 Lonsdale Street, Melbourne VIC 3000Telephone: 03 9603 5300 www.zba.nsw.edu.au, email: studentservices@zba.edu.auCRICOS Provider Code 02997Mrepeat the unit or be given a new reassessment task. You will be reported for this action and you may alsohave to pay a financial penalty.Cheating is where any students use:·Notes in a test·Copies another person’s work·Use unauthorized material in testYou must write your work in your own words, you are being assessed on your own thoughts andknowledge. All work is to be typed and handed directly to your trainer. You have to attach a completedassignment sheet to your work that clearly shows your name and your student Id number as well as yourtrainer’s name. Please keep a copy of any work you submit. It is your responsibility to re – submit any work requested atany time. The Zenith Business Academy takes no responsibility for work that cannot be located.You do have the right to appeal any assessment decision made by the Zenith Business Academy trainer ifyou:·Believe that the assessment is invalid and /or·Feel that the process was invalid, inappropriate or unfair.You will find an overview of this unit in the assessment matrix below and this will help you to develop andunderstand how this unit will run over the period of the weeks. The assessment matrix will give you anopportunity to:Check your progressApply the skills you have learnt during the training sessionsGather evidence to achieve the competency in this unitIn order to demonstrate your employability skills that underpin all job roles, through the set of foundation skills that are essential if learners are to participate successfully in work and be valuable and productive employees. These skills are identified as: learningreadingwritingoral communicationnumeracyBSBITU402–Develop and Use Complex Spreadsheets Version 2:0 updated 17/06/2016 Page 5 of 47
Zenith Business AcademyLevel 7, 399 Lonsdale Street, Melbourne VIC 3000Telephone: 03 9603 5300 www.zba.nsw.edu.au, email: studentservices@zba.edu.auCRICOS Provider Code 02997Mnavigating the world of workinteracting with othersgetting the work done.These foundation skills are embedded in the unit of competency (and sometimes explicitly identified). Youwill need to take time to analyse the unit of competency to identify where particular foundation skills areevident.You must demonstrate in your assessment task the Critical aspects for assessment and evidence requiredto demonstrate competency in this unit.BSBITU402–Develop and Use Complex Spreadsheets Version 2:0 updated 17/06/2016 Page 6 of 47
Zenith Business AcademyLevel 7, 399 Lonsdale Street, Melbourne VIC 3000Telephone: 03 9603 5300 www.zba.nsw.edu.au, email: studentservices@zba.edu.auCRICOS Provider Code 02997MOverview of assessment requirementsTo achieve competency in this unit, a person must be able to demonstrate the required knowledge in these areas: Performance EvidenceEvidence of the ability to:follow organisational and safe work practices including:ergonomic requirementsenergy and resource conservation techniquesadhere to organisational requirements for:ensuring consistency of style, design and layoutsaving and printing documents within designated timelinesnaming and storing documentsadhere to identified or task requirements when producing documents including:editing macros and automating some tasksusing appropriate templatescreating graphs to represent dataresolve issues by referring to user documentation and online helpuse appropriate data storage optionsevaluate tasks to improve efficiencyapply knowledge of functions and features of contemporary computer applicationscommunicate with relevant personnel.Note: If a specific volume or frequency is not stated, then evidence must be provided at least once.Required knowledgeTo complete the unit requirements safely and effectively, the individual must:explain advanced functions of spreadsheet software applicationsdescribe impact of formatting and design on presentation and readability of dataexplain organisational requirements for ergonomics, work periods and breaks, and conservation techniques.BSBITU402–Develop and Use Complex Spreadsheets Version 2:0 updated 17/06/2016 Page 7 of 47
Zenith Business AcademyLevel 7, 399 Lonsdale Street, Melbourne VIC 3000Telephone: 03 9603 5300 www.zba.nsw.edu.au, email: studentservices@zba.edu.auCRICOS Provider Code 02997MSection 2 - Assessment MatrixUnit NameDevelop and Use Complex SpreadsheetsUnit CodeBSBITU402Qualification NameCertificate IV Business AdministrationQualification CodeBSB40515Assessment InstrumentsABCWritten QuestionsProject ActivityProject Activity EvidenceElements/Performance CriteriaABC1.Prepare to develop spreadsheet1.1.Organise personal work environment in accordance with ergonomic requirements1.2.Analyse task and determine specifications for spreadsheets1.3.Identify organisational and task requirements in relation to data entry, storage, output, reporting and presentation requirements1.4.Apply work organisation strategies and energy and resource conservation techniques to plan work activities2.Develop a linked spreadsheet solution2.1.Utilise spreadsheet design software functions and formulae to meet identified requirements2.2.Link spreadsheets in accordance with software procedures2.3.Format cells and use data attributes assigned with relative and/or absolute cell references, in accordance with the task specifications2.4.Test formulae to confirm output meets task requirements3.Automate and standardise spreadsheet operation3.1.Evaluate tasks to identify those where automation would increase efficiency3.2.Create, use and edit macros to fulfil the requirements of the task and automate spreadsheet operation3.3.Develop, edit and use templates to ensure consistency of design and layout for forms and reports, in accordance with organisational requirements4.Use spreadsheetsBSBITU402–Develop and Use Complex Spreadsheets Version 2:0 updated 17/06/2016 Page 8 of 47
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents
DFP Module 2 Assignment Submission Instructions and Activitieslg...
|27
|5551
|272
DFP Module 2 Assignment Submission Instructions and Assessment Activitieslg...
|26
|5678
|159
DFP Module 2 Workplace Simulation Assessment Instructionslg...
|31
|5105
|201
DFP Module 2 Workplace Simulation1703lg...
|32
|5026
|389
BSBITU402 Develop and Use Complex Spreadsheets - Assessment Task 1lg...
|14
|4542
|159
BSBPMG530 - Manage Project Scope Assessment Workbooklg...
|69
|11580
|226