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!
This is a Pack of resources for the 9-1 OCR Computer Science Qualification.
It includes 3 revision worksheets which students can use whilst reading through their notes.
***Bundle Bonus*** a mock exam and mark scheme for topics 1.1-1.3
Save over 50%!
This is the second lesson on Google Sketchup, it introduces the students to new skills that can be used as part of their designing process.
Also included is a worksheet to assist in using the previous tools.
***The whole unit is also available in my shop! Grab a bargain! and decrease your planning time!***
In the pack you will find a full SOW of lessons for google sketchup.
Tried and tested at KS3, these lessons introduce students to 3d printing the developing designs through google sketchup!
All lessons complete with tasks, save yourself some hassle!
An introduction to Python Programming which takes the students through the initial use of:
-Printing
-Variables
-Comments
It also explains the use of Syntax and the ways in which students should structure their work. Has been tried and tested many a time!
Look out for more lessons on Python soon! Including full SOWs
An introduction to python programming aimed at students who may not have come across it before. The SOW includes:
Printing
Commenting
Storing and using Variables
Data Casting
If Statements
Elif Statements
Using Lists
Using LIbraries
Turtle
Using Random
In this pack is a scheme of work which can be used in KS3, why plan when you can have your whole year done for you!
Included are the following topics:
-Digital Safety
-Sequencing & Microbits
-Hardware & Software
-3d Printing in Sketchup Pro
-Python Programming
Topics in the pack can also be bought as separates if you prefer from my shop.
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.
The second lesson in my Python scheme of work, this is aimed at building upon the introduction lesson and taking the students through the following:
- Data Casting
-If statements
-Elif Statements
Students will be challenged to complete some tasks alongside these, easy to follow and all set up for you to use! Reduce 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 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
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 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 topics in 2.5 Making Human Resource Decisions, these include:
2.5.1 Organisational Structures
2.5.2 Effective Recruitment
2.5.3. Effective Training & Development
2.5.4. Motivation
Attached at the end of the notes are revision questions which the students should be able to answer once they have studied the topic.
Enjoy!
Also check out the other revision sheets for the topics within this GCSE in my shop!
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 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!
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 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!
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:
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!