Functional Skills ICT: Finding and selecting information

Update 24/2/22: written by Sharon Roberts and Alexandra Bates, both of Essex ACL. 
This is a fun activity which encourages ESOL learners to engage with digital technology and transacting online. It provides opportunity to explore vocabulary related to shopping while also discussing the advantages of shopping for food online. It can be adapted to all levels and can be extended for a longer activity if required.

Editor's note

Update 24/2/22: written by Paula Fulton and Alexandra Bates, both of Essex ACL. 
A fun activity for ESOL learners which draws on the popularity of the online word guessing game, Wordle.

Editor's note

A complete mini-lesson for ESOL or Functional English! Introductory PPT and a detailed and very useful lesson plan. A great way to integrate spelling strategies with basic ICT skills. Includes discussion about the 26 letters but 44 phonemes of the English language. 

A very useful handout for Entry Level ESOL and/or Functional Skills ICT students. Step by step, illustrated instructions on how to create a basic PPT.

The basic PPT used in the handout images is also provided. This can be adapted by the teacher or (optionally) given to learners to adapt. 

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

Fourteen questions related to Remembrance Day (topics include WW1, WW2 ration books,  Korean War, war poetry, etc.). Use as a traditional paper-based quiz or an IT based investigation. Learners could work individually or in teams / small groups. One way of approaching the quiz would be to see what the class as a whole can answer from their general knowledge befor

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.