ICT Resources

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

Set of resources created by myself and colleague, David Bayne , to help students use Word, Excel and Access. We wanted students to practise for the Level 2 ICT Functional Skills exams, using a method that would be familiar to them. They all drive cars and need to get them serviced, so this seemed a suitable area to use.

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

Mean, Mode, Median and Range: Investigation into house prices.

Students use www.rightmove.co.uk to explore house prices in areas of their choice. For example pairs of students could explore house prices in different cities in the UK.

They will need access to computers. You will also need to establish criteria before they start to collect their data so that like for like houses are being compared. For example all of the groups are to compare prices of 2 bedroom flats in the cities of their choice.

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.

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.

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.

[img_assist|nid=4821|title=|desc=|link=popup|align=left|width=68|height=100]Two resources that can be used together or independently.

• An ICC / Literacy / Functional English / ESOL research project task sheet on “My favourite British animal”. E3-L2 reading, writing and ICT
• A basic animal anatomy vocabulary sheet for E2-E3 ESOL (paw, claw, antler, etc.)

For more of Kathy’s animal resources go to ‘see also’ below. (Birds of Prey resources)

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.