ICT Resources

Slides designed to support delivery of Gateway's EDSQ (Essential Digital Skills Qualification), Unit 5 (Being Safe and Responsible Online) at Entry Level 3 and Level 1, with embedded Functional Skills English activities at L1 and L2. This set of slides includes skills from sections 3 (Communication) .  The slides cover: how to report safety concerns, public Wi-Fi, Health and Safety and other online risks. Also many useful links to YouTube videos and other online learning applications. 

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

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.

A very clever Excel sheet to accompany the ever-popular Smarties data handling resource and a great way of combining numeracy and IT skills.

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.

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.

Two task sheets – one for beauty therapists, one for motor vehicle students, etc. Find information, work out total cost, mean and range, display your results in a chart. (Originally used for Level 1 Key Skills Application of Number portfolio work).