Hero image

Business, Computing & ICT Shop

Average Rating3.59
(based on 55 reviews)

Welcome to my TES shop, here you will find Computing and ICT related items which will be of use throughout the secondary context. Feel free to have a browse of the resources available, which include: -Individual Lessons -Full Schemes of work -Mock Exam Papers & Mark Schemes -Revision Plans All resources are available at a very reasonable price and have be used effectively to teach lessons. Enjoy!

101Uploads

90k+Views

22k+Downloads

Welcome to my TES shop, here you will find Computing and ICT related items which will be of use throughout the secondary context. Feel free to have a browse of the resources available, which include: -Individual Lessons -Full Schemes of work -Mock Exam Papers & Mark Schemes -Revision Plans All resources are available at a very reasonable price and have be used effectively to teach lessons. Enjoy!
4. MAX, MIN, AVG functions in SQLite3 in Python (Great for NEA / Controlled Assessment practice!)
msmarwahamsmarwaha

4. MAX, MIN, AVG functions in SQLite3 in Python (Great for NEA / Controlled Assessment practice!)

(0)
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
Unit 19 - Software- Full Unit, Cambridge Technicals Level 3 (2016)
msmarwahamsmarwaha

Unit 19 - Software- Full Unit, Cambridge Technicals Level 3 (2016)

(1)
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!
J276 OCR Computer Science Unit 1.1 Revision Sheets / Practice Questions
msmarwahamsmarwaha

J276 OCR Computer Science Unit 1.1 Revision Sheets / Practice Questions

(0)
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!
J276 OCR Computer Science Unit 2.1 Revision Sheets / Practice Questions
msmarwahamsmarwaha

J276 OCR Computer Science Unit 2.1 Revision Sheets / Practice Questions

(0)
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!
J276 OCR Computer Science Unit 1.2 Revision Sheets / Practice Questions
msmarwahamsmarwaha

J276 OCR Computer Science Unit 1.2 Revision Sheets / Practice Questions

(0)
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!
J276 OCR Computer Science Unit 1.4 Revision Sheets / Practice Questions
msmarwahamsmarwaha

J276 OCR Computer Science Unit 1.4 Revision Sheets / Practice Questions

(0)
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!
J276 OCR Computer Science Unit 1.3 Revision Sheets / Practice Questions
msmarwahamsmarwaha

J276 OCR Computer Science Unit 1.3 Revision Sheets / Practice Questions

(0)
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!
J276 OCR Computer Science Unit 1.6 Revision Sheets / Practice Questions
msmarwahamsmarwaha

J276 OCR Computer Science Unit 1.6 Revision Sheets / Practice Questions

(0)
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!
J276 OCR Computer Science Unit 1.7 Revision Sheets / Practice Questions
msmarwahamsmarwaha

J276 OCR Computer Science Unit 1.7 Revision Sheets / Practice Questions

(0)
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!
J276 OCR Computer Science Unit 1.5 Revision Sheets / Practice Questions
msmarwahamsmarwaha

J276 OCR Computer Science Unit 1.5 Revision Sheets / Practice Questions

(0)
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!
J277 OCR Computer Science Unit 1.3 Revision Sheets / Practice Questions
msmarwahamsmarwaha

J277 OCR Computer Science Unit 1.3 Revision Sheets / Practice Questions

(0)
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
J277 OCR Computer Science Unit 1.4 Revision Sheets / Practice Questions
msmarwahamsmarwaha

J277 OCR Computer Science Unit 1.4 Revision Sheets / Practice Questions

(0)
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
J277 OCR Computer Science Unit 1.5 Revision Sheets / Practice Questions
msmarwahamsmarwaha

J277 OCR Computer Science Unit 1.5 Revision Sheets / Practice Questions

(0)
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
J276 OCR Computer Science All Units Revision Sheets / Practice Questions
msmarwahamsmarwaha

J276 OCR Computer Science All Units Revision Sheets / Practice Questions

14 Resources
The complete revision set for OCR Computer Science. For all topics: Computer systems • Systems Architecture • Memory • Storage • Wired and wireless networks • Network topologies, protocols and layers • System security • System software • Ethical, legal, cultural and environmental concerns Computational thinking, algorithms and programming • Algorithms • Programming techniques • Producing robust programs • Computational logic • Translators and facilities of languages • Data representation included are 100’s of practice questions related to each topic! Buy now save ££££’s!
J277 OCR Computer Science Unit 2.5 Revision Sheets / Practice Questions
msmarwahamsmarwaha

J277 OCR Computer Science Unit 2.5 Revision Sheets / Practice Questions

(0)
**NEW J277 SPECIFICATION: ** Here you will find easy to follow revision sheets which will help your students to recap the topic: 2.5 – Programming languages and Integrated Development Environments 2.5.1 Languages Characteristics and purpose of different levels of programming language: o High-level languages o Low-level languages The purpose of translators The characteristics of a compiler and an interpreter 2.5.2 The Integrated Development Environment (IDE) Common tools and facilities available in an Integrated Development Environment (IDE): o Editors o Error diagnostics o Run-time environment o Translators
J277 OCR Computer Science Unit 2 (2.1-2.5) Complete Revision Sheets / Practice Questions
msmarwahamsmarwaha

J277 OCR Computer Science Unit 2 (2.1-2.5) Complete Revision Sheets / Practice Questions

5 Resources
A complete set of revision sheets for J277 OCR Computer Science. Includes all of the topics for the first unit J277/02: Computational thinking, algorithms and programming 2.1 Algorithms 2.2 Programming fundamentals 2.3 Producing robust programs 2.4 Boolean logic 2.5 Programming languages and Integrated Development Environments With over 100 practice questions to test your students!!!
J277 OCR Computer Science Unit 2.3 Revision Sheets / Practice Questions
msmarwahamsmarwaha

J277 OCR Computer Science Unit 2.3 Revision Sheets / Practice Questions

(0)
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!
J277 OCR Computer Science Unit 2.4 Revision Sheets / Practice Questions
msmarwahamsmarwaha

J277 OCR Computer Science Unit 2.4 Revision Sheets / Practice Questions

(0)
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!
J277 OCR Computer Science Unit 2.2 Revision Sheets / Practice Questions
msmarwahamsmarwaha

J277 OCR Computer Science Unit 2.2 Revision Sheets / Practice Questions

(1)
NEW J277 SPECIFICATION: Here you will find easy to follow revision sheets which will help your students to recap the topic: 2.2 – Programming fundamentals ¨ 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: o Sequence o Selection o Iteration (count- and condition-controlled loops) ¨ The common arithmetic operators ¨ The common Boolean operators AND, OR and NOT The use of data types: o Integer o Real o Boolean o Character and string o Casting The use of basic string manipulation ¨ The use of basic file handling operations: o Open o Read o Write o 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-dimensional (1D) and two-dimensional arrays (2D) ¨ How to use sub programs (functions and procedures) to produce structured code ¨ Random number generation 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!
Digital Safety
msmarwahamsmarwaha

Digital Safety

(0)
Two resources that cover digital safety for KS3 students, these two resources take the students through staying safe online (social media) as well as emails. The students are to discuss the topic and then use their researching skills to complete the tasks that are set. Both are eye catching and easy to follow! Enjoy!