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!
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
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.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.8 Ethical, legal, cultural and environmental concerns which includes:
how to investigate and discuss Computer Science technologies while considering:
ethical issues
legal issues
cultural issues
environmental issues.
privacy issues.
how key stakeholders are affected by technologies
environmental impact of Computer Science
cultural implications of Computer Science
open source vs proprietary software
legislation relevant to Computer Science:
The Data Protection Act 1998
Computer Misuse Act 1990
Copyright Designs and Patents Act 1988
Creative Commons Licensing
Freedom of Information Act 2000
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:
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!
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)
Here you will find easy to follow revision sheets which will help your students to recap the topics:
-2.1 Algorithms
-2.2 Programming Techniques
-2.3 Robust Programs
-2.4 Computational Logic
-2.5 Translators & Facilities of Languages
2.6 Data Representation
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 for the unit 1 bundle as well as a complete set for unit 1 and 2!
Enjoy!
Here you will find easy to follow revision sheets which will help your students to recap the topic:
2.6 Data Representation
Units
bit, nibble, byte, kilobyte, megabyte, gigabyte, terabyte, petabyte
how data needs to be converted into a binary format to be processed by a computer.
Numbers
how to convert positive denary whole numbers (0–255) into 8 bit binary numbers and vice versa
how to add two 8 bit binary integers and explain overflow errors which may occur
binary shifts
how to convert positive denary whole numbers (0–255) into 2 digit hexadecimal numbers and vice
versa
how to convert from binary to hexadecimal equivalents and vice versa
check digits.
Characters
the use of binary codes to represent characters
the term ‘character-set’
the relationship between the number of bits per character in a character set and the number of
characters which can be represented (for example ASCII, extended ASCII and Unicode).
Images
how an image is represented as a series of pixels represented in binary
metadata included in the file
the effect of colour depth and resolution on the size of an image file.
Sound
how sound can be sampled and stored in digital form
how sampling intervals and other factors affect the size of a sound file and the quality of its playback:
sample size
bit rate
sampling frequency.
Compression
need for compression
types of compression:
lossy
lossless.
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 topics:
1.1 Systems Architecture
1.2 Memory
1.3 Storage
1.4 Wired and Wireless Networks
1.5 Network Topologies Protocols and Layers
1.6 Systems Security
1.7 System Software
1.8 Ethical Legal Cultural and Environmental Concerns
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 for a bundle on unit 2! as well as a complete set of sheets for both unit 1 & 2!
Enjoy!
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
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!
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
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 computer software for KS3, this was part of the Hardware and Software unit that was delivered. Lesson includes an introduction to the topic and tasks to complete. Extensions tasks also included. The full SOW can also be bought in the shop!
***OVER 40 RESOURCES!***
This level 3 BTEC pack includes 4 units, which are:
BTEC Level 3 IT Unit 1: Communication & Employability Skills for IT
BTEC Level 3 Unit 17 Project Planning With IT
BTEC Level 3 Unit 2: Computer Systems
BTEC Level 3 Unit 8: E-Commerce
all of which have been completed with all of the tasks, and have proven successful in the classroom!
Bundle price saves you 25%!
An easy to follow worksheet designed to revisit the CPU and its features as part of 1.1 Systems Architecture in the Computer Systems component.
The worksheet s designed for students to read over their notes, and attempt the questions, Answer sheet is included.
An easy to follow worksheet designed to revisit Flash and Cache Memory as part of 1.2 Memory 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