ICT Resources

Slides designed to support delivery of Gateway's EDSQ (Essential Digital Skills Qualification), Unit 2, at Entry Level and Level 1, with embedded Functional Skills English activities at L1 and L2. This set of slides covers skills from section 2 of the standards (Creating and Editing) with the focus being on creating and editing accessible documents (Entry and L1). Includes link to a Wordwall quiz.

Editor's notes

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).