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 

Completing these challenges will help students to create a basic PowerPoint that runs automatically and provides evidence through printed handouts.

ITQ Learning outcomes covered: 1.1 1.3 1.6 2.3 2.4 3.2 3.3

Editor's note

I think the learning outcomes quoted above relate to the OCR ICT Award  (or similar) but this beautifully clear, step by step task sheet is ideal for any Level 1-2 ICT course.

An exercise in Microsoft Word built around the content of a HR article from:
https://www.consultancy.uk/services/hr-consulting

Editor’s note
Three separate step by step activities cover paragraph formatting, working with tables, and pictures/objects.

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

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

Simulations of email and online banking registration forms. Can be used in succession, as for the banking registration form you need an email address. When you press the “create account” button it will open the printing menu. Good luck!

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.