ICT Resources

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. 

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 

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

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.

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.

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.

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.

A lovely, very topical set of Functional Skills tasks about the UK digital TV switchover that began in 2009 and finishes in 2012.

The task sheet covers reading comprehension, research, and ICT skills such as finding and selecting information, saving and printing files.

An E3-L1 Functional Maths, English and ICT task first used with learners at Leyton Orient Community Sports Programme. Plan and cost a restaurant meal for 20 officials (originally held at Frank and Benny’s, Chingford, but you will need to provide menus from a favourite local restaurant or chain) and then present your results in a spreadsheet..

Super set of three ICT task sheets that successfully embed Functional ICT, Functional English and even some Functional Maths!
Each task sheet involves composing, sending and replying to work-based emails: based in a dental surgery, a health centre and a travel agency.
Please also download the separate, very detailed, Functional Skills mapping document which includes differentiation ideas, teaching tips and embedding ideas.