These adaptable PowerPoint Presentations (79 Slides) cover all aspects of the specification in relation to Edexcel GCSE Computer Science 1CP2 (from 2020) topic 5. It includes: Teaching PowerPoints (including checkpoint questions and answers) Student PowerPoints (Including checkpoint questions, but omits the answers) Content Covered: · understand environmental issues associated with the use of digital devices (energy consumption, manufacture, replacement cycle, disposal) · understand ethical and legal issues associated with the collection and use of personal data (privacy, ownership, consent, misuse, data protection) · understand ethical and legal issues associated with the use of artificial intelligence, machine learning and robotics (accountability, safety, algorithmic bias, legal liability) · understand methods of intellectual property protection for computer systems and software (copyright, patents, trademarks, licencing) · understand the threat to digital systems posed by malware (viruses, worms, Trojans, ransomware, key loggers) and how hackers exploit technical vulnerabilities (unpatched software, out-of-date anti-malware) and use social engineering to carry out cyberattacks · understand methods of protecting digital systems and data (anti-malware, encryption, acceptable use policies, backup and recovery procedures)

This photocopiable resource has been produced to provide 7 to 14 year olds with exciting and engaging opportunities to learn coding concepts using Python in a fun standalone project. Mystery of the Crystal Ball - Students have fun looking into their future. Students learn to use the time and random modules, Variables and IF-ELIF statements. The project takes around one hour to complete and includes a series of activities to extend learning.

This photocopiable resource has been produced to ensure that your students are able to successfully complete their GCSE Computer Science GCSE (9-1), but can also be used by other exam systems. This test has been designed to provide a stimulating, engaging and effective way of assessing the progress of your students. As well as the topic test, you are also provided with a comprehensive marking scheme. Please be aware that there may be appropriate alternative answers to some of the questions, and it is therefore suggested that the teacher uses their discretion when marking students work.

This photocopiable resource has been produced to ensure that your students are able to successfully complete their GCSE Computer Science GCSE (9-1), but can also be used by other exam systems. This test has been designed to provide a stimulating, engaging and effective way of assessing the progress of your students. As well as the topic test, you are also provided with a comprehensive marking scheme. Please be aware that there may be appropriate alternative answers to some of the questions, and it is therefore suggested that the teacher uses their discretion when marking students work.

This sample project is designed to provide a stimulating, engaging and effective way of preparing students for the Programming Project Component of the 9-1 GCSE in computer science. Students use Python to create a Quiz Board Game. Including: Sample project scenario Sample student solution Sample Python code

This photocopiable resource has been produced to ensure that your students are able to successfully complete the OCR Computer Science GCSE NEA. This support pack is designed to provide a stimulating, engaging and effective way of preparing both teachers and students for the Non-Examined Assessment Component of the 9-1 GCSE in computer science. The pack contains: Introduction for students - NEA Procedures Technical Preparation for the NEA component J276 Programming project Sample Task 1 - Archside Academy Detention Database. Including: NEA sample project scenario NEA sample student solution NEA sample Python code J276 Programming project Sample Task 2 - Quiz Board Game Including: NEA sample project scenario NEA sample student solution NEA sample Python code Help sheet 1 - Creating a board game using Python - Includes a complete set of instructions Help sheet 2 - Creating a database using Python - Includes a complete set of instructions Help Sheet 3 - Menus, Lists and Exporting using Python - Includes a complete set of instructions

These adaptable PowerPoint Presentations (111 Slides) cover all aspects of the specification in relation to OCR GCSE Computer Science J277 (from 2020) component 1.3. It includes: Teaching PowerPoint Presentations (including checkpoint questions and answers) Part 1 – Networks & Topologies (66 slides) Part 2 - Wired & Wireless Networks, Protocols & Layers (45 slides) Student PowerPoint Presentations (Including checkpoint questions, but omits the answers) Part 1 – Networks & Topologies Part 2 - Wired & Wireless Networks, Protocols & Layers Content Covered: Types of network: LAN (Local Area Network) WAN (Wide Area Network) Factors that affect the performance of networks The different roles of computers in a client-server and a peer-to-peer network The hardware needed to connect stand-alone computers into a Local Area Network: Wireless access points Routers Switches NIC (Network Interface Controller/Card) Transmission media The Internet as a worldwide collection of computer networks: DNS (Domain Name Server) Hosting The Cloud Web servers and clients Star and Mesh network topologies Modes of connection: Wired - Ethernet Wireless Wi-Fi & Bluetooth Encryption IP addressing and MAC addressing Standards Common protocols including: TCP/IP (Transmission Control Protocol/Internet Protocol) HTTP (Hyper Text Transfer Protocol) HTTPS (Hyper Text Transfer Protocol Secure) FTP (File Transfer Protocol) o POP (Post Office Protocol) IMAP (Internet Message Access Protocol) SMTP (Simple Mail Transfer Protocol) The concept of layers

These adaptable PowerPoint Presentations (62 Slides) cover all aspects of the specification in relation to OCR GCSE Computer Science J277 (from 2020) component 1.1. It includes: · Teaching PowerPoint (includes checkpoint questions and answers) · Student PowerPoint (Includes checkpoint questions, but omits the answers) Content: The purpose of the CPU: The fetch-decode-execute cycle Common CPU components and their function: ALU (Arithmetic Logic Unit) CU (Control Unit) Cache Registers Von Neumann architecture: MAR (Memory Address Register) MDR (Memory Data Register) Program Counter Accumulator How common characteristics of CPUs affect their performance: Clock speed Cache size Number of cores

This pack consists of 14 end of topic tests that can be used to support your delivery of the course. In addition, the topic test bundle also contains a mark scheme for each test. Unit 1.1 – 1 Test Unit 1.2 – 3 Tests Unit 1.3 – 2 Tests Unit 1.4 -1 Test Unit 1.5 - 1 Test Unit 1.6 - 1 Test Unit 2.1 - 1 Test Unit 2.2 - 1 Test Unit 2.3 - 1 Test Unit 2.4 - 1 Test Unit 2.5 - 1 Test

These adaptable PowerPoint Presentations (125 Slides) cover all aspects of the specification in relation to AQA GCSE Computer Science 8525 (from 2020) component 3.3. It includes: Teaching PowerPoints (including checkpoint questions and answers) - 125 Slides Student PowerPoints (Including checkpoint questions, but omits the answers) Content Covered: Understand the following number bases: • decimal (base 10) • binary (base 2) • hexadecimal (base 16). Understand that computers use binary to represent all data and instructions. Explain why hexadecimal is often used in computer science. Understand how binary can be used to represent whole numbers. Understand how hexadecimal can be used to represent whole numbers. Be able to convert in both directions between: • binary and decimal • binary and hexadecimal • decimal and hexadecimal. Know that: • a bit is the fundamental unit of information • a byte is a group of 8 bits. Know that quantities of bytes can be described using prefixes. Know the names, symbols and corresponding values for the decimal prefixes: • kilo, 1 kB is 1,000 bytes • mega, 1 MB is 1,000 kilobytes • giga, 1 GB is 1,000 Megabytes • tera, 1 TB is 1,000 Gigabytes. Be able to compare quantities of bytes using the prefixes above. Be able to add together up to three binary numbers. Be able to apply a binary shift to a binary number. Describe situations where binary shifts can be used. Understand what a character set is and be able to describe the following character encoding methods: • 7-bit ASCII • Unicode. Understand that character codes are commonly grouped and run in sequence within encoding tables. Describe the purpose of Unicode and the advantages of Unicode over ASCII. Know that Unicode uses the same codes as ASCII up to 127. Understand what a pixel is and be able to describe how pixels relate to an image and the way images are displayed. Describe the following for bitmaps: • image size • colour depth. Know that the size of a bitmap image is measured in pixels (width x height). Describe how a bitmap represents an image using pixels and colour depth. Describe using examples how the number of pixels and colour depth can affect the file size of a bitmap image. Calculate bitmap image file sizes based on the number of pixels and colour depth. Convert binary data into a bitmap image. Convert a bitmap image into binary data. Understand that sound is analogue and that it must be converted to a digital form for storage and processing in a computer. Understand that analogue signals are sampled to create the digital version of sound. Describe the digital representation of sound in terms of: • sampling rate • sample resolution. Calculate sound file sizes based on the sampling rate and the sample resolution. Explain what data compression is. Understand why data may be compressed and that there are different ways to compress data.

These adaptable Powerpoint Presentations (274 Slides) cover all aspects of the specification in relation to Edexcel GCSE Computer Science 1CP2 (from 2020) topic 1 and topic 6. These two topics have been combined so that students can learn about algorithms and at the same time have the opportunity to understand how algorithms can then be developed into programs. The programming language used is Python. It includes: Teaching PowerPoints (including checkpoint questions and answers) Student PowerPoints (Including checkpoint questions, but omits the answers) Content Covered: Topic 1 · understand the benefit of using decomposition and abstraction to model aspects of the real world and analyse, understand and solve problems · understand the benefits of using subprograms · be able to follow and write algorithms (flowcharts, written descriptions, draft program code or assessment reference language) that use sequence, selection, repetition (count-controlled, pre-conditioned, post-conditioned) and iteration (over every item in a data structure), and input, processing and output to solve problems · understand the need for and be able to follow and write algorithms that use variables and constants and one- and two-dimensional data structures (strings, records, arrays) · understand the need for and be able to follow and write algorithms that use arithmetic operators (add, subtract, divide, multiply, modulus, integer division), relational operators (equal to, less than, greater than, not equal to, less than or equal to, greater than or equal to) and logical operators (AND, OR, NOT) · be able to determine the correct output of an algorithm for a given set of data and use a trace table to determine what value a variable will hold at a given point in an algorithm · be able to identify and correct errors (logic, runtime) in algorithms · understand how standard algorithms (bubble sort, merge sort, linear search, binary search) work · be able to use logical reasoning and test data to evaluate an algorithm’s fitness for purpose and efficiency (number of compares, number of passes through a loop, use of memory) · be able to apply logical operators (AND, OR, NOT) in appropriate truth tables to solve problems Topic 6 · be able to use decomposition and abstraction to analyse, understand and solve problems · be able to read, write, analyse and refine programs written in a high-level programming language · be able to convert algorithms (flowcharts, written descriptions) into programs and convert programs into algorithms · be able to use techniques (layout, comments, meaningful identifiers, white space) to make programs easier to read, understand and maintain · be able to identify, locate and correct program errors (logic, syntax, runtime) etc

These adaptable PowerPoint Presentations (33 Slides) cover all aspects of the specification in relation to OCR GCSE Computer Science J277 (from 2020) component 1.5. It includes: Teaching PowerPoints (includes checkpoint questions and answers) Student PowerPoints (Includes checkpoint questions, but omits the answers) Content Covered: The purpose and functionality of operating systems: User interface Memory management and multitasking Peripheral management and drivers User management File management The purpose and functionality of utility software Utility system software: Encryption software Defragmentation Data compression

These adaptable PowerPoint Presentations (23 Slides) cover all aspects of the specification in relation to AQA GCSE Computer Science 8525 (from 2020) component 3.7. It includes: Teaching PowerPoint Presentations (includes checkpoint questions and answers) - 23 slides Student PowerPoint Presentations (Includes checkpoint questions, but omits the answers) Content Covered: Explain the concept of a database. Explain the concept of a relational database. Understand the following database concepts: • table • record • field • primary key • foreign key. Understand that the use of a relational database facilitates the elimination of data inconsistency and data redundancy. Be able to use SQL to retrieve data from a relational database, using the commands: • SELECT • FROM • WHERE • ORDER BY…ASC | DESC Be able to use SQL to insert data into a relational database using the commands. INSERT INTO table_name (column1, column 2 …) VALUES (value1, value2 …) Be able to use SQL to edit and delete data in a database using the commands. UPDATE table name SET column1 = value1, column2 = value2 … WHERE condition DELETE FROM table_name WHERE condition

This pack consists of 13 end of topic tests that can be used to support your delivery of the course. In addition, the topic test bundle also contains a mark scheme for each test. Topic 1 & 6 - 3 Tests Topic 2 – 1 Test Topic 3 – 5 Tests Topic 4 – 2 Tests Topic 5 – 2 Tests

In this lesson you learn about 2D Arrays or as they are called in Python - 2D Lists. You will learn how to create a list, append a new item to a list, search for an item in a 2D list and displaying a 2D list as a table. Python and the Python Logo are trademarks or registered trade marks of the Python Software Foundation.

In this lesson you will learn how you can create functions and procedures. This is an essential skill if you want to create more complex problems. Python and the Python Logo are trademarks or registered trade marks of the Python Software Foundation.

This lesson provides an introduction to the use of arrays in Python - These are called lists. The lesson goes through a range of techniques for manipulating and managing simple lists. The next lesson will cover 2D Arrays (2D Lists). Python and the Python Logo are trademarks or registered trade marks of the Python Software Foundation.