ICT 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 

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

This is a scheme of work I have used in EBD schools to get the pupils engaged with English. It is a 7 week scheme of work aimed at between E3-L2, as it can be differentiated. I have also included the lesson plans that go with the scheme.

Editor’s note
Although written for a Key Stage 3/4 school setting this would work well as a way of embedding Functional English into a vocational childcare course or a family learning situation.

First used with a group of E1-E2 numeracy students who had done an ICT based project involving cookery work and visiting a cafe to buy a snack. Print on A4 and fold into a very nice A5 leaflet.
The self assessment check boxes focus on basic money skills (recognising coins, giving change – but also slecting items from a list, weighing, etc.) but there is also the opportunity to link learning to numeracy at home or at college. Ideal for Entry Functional maths / catering / hospitality students.