ICT Resources

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

Rugby themed task on reading (use of quotations and dialogue, facts versus opinions), researching and writing a short article. Topic links to ICT, suitable for use during e.g. Rugby World Cup, Six Nations Tournament or with any group keen on sport![img_assist|nid=5708|title=|desc=|link=popup|align=left|width=100|height=71]

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

This is a fabulous board game created as a fun and gentle introduction to L1-2 Functional ICT (or other ICT type classes). It also makes a good ice breaker at the beginning of term. Best printed onto A3 and laminated.

There is also an extra bonus ‘Quiz makers’ game available online (link available on the answer sheet).

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 paired activity based on the well known web site provides an engaging way to introduce or revise this tricky topic.
Emma suggests that a useful extension activity is for learners to take pictures on their phones – where appropriate – of apostrophe ‘abuse’ they come across and bring them in to class for discussion.

Estimating and measuring weight & capacity is a useful ICT based online supermarket exercise.

Swine flu web research questions. 1 page of general swine flu questions to research and then summarise in Word.

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.