ICT Resources

Displaying 1 - 10 of 16 resources:

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
Level 2
ESOL
General ESOL
ICT
Functional Skills ICT: Using ICT
Functional Skills ICT: Finding and selecting information
Functional Skills ICT: 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
Level 1
Level 2
ICT
Functional Skills ICT: Developing, presenting and communicating information
Functional Skills ICT: 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
Level 1
Level 2
ICT
Functional Skills ICT: Finding and selecting information
Functional Skills ICT: Developing, presenting and communicating information
Level 1 and 2 CLAIT / ECDL
Context
Art Film Media Music Radio 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
Level 2
Level 1
ICT
Level 1 and 2 CLAIT / ECDL
Functional Skills ICT: Developing, presenting and communicating information
Functional ICT
Context
Business & Money management

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
Level 2
Level 1
English
Functional English - writing
Functional English reading
ICT
Functional Skills ICT: Finding and selecting information
Context
History, culture, museums, libraries

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
Level 2
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
Entry Level 2
Entry Level 3
Level 1
Level 2
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

Learners must choose the next manager of the England football team. Using the task sheet to guide them, they must research, collate and present information for five candidates and then make the final choice.

There is scope for plenty of lively discussion around the choices made and also about what the manager’s job entails.

A Power Point presentation is included as an example, but can also be printed out to use in some of the additional activities described.

Level
Entry Level 3
Level 1
Level 2
English
General literacy / English
Functional Skills English
ICT
Functional Skills ICT: Developing, presenting and communicating information
Functional Skills ICT: Finding and selecting information
General
Generic resources for literacy, numeracy and beyond
Context
Sport

Here is another Level 1-2 variant on the classic ‘Smarties’ investigation which incorporates the use of a PC and Excel. I stopped using Smarties and Skittles because of the health and hygiene issues.

Level
Level 2
Level 1
Maths
Averages and range
Collect organise represent
Functional Maths - handling information and data
ICT
Functional Skills ICT: Developing, presenting and communicating information

[img_assist|nid=4821|title=|desc=|link=popup|align=left|width=68|height=100]Two resources that can be used together or independently.

  • An ICC / Literacy / Functional English / ESOL research project task sheet on “My favourite British animal”. E3-L2 reading, writing and ICT
  • A basic animal anatomy vocabulary sheet for E2-E3 ESOL (paw, claw, antler, etc.)

For more of Kathy’s animal resources go to ‘see also’ below. (Birds of Prey resources)

Level
Entry Level 2
Entry Level 3
Level 1
Level 2
English
General literacy / English
Functional Skills English
ESOL
General ESOL
ESOL Rw/E3.1a Recognise and understand relevant specialist key words
ESOL Rw/E2.1a Recognise words on forms related to personal information
ICT
Functional ICT
Context
Animals, animal care, farming & equine