These adaptable PowerPoint Presentations (38 Slides) cover all aspects of the specification in relation to AQA GCSE Computer Science 8525 (from 2020) component 3.8. It includes: Teaching PowerPoint Presentations (includes checkpoint questions and answers) - 38 slides Student PowerPoint Presentations (Includes checkpoint questions, but omits the answers) Content Covered: Explain the current ethical, legal and environmental impacts and risks of digital technology on society. Where data privacy issues arise, these should be considered. Exam questions will be taken from the following areas: • cyber security • mobile technologies • wireless networking • cloud storage • hacking (unauthorised access to a computer system) • wearable technologies • computer-based implants • autonomous vehicles.

These adaptable PowerPoint Presentations (42 Slides) cover all aspects of the specification in relation to OCR GCSE Computer Science J277 (from 2020) component 2.4. It includes: Teaching PowerPoint Presentations (includes checkpoint questions and answers) Student PowerPoint Presentations (Includes checkpoint questions, but omits the answers) Content Covered: Simple logic diagrams using the operators AND, OR and NOT Truth tables Combining Boolean operators using AND, OR and NOT Applying logical operators in truth tables to solve problems

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 (74 Slides) cover all aspects of the specification in relation to AQA GCSE Computer Science 8525 (from 2020) component 3.1. It includes: Teaching PowerPoint Presentations (includes checkpoint questions and answers) -74 Slides Student PowerPoint Presentations (Includes checkpoint questions, but omits the answers) Content Covered: Understand and explain the term algorithm. Understand and explain the term decomposition. Understand and explain the term abstraction. Use a systematic approach to problem solving and algorithm creation representing those algorithms using pseudo-code, program code and flowcharts. Explain simple algorithms in terms of their inputs, processing and outputs. Determine the purpose of simple algorithms. Understand that more than one algorithm can be used to solve the same problem. Compare the efficiency of algorithms explaining how some algorithms are more efficient than others in solving the same problem. Understand and explain how the linear search algorithm works. Understand and explain how the binary search algorithm works. Compare and contrast linear and binary search algorithms. Understand and explain how the merge sort algorithm works. Understand and explain how the bubble sort algorithm works. Compare and contrast merge sort and bubble sort algorithms.

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

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 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. Python is used as the programming language.

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

This is an 18 page introduction to programming using Python. It includes: Python -The Basics The use of variables, constants, operators, inputs, outputs and assignments The use of data types The use of basic string manipulation Each section includes activities for the students to complete. I would greatly appreciate feedback on what you think of this resource.

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

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.