i created a nice introduction to Python for Year 7. It starts with the basics of how to use Python for beginners. Year7 really enjoyed it. I hope it is useful to you. It is a powepoint so you can amend it to your class.

This is a course for ICT Functional Skills. I used this with 17 to 18 year olds in further education. I have included all teacher PowerPoint presentations, worksheets and the scheme of work. The units included are: Unit 1 Making the most of your computer Unit 2 Managing Information - Passwords and viruses Unit 3 Finding and selecting information Unit 4 to 7 Excel Spreadsheets (Basic Formulas, IF Functions, Absolute function, Lookup formula) Unit 8 Working with Microsoft Word Unit 9 Combining and presenting information Unit 10 Using ICT to communicate I hope that you will find this helpful in the classroom. All presentations are easily adaptable as well the worksheets. Some of the Excel worksheets have been used on older versions of Excel, however they have recently been checked to the most updated version of Excel and do work fine.

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.

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.

Being new to app creation as well as the year 6 class I was teaching, I decided to make a step by step of instructions using PowerPoint. This worked brilliantly, it really is a beginners guide for them. It is to make a Ratatouille information app about the film but you can adapt this PowerPoint to suit your needs. I hope you find this useful as much as I did.

A nice introduction to Audacity, I used this PowerPoint with Year 6 for their first ever lesson using Audacity, Helps them to identify the features of Audacity and why we use this software to mix music. I hope you find this useful as I did.

I use this lesson starter for my students. It gives them questions to answer and when everyone is settled, it is a good way to get the class to discuss what they would do. They are easily adaptable to any ICT/Computing lesson.

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.

I have developed an ICT initial assessment test - this resource contains the answers only. This assessment is great to see what my students already know before they start lessons in ICT. This can also be used at the end of the course to establish what knowledge they have developed. Questions asked range from trouble shooting in ICT, Word, Excel, Presentations and Database usage. Please also see the Initial Assessment - to support this assessment answers resource.

I have developed an ICT initial assessment test. This assessment is great to see what my students already know before they start lessons in ICT. This can also be used at the end of the course to establish what knowledge they have developed. Questions asked range from trouble shooting in ICT, Word, Excel, Presentations and Database usage. Please also see the Initial Assessment answers - to support this assessment. This took my students 1 hour to complete.

Creating a database worksheet was used with my students to help them create a basic database, in MS Access. This worksheet contains how to create a database, a report and how to create a query. This worked really well for 15 years plus but I am sure this will suit secondary amd even primary.

I created a mini test for my year 10s and 11s on the fundamentals of algorithms. There are 10 questions and takes about 30 minutes to complete. I have also included a marking scheme. The questions can be changed so that they are easy adaptable to your students. Questions include binary search, merge sort and abstraction.

I developed this worksheet to help studens use Excel basic functions, these include the IF function, Min, Max, Average and also SUM. This worksheet also gives students a chance to design a poster and write an email. This is in a Word document, so you can amend the worksheet to suit the abilities of your learner.

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

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 PowerPoint on how to create a professional email. Could also be used in a literacy lesson. This was used in a recent ICT lesson workshop as well as an English functional skills lesson. This PowerPoint provides information on the difference between informal and formal emails, how you start an email as well as ending an email. As this is a PowerPoint, you can adapt it to your own lessons. I hope you will find this useful. Kathy's ICT Resources.

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.

Recently used as a lesson 16+ year olds. Can easily be used from Year 6 to Secondary. Explains the importance about getting your presentation across to the audience. By the end of the lesson, students will be able to think more logically about how to present an effective presentation to the class.