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

Do your students need a little extra help with understanding if statements in Python programming? Are you looking for some ready to use 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 identify the main operators, a task to correct code and 3 practical challenges for them to practice writing if statements in Python code. . You even have a separate PDF with possible answers. The diversity of these if statement challenges allow 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 visually appealing knowledge organiser is a quick summary to recap how to Python programming techniques. It can help pupils revise for end of unit tests, helping them as a prompt when programming or GCSE computer science exams by including small straightforward facts that can be learnt in minutes. A powerful revision/programming prompt aid that your students will love. What are you waiting for? Grab your copy now and together we can boost your pupil’s confidence in understanding how to create Python programs. WHAT IS INCLUDED? This PDF knowledge organiser includes the important facts and a separate PDF document includes 3 programming challenges and possible solutions. 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. Also great for students to have on their desks to use as a quick guide to remind them of key Python programming techniques WHAT DOES IT COVER? This knowledge organiser includes easy to digest facts on the following topics: Variables, constants, operators, inputs and outputs Sequence Selection Iteration String manipulation Basic file handling SQL searches 1D and 2D arrays Using subprograms Data types Arithmetic and Boolean operators . 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

Here are 6 ready to use computer systems worksheets you can immediately use with your class with absolutely no preparation necessary. They 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. 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. 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 6 PDF worksheets included: Input, Process, Storage, Output – An easy worksheet where students need to write their understanding about each term. A great starter activity o find out your students’ current understanding before starting the a computer systems unit. Hardware and Software – This simple worksheet asks students to explain the difference between hardware and software and identify hardware and software from the listed items. This is perfect for a starter or a plenary to recap what they have learnt. Inside the Computer – This asks students to write how different pieces of hardware are used inside a typical computer system. Great as a homework task. Von Neumann Architecture – Students describe what the different registers and parts of a CPU do, including the program counter, accumulator, arithmetic/logic unit and control unit. Great as a homework or to assess their understanding of the parts of the CPU. System Architecture Crossword – Students complete a crossword by using the clues given to them. A nice way of assessing their understanding of key phrases. Perfect for a homework task or plenary. Fetch, Decode, Execute – Students read the description of the processes and tick if they take part in the fetch, decode or execute sections of the processing life cycle. Great as a plenary activity. 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 6 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 computer systems. What are you waiting for? Buy them now and use them straight away to enhance your lessons whilst saving yourself hours of preparation.

This written end of unit test can be used to assess the pupils understanding of Computational Thinking. It asks questions on decomposition, pattern recognition, abstraction, algorithms, creating flow charts including using selection and iteration and pseudocode including INPUT, OUTPUT, IF…THEN, IF…THEN…ELSE, IF…THEN…ELSEIF…ELSE statements, FOR, WHILE and REPEAT UNTIL loops Suitable for GCSE Computer Science classes and KS3 Computing classes. 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.

Are you looking for a robust, ready to use summative assessment to test your students understanding of data representation? Computers science teachers have been left in a wilderness, without a rigorous, fair and consistent way to test your student’s knowledge in key stage 3 … UNTIL NOW! WHAT IS TESTED? This written test has been carefully mapped to the UK’s Computing At Schools (CAS) Progression Pathways. It includes a mixture of multiple-choice, short answer and long answer questions. This assessment covers the following CAS Progression Pathway descriptions: Performs more complex searches for information e.g. using Boolean and relational operators. Analyses and evaluates data and information and recognises that poor quality data leads to unreliable results, and inaccurate conclusions. Knows that digital computers use binary to represent all data. Understands how bit patterns represent numbers and images. Knows that computers transfer data in binary. Understands the relationship between binary and file size (uncompressed) Defines data types: real numbers and Boolean. Queries data on one table using a typical query language. Understands how numbers, images, sounds and character sets use the same bit patterns. Performs simple operations using bit patterns e.g. binary addition. Understands the relationship between resolution and colour depth, including the effect on file size. Distinguishes between data used in a simple program (a variable) and the storage structure for that data. . The test lasts 50 minutes. WHO IS THIS ASSESSMENT FOR? This test is paper 1 and has been written for year 7. HOW DO I USE THE ASSESSMENT? This assessment is super easy to use. Simply print out the question paper and give to your students. It is better to run this assessment in class rather than as a homework task to ensure reliability. Students complete the test on paper. HOW IS THE ASSESSMENT MARKED? You mark the papers yourself but don’t worry, you get an easy to follow mark scheme and can even watch the helpful video which shows you exactly how to mark it. HOW IS THE ASSESSMENT GRADED? Included in the resource is an Excel spreadsheet. Once you enter the marks onto the spreadsheet, it will automatically show you the total marks, the grade (A* to U) and if they have met expectations, are above expectations or are below expectations to help you with report writing. You also get a summary showing you how well the CAS Progression Pathways have been answered by your students to help you with future planning. This simple, easy to use summative assessment paper provides you with useful feedback your senior leadership team will love. Download it now to add it to your teacher toolkit.

Here are 8 ready to use worksheets to help students recap how a computer works and the hardware that is commonly found inside a computer. You can immediately use these worksheets 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 8 PDF worksheets included: Building a computer – This worksheet asks pupils to perform some internet research to find out the price and descriptions of common pieces of hardware. It also includes an extension activity for pupils to research Doug Engelbart. How does a computer work – Students label a diagram of the Von Neumann computer model based on the description given. Input and Output – an ideal homework activity where pupils identify common input and output devices found in their home. Inside a computer crossword – You have two versions of this crossword which uses picture clues rather than written clues. One version even includes the words they will need which can help lower ability pupils with the spelling of key words. Inside a computer – Pupils write descriptions of common hardware found inside computers including power supply, motherboard, fan, hard drive, expansion cards, ROM, RAM, CPU and heat sink. A great assessment activity. Inside devices – a nice quick activity demonstrating how different devices will have the same technology inside. Pupils need to identify the file storage, motherboard and power supply/battery in a laptop and a desktop computer. Memory and Storage – Pupils answer questions non the differences between ROM and RAM and a magnetic hard drive and a SSD. 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 8 worksheets will quickly become an essential tool in your teacher toolkit. Looking for more worksheets? Click here to see my other ready to use classroom worksheets for computer science. They are a great way to break up the lesson, reinforce the learning and check your pupils’ understanding of memory and storage. What are you waiting for? Buy them now and use them straight away to enhance your lessons whilst saving yourself hours of preparation.

This has got to be one of the most unusual and fun ways of introducing your students to the delights of the bubble, insert and merge sorting algorithms. Even if your exam board only teaches two of these sorting algorithms it’s still worth getting this activity and teaching all three as it is just so much fun! Using an escape room activity that involves a witch and a goblin (who doesn’t want that?) your students will learn the basics of how these three algorithms work. This is a student-led interactive escape room activity that is ideal for social distancing and does not require any student computers and they can remain at their individual desks and yet they will still be working together. The entire activity will last a single lesson. Your role is to not do a lot and put the emphasis on your students working together. Early on you will be turned into a goblin! Sorry (not really sorry) so you may want to practise your goblin roar for when it’s called upon. Students therefore cannot rely on you to help them (because you’ll be a goblin) and they’ll have to work together (either as a whole class or in smaller teams if you prefer) to try and solve all the riddles in their “spell books” for themselves. The main activity is introduced via a whole-class PowerPoint presentation which includes videos giving the students vital instructions and helping them if necessary. Each pupil is given a printout of the spell book which contains all the challenges. This escape room style activity gives your students a great introduction to the three sorting algorithms (bubble sort, insert sort and merge sort) and will certainly give your students a boost at the start of learning this topic. Suitable for higher KS3 classes and GCSE Computer Science classes. 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.

This highly engaging series of 3 lessons can be run with no student computers so is suitable for lessons in a standard non-ICT classroom, in a computer suite or when pupils are self-isolating at home. Each lesson comes with a dyslexia-friendly PowerPoint presentation that includes all the instructions and takes the teacher and class through each lesson making this resource suitable for specialist and non-specialist teachers. The students have a workbook they fill in each lesson as they progress, extending their knowledge and helping you monitor their progress. An answer book is provided which can be used by the teacher or issued to students as a self-marking aid. This is a hands-on enjoyable series of three lessons that help pupils understand the hardware in a computer along with common software. Written for KS3 this is suitable for years 7 to 9 and can even be used with GCSE groups if you wish. Equipment needed: pupils should have access to a pair of scissors, a glue stick and a sheet of colourful A4 (or letter sized) paper along with a print-out of the 7-page template and 13-page workbook each (oh, and they will also need a pen). 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.

Here are 12 ready to use algorithms 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. Most of the worksheets can be printed out or completed on-screen as they comprise of PDF files with editable areas for students to enter their answers. HOW CAN I USE THEM? These worksheets are ideal for An easy grab-and-go classroom activity, homework tasks and cover worksheets. . WHAT IS INCLUDED? The 12 PDF worksheets included: Human and Computer Tasks – Brilliant as a introduction to algorithms. Students decide which of the tasks are most suitable for a human or a computer/robotic system which form a basis of a class discussion. Flow diagrams – Students explain what the shapes of the flow diagram are used for. They also read a flow diagram and demonstrate their understanding by giving the outputs for a variety of inputs. A lovely homework task or plenary. Pseudocode – Students are given sample pseudocode using a If…else statement. They explain what the algorithm will do and then write their own pseudocode for another scenario. Great to check current understanding, as a plenary or for a homework task. Pseudocode – Similar to worksheet 3 based on if…else if… else pseudocode. Pseudocode – Similar to worksheet 3 based on while loop pseudocode. Pseudocode – Similar to worksheet 3 based on for loop pseudocode. Pseudocode – Similar to worksheet 3 based on using a list with pseudocode. Pseudocode – Students examine a flow diagram and write the pseudocode to match the flow diagram. A nice in-class activity to reinforce learning. Flow diagram – Students are given pseudocode for a while loop and they need to draw a flow diagram to match the algorithm. A Lovely starter or plenary activity to check understanding. Pseudocode and flow diagram – A great 2-page worksheet. Students are given details for an algorithm they need to create based on a hotel costing system. They need to write the pseudocode and then draw the flow diagram for the algorithm. Pseudocode and flow diagram - Similar to worksheet 10 based on an addition quiz algorithm. Pseudocode and flow diagram - Similar to worksheet 10 based on a list algorithm. Worksheets 9 to 12 are designed to be printed and filled in by hand due to the drawing elements involved. 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. What are you waiting for? Buy them now and use them straight away to enhance your lessons whilst saving yourself hours of preparation. You may also be interested in my Computational Thinking Worksheets which you can buy from here.

How can you teach your students about the purpose of the CPU 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 lesson does. Why spend hours making your own resources when it is all done for you? Download this lesson today and save yourself all that preparation. WHAT IS INCLUDED? Suitable for GCSE Computer Science pupils following either OCR GCSE Computer Science (J277) and 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, a printable ready-to-use worksheet for classwork, 3 differentiated exam-style questions which can be used either in the plenary or set for a homework task, a comprehensive 2-page teacher’s lesson plan including ALL THE ANSWERS. . WHAT DOES IT COVER? With virtually no preparation (apart from photocopying the single page worksheet) you will be ready to teach your classes about: the relationship between hardware and software the fetch - decode - execute cycle address busses and data busses the purpose and main functions of the CPU . **DURATION: **1 lesson Please note: This lesson does not teach pupils about the Von Neumann Architecture as that is covered in a separate lesson. 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 great resources by Nichola Wilkin (nwilkin): CPU Performance Von Neumann Architecture Rom, Ram and Virtual Memory Embedded Systems Secondary Storage

This complete Python programming lesson teaches pupils how to create and amend simple one-dimensional lists in Python. This lesson deals with one-dimensional lists only. It does not teach pupils about two-dimensional lists as that is covered in another lesson available from here. Download this no-prep lesson now to help you take control of your workload. 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: Creating simple 1D lists Displaying the list Displaying the list with each item on a separate line Displaying single items in a list Adding data to the end of a list Adding data to a specific position in the list Altering data in a list Removing data from a list Finding the length of a list . 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. 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

How can you teach your students about ROM, RAM and virtual memory 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 ROM, RAM and virtual memory 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, videos to change focus and break up the lesson, loads of individual and group tasks and questions, a printable ready-to-use worksheet 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 about your classes about: The difference between ROM and RAM The need for virtual memory and identifies a disadvantage of using virtual memory The types of RAM technology available (DRAM and SRAM) . DURATION: 1 lesson Download this fantastic, 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 complete Python programming lesson teaches pupils how to use subprograms including how to pass variables, call subprograms and use local and global variables. 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 and 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 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 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: Subprograms Passing variable to a subprogram Returning variables from a subprogram to the main program Local and global variables . 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. 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] (https://www.tes.com/resources/search/?authorId=835903&q=Python Lessons&shop=nwilkin)

Do your students need a little extra help understanding how to use the turtle to draw patterns using Python programming? Are you looking for some ready-to-use 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 tasks to read code, a task to correct code and 3 practical challenges for them to practice writing Python code. . You even have a separate PDF with possible answers. The diversity of these turtle challenges 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 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 Challenges

This Fundamentals of Computer Networks workbook is perfect for students studying for the AQA GCSE (9-1) in computer science and has been updated to completely cover the new specification 8525. 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 33-page workbook completely covers the new specification 8525 3.5 Fundamentals of Computer Networks theory. Table of Contents: PAN, LAN and WAN Lan topologies (star and bus) Network protocols (Ethernet, Wi-Fi, TCP, UDP, IP, HTTP, HTTPS, FTP, SMTP and IMAP) Network security (authentication, encryption, firewall and MAC address filtering) 4-layer TCP/IP model (application layer, transport layer, internet layer and link layer) . 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. You may also be interested in these workbooks which have also been updated for the new specification: Algorithms Python Programming Fundamentals of Data Representation Computer Systems Cyber Security Relational databases and SQL Ethical, Legal and Environmental Impacts

This Python programming workbook is perfect for students studying for the AQA GCSE (9-1) in computer science and has been updated to completely cover the new specification 8525. 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 88-page workbook completely covers the new specification 8525 3.2 Programming theory and gives pupils plenty of practical Python challenges to complete. Table of Contents: Data types Variables and constants Iteration Selection Subroutines (procedures and functions) Nested selection and iteration structures Arithmetic operations Relational operations Boolean operations Data structures (1D and 2D arrays) Use of records String handling Random number generation A structures approach to programming Robust and secure programming Syntax and logic errors . 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. You may also be interested in these workbooks which have also been updated for the new specification: Algorithms Fundamentals of Data Representation Computer Systems Fundamentals of Computer Networks Cyber Security Relational databases and SQL Ethical, Legal and Environmental Impacts

This is exceptional value as it includes my “Relational Databases and Structured Query Language (SQL)” workbook and answer book, clear instructions to walk you through installing DB Browser and two databases to practise with. This pack is perfect for students studying for the AQA GCSE (9-1) in computer science and has been updated to completely cover the new specification 8525. 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. As part of that workbook it also includes gives clear, easy to follow instructions for creating an SQL database using DB Browser. It also shows how Python can be used to insert, update and delete data in the SQL database as well as retrieving specific data from the SQL database using select, from, where and order by. A separate PDF answer booklet is provided giving you all the answers to the tasks in the workbook so you can assign your students the workbook without including the answers. The 39-page workbook completely covers the new specification 8525 3.7 Relational Databases and Structured Query Language (SQL) section of the AQA (8525) GCSE in Computer Science. Table of Contents: Explain the concepts of databases Relational databases Table Record Field Primary Key Foreign key SQL SELECT FROM WHERE ORDER BY … ASC / DESC INSERT INTO UPDATE DELETE FROM . You may also be interested in these workbooks which have also been updated for the new specification: Algorithms Python Programming Fundamentals of Data Representation Computer Systems Fundamentals of Computer Networks Cyber Security Ethical, Legal and Environmental Impacts