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.

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

Attached is a lesson on how to read and write to a csv file in Python. Included are the following: 1. PPT explaining how to write and read from a csv file 2. Example programs (in zip file)

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

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

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!

NEW J277 SPECIFICATION: 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: o The fetch-execute cycle ¨ Common CPU components and their function: o ALU (Arithmetic Logic Unit) o CU (Control Unit) o Cache o Registers ¨ Von Neumann architecture: o MAR (Memory Address Register) o MDR (Memory Data Register) o Program Counter o Accumulator How common characteristics of CPUs affect their performance: o Clock speed o Cache size o Number of cores ¨ The purpose and characteristics 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!

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!

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

Attached is a lesson on how to write to a database using SQLite3 in Python. Included are the following: 1. PPT explaining how to write to a database 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

In this pack is a scheme of work which can be used in KS3, why plan when you can have your whole year done for you! Included are the following topics: -Digital Safety -Sequencing & Microbits -Hardware & Software -3d Printing in Sketchup Pro -Python Programming Topics in the pack can also be bought as separates if you prefer from my shop.

Attached is a lesson on how to create a login system using a csv file in Python. Included are the following: 1. PPT explaining how to create a login system 2. Example programs (in zip file)

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

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

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!