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.

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.

A straight forward lesson which explains the ways in which you perform binary addition, the lesson outlines the rules for binary addition and also has example questions. Answers are included on the final slide.

A fully set of resources to complete Unit 13, the set includes all the tasks used by myself to teach Unit 13 - website Development. I have added extra hints and tips to the slides to ensure you fully understand what to do! This unit has been moderated several times and has never had an issue. 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!

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.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: 1.3 Storage which includes: the need for secondary storage data capacity and calculation of data capacity requirements common types of storage: optical magnetic solid state suitable storage devices and storage media for a given application, and the advantages and disadvantages of these, using characteristics: capacity speed portability durability reliability cost 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.2 Memory which includes: the difference between RAM and ROM the purpose of ROM in a computer system the purpose of RAM in a computer system the need for virtual memory flash memory. 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.1 Systems Architecture which includes: the purpose of the CPU Von Neumann architecture: MAR (Memory Address Register) MDR (Memory Data Register) Program Counter Accumulator common CPU components and their function: ALU (Arithmetic Logic Unit) CU (Control Unit) Cache the function of the CPU as fetch and execute instructions stored in memory how common characteristics of CPUs affect their performance: clock speed cache size number of cores embedded systems: purpose of embedded systems examples of embedded systems. 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!

Here you will find easy to follow revision sheets which will help your students to recap the topic: 2.1 Algorithms computational thinking: abstraction decomposition algorithmic thinking standard searching algorithms: binary search linear search standard sorting algorithms: bubble sort merge sort insertion sort how to produce algorithms using: pseudocode using flow diagrams interpret, correct or complete 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. 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: 2.4 Computational logic: why data is represented in computer systems in binary form simple logic diagrams using the operations AND, OR and NOT truth tables combining Boolean operators using AND, OR and NOT to two levels applying logical operators in appropriate truth tables to solve problems applying computing-related mathematics: – / Exponentiation (^) MOD DIV 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!

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: input sanitisation/validation planning for contingencies anticipating misuse authentication maintainability: comments indentation the purpose of testing types of testing: iterative final/terminal how to identify syntax and logic errors selecting and using suitable test data. 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.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: 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