100%(1)1 out of 1 people found this document helpful
This preview shows page 2 - 4 out of 17 pages.
requirements and exit application without data loss/damage4.4 Print and present document according to requirementsBSBITU402 Develop and use complex spreadsheets1.1 Organise personal work environment in accordance with ergonomic requirements1.2 Analyse task and determine specifications for spreadsheets1.3 Identify organisational and task requirements of data entry, storage, output, reporting and presentation requirements1.4 Apply work organisation strategies and energy and resource conservation techniques to plan work activities2.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 task specifications2.4 Test formulae to confirm output meets task requirements3.1 Evaluate tasks to identify those where automation would increase efficiency3.2 Create, use and edit macros to fulfil requirements of 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 requirementsHM_ICT Business Documents Assessment I_v2, Last Updated 29/06/19 Page 2of 17
T-22.214.171.124 Enter, check and amend data in accordance with organisational and task requirements4.2 Import and export data between compatible spreadsheets and adjust host documents, in accordance with software and system procedures4.3 Use manuals, user documentation and online help to overcome problems with spreadsheet design and production4.4 Preview, adjust and print spreadsheet in accordance with organisational and task requirements4.5 Name and store spreadsheet in accordance with organisational requirements and exit application without data loss or damage5.1 Determine style of graph to meet specified requirements and manipulate spreadsheet data if necessary to suit graph requirements5.2 Create graphs with labels and titles from numerical data containedin a spreadsheet file5.3 Save, view and print graph within designated timelinesAssessment / evidence gathering conditionsEach assessment component is recorded as either Competent (C) or Not Yet Competent (NYC). A student can only achieve competence when all assessment components listed under “Purpose of the assessment” section are recorded as competent. Your trainer will give you feedback after the completion of each assessment. A student who is assessed as NYC (Not Yet Competent) is eligiblefor re-assessment.Resources required for this AssessmentAll documents must be created in Microsoft Word/ Excel and powerpointUpon completion, submit the assessment printed copy to your trainer along with assessment coversheetRefer to the notes on eLearning to answer the task/sAny additional material will be provided by your TrainerComputer with relevant software applications and access to interneteLearning notes relevant to the tasks/questionsInstructions for Students