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.

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.

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)

Internet Searching is a gentle introduction for those new to the internet (suitable for all levels from E2 upwards) based on the BBC home page.

A paired activity based on the well known web site provides an engaging way to introduce or revise this tricky topic.
Emma suggests that a useful extension activity is for learners to take pictures on their phones – where appropriate – of apostrophe ‘abuse’ they come across and bring them in to class for discussion.

A set of 3 web research task sheets. Choose between rugby team, football team or favourite singer / group. Provides practice in web research, skimming, scanning and reading comprehension.

Estimating and measuring weight & capacity is a useful ICT based online supermarket exercise.