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

Designed for Entry 3 – Level 2 Functional Skills English.
Students loved this lesson. Can be designed around other areas but covers:
Writing persuasively.
Fact and opinion.
Research write a factual article
Create a poster using appropriate language.

Literacy – aimed at Level 1-2 and links to imaginative writing at GCSE.
Quirky fun starter – find your pirate name. This can be done on mobile phones if there are no PCs.
Comprehension tasks.
After finding the King’s shilling, write descriptive letter home.

This is a literacy resource based around a recent news story. There are a range of tasks relating to an anti-litter app called ‘littergram’ and legal challenges made to the use of its name, with the potential to extend tasks into other aspects of littering and how the litter problem might be resolved. A final extension task asks students to take their own photographs of local examples of litter as supporting evidence for a writing activity.

This is a set of three (maybe more) lessons which looks at the costs of a night out to London. It starts with students having to look at a train ticket and get the asked information from it – cost/type of ticket/time. It uses addition as students need to find out the cost of two tickets. They then use google to search times of trains. The next session looks at the cost of the theatre ticket and finding out the change you would have from a given amount again researching the theatre on the internet.

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]

Mean, Mode, Median and Range: Investigation into house prices.

Students use www.rightmove.co.uk to explore house prices in areas of their choice. For example pairs of students could explore house prices in different cities in the UK.

They will need access to computers. You will also need to establish criteria before they start to collect their data so that like for like houses are being compared. For example all of the groups are to compare prices of 2 bedroom flats in the cities of their choice.

A lovely unit of work from Australia. Designed to be used during and after the games.
Cloze exercise, web research, discussion and self-evaluation.

Editor’s note
Apologies, the resource file had gone missing! Re-attached Dec 9, 2013

Learners must choose the next manager of the England football team. Using the task sheet to guide them, they must research, collate and present information for five candidates and then make the final choice.

There is scope for plenty of lively discussion around the choices made and also about what the manager’s job entails.

A Power Point presentation is included as an example, but can also be printed out to use in some of the additional activities described.