ICT Resources

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

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
Level
Level 1
Level 2
ICT
Functional Skills ICT: Developing, presenting and communicating information
Functional Skills ICT: Finding and selecting information
Context
Motor vehicles & Transport

This is a set of worksheets in a MS Excel workbook that deals with fractions.
- Sheet one: a set of pictures (pie charts) that shows fractions from halves to tenths
- Sheet two: equivalent fractions with two pie charts, learners can input fractions and see if they are equivalent by looking at the shape of the pie charts
- Sheet three: starting to look at fractions being equivalent to decimals with two pie charts one for fractions and one for decimals

Level
GCSE L1-5
Level 2
Level 1
Maths
N2/L2.3
N2/L2.1
Adult Numeracy N2/L2.2
Adult Numeracy N2/L1.3
GCSE N10 (Work interchangeably with terminating decimals & their corresponding fractions)
Functional Maths - numbers and the number system
ICT
Functional Skills ICT: Using ICT

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.

Level
Level 2
Level 1
Entry Level 3
English
Functional Skills English
ICT
Functional Skills ICT: Finding and selecting information
Context
History, culture, museums, libraries

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.

Level
Level 2
Level 1
English
Functional English - writing
Functional English reading
ICT
Functional Skills ICT: Finding and selecting information
Context
History, culture, museums, libraries

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.

Level
Level 2
Level 1
English
Functional English - writing
Functional English - speaking, listening & communicating
Functional English reading
General literacy / English
ICT
Functional Skills ICT: Finding and selecting information
Context
News, Politics & Government items
Electrical, Electronics & Technology

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
Entry Level 3
Level 1
Level 2
English
Functional English - speaking, listening & communicating
Functional English reading
Functional English - writing
General literacy / English
ICT
Functional Skills ICT: Developing, presenting and communicating information
Entry 3 ICT
Functional Skills ICT: Finding and selecting information
General ICT resources
Functional Skills ICT: Using ICT
Context
Sport and fitness
Electrical, Electronics & Technology

A recap exercise where Functional English learners match the correct aspects of formal letter writing together and lay them out in letter format.

This could be printed out and laminated but I usually give my students a printout of the first pages and they cut out the text boxes and arrange them appropriately. I have included some red herrings such as incorrect text alignment and unsuitable salutations and closures.

I have included my suggestion of the correct layout on the third page.

Level
Level 2
Level 1
English
Functional English - writing
Functional English reading
General literacy / English
ICT
Functional Skills ICT: Developing, presenting and communicating information
Context
Retail Hospitality Customer service

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
Level 2
Level 1
Maths
HD1/L2.4
HD1/L2.3
HD1/L1.4
HD1/L1.3
Functional Maths - handling information and data
ICT
Functional Skills 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
Entry Level 3
Level 1
Level 2
English
General literacy / English
Functional Skills English
ICT
Functional Skills ICT: Developing, presenting and communicating information
Functional Skills ICT: Finding and selecting information
General
Generic resources for literacy, numeracy and beyond
Context
Sport and fitness