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!
A simple resource to teach the students about sequencing and flow charts at KS3, it includes all the terminology needed as well as the correct way to develop a flow chart using the correct symbols. Also included is a task related to the use of a "Big Trak" which was used to programme a sequence of instructions.
I used this for 2 lessons to get the students used to the ideas of flow charts and sequencing prior to programming.
**If Big Traks are unavailable you can also switch this task to something like Flowol as the resource will have already given insight into flow charts
The ultimate revision pack for your students to get to grips with the J277 OCR Computer Science specification
Includes ALL the resources needed for both unit 1 and unit 2
Computer Systems
1.1 Systems architecture
1.2 Memory and storage
1.3 Computer networks, connections and protocols
1.4 Network security
1.5 Systems software
1.6 Ethical, legal, cultural and environmental impacts of digital technology
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
Save yourself 50% with this bundle :)
This python workbook starts with the very basics and guides the students in developing their skills. It hasd multiple tasks throughout the booklet and covers topics such as:
Print
Data Types
Operands
Variables
Loops
Indexing
A complete set of revision sheets for J277 OCR Computer Science. Includes all of the topics for the first unit J277/01: Computer systems.
1,1 Systems architecture
1,2 Memory and storage
1,3 Computer networks, connections and
protocols
1.4 Network security
1.5 Systems software
1.6 Ethical, legal, cultural and environmental impacts of digital technology
With over 150 practice questions to test your students!!!
**Unit 18 / 19 / 20 Cambridge Technicals (2016) Level 3 Triple Pack
**
This rescource will provide you with the relevant resoucres to complete the following units on the Cambridge Technicals units:
Unit 18 - Hardware
Unit 19 - Software
Unit 20 - Technical Support
Combine these 3 units with the examination units (1 & 2) to achieve 1 A Level for your students!
Each unit is available on their own in my shop, the 3 together offered at over 40% off!
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!
NEW J277 SPECIFICATION:
Here you will find easy to follow revision sheets which will help your students to recap the topic:
2.1 – Algorithms
Principles of computational thinking:
o Abstraction
o Decomposition
o Algorithmic thinking
Identify the inputs, processes, and outputs for a problem
¨ Structure diagrams
¨ Create, interpret, correct, complete, and refine algorithms using:
o Pseudocode
o Flowcharts
o Reference language/high-level programming language
¨ Identify common errors
¨ Trace tables
Standard searching algorithms:
o Binary search
o Linear search
¨ Standard sorting algorithms:
o Bubble sort
o Merge sort
o Insertion sort
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!
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
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!
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)
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!
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.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!
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!
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
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
A checklist i gave to my students to help them cover the key aspects of the specificiation.
They tick each box as they go along and feel confident in that area. A good tool to locate weaknesses and improve!