Unit Award Scheme

122354 CREATING SPREADSHEETS AND GRAPHS (UNIT 2)

In successfully completing this unit, the Learner will have		Evidence needed
demonstrated the ability to
1	insert and align at least two pieces of text and numerical data	Student completed work
2	insert at least two headers and footers including automatic fields, eg filename, date and time, page number	Student completed work
3	use at least two formulae and basic functions that produce correct results, eg sum, average, brackets	Student completed work
4	insert and delete at least two rows and columns	Student completed work
5	format at least two pieces of numerical data, eg to display in an integer, to two decimal places, to display a currency symbol	Student completed work
6	set the page layout, eg margins, page size, page orientation	Student completed work
7	print the spreadsheet showing the data, formulae, gridlines, column and row headings	Student completed work
8	select at least two data sets to create a graph distinguishing between pie charts, line graphs, bar and column charts and comparative graphs	Student completed work
9	use common formatting and alignment techniques in at least two graphs and charts, eg axes titles, data labels, a legend	Student completed work
10	print the graph on a sheet separate to the data source.	Student completed work

All outcomes recorded on an AQA Summary Sheet

Approved 30 October 2024Level - Level One