This “producing robust programs” workbook is perfect for students studying for the OCR GCSE (9-1) in computer science and has been updated to completely cover the new specification J277. It can be used in the classroom as a teaching aid, for self-study or as a revision tool. In this resource you will receive an interactive PDF workbook so your students can either print it out and complete the activities by hand or fill it in electronically making this an ideal workbook for use in school or for students studying at home. The answer booklet is provided as a separate PDF file so you can assign your students the workbook without including the answers. This 21-page workbook completely covers the new specification J277 2.3 producing robust programs theory. Table of Contents: Defensive Design Considerations Input validation Maintainability (sub programs, naming conventions, indentation, commenting) The purpose of testing Types of testing (iterative, final/terminal) Identifying syntax and logical errors Selecting and using suitable test data Refining algorithms . You may also be interested in these workbooks which have also been written to cover the J277 specification: Systems Architecture Memory and Storage Computer networks, connections and protocols Network Security Systems Software Ethical, Legal, Cultural and Environmental Impacts Algorithms Programming Fundamentals Boolean Logic Programming Languages and IDEs

This programming fundamentals workbook is perfect for students studying for the OCR GCSE (9-1) in computer science and has been updated to completely cover the new specification J277. It can be used in the classroom as a teaching aid, for self-study or as a revision tool. In this resource you will receive an interactive PDF workbook so your students can either print it out and complete the activities by hand or fill it in electronically making this an ideal workbook for use in school or for students studying at home. The answer booklet is provided as a separate PDF file so you can assign your students the workbook without including the answers. This 70-page workbook completely covers the new specification J277 2.2 programming fundamentals theory. Table of Contents: The use of variables, constants, operators, inputs, outputs and assignments Sequence Selection Iteration (count-controlled and condition-controlled loops) Common arithmetic operators Common Boolean operators (AND, OR and NOT) Data types (integer, real, Boolean, character, string and casting) Basic string manipulation File handling operations (open, read, write and close) The use of records to store data The use of SQL to search for data The use of arrays (1D and 2D arrays) How to use sub programs (functions and procedures) Random number generation . You may also be interested in these workbooks which have also been written to cover the J277 specification: Systems Architecture Memory and Storage Computer networks, connections and protocols Network Security Systems Software Ethical, Legal, Cultural and Environmental Impacts Algorithms Producing Robust Programs Boolean Logic Programming Languages and IDEs

How can you teach your students about wireless networks in an engaging way? The key is to break up the theory into small manageable chunks and reinforce each section with a variety of activities. And that is exactly what this computer science lesson does. Why spend hours making your own resources when it is all done for you? Download this wireless networks computing lesson today and save yourself all that preparation. WHAT IS INCLUDED? Suitable for GCSE Computer Science pupils following either OCR GCSE Computer Science (J277) or AQA GCSE Computer Science (8520) syllabuses. This lesson includes: an attractive dyslexia-friendly PowerPoint presentation, differentiated lesson objectives, a video to change focus and break up the lesson, loads of individual and group tasks and questions, printable ready to use worksheets for classwork, 3 differentiated exam-style questions which can be used either in the plenary or set for a homework task, a comprehensive teacher’s lesson plan including ALL THE ANSWERS. . WHAT DOES IT COVER? With virtually no preparation (apart from photocopying the worksheets) you will be ready to teach your classes about: Wi-Fi The hardware used to connect to a wireless network Public Wi-Fi hotspots The dangers associated with using hotspots Virtual private networks (VPN) The importance of encrypting wireless networks . DURATION: 1 lesson Download this ready-to-use lesson now and take back control of your workload. FREE BONUS PRODUCT INCLUDED As a special thank you for purchasing this product I am pleased to be able to also include a surprise FREE bonus gift. This gift is one of my complete resources for which I usually charge full price but is yours absolutely free when you purchase this product. Just my little way of saying thank you to my valued customers. I hope you enjoy it and get use out of it, with my compliments. Click here to see some more computer science lessons

This escape room is a wonderful no-prep lesson your students will love, to enhance their learning about creating and understanding vector graphics. Created for year 8 students this escape room combines quizzes, puzzles and sound to test their understanding of important concepts in the vector graphics unit. Absolutely no preparation, no printing and no specialist knowledge required by the teacher. This lesson makes an ideal activity to use as: part of a cover lesson, an end of term activity or a fun homework task. A fun, educational escape room game, this is sure to be a memorable activity your students will adore. HOW DOES IT WORK? This is an activity for part of a lesson and will take approximately 35 to 45 minutes to complete. Ideally, students would need headphones to make the most out of this activity, but it can be run without if necessary. Simply give the students the link to the online site (no sign up required) and away they go. Students can work individually or, if you prefer, they can work through this activity in pairs using computers located side by side. The teacher doesn’t need to do anything other than give the students the link to this online activity. All the puzzles and quizzes are self-contained with students getting feedback automatically on their progress. PLEASE NOTE: Students will need internet access in order to play this escape room game. HOW LONG DOES THE ACTIVITY LAST? It takes approximately 35 to 45 minutes to work through all the escape room challenges and makes an ideal end of unit activity to recap the skills they have learned in the unit. Alternatively, set the pupils the escape room as a fun homework task that requires no marking. Simply ask the students to send you a screenshot of the final screen to show they have completed the activity. WHAT IS INCLUDED? When you purchase this activity, you get a PDF document that contains a link to the online escape room. It also includes the answers so you can help pupils who may get into difficulty. What are you waiting for? Grab your copy of this exciting and educational escape room today to help them recap the skills they have learned with vector images. FREE BONUS PRODUCT INCLUDED As a special thank you for purchasing this product I am pleased to be able to also include a surprise FREE bonus gift. This gift is one of my complete resources for which I usually charge full price but is yours absolutely free when you purchase this product. Just my little way of saying thank you to my valued customers. I hope you enjoy it and get use out of it, with my compliments. CLICK HERE TO SEE MY VECTOR IMAGES WORKSHEETS

This network security workbook is perfect for students studying for the OCR GCSE (9-1) in computer science and has been updated to completely cover the new specification J277. It can be used in the classroom as a teaching aid, for self-study or as a revision tool. In this resource you will receive an interactive PDF workbook so your students can either print it out and complete the activities by hand or fill it in electronically making this an ideal workbook for use in school or for students studying at home. The answer booklet is provided as a separate PDF file so you can assign your students the workbook without including the answers. This 45-page workbook completely covers the new specification J277 1.4 network security theory. Table of Contents: What is network security? Forms of attack Threats posed to networks Hackers and crackers Malware Social engineering Brute Force Attacks Denial of Service Attacks Data Interception Data theft SQL injection Poor network policy Identifying and preventing vulnerabilities Penetration testing Network forensics Network policies Anti-malware software Firewalls User access levels Passwords Encryption Physical security . You may also be interested in these workbooks which have also been written to cover the J277 specification: Systems Architecture Memory and Storage Computer networks, connections and protocols Systems Software Ethical, Legal, Cultural and Environmental Impacts Algorithms Programming Fundamentals Producing Robust Programs Boolean Logic Programming Languages and IDEs

Planning you first lesson to welcome your new year 7 computing class? This lesson includes an attractive editable PowerPoint presentation which covers the following skills: Logging on to the school network Creating a strong password Searching the internet This allows you to get to your know classes a little easier, learn their names and make an initial judgment on their current ICT abilities. This resource also includes teachers lesson plan, teachers observation form and a worksheet and answers. FREE BONUS PRODUCT INCLUDED As a special thank you for purchasing this product I am pleased to be able to also include a surprise FREE bonus gift. This gift is one of our complete resources which we will usually charge full price for but is yours absolutely free when you purchase this product. Just our little way of saying thank you to our valued customers. I hope you enjoy it and get use out of it, with my compliments.

This systems architecture workbook is perfect for students studying for the OCR GCSE (9-1) in Computer Science and has been updated to completely cover the new specification J277. It can be used in the classroom as a teaching aid, for self-study or as a revision tool. In this resource you will receive an interactive PDF workbook so your students can either print it out and complete the activities by hand or fill it in electronically, making this an ideal workbook for use in school or for students studying at home. The answer booklet is provided as a separate PDF file so you can assign your students the workbook without including the answers. This 24 page workbook completely covers the new specification J277 1.1 systems architecture theory. Table of Contents: Systems Architecture Hardware Software The purpose of the CPU Von Neumann Architecture Memory Address Register (MAR) Memory Data Register (MDR) Program Counter (PC) Accumulator (AC) Common CPU Components Arithmetic / Logic unit (ALU) Control unit (CU) Cache Busses The Fetch-Execute cycle How common characteristics of CPUs affect their performance Clock speed Cache size Number of cores Purpose of embedded systems Examples of embedded systems . You may also be interested in these workbooks which have also been written to cover the J277 specification: Memory and Storage Computer networks, connections and protocols Network Security Systems Software Ethical, Legal, Cultural and Environmental Impacts Algorithms Programming Fundamentals Producing Robust Programs Boolean Logic Programming Languages and IDEs

Are you looking for some ready to use Python programming challenges that can be easily incorporated into your lessons? This worksheet can be used as a classroom activity, for a homework task or as a ready-to-use task for quick finishers, making this an invaluable resource to have in your teacher kit. Download this ready to use worksheet now and take control of your workload. Use it immediately or simply keep it in reserve for when you need it. WHAT IS INCLUDED? This 2-page PDF printable handout includes: example code, a task to read code, a task to correct code and 4 practical programming challenges. . You even have a separate PDF with possible answers. The diversity of challenges that are included allows pupils to develop a variety of useful programming skills. This resource is perfect for established computer science teachers, non-specialist teachers or newly qualified teachers. What are you waiting for? Take action straight away and grab your copy of this wonderful worksheet today that will keep your pupils engaged and making real progress. Everything is done for you which will save you hours of preparation time. Please note: This resource is a non-editable PDF FREE BONUS PRODUCT INCLUDED As a special thank you for purchasing this product I am pleased to be able to also include a surprise FREE bonus gift. This gift is one of our complete resources which we will usually charge full price for but is yours absolutely free when you purchase this product. Just our little way of saying thank you to our valued customers. I hope you enjoy it and get use out of it, with my compliments. Click Here To See More Of My Great Python Challenges

This Python programming lesson teaches pupils about using more complex if statements including if…else, elif and nested if statements. It also helps students get to grips with more complex criteria including using “and” and “or” operators. It also includes lots of practice with reading and drawing flow diagrams. Download this no-prep lesson now to help you take control of your workload. This complete lesson includes an attractive dyslexia friendly PowerPoint presentation includes a pop quiz and lots of practical programming practice. The easy to follow teacher’s lesson plan includes all the answers. This ready-to-use lesson is perfect for non-specialist teachers, newly qualified teachers and teachers who are teaching Python for the first time. Please note: This lesson does assume the pupils are familiar with using basic if and else statements in Python. Duration: 1 lesson. This lesson teaches pupils about: if…elif…else statements nested if statements “and” and “or” operators . What are you waiting for? Take action straight away and grab your copy of this wonderful lesson today that will keep your pupils engaged and making real progress. Everything is done for you which will save you hours of preparation time. FREE BONUS PRODUCT INCLUDED As a special thank you for purchasing this product I am pleased to be able to also include a surprise FREE bonus gift. This gift is one of my complete resources for which I usually charge full price but is yours absolutely free when you purchase this product. Just my little way of saying thank you to my valued customers. I hope you enjoy it and get use out of it, with my compliments. Click Here To See More Of My Great Python Lessons

Secondary storage is an important part of the computer science curriculum your pupils must understand. It often comes up in the exam in one form or another so students need to fully grasp it. This lesson completely covers both the OCR GCSE Computer Science (J277) and AQA GCSE Computer Science (8520) specifications helping your students learn about the different types of secondary storage media and compare them to each other. Why waste your precious time slaving over creating your own lesson when it has all been done for you for the price of a coffee in Starbucks? Grab this ready-to-use, no-prep lesson now to save time and take control of your workload. What does it cover? This lesson teaches pupils about: Optical storage Magnetic storage Solid state storage . What is included? You’ll get… An attractive dyslexia-friendly PowerPoint presentation that includes differentiated lesson objectives, a video and lots of tasks and questions. 3 differentiated exam style questions A comprehensive 2-page teacher’s lesson plan including all the answers. . Are you really going to spend a couple of hours of your time creating something similar when you can spend that time doing something far more fun and interesting? Grab your copy of this secondary storage complete lesson now and take control of your workload. FREE BONUS PRODUCT INCLUDED As a special thank you for purchasing this product I am pleased to be able to also include a surprise FREE bonus gift. This gift is one of my complete resources for which I usually charge full price but is yours absolutely free when you purchase this product. Just my little way of saying thank you to my valued customers. I hope you enjoy it and get use out of it, with my compliments. Check out these other useful lesson resources from Nichola Wilkin (nwilkin): The purpose of the CPU CPU Performance Von Neumann Architecture Rom, Ram and Virtual Memory Embedded Systems

Supercharge your teaching with these irresistible worksheets that ignite a passion for vector graphics! Designed to compliment your current scheme of work, these 6 stunning, no-prep worksheets enhance learning and spark critical thinking. Several worksheets are on-screen friendly meaning no printing costs, just an exciting twist in the classroom! FOR WHOM? Tailored for year 8 pupils who are learning about creating vector graphics and suitable for experienced computing teachers and non-specialist teachers. These worksheets have been developed to compliment your existing scheme of work, break up the lessons and can promote deeper thinking into the subject matter along with giving your students vital extra practice. WHAT’S INSIDE? Uncover magic with these 6 comprehensive PDF worksheets: Draw from Shapes Mouse – Students are given a simple image of a mouse that they are asked to analyse. Using the skills they have previously learnt they identify the elements that make up the image and then have a go at creating it themselves. Draw from Shapes Rocket – Similar to the previous worksheet but this involves slightly more advanced skills and is suitable for higher ability students. Combining shapes – A simple instructional worksheet pupils follow to draw a penguin. Drawing Lines – A simple instructional worksheet pupils follow to draw a fish which is useful to consolidate and embed the skills they have previously been taught. Planning your image – an attractive worksheet to help pupils plan their image they will be creating for their final project. Evaluating your project – A useful worksheet that helps pupils look at their image critically. Break monotony, energise your lessons and reinforce learning with these versatile worksheets. Ideal for time-strapped teachers seeking engaging, hassle-free activities. Transform teaching and instil skills required to create imaginative vector images. Perfect for ready-to-use alternatives to compliment your current scheme of work, these captivating worksheets are available now! Grab your copy now and embark on an exhilarating teaching journey! FREE BONUS PRODUCT INCLUDED As a special thank you for purchasing this product I am pleased to be able to also include a surprise FREE bonus gift. This gift is one of our complete resources which we will usually charge full price for but is yours absolutely free when you purchase this product. Just our little way of saying thank you to our valued customers. I hope you enjoy it and get use out of it, with my compliments.

Task cards that help your students’ confidence grow when learning programming! Have you ever felt your students were just not grasping the basics when it comes to programming? Sometimes all they need is a little bit more practice and repetition of the simple things before you move onto more complex tasks. With these quick programming tasks cards you can easily do just that. 40 TASKS CARDS WHICH FOCUS ON COUNT CONTROLLED LOOPS AND CONDITION CONTROLLED LOOPS AND NOTHING ELSE! Created for use with multiple text-based programming languages such as Python, Visual Basic, C/C++, C#, Ruby and Small Basic. These fun challenges are perfect to allow your students to recap skills you have taught them previously to help transfer those skills into their long-term memory. Buy these quick programming task cards now to give your pupils the boost they need and deserve. WHAT IS INCLUDED? There are 40 different tasks and 4 more blank cards so you can create your own additional tasks if you want. Colour and black/white versions are both included (using the same 40 tasks in each) to help you save on printing costs. If you are using the black and white version, you can print them onto coloured paper or card to add interest. WHAT PREPARATION IS REQUIRED? These tasks cards are so simple to prepare and once you have created them, you can use them time and time again. Print the pages you want to use. Colour and black/white versions are both included. If you want to reuse them, you can laminate the pages or print on card. Cut each page into 4 sections. . HOW CAN THEY BE USED? Once you have your pack of cards you can easily use them at any time you want. You can use them in so many ways… As a starter or plenary To give your pupils more practice during a lesson To give to quick finishers To help lower ability pupils reinforce the key skills . To use them you can either allocate particular cards to pupils or allow them to pick a random card from the deck themselves. Your students then create the program and can test it out on a classmate. The beauty of this activity is because all the pupils are working on different tasks their classmates will not know the answers and are often delighted by the silly and humorous responses they get from the computer. Once students have one program working correctly they can pick another card which keeps the entire class fully engaged allowing you to focus on helping the students who need your one-to-one help. An exciting and easy classroom activity to reinforce key programming skills. What are you waiting for? Buy them now and give your pupils an activity they will simply love. If you are still unsure how these can be used in your classroom, please check out my totally FREE If Statement Task Card set now so you can see how versatile and engaging these cards are for yourself.

Here are 3 ready to use programming languages worksheets you can immediately use with your class, with absolutely no preparation necessary. You even have a separate copy of each handout that contains the answers, making these a brilliant easy to use addition to your teacher toolkit. These worksheets can be printed out or completed on-screen as they comprise of PDF files with editable areas for students to enter their answers. You can even assign these worksheets as learning tasks using a VLE for students working at home. HOW CAN I USE THEM? These worksheets are ideal for An easy grab-and-go classroom activity, homework tasks and cover worksheets. . These engaging worksheets are perfect for computer science teachers, non-specialists and new teachers. WHAT IS INCLUDED? The 3 PDF worksheets included: Types of Programming Languages – A great plenary activity. Where students look at the differences between machine code, assembly language or a high-level language Purpose of Translators – A 2-page worksheet that makes an ideal homework task. Students look at the differences between a compiler and an interpreter. Integrated Development Environment (IDEs) Crossword – A lovely plenary activity to recap what your students have learnt Don’t forget the answers to each worksheet are included meaning you can use the answers yourself or give them to students for self-marking. These 3 worksheets will quickly become an essential tool in your teacher toolkit. They are a great way to break up the lesson, reinforce the learning and check your pupils’ understanding of programming languages. What are you waiting for? Buy them now and use them straight away to enhance your lessons whilst saving yourself hours of preparation. FREE BONUS PRODUCT INCLUDED As a special thank you for purchasing this product I am pleased to be able to also include a surprise FREE bonus gift. This gift is one of our complete resources which we will usually charge full price for but is yours absolutely free when you purchase this product. Just our little way of saying thank you to our valued customers. I hope you enjoy it and get use out of it, with my compliments.

Supercharge your teaching with these irresistible worksheets that ignite a passion for clear messaging in digital media! Designed to compliment your current SoW, these 5 stunning, no-prep worksheets enhance learning and spark critical thinking. Several worksheets are on-screen friendly meaning no printing costs, just an exciting twist in the classroom! FOR WHOM? Tailored for year 7 pupils who are learning about the importance of clear messaging in digital media and suitable for experienced computing teachers and non-specialist teachers. These worksheets have been developed to compliment your existing scheme of work, break up the lessons and can promote deeper thinking into the subject matter. WHAT’S INSIDE? Uncover magic with these 5 comprehensive PDF worksheets: Searching for keywords – An attractive worksheet that helps pupils understand how to identify keywords for their search criteria. Based on the popular activity of looking for a poster for an environmental charity, this helps students identify 5 keywords they can use. What makes a good poster? – An interactive activity works well on-screen or as a printout. Students are given a set of features and then need to tick if they agree or disagree if the feature would be important on a “good” poster. They then have space to justify their reasons. Evaluating your poster – A brilliant printed worksheet. Students decide on their own criteria of what makes a good poster and then evaluate their own poster in a graphical format helping them to easily see possible areas of improvement. Easy to follow instructions and an example of a completed evaluation chart are included at the top of the worksheet. Finding Content – A wonderful planning sheet which can be completed on-screen or as a printed worksheet. Helps pupils think about how they will find suitable and relevant content for their presentations. It also outlines the difference between text they have written themselves ad how to present statistics or quotes copied from a source. Evaluating another’s poster –This printed worksheet works particularly well when completed in pairs with each student evaluating the other’s presentation. Break monotony, energise your lessons and reinforce learning with these versatile worksheets. Ideal for time-strapped teachers seeking engaging, hassle-free activities. Transform teaching and instil the importance of clear messaging in digital media. Perfect for ready-to-use alternatives, these captivating worksheets are available now! Grab your copy now and embark on an exhilarating teaching journey! Click here to see my CLEAR MESSAGING IN DIGITAL MEDIA ESCAPE ROOM

This complete Python programming lesson teaches pupils hoe to create a robust user-friendly program. It allows pupils to consolidate their Python programming skills by giving them a challenging program to complete. Students need to create a program that allows messages to be encoded and decode using a Caesar cypher. While they are doing this, they are acquiring valuable skills about creating robust programs and how to break a complex task into manageable chunks along with common techniques programmers use when tackling large programs. Download this no-prep lesson now to help you take control of your workload. This ready to use lesson is suitable for Key Stage 3 qand GCSE computer science pupils. This complete lesson includes an attractive dyslexia friendly PowerPoint presentation including videos to teach the key skills and the easy to follow teachers lesson plan includes all the answers. This ready-to-use lesson is perfect for non-specialist teachers, newly qualified teachers and teachers who are teaching Python for the first time. Please note: This lesson does assume the pupils are confident with using basic programming constructs of sequence, selection (if statements) and iteration (while and for loops). Duration: 1 lesson. This lesson teaches pupils about: Using sensible variable names and user prompts Creating a menu system that works Creating a robust program that takes into account user errors to prevent them from crashing the program How to break a complex task into manageable chunks Caesar cypher Converting strings into ASCII code and converting ASCII code into strings . What are you waiting for? Take action straight away and grab your copy of this wonderful lesson today that will keep your pupils engaged and making real progress. Everything is done for you which will save you hours of preparation time. FREE BONUS PRODUCT INCLUDED As a special thank you for purchasing this product I am pleased to be able to also include a surprise FREE bonus gift. This gift is one of our complete resources which we will usually charge full price for but is yours absolutely free when you purchase this product. Just our little way of saying thank you to our valued customers. I hope you enjoy it and get use out of it, with my compliments. Click Here To See More Of My Great Python Lessons

This Python lesson is perfect for GCSE computer science classes learning how to manage large programming projects. It shows them how they can use structure diagrams in the planning stages to help visualise how a large programming project may be created. It includes an attractive dyslexia-friendly PowerPoint presentation that includes differentiated lesson objectives, a pop quiz and lots of practice drawing structure charts. It also includes a teacher’s lesson plan that contains suggested complete answers and three handouts. This ready-to-use lesson is perfect for non-specialist teachers, newly qualified teachers and teachers who are teaching Python for the first time. Download this ready-to-use lesson now and take control of your workload. Please note: This lesson does assume your students are familiar with the KS3 national curriculum requirements and have previously been taught how to use sub programs, selection and iteration. Duration: 1 lesson. This lesson helps pupils understand the following key skills: What is a structure diagram? What do the symbols mean in a structure chart? How do you decompose a problem? How are subprograms used to split up larger programs into smaller more manageable chunks? . What are you waiting for? Take action straight away and grab your copy of this wonderful lesson today that will keep your pupils engaged and making real progress. Everything is done for you which will save you hours of preparation time. FREE BONUS PRODUCT INCLUDED As a special thank you for purchasing this product I am pleased to be able to also include a surprise FREE bonus gift. This gift is one of my complete resources for which I usually charge full price but is yours absolutely free when you purchase this product. Just my little way of saying thank you to my valued customers. I hope you enjoy it and get use out of it, with my compliments. Click Here To See More Of My Great Python Lessons

This visually appealing knowledge organiser is a quick summary to recap systems architecture. It can help pupils revise for end-of-unit tests or GCSE computer science exams by including small straightforward facts that can be learned in minutes. A powerful revision aid that your students will love. What are you waiting for? Grab your copy now and together we can boost your pupils’ confidence in understanding systems architecture. WHAT IS INCLUDED? This PDF knowledge organiser includes the important facts and a separate PDF document includes revision tips and an exam style question including a possible answer. HOW CAN I USE IT? This resource makes an ideal homework task, can be used as part of a lesson or given to pupils to help them with their revision. WHAT DOES IT COVER? This knowledge organiser includes easy to digest facts on the following topics: The purpose of the CPU Von Neumann Architecture Fetch, decode, execute cycle Factors that affect the performance of the CPU Cache memory Embedded systems . Get your copy of this fantastic knowledge organiser now. You’ll wonder how you ever managed without it. FREE BONUS PRODUCT INCLUDED As a special thank you for purchasing this product I am pleased to be able to also include a surprise FREE bonus gift. This gift is one of my complete resources for which I usually charge full price but is yours absolutely free when you purchase this product. Just my little way of saying thank you to my valued customers. I hope you enjoy it and get use out of it, with my compliments. Click here to see my other computer science knowledge organisers

This is lesson 4 from a series of 6 lessons which teach pupils computational thinking. In this lesson pupils learn about Algorithms and creating flow charts using selection and iteration This lesson includes a PowerPoint presentation, fun activities to reinforce their learning and a differentiated homework task. There is also a teacher’s guide containing answers. For the full 6 lesson unit which also includes an end of unit test and self-assessment student marking sheet use this link https://www.tes.com/teaching-resource/computational-thinking-6-lesson-unit-of-work-gcse-computer-science-and-ks3-computing-11597274. FREE BONUS PRODUCT INCLUDED As a special thank you for purchasing this product I am pleased to be able to also include a surprise FREE bonus gift. This gift is one of our complete resources which we will usually charge full price for but is yours absolutely free when you purchase this product. Just our little way of saying thank you to our valued customers. I hope you enjoy it and get use out of it, with my compliments.

This lesson is perfect to for students learning how to create their own SQL databases using DB Browser and SQLite. In this lesson the pupils create an SQL database using DB Browser (free software) which helps them understand what tables are, the importance of field names and the data types used in an SQL database. It also introduces them to the concept of primary keys. Although pupils are not using Python at all in this lesson and are instead using DB Browser it sets them up for the next lesson in the series (available from here) which does allow them to start interrogating an SQL database using Python. Please note this lesson will NOT teach them how to interrogate an SQL database using Python and it instead teaches them how to create an external database using DB Browser. Download this no-prep lesson now to help you take control of your workload. This teaching resource includes an attractive dyslexia friendly PowerPoint presentation and the teachers lesson plan that includes the answers. This ready-to-use lesson is perfect for non-specialist teachers, newly qualified teachers and teachers who are teaching Python for the first time. Please note: In order to use this lesson you MUST download and install DB Browser on every computer prior to the lesson. You can download the latest version of DB Browser for free from https : // sqlitebrowser . org / Duration: 1 lesson This lesson teaches pupils about: What is a database Tables Fields and records Primary key Setting up a database using DB Bowser SQL data types Adding data to a table in DB Browser Filtering data in a table in DB Browser . FREE BONUS PRODUCT INCLUDED As a special thank you for purchasing this product I am pleased to be able to also include a surprise FREE bonus gift. This gift is one of our complete resources which we will usually charge full price for but is yours absolutely free when you purchase this product. Just our little way of saying thank you to our valued customers. I hope you enjoy it and get use out of it, with my compliments. What are you waiting for? Take action straight away and grab your copy of this wonderful lesson today that will keep your pupils engaged and making progress and save you preparation time. ** [Click Here To See More Of My Great Python Lessons] (https://www.tes.com/resources/search/?authorId=835903&q=Python Lessons&shop=nwilkin)**