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 

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

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.

Activity to get students using Word and some of its applications by designing a poster for a gig.

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.

A demonstration of how not to make a PowerPoint. This has been used for all levels as an extreme example of the worst PowerPoint ever.

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.

Very clear, step by step task sheet for E3 ICT / Literacy / ESOL learners.
Enter a given short text into the PC, save and name files, set font size, etc. Then plan, write and proofread a short description about your own morning.