ICT task sheet

This resource covers what is expected at the Entry 1 ICT Functional Skills exam. It follows the structure of an exam paper.  An E2 version is also available.

I based in it on a Skillsworkshop English resource by Isabel Jordan.

Editor's note

Super practice for Entry Level 1 ICT. I love it when skillsworkshop users adapt and recycle existing resources. :) You can find the E2 version of this resource, along with Isabel Jordan's original Pavement Plants Functional English resources under "See Also".

This resource covers what is expected at the Entry 2 ICT Functional Skills exam. It follows the structure of an exam paper.  An E1 version is also available.

I based in it on a Skillsworkshop English resource by Isabel Jordan. 

Editor's note

Super practice for Entry Level 2 ICT. I love it when skillsworkshop users adapt and recycle existing resources. :) You can find the E1 version of this resource, along with Isabel Jordan's original Pavement Plants Functional English resources under "See Also".

British Values project based on ICT Level 2 City and Guilds covering all content including

• Task 1 - Internet Research, Word
• Task 2 - Excel IF / AND, charts, formatting, formulae,  etc
• Task 3  - PPT with images, animation, etc.
• Task 4 -  Mail Merge (needs memo.txt and employees.txt - see below)
• Task 5 - Word, poster
• Task 6  - Access database (needs training.txt file - see below)
• Task 7 -  General ICT  Knowledge 

ICT Project about British Values - based on City & Guilds Level 1 Functional ICT assessments.

• Task 1 - Internet research and copying and pasting
• Task 2 - Excel activity - including formula, adding a chart, formatting
• Task 3 - PowerPoint activity - adding slides, animation, images etc.
• Task 4 - Create a poster on Word
• Task 5 - Databases - sort and filter 
• Task 6 - General ICT Knowledge

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