View Unit : Spreadsheet Software

Unit

Unit Reference Number

A/502/4624

Qualification Framework

QCF

Title

Spreadsheet Software

Unit Level

Level 1

Unit Sub Level

None

Guided Learning Hours

Unit Credit Value

Date of Withdrawal

SSAs

6.2 ICT for Users

Unit Grading Structure

Pass

Assessment Guidance

See IT User Assessment Strategy available from www.e-skills.com

Learning Outcomes and Assessment Criteria

Learning Outcome - The learner will:		Assessment Criterion - The learner can:
1	Use a spreadsheet to enter, edit and organise numerical and other data	1.1	Identify what numerical and other information is needed and how the spreadsheet should be structured to meet needs
		1.2	Enter and edit numerical and other data accurately
		1.3	Store and retrieve spreadsheet files effectively, in line with local guidelines and conventions where available
2	Use appropriate formulas and tools to summarise and display spreadsheet information	2.1	Identify how to summarise and display the required information
		2.2	Use functions and formulas to meet calculation requirements
		2.3	Use spreadsheet tools and techniques to summarise and display information
3	Select and use appropriate tools and techniques to present spreadsheet information effectively	3.1	Select and use appropriate tools and techniques to format spreadsheet cells, rows and columns
		3.2	Identify which chart or graph type to use to display information
		3.3	Select and use appropriate tools and techniques to generate, develop and format charts and graphs
		3.4	Select and use appropriate page layout to present and print spreadsheet information
		3.5	Check information meets needs, using spreadsheet tools and making corrections as necessary

Equivalent Units

There are no equivalences to display.