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

+13062052269

info@desklib.com

Salary Compared to Age and Years Experience

Contribute Materials