Functional skills ICT spreadsheet task

This resource I have used many times to help and support students in schools and learners with functional ICT at level 1. Most awarding bodies for functional skills ask for this level of activity during assessment.

Whilst some learners are competent with word processing I have found that spread sheets tend to be the most troublesome, hence the reason for this and many other activities I have created.

The task is based around the learner being able to create a spread sheet and use formula, fill colours, borders, the sum, average, minimum and maximum function to create the desired data results.

In addition the task allows the learner to format the units to currency and percentages and also use absolute cell references within the tables that they create.

The completed task should be clear and easy to understand

The task readily lends itself for the learner to explore the use of different charts and graph to display the information they have created, making use of the various chart wizards depending on which software they use.

Ideally the two sided task can be laminated for future use with learners to reduce printing cost

This task can be added to with additional tasks and activities and scenarios to further develop and explore skills.

The task has been saved into a PDF format for ease of use and printing, I have also added in the completed example using Excel for tutors to use as an example on a whiteboard or smart screen

I hope you enjoy using this resource and find it useful, should you decide to use this please provide feedback on how you found the resource worked with your students, thanks for looking

Regards
Tony