51ºÚÁÏ

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 /teaching-resources/shop/haltest/%22%3e

This lesson builds on lesson 1 to look at the difference between Absolute and Relative Cells Learning Objectives: Understand how to use Absolute and Relative Cells Know how to do currency conversions This Download includes: Presentation Two practical tasks with differentiation Two Extension Tasks Student Presentation to complete Teacher Example

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 resource is one of a series (scheme of work) to teach Input, Output and Storage. It has been especially designed for GCSE Computer Science. â € This lesson has the following Learning Objectives: Understand input and output devices and then colour code them to show students understand they are input, output or storage devices. â € Resources to run the lesson(s) included in this download: Wordsearch Full Solution â € All necessary resources to run the lessons are included in this download and all resources are for a double lesson (or two single lessons) i.e. there should be enough to content 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. â € 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, Computer Science and ICT here

A wonderful starter for any lesson on Logical / computational Thinking. Print out the sheet and get students in pairs to see if they can come up with a solution The objective is to arrange the pegs (numbers 1-8) such that no consecutive number touches on any connecting line. For example number 1 cannot connect with number 2; number 2 cannot connect with 3 or 1; number 5 cannot connect with 4 or 6; etc. Answer is included in the pack

Task to give to students for them to sort and organise how a monitor and control system works using sensors

This lesson / resource follows on from the previous 2 lessons on Flowcharts It has been especially designed for GCSE. Learning Objectives Know how to create flowcharts to achieve a variety of tasks: Understand how to solve more advanced tasks using: Variety of Conditionals Variety of Loops â € All necessary resources to run the lessons are included in this download: Full Lesson Powerpoint 6 Advanced Tasks Printable Student workbook Printable teacher solutions All solutions are also in the lesson presentation Python extension tasks with full program 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

A great intro to Variables to reflect on the best practices for potential computer scientists when dealing with variables! Deals with: •Understand what variables are •Know the different variable types •Understand how variable names are chosen 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. The contents of this page and all downloaded materials are copyrighted Taylor Teaching Resources

Here are 6 Logic Gate circuits of varying difficulty with their full solutions (showing intermediate points as well as the final answers!) Ideal for revision of just to practice completing Truth Tables Updated October 2018 to correct typos

This is lesson two of the Word Processing basics series of lessons. This gets students to understand how to use landscape, insert and deal with tables / rows / columns, and formatting of cells and text Learning Objectives: Know how to create a timetable in Microsoft Word Understand how to create and format a table Know how to add / remove / merge Columns or Rows This Download includes: Presentation Practical tasks allowing for differentiation with lots of extension tasks Teacher exemplar 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 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 lesson / resource covers 1 Introduction to computer systems: Input Devices and has been designed for GCSE / iGCSE Computing / ICT. It has the following learning objectives shown below: Learning objectives/Outcomes: Know the different kinds of input devices Understand the Application and Advantages / Disadvantages of each type of device Know how to choose the best type of input device for certain tasks This download includes: Full Presentation Student Cards to allocate a research task Crossword with solution Extension task All necessary resources to run the lessons are included in this download and all resources are for a double lesson (or two single lessons) i.e. there should be enough to content 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 lesson / resource covers 1 Introduction to computer systems: Output Devices and has been designed for GCSE / iGCSE Computing / ICT. It has the following learning objectives shown below: Learning objectives/Outcomes: Know the principles of operation of a range of output devices Understand how these principles are applied to real life situations This download includes: Full Presentation Two choices of data sheets for activity for small groups or individual students Extension task All necessary resources to run the lessons are included in this download and all resources are for a double lesson (or two single lessons) i.e. there should be enough to content 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 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 /teaching-resources/shop/haltest/">

This lesson / resource covers **Shapes and Patterns ** and is part of the unit on Drawing and Manipulating shapes. This lesson looks at abstraction and the use of shapes to create graphics. It also introduces the idea that colors can be controlled by the computer to create gradients and color changes which is explored further in a later lesson. This lesson was designed for Year 7. It has the following learning objectives shown below: Learning objectives/Outcomes: Understand how colour and simple shapes can create art on a computer Know how algorithms might be used to manipulate colour Understand the concept of abstraction This download includes: Full Presentation Practical task for students Teacher Examples All necessary resources to run the lessons are included in this download and all resources are for two single lessons per week for Years 7/8/9 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

This download covers the most common Keyboard Shortcuts. This version is for Windows, for the Mac Version, please click here. It has been especially designed for KS2/3 Computer Science and ICT. â € This download covers the following Keyboard Shortcuts: Copy Cut Paste Save Print Undo Redo Select All Bold Italic Underline Find Replace Insert Hyperlink â € 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 / resource covers Storage and has been designed for GCSE / iGCSE Computing / ICT. This lesson covers Primary, Secondary and Offline Storage. It is followed by lessons that cover Magnetic, Optical and Solid State Storage and how they all work. It has the following learning objectives shown below: Learning objectives/Outcomes: Know the difference between Memory and Storage Understand the difference between Primary, Secondary and Off-line storage Know the advantages and disadvantage of each type of Storage This download includes: Full Lesson Powerpoint Printable Sort starter activity Active Printable Reading Activity with Teacher Answers All necessary resources to run the lessons are included in this download and all resources are for a double lesson (or two single lessons) i.e. there should be enough to content 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 (2020) See my other resources for Business Studies, Computer Science and ICT here

This worksheet is a word search that covers Computer Security Threats and is part of a series of differentiated resources to easily scaffold key terms for learners or can be used to introduce the topic of Computer Security Threats, revise the key words or just to bring spaced practice into lessons. The full range of activities (from easy to more difficult) are: â € Word Search (two versions - one with and one without the word bank) - Available as a free download here Crossword Fallen Phrase Puzzle Word Scramble â € The full set Computer Security Threat Activities can be found as a bundle here â € 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, Computer Science and ICT here

These two posters cover Comparison and Arithmetic operators in Python. â € The full set of Python Reference Posters for Computer Science can be found here â € 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, Computer Science and ICT here

This lesson is one of a series to teach Coding techniques in Python and it focusses on introducing Python and gets users to start thinking about how to structure a simple program using interactive and script modes as well as looking at what operators can be used in programs and how Python can output data. It has been especially designed for GCSE. Learning Objectives Know the difference between Interactive and Script mode Understand how to print out simple Output in Python Understand what Syntax Errors are and how to avoid them All necessary resources to run the lesson are included in this download. A lesson presentation with examples of the code Challenges to allow students to show their mastery of the concepts all based upon outputting text using different techniques Possible solutions for each challenge Original Python files to allow you to run the programs to see how the programs work Mathematical operators discovery 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 visit /teaching-resources/shop/haltest/">