ICT Resources

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. 

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

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.

This is a set of worksheets in a MS Excel workbook that deals with fractions.
- Sheet one: a set of pictures (pie charts) that shows fractions from halves to tenths
- Sheet two: equivalent fractions with two pie charts, learners can input fractions and see if they are equivalent by looking at the shape of the pie charts
- Sheet three: starting to look at fractions being equivalent to decimals with two pie charts one for fractions and one for decimals

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.

I have created a paper based initial assessment for ICT to identify if students should be working towards Level 1 or Level 2.

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]

Practice some of the skills needed for ICT Functional skills and also a bit of fun. Can be used individually, in pairs or groups. Two lots of 15 questions with fill-in answersheet attached.

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.