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 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
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!
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.2 Storage and Memory which includes:
The need for primary storage
The difference between RAM and ROM
The purpose of ROM in a computer system
The purpose of RAM in a computer system
Virtual memory
¨ The need for secondary storage
¨ Common types of storage:
o Optical
o Magnetic
o Solid state
¨ Suitable storage devices and storage media for a given application
¨ The advantages and disadvantages of different storage devices
and storage media relating to these characteristics:
o Capacity
o Speed
o Portability
o Durability
o Reliability
o Cost
¨ The units of data storage:
o Bit
o Nibble (4 bits)
o Byte (8 bits)
o Kilobyte (1,000 bytes or 1 KB)
o Megabyte (1,000 KB)
o Gigabyte (1,000 MB)
o Terabyte (1,000 GB)
o Petabyte (1,000 TB)
¨ How data needs to be converted into a binary format to be
processed by a computer
¨ Data capacity and calculation of data capacity requirements
Numbers
¨ How to convert positive denary whole numbers to binary numbers
(up to and including
8 bits) and vice versa
¨ How to add two binary integers together (up to and including
8 bits) and explain overflow errors which may occur
¨ How to convert positive denary whole numbers into 2-digit
hexadecimal numbers and vice versa
¨ How to convert binary integers to their hexadecimal equivalents
and vice versa
¨ Binary shifts
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, e.g.:
o ASCII
o Unicode
Images
¨ How an image is represented as a series of pixels, represented in
binary
¨ Metadata
¨ The effect of colour depth and resolution on:
o The quality of the image
o The size of an image file
Sound
¨ How sound can be sampled and stored in digital form
¨ The effect of sample rate, duration and bit depth on:
o The playback quality
o The size of a sound file
¨ The need for compression
¨ Types of compression:
o Lossy
o Lossless
The revision sheets include over 50 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
A introduction to 3d printing and Google SketchUp, which was used as part of our 3d printing topic with keystage 3. It requires the students to look into the ways in which 3d printing works as well as introducing them to Google Sketchup
Also included is a worksheet to remind students of the tools in SketchUp
***The whole unit is also available in my shop! Grab a bargain! and decrease your planning time!***
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 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)
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!
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!
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!
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!
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!!!
A introduction to the future of hardware and 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%!
A mock exam and mapped mark scheme that was used to test students knowledge and abilities on the A451 Computer Science topics. Test is made up of previous questions all of which are mapped out.
Examination Board: OCR
An easy to follow worksheet designed to revisit RAM, ROM and Virtual 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
DB Browser is a handy tool you can use for SQLite, it is freeware which is available at:
http://sqlitebrowser.org
This little guide take you through how to make use of DB Browser for SQLite!