ICT Resources

A very useful handout for Entry Level ESOL and/or Functional Skills ICT students. Step by step, illustrated instructions on how to create a basic PPT.

The basic PPT used in the handout images is also provided. This can be adapted by the teacher or (optionally) given to learners to adapt. 

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

I’ve adapted a resource made by Janet Wilkins on your site in 2008 (see link below under See also), on global best selling singles-making a pie chart. I’ve updated it for the digital age! You’ll see what I mean…..enjoy.

Editor’s note
Ideal for L2 Functional Maths

Useful 1 page handout. Very simple instructions on how to correct a mistake made when typing in Microsoft Word. First used with residents at a clinic who have learning difficulties but ideal for any beginner.

I created this resource as practice in data handling for a Level 1 Functional Maths group and it covers skills from Entry 3 to Level 2. It includes creating tallies and charts, using a distance chart, calculating average and range, and working with money. It is fully mapped to the Functional Maths criteria and includes an answer sheet.

My students are 16-18, and have a limited knowledge of geography, so I included an outline map of the UK (not included in the resource) and got them to use a road map to find and mark the cities and towns that are on the distance chart.

An interesting way to improve pie chart skills – whether the chart is calculated and drawn ‘by hand’ or in a spreadsheet. With answer sheet and extension ideas.

A straightforward illustrated guide for beginners that can easily be adapted to suit your own institution. Ideal for many students including E2-E3 Skills for Life ICT.

Interactive worksheet with 3 pages of colourful information and key vocabulary followed by a 2 page time quiz (whole hours) with drop down menus.
Written for Entry Level ESOL, ICT and Numeracy learners.

What’s the weather like? and Party Time! are two ‘real-life’ task sheets that involve budgeting, Excel charts and tables, rounding and checking, and finding mean and range.