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!
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!
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!
NEW J277 SPEC
Here you will find easy to follow revision sheets which will help your students to recap the topic:
1.6 Ethical, Legal, Cultural and Environmental Impacts of Digital Technology
¨ Impacts of digital technology on wider society including:
o Ethical issues
o Legal issues
o Cultural issues
o Environmental issues
o Privacy issues
¨ Legislation relevant to Computer Science:
o The Data Protection Act 2018
o Computer Misuse Act 1990
o Copyright Designs and Patents Act 1988
o Software licences (i.e. open source and proprietary)
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:
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
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!
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:
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
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
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!
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 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 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 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
This is a Pack of resources for the 9-1 OCR Computer Science Qualification.
It includes 3 revision worksheets which students can use whilst reading through their notes.
***Bundle Bonus*** a mock exam and mark scheme for topics 1.1-1.3
Save over 50%!
part of the BTEC Level 3 Diploma in Information Technology that i delivered at Level 3, contains all of the lessons and assignments for unit 8 e-commerce
All of the resources i used for this unit of work at level 3, the pack contains all of the assignments i used as well as the resources for each section.
part of the BTEC Level 3 Diploma in Information Technology which i delivered to level 3 students, pack contains all resources that i used including assignments
Here you will find the resources to complete unit 18 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.
Also attached is a sample of how you could complete the practical element to the assignment, although you can choose another method!
The assignment which has been used has also been checked using the Assignment Checking service from OCR. (Service is £30 per assignment)
Enjoy!
