Here you will find the resources to complete Unit 19 in the level 3 Cambridge Technicals. All of the Learning Objectives have been covered and the lessons contain notes from the chief moderator from OCR. The assignment which has been used has also been checked using the Assignment Checking service from OCR. (Service is £30 per assignment) Enjoy!

Attached is a lesson on how to use MAX, MIN & AVG in SQLite3 in Python. Included are the following: 1. PPT explaining how to use the functions 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

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.2 Programming techniques 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: sequence selection iteration (count and condition controlled loops) the use of basic string manipulation the use of basic file handling operations: open read write 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 and two dimensional arrays how to use sub programs (functions and procedures) to produce structured code the use of data types: integer real Boolean character and string casting the common arithmetic operators the common Boolean operators. 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.4 Wired and Wireless Networks which includes: types of networks: 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 the concept of virtual networks 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.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

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!