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 

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

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

Set of resources created by myself and colleague, David Bayne , to help students use Word, Excel and Access. We wanted students to practise for the Level 2 ICT Functional Skills exams, using a method that would be familiar to them. They all drive cars and need to get them serviced, so this seemed a suitable area to use.

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]

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.

This is a fabulous board game created as a fun and gentle introduction to L1-2 Functional ICT (or other ICT type classes). It also makes a good ice breaker at the beginning of term. Best printed onto A3 and laminated.

There is also an extra bonus ‘Quiz makers’ game available online (link available on the answer sheet).

A 4 week scheme of work for OCN E3 Garden Horticulture. Great example of embedding aspects of all three Functional Skills into a vocational course. 4 × 2 hour sessions covering identifying weeds and vegetables; sowing seeds, bulbs and tubers; and preparing growing beds.
With detailed E3 Functional Maths,English and ICT mapping charts showing embedding of measuring, internet searching, reading instructions, writing plant profiles, etc.

A wonderfully detailed plan for 3 × 2 hours sessions for computer beginners. It is also mapped to the literacy curriculum – making it ideal for embedded learning and Entry Functional ICT. Includes scheme of work, session plans, feedback/evaluation forms and 7 resource sheets.
ICT covers creating, opening, printing a document; formatting, printing, copying, proof reading. Mapped to Entry 2 and 3 speaking & listening, and writing (including several exercises on conjunctions and compound sentences).