Spreadsheet Applications

Reference

M/618/2890

Level

Level 1

Credit Value

Guided Learning Hours

Aim

This unit is about using spreadsheet applications to create and manipulate worksheets for a range of purposes which could include education, entertainment, information sharing or work.

The learner will use spreadsheets to enter, edit and organise information. They will use a range of formulas, tools and techniques to summarise, display and present information effectively.

Assessment guidance and/or requirements

LO 2 Formulas may include but is not limited to: SUM, AVERAGE, COUNT, MEDIAN, MIN, MAX etc. Additionally at this level the learner should be able to use the SUM function for subtraction.
LO 2 and LO 3 Spreadsheets should ‘meet requirements’ such as those set out by customers both internal and external or the requirements of the task as set by the tutor/assessor.