Level 3 Diploma in Accounting: Spreadsheet Software

Department of Business Services

Level 3 Diploma in Accounting

Spreadsheet Software

Tutor: Sue Davies

Spreadsheet Software

This unit is about the learner having the ability to use a software application designed to record data in rows and columns, perform calculations with numerical data and also present the information using charts and graphs.

Assessment Method

This unit is assessed through the completion of a Computer Based Assessment which is set centrally and assessed by the AAT.

The assessment is approximately 1 hour and 30 minutes.

Part 1 contains several short written tasks which must be completed in one session

Part 2 consists of an assignment asking the learner to input data into a spreadsheet and produce charts

Part 3 contains two multiple choice questions

The purpose of the assessment is to allow the learner to demonstrate the skills and knowledge necessary to use spreadsheet software at level 3.

For the purpose of assessment the competency level for AAT assessment is set at 70%.

Learning Outcomes

1. Use a spreadsheet to enter, edit and organise numerical and other data

C Identify what numerical and other information is needed in the spreadsheet and how it should be structured

C Enter and edit numerical and other data accurately

C Combine and link data from different sources

C Store and retrieve spreadsheet files effectively in line with local guidelines and conventions where available

2. Select and use formulas and data analysis tools and techniques to meet requirements

C Explain what methods can be used to summarise, analyse and interpret spreadsheet data and when to use them

C Select and use a wide range of appropriate functions and formulas to meet calculation requirements

C Select and use a range of tools and techniques to analyse and interpret data to meet requirements

C Select and use forecasting tools and techniques

3. Use tools and techniques to present and format and publish spreadsheet information

C Explain how to present and format spreadsheet information effectively to meet needs

C Select and use appropriate tools and techniques to format spreadsheet cells, rows, columns and worksheets effectively

C Select and use appropriate tools and techniques to generate, develop and format charts and graphs

C Select and use appropriate page layout to present, print and publish spreadsheet information

C Explain how to find and sort out any errors in formulas

C Check spreadsheet information meets needs using IT tools and making corrections as necessary

C Use auditing tools to identify and respond appropriately to any problems with spreadsheets

Rights and Responsibilities

Rights / Responsibilities
We all have rights: / We all have responsibilities:
· To feel safe and comfortable / · To help others feel safe and secure
· To be treated with respect and fairness / · To treat others with respect and consideration for their learning and at all times
· To learn and teach without interruptions / · To allow pupils to learn and teachers to teach without causing distractions
· To communicate and be listened to / · To listen to others and value their contributions and respect their opinions
· To work in a pleasant environment with all facilities and equipment that are in good condition / · To look after the college buildings and grounds, facilities and equipment

Class Rules

1 Arrive on time for lessons with the correct equipment and ready to start work.

2 Concentrate fully when the teacher is explaining something or giving instructions.