ICT task sheet

Instructions or guidance for creating documents, tables, spreadsheets, etc.

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.

Level
L1
L2
ICT
Finding and selecting information
Developing, presenting and communicating information
Level 1 and 2 CLAIT / ECDL
Context
Art Film Media Music TV

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.

Level
L2
L1
ICT
Level 1 and 2 CLAIT / ECDL
Developing, presenting and communicating information
Functional ICT
Context
Business & Money management

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.

Level
L1
ICT
Developing, presenting and communicating information
General ICT resources
Context
Catering Food Nutrition
Art Film Media Music TV

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.

Level
E2
E3
Maths
FM Context free underpinning
FM E2.3 Recognise and sequence odd and even numbers up to 100
AN N1/E3.1
AN N1/E2.2
AN N1/E2.1

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

Level
L2
L1
English
Functional English - writing
Wt/L2.1
Wt/L1.1

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.

Level
E3
E2
ICT
Functional ICT

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.

Level
L2
L1
English
Functional English - writing
Functional English - reading
ICT
Finding and selecting information
Context
History

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.

Level
L2
ICT
Functional ICT
Context
Motor vehicles & Transport

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

Level
E2
E3
L1
L2
English
Functional English - writing
Functional English - reading
Form filling
General literacy / English
ICT
Functional ICT
General
Generic resources for literacy, numeracy and beyond
Context
Employment skills & Public services

Simulations of email and online banking registration forms. Can be used in succession, as for the banking registration form you need an email address. When you press the “create account” button it will open the printing menu. Good luck!

Level
E2
E3
English
Functional English - writing
Rw/E3.2
Functional English - reading
Form filling
Maths
MSS1/E2.3
ICT
Entry 3 ICT
Using ICT
Entry 1 and 2 ICT
Context
Employment skills & Public services