ICT Resources

Displaying 1 - 10 of 17 resources:

Checklist designed to support delivery of Gateway's EDSQ (Essential Digital Skills Qualification) E3 and L1. This list allows learners, and staff, to rate their confidence with each element of the qualification at each unit (1-5). 

Editor's notes

An essential piece of kit for those embarking on EDS teaching. Love the 4 tier "traffic light" system. Written for Gateway but useful for all awarding bodies.

 

Level
Entry Level 3
Level 1
Level 2
English
Functional Skills English
ICT
EDS: Using devices & handling information
EDS: Creating & editing
EDS: Communicating
EDS: Transacting
EDS: Being safe & responsible online

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

Rugby themed task on reading (use of quotations and dialogue, facts versus opinions), researching and writing a short article. Topic links to ICT, suitable for use during e.g. Rugby World Cup, Six Nations Tournament or with any group keen on sport![img_assist|nid=5708|title=|desc=|link=popup|align=left|width=100|height=71]

Level
Entry Level 3
Level 1
Level 2
English
Functional English - speaking, listening & communicating
Functional English reading
Functional English - writing
General literacy / English
ICT
Functional Skills ICT: Developing, presenting and communicating information
Entry 3 ICT
Functional Skills ICT: Finding and selecting information
General ICT resources
Functional Skills ICT: Using ICT
Context
Sport and fitness
Electrical, Electronics & Technology

Mean, Mode, Median and Range: Investigation into house prices.

Students use www.rightmove.co.uk to explore house prices in areas of their choice. For example pairs of students could explore house prices in different cities in the UK.

They will need access to computers. You will also need to establish criteria before they start to collect their data so that like for like houses are being compared. For example all of the groups are to compare prices of 2 bedroom flats in the cities of their choice.

Level
Level 2
Level 1
Maths
HD1/L2.4
HD1/L2.3
HD1/L1.4
HD1/L1.3
Functional Maths - handling information and data
ICT
Functional Skills ICT: Finding and selecting information

Students design a board game to demonstrate their learning. This can incorporate IT skills (Word template provided below) or can be done with paper, card and pens.

I originally did this with an E2E group and it proved popular. It’s an alternative to the “design a poster” task to review learning. The instructions are set out as a board game. it can be used for literacy, numeracy, ICT or ESOL.

Level
Entry Level 2
Entry Level 3
Level 1
Level 2
English
General literacy / English
Functional Skills English
Maths
General numeracy / maths
Functional Maths
ESOL
General ESOL
ICT
Functional ICT
General
Generic resources for literacy, numeracy and beyond

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 and fitness

A demonstration of how not to make a PowerPoint. This has been used for all levels as an extreme example of the worst PowerPoint ever.

Level
Level 2
Level 1
Entry Level 3
ICT
Functional Skills ICT: Developing, presenting and communicating information
General ICT resources
General
Study Skills and General Teaching

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

Lovely classroom display that will help learners define and understand the function of 20 common Excel toolbar buttons.

Level
Level 2
Level 1
Entry Level 3
ICT
Level 1 and 2 CLAIT / ECDL
General ICT resources
Functional ICT