Here you will find easy to follow revision sheets which will help your students to recap the topic: 1.5 Network topologies, protocols and layers which includes: star and mesh network topologies Wifi: frequency and channels encryption ethernet the uses of IP addressing, MAC addressing, and protocols including: TCP/IP (Transmission Control Protocol/Internet Protocol) HTTP (Hyper Text Transfer Protocol) HTTPS (Hyper Text Transfer Protocol Secure) FTP (File Transfer Protocol) POP (Post Office Protocol) IMAP (Internet Message Access Protocol) SMTP (Simple Mail Transfer Protocol) the concept of layers packet switching. 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. Check out my shop to save on buying multiple sheets!! Enjoy!

Here you will find easy to follow revision sheets which will help your students to recap the topic: 1.6 Systems Security which includes: forms of attack threats posed to networks: malware phishing people as the ‘weak point’ in secure systems (social engineering) brute force attacks denial of service attacks data interception and theft the concept of SQL injection poor network policy identifying and preventing vulnerabilities: penetration testing network forensics network policies anti-malware software firewalls user access levels passwords encryption. 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. Check out my shop to save on buying multiple sheets!! Enjoy!

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: 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

Attached is a lesson on how to create a login system using a database of users in SQLite3 in Python. Included are the following: 1. PPT explaining how to create a login system (2 ways) 2. Example programs (in zip file) 3.Example Database (in zip file, access through a program such as DB Browser (Freeware)) if you need free software to run and connect to sql databases please download the DB Broswer for FREE and also check out a little guide i made to the software, also FREE: https://www.tes.com/teaching-resource/sqlite-program-introduction-db-browser-11751031

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)

An easy to follow worksheet designed to revisit the CPU and its features as part of 1.1 Systems Architecture in the Computer Systems component. The worksheet s designed for students to read over their notes, and attempt the questions, Answer sheet is included.

This lesson guides the students through Python Lists, it has challenges to test students knowledge and build upon their previous lessons (also available in shop). This will develop their skills in using lists and combining data together.

Here you will find easy to follow revision sheets which will help your students to recap the topic: 1.7 Systems Software which includes: the purpose and functionality of systems software operating systems: user interface memory management/multitasking peripheral management and drivers user management file management utility system software: encryption software defragmentation data compression the role and methods of backup: full incremental. 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. Check out my shop to save on buying multiple sheets!! Enjoy!

Here you will find easy to follow revision sheets which will help your students to recap the topic: 2.5 Translators and facilities of languages characteristics and purpose of different levels of programming language, including low level languages the purpose of translators the characteristics of an assembler, a compiler and an interpreter common tools and facilities available in an integrated development environment (IDE): editors error diagnostics run-time environment translators. 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. Check out my shop to save on buying multiple sheets!! Enjoy!

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: 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!

A introduction to computer software for KS3, this was part of the Hardware and Software unit that was delivered. Lesson includes an introduction to the topic and tasks to complete. Extensions tasks also included. The full SOW can also be bought in the shop!

A introduction to 3d printing and Google SketchUp, which was used as part of our 3d printing topic with keystage 3. It requires the students to look into the ways in which 3d printing works as well as introducing them to Google Sketchup Also included is a worksheet to remind students of the tools in SketchUp ***The whole unit is also available in my shop! Grab a bargain! and decrease your planning time!***

An introduction to logic gates which i used at KS3 and KS4. Easy to understand and straight forward. Included are: Teachers powerpoint (walks the students through the gates with examples) Progress log (Track students progress) Self marking spreadsheet that includes tasks, extension and a helpsheet

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