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.

This PowerPoint includes what students need to know for the unit of object orientation for AQA. The PowerPoint slides include : What is OOP? What is a class and an object instantiation encapsulation inheritence aggregation composition polymorphism overriding favour composition over inheritence methods tasks for students o complete I have used this PowerPoint to support my students in introducing OOP to them. I hope you find this useful.

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.

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.

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 use these lesson starters to help students understand why they learn ICT and Computing. Students research questions for each person then class discussions afterwards. Great activities to support research skills and develop further knowledge about these great people.

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.

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.

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.

Introduction to Python - the basics, includes 4 PowerPoints with a scheme of work. All lessons and SOW are editable for you to adjust for your classes. Lesson 1 - Identify features of Python Idle as well as basic Math and use the print statement. Lesson 2 - Identify some errors in Python code and introduction to variables. Lesson 3 - Introduces the IF statement Lesson 4 - introduces students to ELIF I delivered this to year 7 and it worked really well. Hope it is useful to you.

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.

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.

I created knowledge organisers for my computer science students studying AQA A Level. These are for Fundamentals of Programming and Programming Paradigms. I used these organisers to support students learning in these units. I have included Publisher documents as well as PDFs so that you can amend them if you need to adapt them to suit your class. I hope you find them useful.

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.

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 have developed a project called Alpine Quality Vehicles 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. I have used this as a mock exam in preparation 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.

These resouces were used to teach customer service to 16 - 24 year olds. However, they could also be used to teach in secondary schools too. The resouces point out what good customer service is, how to prepare to deal with customer service and a booklet of questions that ask the student customer service questions.

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.