This lesson carries on for the previous four lessons to teach the basics of spreadsheets. The focus here is on using IFs and conditional formatting to create self marking quiz. The extension is to lock down a worksheet and protect cells / use a password to restrict access to a sheet / workbook. The files also contain a teacher exemplar to use with the class and a step by step presentation for students to follow. Learning Objectives • Understand how to use the IF function to create a quiz • Know how to protect cells so that only the owner of the document can edit parts of it The aim of all my resources is to provide lessons / activities of good quality that will add value to your lessons / schemes of work. All activities and resources have been used in class and any errors will be fixed and resources updated as soon as I am aware of any errors. I have priced my resources at what I consider to be a reasonable cost based upon the amount of effort and work I have put into them but **all comments and suggestions are very welcome** and will be used to improve future resources. If you have an idea for a topic / resource that you would like to see, feel free to leave a comment. The contents of this page and all downloaded materials are copyrighted Taylor Teaching Resources To see other resources in my shop visit https://www.tes.com/teaching-resources/shop/haltest/%22%3e

This lesson puts together all the learning from the previous 6 lessons in the Spreadsheets Basics Series into a practical task to create a battleships game using a spreadsheet to make use of formatting techniques, Averages, Max, Min, IFs, Conditional Formatting. I normally use this with KS3. I have also include a student example which has a Star Wars theme rather than the traditional battleships theme. This is a great activity that involves some quite complex use of Spreadsheet principles so there is a teacher exemplar to show each stage and a video to show the teacher / students what to do if they get stuck. The extension tasks are very tricky and should stretch the most able students.

This is a full lesson on data transmission with all resources / activities. I use this for a double lesson of around 1 hour and 50 minutes and it provides a thorough understanding of simplex / duplex transmission and then goes on to look at serial / parallel transmission before finishing with odd and even parity bits and then parity blocks. The Learning Objectives are: Understand what is meant by transmission of data Know the difference between serial and parallel data transmission understand of the reasons for choosing serial or parallel data transmission Know why it is necessary to check for errors Understand how parity works to identify if an error has occurred / locate errors Resources included: Parallel Ports Handout Serial Port Handout Lesson Presentation Parity demonstration Parity Puzzle Plenary The aim of all my resources is to provide lessons / activities of good quality that will add value to your lessons / schemes of work. All activities and resources have been used in class and any errors will be fixed and resources updated as soon as I am aware of any errors. I have priced my resources at what I consider to be a reasonable cost based upon the amount of effort and work I have put into them but all comments and suggestions are very welcome and will be used to improve future resources. If you have an idea for a topic / resource that you would like to see, feel free to leave a comment. The contents of this page and all downloaded materials are copyrighted Taylor Teaching Resources To see other resources in my shop visit https://www.tes.com/teaching-resources/shop/haltest/">

This is lesson six of the Spreadsheet basics series of lessons. This gets students to understand how to use functions in order to do simple calculations (SUM, AVERAGE, MAX, MIN) for a class of students with a mark-sheet for a fictional class. There is an advanced version of the mark-sheet for those super fast students which also needs them to work out how to calculate ranges and relies on earlier taught content on this course which required them to convert scores to percentages. The lesson comes with teacher exemplars to use with students and a step by step presentation Learning Objectives: • Know how to use the SUM, AVERAGE, MIN and MAX functions • Understand how to speed up setting up spreadsheets with Copy and Paste This Download includes: Presentation Two practical tasks allowing for differentiation Teacher model answers for both tasks This resource has enough for 2 lessons X 50 minutes with extension tasks for those students that get through their tasks quicker than all the rest

This lesson / resource covers Network Topologies and has been designed for GCSE / iGCSE Computing / ICT. This lesson is one of a series that introduces networking: Lesson 1: What is a Network? Lesson 2: Network Topologies Lesson 3: Network Hardware Lesson 4: Network Addressing ⠀ This lesson has the following Learning Objectives: Understand the three main networking topologies * Bus * Star * Ring * Mixed ⠀ All necessary resources to run the lesson(s) are included in this download: Full Presentation ⠀ The aim of all my resources is to provide lessons / activities of good quality that will add value to your lessons / schemes of work. ⠀ All activities and resources have been used in classes and any errors will be fixed and resources updated as soon as I am aware them. I have priced my resources at what I consider to be a reasonable cost based upon the amount of effort and work I have put into them but all comments and suggestions are very welcome and will be used to improve future resources. ⠀ If you have an idea for a topic / resource that you would like to see, feel free to leave a comment. ⠀ The contents of this page and all downloaded materials are copyrighted Taylor Teaching Resources. ⠀ To see other resources in my shop, click here

This lesson / resource introduces Flowcharts It has been especially designed for GCSE. Learning Objectives Know the different shapes used in Flowcharts and what they mean Understand how to construct basic Flowcharts ⠀ All necessary resources to run the lessons are included in this download: Full Lesson Powerpoint Differentiated Starter Full teacher solutions Extension Python Task with 2 files ⠀ This lesson is part of a full series on Algorithms Introduction to Alogorithms Top-Down Design and Structure Diagrams Introduction to Flowcharts Simple Flowcharts Advanced Flowcharts Introduction to Pseudocode Advanced Pseudocode ⠀ All activities and resources have been used in classes and any errors will be fixed and resources updated as soon as I am aware them. I have priced my resources at what I consider to be a reasonable cost based upon the amount of effort and work I have put into them but <strong> all comments and suggestions are very welcome </strong> and will be used to improve future resources. ⠀ If you have an idea for a topic / resource that you would like to see, feel free to leave a comment. ⠀ The contents of this page and all downloaded materials are copyrighted Taylor Teaching Resources. ⠀ See our other resources for Business Studies, Computer Science and ICT here

End of unit test for Binary / Hex / Decimal Conversion (with answers). There are 10 questions for each conversion for a total of 60 questions e.g. •Binary to Hex / Hex to Binary •Decimal to Binary / Binary to Decimal •Decimal to Hex / Hex to Decimal

This is a full lesson on Error Checking with all resources / activities. I use this for a double lesson of around 1 hour and 50 minutes and it provides a thorough understanding of Checksum, ARQs, Echo Checks, and Modulus. There are lots of extension activities linking to Python and Spreadsheets with full examples. For the lesson on parity, please click here The Learning Objectives are: Know why error checking is important in a computer system Know ways of error checking using algorithms Checksums ARQs Echo Checks Modulus Understand how error checking can have real world application beyond just simple data transmission Resources included: Full lesson presentation Demonstration handout for ARQs Python extension for checksums with coded example Spreadsheet ISBN extension with example The aim of all my resources is to provide lessons / activities of good quality that will add value to your lessons / schemes of work. All activities and resources have been used in class and any errors will be fixed and resources updated as soon as I am aware of any errors. I have priced my resources at what I consider to be a reasonable cost based upon the amount of effort and work I have put into them but all comments and suggestions are very welcome and will be used to improve future resources. If you have an idea for a topic / resource that you would like to see, feel free to leave a comment. The contents of this page and all downloaded materials are copyrighted Taylor Teaching Resources To see other resources in my shop visit https://www.tes.com/teaching-resources/shop/haltest/">

This lesson / resource is for Binary. This lesson has been designed for GCSE and iGCSE Computing and ICT. This lesson has the following learning objectives: **Learning objectives **: Know what Binary numbers are Understand why Binary is used in Computing Know how to : Convert Binary numbers into Denary numbers (Decimal) , Convert Denary numbers into Binary numbers Add Binary Numbers This download includes: A full lesson PowerPoint 2 Differentiated worksheets with solutions to convert from Decimal to Binary with solutions 3 Differentiated Binary Crosswords with solutions All necessary resources to run the lesson are included in this download and all my lessons are for a double lesson i.e. to take around 1 hour and fifty minutes so they can be separated into two single lessons if required. The aim of all my resources is to provide lessons / activities of good quality that will add value to your lessons / schemes of work without any extra planning. All activities and resources have been used in class and any errors will be fixed and resources updated as soon as we are aware of any errors. We have priced the resources at what we consider to be a reasonable cost based upon the amount of effort and work we have put into them but all comments and suggestions are very welcome and will be used to improve future resources. Please do leave a review and if you have an idea for a topic / resource that you would like to see (or improvement for this resource), feel free to contact us. The contents of this page and all downloaded materials are copyrighted Taylor Teaching Resources See our other resources for Business Studies, Computer Science and ICT here

This lesson / resource covers What is a Network - Introduction to Networks and has been designed for GCSE / iGCSE Computing / ICT. This lesson is one of a series that introduces networking: Lesson 1: What is a Network? Lesson 2: Network Topologies Lesson 3: Network Hardware Lesson 4: Network Addressing ⠀ This lesson has the following Learning Objectives: Understand the key terms and ideas of a computer Network LAN WAN IP address Mac Address Packets Know the Advantages of networking / Stand alone Computers ⠀ UPDATED Added in IPv4 and IPv6 Overview Added more details to Packets ⠀ All necessary resources to run the lesson(s) are included in this download: Full Presentation Printable Reading Task ⠀ The aim of all my resources is to provide lessons / activities of good quality that will add value to your lessons / schemes of work. ⠀ All activities and resources have been used in classes and any errors will be fixed and resources updated as soon as I am aware them. I have priced my resources at what I consider to be a reasonable cost based upon the amount of effort and work I have put into them but all comments and suggestions are very welcome and will be used to improve future resources. ⠀ If you have an idea for a topic / resource that you would like to see, feel free to leave a comment. ⠀ The contents of this page and all downloaded materials are copyrighted Taylor Teaching Resources. ⠀ To see other resources in my shop, click here

This lesson / resource follows on the the Introduction to Flowcharts lesson and looks at Simple Flowcharts for some very common tasks. It has been especially designed for GCSE. This lesson has the following Learning Objectives Know how to create flowcharts to achieve a variety of tasks: Totalling Counting Finding maximum, minimum and average values ⠀ All necessary resources to run the lessons are included in this download: Full Lesson Powerpoint 3 Different Tasks Full teacher solutions Differentiated Framework printables for weaker students Extension Python Task with 3 files ⠀ ⠀ The aim of all my resources is to provide lessons / activities of good quality that will add value to your lessons / schemes of work. ⠀ This lesson is part of a full series on Algorithms Introduction to Alogorithms Top-Down Design and Structure Diagrams Introduction to Flowcharts Simple Flowcharts Advanced Flowcharts Introduction to Pseudocode Advanced Pseudocode ⠀ All activities and resources have been used in classes and any errors will be fixed and resources updated as soon as I am aware them. I have priced my resources at what I consider to be a reasonable cost based upon the amount of effort and work I have put into them but <strong> all comments and suggestions are very welcome </strong> and will be used to improve future resources. ⠀ If you have an idea for a topic / resource that you would like to see, feel free to leave a comment. ⠀ The contents of this page and all downloaded materials are copyrighted Taylor Teaching Resources. ⠀ See our other resources for Business Studies, Computer Science and ICT here

This lesson is one of a series (scheme of work) to teach Compression and focuses on the use of Lossy and Lossless techniques and how they work. It has been especially designed for GCSE. ⠀ This lesson has the following Learning Objectives: Understand what is meant by Compression Know the difference between Lossy and Lossless compression ⠀ All necessary resources to run the lesson(s) are included in this download: Full Lesson Powerpoint Two Printable activities Choice of Final Task Knowledge questions ⠀ The aim of all my resources is to provide lessons / activities of good quality that will add value to your lessons / schemes of work. ⠀ All activities and resources have been used in classes and any errors will be fixed and resources updated as soon as I am aware them. I have priced my resources at what I consider to be a reasonable cost based upon the amount of effort and work I have put into them but all comments and suggestions are very welcome and will be used to improve future resources. ⠀ If you have an idea for a topic / resource that you would like to see, feel free to leave a comment. ⠀ The contents of this page and all downloaded materials are copyrighted Taylor Teaching Resources. ⠀ To see other resources in my shop, click here

This is printable resource to support students in Grades 7-9 to practice the different number systems - Binary, Denary, and Hexadecimal ⠀ It has been especially designed for KS 3 Computer Science / ICT. ⠀ I have also used this resource for weaker students at GCSE level to give them opportunity to practice. ⠀ This download includes 9 Different Tasks with Full Teacher Solutions: Binary to Decimal Practice 4 Bit Binary Crossword Binary Box Binary to Decimal Extension Binary Crossword with some 8 Bit Questions Denary to Binary Practice Binary to Hex Hex Words Binary Adding ⠀ The aim of all my resources is to provide lessons / activities of good quality that will add value to your lessons / schemes of work. ⠀ All activities and resources have been used in classes and any errors will be fixed and resources updated as soon as I am aware them. I have priced my resources at what I consider to be a reasonable cost based upon the amount of effort and work I have put into them but all comments and suggestions are very welcome and will be used to improve future resources. ⠀ If you have an idea for a topic / resource that you would like to see, feel free to leave a comment. ⠀ The contents of this page and all downloaded materials are copyrighted Taylor Teaching Resources. ⠀ See our other resources for Business Studies, Economics, Computer Science and ICT here

This lesson is one of a series (scheme of work) to teach Coding techniques in Python and focusses on Types of Variables and Inputs. There is enough content here for 1 double lesson for very advanced students (or a small class) but there is enough challenge here for around 4 hours of teaching time. There are lots of Python challenges for students to try and extension task as well! It has been especially designed for GCSE. Learning Objectives Understand what a Variable is in Python Know what the different types of Variables are and what they are used for Understand and use Operator Precedence Know how to take an input of different data types from the user The resources in this pack will be enough for 2 X double lessons of Computer Science (each double lesson of around 1 hour 50 minutes) . All necessary resources to run the lessons are included in this download. Lesson presentation with examples of the code Eight Challenges to allow students to show their mastery of the concepts Possible solutions for each of the eight challenges Original Python files to allow you to run the programs to see how the programs work Variables Worksheet This lesson is perfect to use to deliver a full lesson or as revision to help students recap skills they have learnt previously. It is also ideal for NQTs and non-specialist teachers who need to learn Python programming or any teacher wanting to fill in gaps in their Python programming knowledge The aim of all my resources is to provide lessons / activities of good quality that will add value to your lessons / schemes of work. All activities and resources have been used in class and any errors will be fixed and resources updated as soon as I am aware of any errors. I have priced my resources at what I consider to be a reasonable cost based upon the amount of effort and work I have put into them but <strong> all comments and suggestions are very welcome </strong> and will be used to improve future resources. If you have an idea for a topic / resource that you would like to see, feel free to leave a comment. The contents of this page and all downloaded materials are copyrighted Taylor Teaching Resources. To see other resources in my shop, click here

This is a full lesson with all resources to teach students how to draw shapes in Scratch (good for KS3 and I normally use it with KS3.) All worksheets are included with Powerpoint and a quick video explanation that can be shown to students. Students have to draw simple shapes in scratch from triangles up to circles which teachers them how loops work and how to conceptualise an algorithm. Loops inside loops can also be used as extension to draw some great geometric art. Learning objectives are: Understand simple algorithm design Know how to identify important ideas (abstraction) Understand how to break a problem into manageable units (decomposition). Know what repetition is (iteration) Extension task 2 also included for more difficult shapes

This lesson / resource covers Formatting Text and Documents and has been designed for Key Stage 3 Computing / ICT. It has the following learning objectives shown below: Learning objectives/Outcomes: Understand how to format a document in different ways using Microsoft Word Know some useful keyboard shortcuts to enable you to work faster and more efficiently! Know how to use headings to organise your work and navigate around a document This download includes: Full Presentation Worksheet task Extension task with simple Teacher Example All necessary resources to run the lessons are included in this download and all resources are for two single lessons per week for KS 3 Computing i.e. should have enough to cover around 1 hour and fifty minutes. The aim of all my resources is to provide lessons / activities of good quality that will add value to your lessons / schemes of work without any extra planning. All activities and resources have been used in class and any errors will be fixed and resources updated as soon as I am aware of any errors. I have priced my resources at what I consider to be a reasonable cost based upon the amount of effort and work I have put into them but all comments and suggestions are very welcome and will be used to improve future resources. Please do leave a review and if you have an idea for a topic / resource that you would like to see (or improvement for this resource), feel free to contact me. The contents of this page and all downloaded materials are copyrighted Taylor Teaching Resources. See my other resources for Business Studies, Computer Science and ICT here

This is my take on getting students to use their simple binary knowledge (they have looked at binary and how up to 5 bits works) and now it’s time to take this knowledge and use a simple task (1 bit binary which means two colours) and then progressing to 3 bit combinations (allowing for 8 colours). There are two spreadsheets that can be used which are available here and these can be shared with students. Task 1 is a simple 10 X 10 grid with 2 colours Task 2 is a 15 X 15 grid that allows 8 colours to be used The aim of all my resources is to provide lessons / activities of good quality that will add value to your lessons / schemes of work without any extra planning. All activities and resources have been used in class and any errors will be fixed and resources updated as soon as I am aware of any errors. I have priced my resources at what I consider to be a reasonable cost based upon the amount of effort and work I have put into them but all comments and suggestions are very welcome and will be used to improve future resources. Please do leave a review and if you have an idea for a topic / resource that you would like to see (or improvement for this resource), feel free to contact me. The contents of this page and all downloaded materials are copyrighted Harvey Taylor (2018) See my other resources for Business Studies, Computer Science and ICT here

Quickly brighten up your classroom by printing out these colour posters and hanging them on the walls. Fun facts about the following computing related businesses: • Alibaba • Amazon • Instagram • Facebook • Google • LinkedIn • Twitter • YouTube All pictures/logos are labelled for reuse. This resource is a pdf, if you would like the publisher file to edit, please leave a comment The aim of all my resources is to provide lessons / activities of good quality that will add value to your lessons / schemes of work. All activities and resources have been used in class and any errors will be fixed and resources updated as soon as I am aware of any errors. I have priced my resources at what I consider to be a reasonable cost based upon the amount of effort and work I have put into them but ** all comments and suggestions are very welcome** and will be used to improve future resources. If you have an idea for a topic / resource that you would like to see, feel free to leave a comment. The contents of this page and all downloaded materials are copyrighted Taylor Teaching Resources. To see other resources in my shop visit https://www.tes.com/teaching-resources/shop/haltest/">