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!
As part of the 3d printing module students are asked to showcase their work and assess their progress, they also gain feedback from their peers as part of the process. This lesson is designed to completed the unit and allow the students to improve upon their designs using their own assessments and peers thoughts.
***The whole unit is also available in my shop! Grab a bargain! and decrease your planning time!***
The fourth lesson in my introduction to python takes the students through the use of while loops and also random. I have used turtle to show the students this as it uses visual graphics and the students tend to enjoy using this.
Skills Covered
Variables
Loops
While Loops
Libraries
Random
Turtle
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.
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 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
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.
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)
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 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!
**Unit 18 / 19 / 20 Cambridge Technicals (2016) Level 3 Triple Pack
**
This rescource will provide you with the relevant resoucres to complete the following units on the Cambridge Technicals units:
Unit 18 - Hardware
Unit 19 - Software
Unit 20 - Technical Support
Combine these 3 units with the examination units (1 & 2) to achieve 1 A Level for your students!
Each unit is available on their own in my shop, the 3 together offered at over 40% off!
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 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.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.6 Systems Security which includes:
forms of attack
threats posed to networks:
malware
phishing
people as the ‘weak point’ in secure systems (social engineering)
brute force attacks
denial of service attacks
data interception and theft
the concept of SQL injection
poor network policy
identifying and preventing vulnerabilities:
penetration testing
network forensics
network policies
anti-malware software
firewalls
user access levels
passwords
encryption.
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.7 Systems Software which includes:
the purpose and functionality of systems software
operating systems:
user interface
memory management/multitasking
peripheral management and drivers
user management
file management
utility system software:
encryption software
defragmentation
data compression
the role and methods of backup:
full
incremental.
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.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.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!