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

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]

I’ve adapted a resource made by Janet Wilkins on your site in 2008 (see link below under See also), on global best selling singles-making a pie chart. I’ve updated it for the digital age! You’ll see what I mean…..enjoy.

Editor’s note
Ideal for L2 Functional Maths

Lovely classroom display that will help learners define and understand the function of 20 common Excel toolbar buttons.

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.

Useful handout that clearly explains the principles of backing up files. Includes information on hardware, software and how to back up data.

Useful illustrated handout that clearly explains the principles of basic file management: how to create new folders and how to rename them.

Useful handout that clearly explains the principles of basic file management using folders and sub-folders.

A clear guidebook to computers (mouse, keyboard) and to using Microsoft Word. Ideal for E3-L1 Functional ICT and ECDL (European computer driving licence).