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

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)

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

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)

Here you will find the resources to complete Unit 20 in the level 3 Cambridge Technicals. All of the Learning Objectives have been covered within the lessons provided. The assignment which has been used has also been checked using the Assignment Checking service from OCR. (Service is £30 per assignment) 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: 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: 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

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!

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

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

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

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

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!

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!

A little checklist I made for my computer science class to use for revision purposes. It is for the first three topics in the Computer Systems topic