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 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.

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.

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

How to use Hot Potatoes to make a crossword – is an ideal embedded literacy exercise for ICT classes (or embedded ICT for literacy!) with step by step illustrated help for using this popular freeware program to create web based word puzzles.
Karen has also provided two sample crosswords to show learners the type of puzzle they can quickly produce. Puzzle A is on parts of speech, puzzle B is on punctuation marks. (See below)

Lovely interactive crossword. 13 clues. Would make a good group activity on an interactive whiteboard.

To run, unzip the file (select “Extract all files”) into a new folder and click on *partsofspeechhotpotcrossword *to run.

Created with the excellent freeware program Hot Potatoes http://hotpot.uvic.ca/
Please see Karen’s separate “How to use Hot Potatoes to make a crossword” ICT guide for further information.

Lovely interactive crossword. 8 clues. Would make a good group activity on an interactive whiteboard.

To run, unzip the file (select “Extract all files”) into a new folder and click on punctuationhotpotcrossword to run.

Created with the excellent freeware program Hot Potatoes http://hotpot.uvic.ca/
Please see Karen’s separate “How to use Hot Potatoes to make a crossword” ICT guide for further information.