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 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!
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
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 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.
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!
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!
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!
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 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!
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
A introduction to inputs and outputs 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
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
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 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
A straight forward lesson which explains the ways in which you perform binary addition, the lesson outlines the rules for binary addition and also has example questions. Answers are included on the final slide.
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!