ICT Resources

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

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.

A task sheet for L1 Functional Skills ICT. It focuses on Task 3 of the Edexcel exam paper which involves being creative and producing a document that uses clear presentation features and is fit for purpose.
Includes two tasks (a restaurant menu and a flyer for a student production) plus a short extension.

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.

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

Simulation of completing an online CV. Very easy to use, fill in the boxes and print after completion.

Students design a board game to demonstrate their learning. This can incorporate IT skills (Word template provided below) or can be done with paper, card and pens.

I originally did this with an E2E group and it proved popular. It’s an alternative to the “design a poster” task to review learning. The instructions are set out as a board game. it can be used for literacy, numeracy, ICT or ESOL.

Practice some of the skills needed for ICT Functional skills and also a bit of fun. Can be used individually, in pairs or groups. Two lots of 15 questions with fill-in answersheet attached.