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 the solution i made to the sample task released by OCR, it has been created using Python (version 3) with the use of the SQLite3 library.
An SQL database was created called students to store the information needed.
The program allows the user to log in and do the following:
1. Enter and store the students details
2. Recall a students details (need ID number)
3. Show all students
4. Show students by gender
5. Show students by form
6. Delete a Student
7. Log out
the data in the database was created using a random name/street generator.
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)
Included in this teaching pack is the full set of resources that have been used to complete the BTEC first unit 3- Digital Portfolio
It includes all the relevant PowerPoints to guide students towards completion of the unit. The resources cover the full specification of the unit and will enable the students to gain the Pass, Merit or Distinction levels. Enjoy!
Here you will find easy to follow revision sheets which will help your students to recap the topic:
2.2 Programming techniques
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:
sequence
selection
iteration (count and condition controlled loops)
the use of basic string manipulation
the use of basic file handling operations:
open
read
write
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 and two dimensional
arrays
how to use sub programs (functions and procedures) to produce structured code
the use of data types:
integer
real
Boolean
character and string
casting
the common arithmetic operators
the common Boolean operators.
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!
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
A fully set of resources to complete Unit 13, the set includes all the tasks used by myself to teach Unit 13 - website Development. I have added extra hints and tips to the slides to ensure you fully understand what to do! This unit has been moderated several times and has never had an issue.
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 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!
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.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:
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.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:
2.4 Computational logic:
why data is represented in computer systems in binary form
simple logic diagrams using the operations AND, OR and NOT
truth tables
combining Boolean operators using AND, OR and NOT to two levels
applying logical operators in appropriate truth tables to solve problems
applying computing-related mathematics:
–
/
Exponentiation (^)
MOD
DIV
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.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 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:
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!
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 is the bundle available to prep students for their GCSEs and also teach them the basics of SQLite3.
Easy to follow lessons will help you to:
Use SQLite 3
Write To a Database
Query a Database (Using one + more criteria)
Create a Login System (multiple ways)
Make use of Functions (MAX, MIN & AVG)
If you want an individual lesson from this pack check out my shop!
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!
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!