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 worksheet designed for motor vehicle students studying Functional Skills level 1/2. A spreadsheet activity encouraging them to look up on the internet cost of essential tools they need and then display this in an Excel Spreadsheet. Can be adapted to other industries.

Covers:

• formula
• average
• formatting
• % discount
• adding charts

Fourteen questions related to Remembrance Day (topics include WW1, WW2 ration books,  Korean War, war poetry, etc.). Use as a traditional paper-based quiz or an IT based investigation. Learners could work individually or in teams / small groups. One way of approaching the quiz would be to see what the class as a whole can answer from their general knowledge befor

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.

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]

Students design a board game to demonstrate their learning. This can incorporate IT skills (Word template provided below) or can be done with paper, card and pens.

I originally did this with an E2E group and it proved popular. It’s an alternative to the “design a poster” task to review learning. The instructions are set out as a board game. it can be used for literacy, numeracy, ICT or ESOL.

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.

First used with a group of E1-E2 numeracy students who had done an ICT based project involving cookery work and visiting a cafe to buy a snack. Print on A4 and fold into a very nice A5 leaflet.
The self assessment check boxes focus on basic money skills (recognising coins, giving change – but also slecting items from a list, weighing, etc.) but there is also the opportunity to link learning to numeracy at home or at college. Ideal for Entry Functional maths / catering / hospitality students.