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 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!***
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!
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!***
As part of the 3d printing module students are tasked with designing and implementing a product, this takes the students through that process and introduces them to the importance of design work
They are then tasked with producing a design which is to be implemented
***The whole unit is also available in my shop! Grab a bargain! and decrease your planning time!***
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
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 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
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%!
Attached is a lesson on how to write to a database using SQLite3 in Python. Included are the following:
1. PPT explaining how to write to 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
An easy to follow worksheet designed to revisit calculating file sizes as part of 1.3 Storage 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
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
Here you will find easy to follow revision sheets which will help your students to recap the topics in 1.3 Putting A Business Idea Into Practice , these include:
1.3.1. Business Aims & Objectives
1.3.2 Business Revenues, Costs And Profits
1.3.3 Cash And Cash-Flow
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!
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 topics in Theme 1 - Investigating Small Business & Theme 2 - Building a Business
Includes over 200 practice exam questions to test your students knowledge! As well as extended response questions!
topics can be bought separately if needed from my shop!
SAVE 50% FOR THE WHOLE OF THEME 1 & 2 WITH THIS BUNDLE.
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:
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!
NEW J277 SPECIFICATION:
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:
o The fetch-execute cycle
¨ Common CPU components and their function:
o ALU (Arithmetic Logic Unit)
o CU (Control Unit)
o Cache
o Registers
¨ Von Neumann architecture:
o MAR (Memory Address Register)
o MDR (Memory Data Register)
o Program Counter
o Accumulator
How common characteristics of CPUs affect their performance:
o Clock speed
o Cache size
o Number of cores
¨ The purpose and characteristics 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