NEW J277 SPEC Here you will find easy to follow revision sheets which will help your students to recap the topic: 1.6 Ethical, Legal, Cultural and Environmental Impacts of Digital Technology ¨ Impacts of digital technology on wider society including: o Ethical issues o Legal issues o Cultural issues o Environmental issues o Privacy issues ¨ Legislation relevant to Computer Science: o The Data Protection Act 2018 o Computer Misuse Act 1990 o Copyright Designs and Patents Act 1988 o Software licences (i.e. open source and proprietary)

NEW J277 SPECIFICATION Here you will find easy to follow revision sheets which will help your students to recap the topic: 1.3 Computer Networks, Connections and Protocols 1.3.1 Networks and topologies ¨ Types of network: o LAN (Local Area Network) o WAN (Wide Area Network) ¨ Factors that affect the performance of networks ¨ The different roles of computers in a client-server and a peer-topeer network ¨ The hardware needed to connect stand-alone computers into a Local Area Network: o Wireless access points o Routers o Switches o NIC (Network Interface Controller/Card) o Transmission media ¨ The Internet as a worldwide collection of computer networks: o DNS (Domain Name Server) o Hosting o The Cloud o Web servers and clients ¨ Star and Mesh network topologies 1.3.2 Wired and wireless networks, protocols and layers ¨ Modes of connection: o Wired • Ethernet o Wireless • Wi-Fi • Bluetooth ¨ Encryption ¨ IP addressing and MAC addressing ¨ Standards ¨ Common protocols including: o TCP/IP (Transmission Control Protocol/Internet Protocol) o HTTP (Hyper Text Transfer Protocol) o HTTPS (Hyper Text Transfer Protocol Secure) o FTP (File Transfer Protocol) o POP (Post Office Protocol) o IMAP (Internet Message Access Protocol) o SMTP (Simple Mail Transfer Protocol) ¨ The concept of layers

NEW J277 SPECIFICATION Here you will find easy to follow revision sheets which will help your students to recap the topic: 1.5 Systems Security The purpose and functionality of operating systems: o User interface o Memory management and multitasking o Peripheral management and drivers o User management o File management 1.5.2 Utility software ¨ The purpose and functionality of utility software ¨ Utility system software: o Encryption software o Defragmentation o Data compression

NEW J277 SPECIFICATION: Here you will find easy to follow revision sheets which will help your students to recap the topic: 2.3 Producing Robust Programs ¨ Defensive design considerations: o Anticipating misuse o Authentication ¨ Input validation ¨ Maintainability: o Use of sub programs o Naming conventions o Indentation o Commenting ¨ The purpose of testing ¨ Types of testing: o Iterative o Final/terminal ¨ Identify syntax and logic errors ¨ Selecting and using suitable test data: o Normal o Boundary o Invalid/Erroneous ¨ Refining algorithms The revision sheets include exam questions at the end of each topic to help the students recap their revision and apply it to a question. Enjoy!

NEW J277 SPECIFICATION: Here you will find easy to follow revision sheets which will help your students to recap the topic: 2.4 – Boolean logic 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 The revision sheets include exam questions at the end of each topic to help the students recap their revision and apply it to a question. Enjoy!

NEW J277 SPECIFICATION: Here you will find easy to follow revision sheets which will help your students to recap the topic: 2.2 – Programming fundamentals ¨ The use of variables, constants, operators, inputs, outputs and assignments ¨ The use of the three basic programming constructs used to control the flow of a program: o Sequence o Selection o Iteration (count- and condition-controlled loops) ¨ The common arithmetic operators ¨ The common Boolean operators AND, OR and NOT The use of data types: o Integer o Real o Boolean o Character and string o Casting The use of basic string manipulation ¨ The use of basic file handling operations: o Open o Read o Write o Close ¨ The use of records to store data ¨ The use of SQL to search for data ¨ The use of arrays (or equivalent) when solving problems, including both one-dimensional (1D) and two-dimensional arrays (2D) ¨ How to use sub programs (functions and procedures) to produce structured code ¨ Random number generation The revision sheets include exam questions at the end of each topic to help the students recap their revision and apply it to a question. Enjoy!

NEW J277 SPECIFICATION Here you will find easy to follow revision sheets which will help your students to recap the topic: 1.4 Network Security 1.4.1 Threats to computer systems and networks ¨ Forms of attack: o Malware o Social engineering, e.g. phishing, people as the ‘weak point’ o Brute-force attacks o Denial of service attacks o Data interception and theft o The concept of SQL injection 1.4.2 Identifying and preventing vulnerabilities ¨ Common prevention methods: o Penetration testing o Anti-malware software o Firewalls o User access levels o Passwords o Encryption o Physical security

An easy to follow worksheet designed to revisit Secondary Storage as part of 1.3 Storage in the Computer Systems component. The worksheet s designed for students to read over their notes, and attempt the questions, Answer sheet is included. Has been found useful for mock papers with the students in the past ** Answers are included for teachers who are new to the subject

An easy to follow worksheet designed to revisit Secondary Storage using scenarios as part of 1.3 Storage in the Computer Systems component. The worksheet s designed for students to read over their notes, and attempt the questions, Answer sheet is included. Has been found useful for mock papers with the students in the past ** Answers are included for teachers who are new to the subject

An easy to follow worksheet designed to revisit calculating file sizes as part of 1.3 Storage in the Computer Systems component. The worksheet s designed for students to read over their notes, and attempt the questions, Answer sheet is included. Has been found useful for mock papers with the students in the past ** Answers are included for teachers who are new to the subject

This is the second lesson on Google Sketchup, it introduces the students to new skills that can be used as part of their designing process. Also included is a worksheet to assist in using the previous tools. ***The whole unit is also available in my shop! Grab a bargain! and decrease your planning time!***

An introduction to Python Programming which takes the students through the initial use of: -Printing -Variables -Comments It also explains the use of Syntax and the ways in which students should structure their work. Has been tried and tested many a time! Look out for more lessons on Python soon! Including full SOWs

The second lesson in my Python scheme of work, this is aimed at building upon the introduction lesson and taking the students through the following: - Data Casting -If statements -Elif Statements Students will be challenged to complete some tasks alongside these, easy to follow and all set up for you to use! Reduce your planning time!

As part of the 3D Printing module students are tasked with creating a product, this lesson takes them through the process of developing their product ***The whole unit is also available in my shop! Grab a bargain! and decrease your planning time!***

As part of the 3d printing module students are tasked with designing and implementing a product, this takes the students through that process and introduces them to the importance of design work They are then tasked with producing a design which is to be implemented ***The whole unit is also available in my shop! Grab a bargain! and decrease your planning time!***

The fourth lesson in my introduction to python takes the students through the use of while loops and also random. I have used turtle to show the students this as it uses visual graphics and the students tend to enjoy using this. Skills Covered Variables Loops While Loops Libraries Random Turtle

Attached is the solution i made to the sample task released by OCR, it has been created using Python (version 3) with the use of the SQLite3 library. An SQL database was created called students to store the information needed. The program allows the user to log in and do the following: 1. Enter and store the students details 2. Recall a students details (need ID number) 3. Show all students 4. Show students by gender 5. Show students by form 6. Delete a Student 7. Log out the data in the database was created using a random name/street generator.