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

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.

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.

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.

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.