This unit covers creating and using simple spreadsheets and charts through the use of spreadsheet software. This unit is related to BSBCMN107A Operate a personal computer and BSBCMN108A Develop keyboard skills.
Tips for gathering evidence to demonstrate your skills
The important thing to remember when gathering evidence is that the
more evidence the better - that is, the more evidence you gather to
demonstrate your skills, the more confident an assessor can be that you
have learned the skills not just at one point in time, but are
continuing to apply and develop those skills (as opposed to just
learning for the test!). Furthermore, one piece of evidence that you
collect will not usualy demonstrate all the required criteria for a
unit of competency, whereas multiple overlapping pieces of evidence
will usually do the trick!
The Evidence Guide identifies the critical aspects, knowledge and skills to be demonstrated to confirm competency for this unit. This is an integral part of the assessment of competency and should be read in conjunction with the Range Statement. Critical Aspects of Evidence · Integrated demonstration of all elements of competency and their performance criteria · Design appropriate to type and use of spreadsheet · Use of cell-based formulae Underpinning Knowledge* *At this level the learner must demonstrate basic operational knowledge in a moderate range of areas. · The relevant legislation from all levels of government that affects business operation, especially in regard to Occupational Health and Safety and environmental issues, equal opportunity, industrial relations and anti-discrimination · Knowledge of the purpose and ranges of uses of spreadsheet's functions · Organisational requirements for ergonomic standards, work periods and breaks, and conservations techniques · Organisational guidelines on spreadsheet manipulation and processing · Format of workplace documents Underpinning Skills · Computer literacy · Keyboarding skills · Literacy skills in relation to spelling correctly · Numeracy skills in relation to creating and using spreadsheet formulae · Communication skills to interpret instructions · Ability to relate to people from a range of social, cultural and ethnic backgrounds and physical and mental abilities Resource Implications · The learner and trainer should have access to appropriate documentation and resources normally used in the workplace · These may include: · workplace reference materials such as style guides · computer equipment with spreadsheet software · English dictionary Consistency of Performance In order to achieve consistency of performance, evidence should be collected over a set period of time which is sufficient to include dealings with an appropriate range and variety of situations: Eg dealing with different office requirements, different types of data, different types of spreadsheets and over a period of time to ensure that situational variables are consistently achieved Context/s of Assessment · Competency is demonstrated by performance of all stated criteria, including paying particular attention to the critical aspects and the knowledge and skills elaborated in the Evidence Guide, and within the scope as defined by the Range Statement · Assessment must take account of the endorsed assessment guidelines in the Business Services Training Package · Assessment of performance requirements in this unit should be undertaken in an actual workplace or simulated environment · Assessment should reinforce the integration of the key competencies and the Business Services Common Competencies for the particular AQF Level. Refer to the Key Competency Levels at the end of this unit Key Competency Levels
· Collecting, analysing and organising information (Level 1) to determine the most appropriate spreadsheet format · Communicating ideas and information (Level 1) through the production of an effective spreadsheet · Planning and organising activities (Level 1) to determine formulae and input data · Working with teams and others (Level 1) to determine spreadsheet and printing requirements · Using mathematical ideas and techniques (Level 2) while using formulae in the spreadsheet · Solving problems (Level 2) using manuals and on-line help · Using technology (Level 2) to create and use spreadsheets Please refer to the Assessment Guidelines for advice on how to use the Key Competencies