ICT Resources

Displaying 1 - 10 of 14 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 
Level
L2
ESOL
General ESOL
ICT
Using ICT
Finding and selecting information
Developing, presenting and communicating information
Charts & graphs
Context
Faith & Religion

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.

Level
E3
E2
Maths
Functional Maths
ICT
Finding and selecting information
Context
Leisure Travel Tourism

I have created a paper based initial assessment for ICT to identify if students should be working towards Level 1 or Level 2.

Level
L2
L1
E3
ICT
Level 1 and 2 CLAIT / ECDL
General ICT resources
Functional ICT

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.

Level
L2
ICT
Functional ICT
Context
Motor vehicles & Transport

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]

Level
E3
L1
L2
English
Engage in Discussion
Functional English - writing
Writing: text focus (composition)
Use reference sources
Use knowledge of punctuation and capitalisation
Reading: text focus (comprehension)
Functional English - speaking, listening & communicating
Functional English reading
Apply punctuation and capitalisation
General literacy / English
ICT
Developing, presenting and communicating information
Entry 3 ICT
Finding and selecting information
General ICT resources
Using ICT
Context
Sport
Electrical, Electronics & Technology

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.

Level
L2
L1
Maths
HD1/L2.4
HD1/L2.3
HD1/L1.4
HD1/L1.3
Functional Maths - handling information and data
ICT
Finding and selecting information

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.

Level
E3
L1
L2
English
General literacy / English
Functional Skills English
ICT
Developing, presenting and communicating information
Finding and selecting information
General
Generic resources for literacy, numeracy and beyond
Context
Sport

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.

Level
E2
E1
ICT
Developing, presenting and communicating information
General
Aims & objectives, ILPs, reflections
Context
Catering Food Nutrition

Here is another Level 1-2 variant on the classic ‘Smarties’ investigation which incorporates the use of a PC and Excel. I stopped using Smarties and Skittles because of the health and hygiene issues.

Level
L2
L1
Maths
Averages and range
Collect organise represent
Functional Maths - handling information and data
ICT
Developing, presenting and communicating information

Super set of three ICT task sheets that successfully embed Functional ICT, Functional English and even some Functional Maths!
Each task sheet involves composing, sending and replying to work-based emails: based in a dental surgery, a health centre and a travel agency.
Please also download the separate, very detailed, Functional Skills mapping document which includes differentiation ideas, teaching tips and embedding ideas.

Level
E3
E2
English
Functional English - writing
Functional English reading
ICT
Developing, presenting and communicating information
Finding and selecting information
Entry 3 ICT
Context
Leisure Travel Tourism
Health, Social care, Early years
Employment skills & Public services