I have developed a project called Alpine Snow School Project - This project enables students to develop a wide range of skills by researching, developing a poster, presentation, excel spreadsheet tasks including SUM, MIN, MAX, Average, IF function, Lookup Function, Absolute as well as general ICT questions. This can be used for an assessment to identify knowledge already obtained or need obtaining. I have used this as a mock exam in preparation for an ICT exam. This took my my students 2 lessons to complete but you really do get an idea of what ICT skills they have. I hope you find this useful.

Students need to learn about spyware and also how to research. This activity asks the students to develop a poster on spyware but using the internet to find information. A fabulous activity to get the learners developing their knowledge on spyware. Learners need to know how to research as part of any ICT course.

A nice revision resource for learners who need to know how to develop a secure password. This helps all students to understand about passwords in the virtual world.

This is another great worksheet that supported my students understanding of the LookUp function. Step by Step instructions to develop the skills on the LookUp function in Excel. An extension worksheet.

This is a great worksheet that introduces the LookUp function to learners. This gives a step by step process to carry out the lookup function. My students really enjoyed my activity and it really supported their understanding.

Check your learning worksheet is a great way to see what your students have retained at the end of the lesson. I use this when I have finished the lesson to see what they remember. A great assessment to establish gaps in learning.

This booklet includes a range of activities to support learners in ICT functional skills. This can even be used for ICT GCSE classes. This covers the following: Using ICT activity, Email activity, Word poster activity, Gathering information activity, Excel activity including absolute, Lookup and IF functions as wells a chart activity. A great range of skills to identify any gaps in their ICT knowledge. This took my students around 2 lessons to complete.