ICT task sheet

A worksheet designed for motor vehicle students studying Functional Skills level 1/2. A spreadsheet activity encouraging them to look up on the internet cost of essential tools they need and then display this in an Excel Spreadsheet. Can be adapted to other industries.

Covers:

• formula
• average
• formatting
• % discount
• adding charts

Completing these challenges will help students to create a basic PowerPoint that runs automatically and provides evidence through printed handouts.

ITQ Learning outcomes covered: 1.1 1.3 1.6 2.3 2.4 3.2 3.3

Editor's note

I think the learning outcomes quoted above relate to the OCR ICT Award  (or similar) but this beautifully clear, step by step task sheet is ideal for any Level 1-2 ICT course.

An exercise in Microsoft Word built around the content of a HR article from:
https://www.consultancy.uk/services/hr-consulting

Editor’s note
Three separate step by step activities cover paragraph formatting, working with tables, and pictures/objects.

A task sheet for L1 Functional Skills ICT. It focuses on Task 3 of the Edexcel exam paper which involves being creative and producing a document that uses clear presentation features and is fit for purpose.
Includes two tasks (a restaurant menu and a flyer for a student production) plus a short extension.

This is an Excel file with a basic odd/even activity. I took inspiration from Jean Thomas’ “Reveal the hidden shapes!” activity from 2005.

With this activity, the tutor can design a picture (or one learner can design a picture for another learner) and it produces a printable sheet. The learner then shades all the odd numbers on the sheet in one colour, and all the even numbers in a different colour – revealing a picture or a message.

There are no macros, so cross-compatibility with Excel shouldn’t be a problem.

How to format and plan a formal letter or email for English functional skills.
Word document / template.

Editor’s note
Two very useful editable Word documents – one for a letter, one for an email.
[5/12/17] Minor edits to the formal letter template

A word processing activity which involves typing and formatting and also contains useful information.

The idea is that the learners digest the text that they are working with and learn from it. I would put it at about level E2/3.

Literacy – aimed at Level 1-2 and links to imaginative writing at GCSE.
Quirky fun starter – find your pirate name. This can be done on mobile phones if there are no PCs.
Comprehension tasks.
After finding the King’s shilling, write descriptive letter home.

Set of resources created by myself and colleague, David Bayne , to help students use Word, Excel and Access. We wanted students to practise for the Level 2 ICT Functional Skills exams, using a method that would be familiar to them. They all drive cars and need to get them serviced, so this seemed a suitable area to use.

Simulation of completing an online CV. Very easy to use, fill in the boxes and print after completion.