ICT task sheet

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

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 
Level
L2
ESOL
General ESOL
ICT
Using ICT
Finding and selecting information
Developing, presenting and communicating information
Charts & graphs
Context
Faith & Religion

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
Level
L1
ESOL
General ESOL
ICT
Using ICT
Finding and selecting information
Developing, presenting and communicating information
Charts & graphs
Context
Faith & Religion

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
Level
L1
L2
ICT
Developing, presenting and communicating information
Finding and selecting information
Context
Motor vehicles & Transport

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 place value <1000, odd / even, count in 10s /100s
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