High-impact computer science resources that are based on sound educational psychological theories to help all pupils reach their full potential. I’m an experienced teacher/HoD and professionally create computing and computer science teaching resources through my company Nichola Wilkin Ltd. All these resources have been exclusively created by me. I’m an author who has written for both BBC Bitesize and Cambridge University Press. Quality teaching resources you can trust!
High-impact computer science resources that are based on sound educational psychological theories to help all pupils reach their full potential. I’m an experienced teacher/HoD and professionally create computing and computer science teaching resources through my company Nichola Wilkin Ltd. All these resources have been exclusively created by me. I’m an author who has written for both BBC Bitesize and Cambridge University Press. Quality teaching resources you can trust!
This ethical, legal, cultural and environmental impacts of digital technology workbook is perfect for students studying for the OCR GCSE (9-1) in computer science and has been updated to completely cover the new specification J277.
It can be used in the classroom as a teaching aid, for self-study or as a revision tool. In this resource you will receive an interactive PDF workbook so your students can either print it out and complete the activities by hand or fill it in electronically making this an ideal workbook for use in school or for students studying at home.
The answer booklet is provided as a separate PDF file so you can assign your students the workbook without including the answers.
This 31-page workbook completely covers the new specification J277 1.6 ethical, legal, cultural and environmental impacts of digital technology theory.
Table of Contents:
How to investigate and discuss Computer Science technologies
Ethical issues
Legal issues
Cultural issues
Environmental issues
Privacy issues
How key stakeholders are affected by technologies
Legislation relevant to Computer Science
The Data Protection Act 2018 (GDPR)
Wireless networking
The Computer Misuse Act 1990
The Copyright, Designs and Patents Act 1988
Software licences
.
You may also be interested in these workbooks which have also been written to cover the J277 specification:
Systems Architecture
Memory and Storage
Computer networks, connections and protocols
Network Security
Systems Software
Algorithms
Programming Fundamentals
Producing Robust Programs
Boolean Logic
Programming Languages and IDEs
This systems software workbook is perfect for students studying for the OCR GCSE (9-1) in computer science and has been updated to completely cover the new specification J277.
It can be used in the classroom as a teaching aid, for self-study or as a revision tool. In this resource you will receive an interactive PDF workbook so your students can either print it out and complete the activities by hand or fill it in electronically, making this an ideal workbook for use in school or for students studying at home.
The answer booklet is provided as a separate PDF file so you can assign your students the workbook without including the answers.
This 17-page workbook completely covers the new specification J277 1.5 systems software theory.
Table of Contents:
The purpose and functionality of systems software
Operating Systems
User Interface
Memory management and multitasking
Peripheral management and drivers
User Management
File Management
Utility system software
Encryption software
Defragmentation
Data Compression
The role and methods of backup
.
You may also be interested in these workbooks which have also been written to cover the J277 specification:
Systems Architecture
Memory and Storage
Computer networks, connections and protocols
Network Security
Ethical, Legal, Cultural and Environmental Impacts
Algorithms
Programming Fundamentals
Producing Robust Programs
Boolean Logic
Programming Languages and IDEs
This network security workbook is perfect for students studying for the OCR GCSE (9-1) in computer science and has been updated to completely cover the new specification J277.
It can be used in the classroom as a teaching aid, for self-study or as a revision tool. In this resource you will receive an interactive PDF workbook so your students can either print it out and complete the activities by hand or fill it in electronically making this an ideal workbook for use in school or for students studying at home.
The answer booklet is provided as a separate PDF file so you can assign your students the workbook without including the answers.
This 45-page workbook completely covers the new specification J277 1.4 network security theory.
Table of Contents:
What is network security?
Forms of attack
Threats posed to networks
Hackers and crackers
Malware
Social engineering
Brute Force Attacks
Denial of Service Attacks
Data Interception
Data theft
SQL injection
Poor network policy
Identifying and preventing vulnerabilities
Penetration testing
Network forensics
Network policies
Anti-malware software
Firewalls
User access levels
Passwords
Encryption
Physical security
.
You may also be interested in these workbooks which have also been written to cover the J277 specification:
Systems Architecture
Memory and Storage
Computer networks, connections and protocols
Systems Software
Ethical, Legal, Cultural and Environmental Impacts
Algorithms
Programming Fundamentals
Producing Robust Programs
Boolean Logic
Programming Languages and IDEs
This computer networks, connections and protocols workbook is perfect for students studying for the OCR GCSE (9-1) in computer science and has been updated to completely cover the new specification J277.
It can be used in the classroom as a teaching aid, for self-study or as a revision tool. In this resource you will receive an interactive PDF workbook so your students can either print it out and complete the activities by hand or fill it in electronically making this an ideal workbook for use in school or for students studying at home.
The answer booklet is provided as a separate PDF file so you can assign your students the workbook without including the answers.
This 45-page workbook completely covers the new specification J277 1.3 computer networks, connections and protocols theory
Table of Contents:
What is a network?
Server
Advantages and disadvantages of computer networks
Types of network
Local Area Network (LAN)
Wide Area Network (WAN)
Factors that affect the performance of networks
Bandwidth
Number of devices
Cable or wireless media
Error rate
Latency
The different roles of computers in a client server and a peer-to-peer network
Client Server
Peer-to-Peer
The hardware needed to connect stand-alone computers to a LAN
Stand-alone computer
Network Interface Controller/Card
Transmission Media
Switch
Router
Wireless Access Points
The internet
Web servers and clients
Domain Name Server
Hosting
The cloud
Cloud computing
Network topologies
Star network topology
Mesh network topology
Modes of connection
Wired
Wireless
WiFi
Frequency
Channels
Encryption
Packet Switching
Bandwidth
Ethernet
IP addressing
MAC addressing
Network Protocols
TCP/IP model
TCP (Transmission Control Protocol)
IP (Internet Protocol)
The 4 layers of network protocols
Application layer
Transport layer
Internet layer
Link layer
.
Please note: It has come to our attention that YouTube changed their privacy policy and some of the links in our workbooks are not uploading correctly.
We have now sorted out the problem but it did mean that we had to change the links in the workbook.
If you have previously downloaded this workbook please download it again from your download library to get the new version.
You may also be interested in these workbooks which have also been updated for the new specification:
Systems Architecture
Memory and Storage
Network Security
Systems Software
This memory and storage workbook is perfect for students studying for the OCR GCSE (9-1) in computer science and has been updated to completely cover the new specification J277.
It can be used in the classroom as a teaching aid, for self-study or as a revision tool. In this resource you will receive an interactive PDF workbook so your students can either print it out and complete the activities by hand or fill it in electronically making this an ideal workbook for use in school or for students studying at home.
The answer booklet is provided as a separate PDF file so you can assign your students the workbook without including the answers.
This 64-page workbook completely covers the new specification J277 1.2 Memory and Storage theory.
Table of Contents:
Read Only Memory (ROM)
The purpose of ROM
Random Access Memory (RAM)
The purpose of RAM
Dynamic RAM (DRAM)
Static RAM (SRAM)
The difference between ROM and RAM
The need for virtual memory
The need for secondary storage
Common types of storage (Optical, Magnetic, Solid state)
Data capacity and calculation of data requirements
Denary (base 10)
Binary (base 2)
Hexadecimal (base 16)
Convert between binary, denary and hexadecimal
Adding binary numbers
Binary Shifts
Character Sets (ASCII and Unicode)
Bitmap images
Colour depth
Resolution
Metadata
Sound
How sound can be sampled and stored in a digital form
Sample rate
Bit depth
Compression (Lossless and Lossy)
.
You may also be interested in these workbooks which have also been updated for the new specification:
Systems Architecture
Computer Networks, Connections and Protocols
Network Security
Systems Software
Ethical, legal, cultural and environmental impacts of digital technology
Algorithms
Programming Fundamentals
Producing Robust Programs
This systems architecture workbook is perfect for students studying for the OCR GCSE (9-1) in Computer Science and has been updated to completely cover the new specification J277.
It can be used in the classroom as a teaching aid, for self-study or as a revision tool. In this resource you will receive an interactive PDF workbook so your students can either print it out and complete the activities by hand or fill it in electronically, making this an ideal workbook for use in school or for students studying at home.
The answer booklet is provided as a separate PDF file so you can assign your students the workbook without including the answers.
This 24 page workbook completely covers the new specification J277 1.1 systems architecture theory.
Table of Contents:
Systems Architecture
Hardware
Software
The purpose of the CPU
Von Neumann Architecture
Memory Address Register (MAR)
Memory Data Register (MDR)
Program Counter (PC)
Accumulator (AC)
Common CPU Components
Arithmetic / Logic unit (ALU)
Control unit (CU)
Cache
Busses
The Fetch-Execute cycle
How common characteristics of CPUs affect their performance
Clock speed
Cache size
Number of cores
Purpose of embedded systems
Examples of embedded systems
.
You may also be interested in these workbooks which have also been written to cover the J277 specification:
Memory and Storage
Computer networks, connections and protocols
Network Security
Systems Software
Ethical, Legal, Cultural and Environmental Impacts
Algorithms
Programming Fundamentals
Producing Robust Programs
Boolean Logic
Programming Languages and IDEs
At the start of every term I get many emails and phone calls from teachers who have recently taken over as the head of Computer Science and are unsure where to start. Some of them are walking into a well-ordered department where everything is laid out and ready-to-go, others are not so lucky.
Often, they are the only person in that department and so don’t have anywhere to turn to ask for help. And then the headteacher casually strolls into your room when you have barely been for a day and asks you for your ICT policy document by the end of the week. Gulp!
Not to worry, I have this one ready to go and better still it is completely free!
With a brief read through, only some minor tweaking to make it fit your school and copying them into your schools template it should satisfy your headteacher and give you a bit of valuable breathing space while you try to get your head around the one hundred and one other things you need to do.
School Data Protection Policy
A School Data Protection policy isn’t really your responsibility as head of computer science and is something somebody who has received adequate training should be looking after. The name of the allocated data protection officer (DPO) and their contact details should be inserted into section 5.2 (Data protection officer) and is usually somebody in the admin team.
At the start of every term I get many emails and phone calls from teachers who have recently taken over as the head of Computer Science and are unsure where to start. Some of them are walking into a well-ordered department where everything is laid out and ready-to-go, others are not so lucky.
Often, they are the only person in that department and so don’t have anywhere to turn to ask for help. And then the headteacher casually strolls into your room when you have barely been for a day and asks you for your ICT policy document by the end of the week. Gulp!
Not to worry, I have this one ready to go and better still it is completely free!
With a brief read through, only some minor tweaking to make it fit your school and copying them into your schools template it should satisfy your headteacher and give you a bit of valuable breathing space while you try to get your head around the one hundred and one other things you need to do.
Acceptable Use Of ICT Policy For Staff
The acceptable use of ICT policy is for staff and is a little more detailed than my policy for pupils. This can also be coped into your school template and requires staff to sign the last page.
At the start of every term I get many emails and phone calls from teachers who have recently taken over as the head of Computer Science and are unsure where to start. Some of them are walking into a well-ordered department where everything is laid out and ready-to-go, others are not so lucky.
Often, they are the only person in that department and so don’t have anywhere to turn to ask for help. And then the headteacher casually strolls into your room when you have barely been for a day and asks you for your ICT policy document by the end of the week. Gulp!
Not to worry, I have this one ready to go and better still it is completely free!
With a brief read through, only some minor tweaking to make it fit your school and copying them into your schools template it should satisfy your headteacher and give you a bit of valuable breathing space while you try to get your head around the one hundred and one other things you need to do.
Acceptable Use Of ICT Policy For Pupils
The acceptable use of ICT policy is for pupils and includes an acceptance form, they need to sign and hand back to you.
Make sure you insert your school name in the first paragraph of page 1 and if you are printing it out to send home you will probably want to copy it into your schools’ template.
The totally FREE lesson teaches your students about reading from and writing to text files with Python.
This lesson is perfect for GCSE computer science classes learning how to write to an external text file and read from an external text file, displaying the results in the Python shell.
Download this ready to use lesson now and become more confident in teaching more programming skills to your pupils. It’s free so what have you got to lose?
This ready to use lesson is suitable for GCSE computer science pupils.
This resource includes an attractive dyslexia friendly PowerPoint presentation that includes three videos to teach the key skills and includes lots of programming practise and the teachers lesson plan even includes complete answers to all the programming challenges.
This ready-to-use lesson is perfect for non-specialist teachers, newly qualified teachers and teachers who are teaching Python for the first time.
Please note: students should be familiar with using sub programs and for loops, before this lesson.
Duration: 1 lesson
In this lesson your students will learn about:
Writing to a new text file
Appending data to an existing text file
Reading data from a text file
The importance of closing a file
Concatenating line breaks
Casting from integer to strings
.
What are you waiting for? Take action straight away and download your FREE copy of this wonderful no-prep lesson today that will keep your pupils engaged and making progress.
Click Here To See More Of My Great Python Lessons
This FREE simple Christmas activity teaches pupils about how bitmap images are constructed. They need to convert the binary numbers into denary and then use them to create various images. They are shown the final image as well as the binary numbers used to create the bitmap image.
Suitable for Year 7 or 8 as a fun Christmas lesson.
Please note: the Excel spreadsheet is protected and only some cells are open for the pupils to type into.
This Python lesson is perfect to help GCSE classes get back into Python programming after they have had a break from it. It does assume they are familiar with the KS3 national curriculum requirements and have previously been taught about data structures including lists and 2D lists and sub programs.
Please note: This lesson recaps these key areas, giving pupils a chance to practise previously learnt skills but this lesson is not suitable for teaching these elements to your class for the first time.
Download this no-prep lesson now to help you take control of your workload.
This complete lesson includes an attractive dyslexia- friendly PowerPoint presentation includes a pop quiz and lots of practical programming practice. The easy-to-follow teacher’s lesson plan includes all the answers.
This ready-to-use lesson is perfect for non-specialist teachers, newly qualified teachers and teachers who are teaching Python for the first time.
Duration: 1 lesson although you can easily extend this into a longer project by asking the pupils to write up how they tackled the problem, problems they had to overcome, where they looked for help and creating a test table.
This lesson helps pupils understand the following key skills:
Using sensible variable names
Adding comments to programs to explain the coding
Leaving blank lines in programs to make them easier to read
Considering the end user and making the system user friendly
Including sensible input messages and error messages
The importance of testing a program
.
What are you waiting for? Take action straight away and grab your copy of this wonderful lesson today that will keep your pupils engaged and making real progress. Everything is done for you which will save you hours of preparation time.
FREE BONUS PRODUCT INCLUDED
As a special thank you for purchasing this product I am pleased to be able to also include a surprise FREE bonus gift. This gift is one of my complete resources for which I usually charge full price but is yours absolutely free when you purchase this product. Just my little way of saying thank you to my valued customers. I hope you enjoy it and get use out of it, with my compliments.
**Click Here To See More Of My Great Python Lessons
**
This Python lesson is perfect to help GCSE classes get back into Python programming after they have had a break from it. It does assume they are familiar with the KS3 national curriculum requirements and have previously been taught about data structures including lists and 2D lists.
Please note: This lesson recaps these key areas, giving pupils a chance to practise previously learnt skills but this lesson is not suitable for teaching these elements to your class for the first time.
Download this no-prep lesson now to help you take control of your workload.
This complete lesson includes an attractive dyslexia-friendly PowerPoint presentation includes a pop quiz and lots of practical programming practice. The easy-to-follow teacher’s lesson plan includes all the answers.
This ready-to-use lesson is perfect for non-specialist teachers, newly qualified teachers and teachers who are teaching Python for the first time.
Duration: 1 lesson.
This lesson teaches pupils about:
What is a list?
Creating, editing and deleting data from a list
Creating and editing data in a 2D list
.
What are you waiting for? Take action straight away and grab your copy of this wonderful lesson today that will keep your pupils engaged and making real progress. Everything is done for you which will save you hours of preparation time.
FREE BONUS PRODUCT INCLUDED
As a special thank you for purchasing this product I am pleased to be able to also include a surprise FREE bonus gift. This gift is one of my complete resources for which I usually charge full price but is yours absolutely free when you purchase this product. Just my little way of saying thank you to my valued customers. I hope you enjoy it and get use out of it, with my compliments.
Click Here To See More Of My Great Python Lessons
This Python lesson is perfect to help GCSE classes get back into Python programming after they have had a break from it. It does assume they are familiar with the KS3 national curriculum requirements and have previously been taught about sub programs, functions and procedures.
Please note: This lesson recaps these key areas, giving pupils a chance to practise previously learnt skills but this lesson is not suitable for teaching these elements to your class for the first time.
Download this no-prep lesson now to help you take control of your workload.
This complete lesson includes an attractive dyslexia-friendly PowerPoint presentation, a pop quiz and lots of practical programming practice. The easy-to-follow teacher’s lesson plan includes all the answers.
This ready-to-use lesson is perfect for non-specialist teachers, newly qualified teachers and teachers who are teaching Python for the first time.
Duration: 1 lesson.
This lesson teaches pupils about:
What is a sub program?
Calling sub programs
Passing single and multiple variables to sub programs
Returning single and multiple variables to the main program
.
What are you waiting for? Take action straight away and grab your copy of this wonderful lesson today that will keep your pupils engaged and making real progress. Everything is done for you which will save you hours of preparation time.
FREE BONUS PRODUCT INCLUDED
As a special thank you for purchasing this product I am pleased to be able to also include a surprise FREE bonus gift. This gift is one of my complete resources for which I usually charge full price but is yours absolutely free when you purchase this product. Just my little way of saying thank you to my valued customers. I hope you enjoy it and get use out of it, with my compliments.
Click Here To See More Of My Great Python Lessons
This Python lesson is perfect to help refresh pupils’ knowledge of Python programming after they have had a break from it.
It does assume students have previously been taught about if statements, for loops and while loops and this lesson will recap these skills helping to embed them further.
Download this ready to use lesson now and take control of your workload.
It includes an attractive dyslexia-friendly PowerPoint presentation that includes differentiated lesson objectives, created in authentic English by an experienced computer science teacher and the lesson also includes lots of practical programming practice. It also includes a comprehensive lesson plan including all the answers.
This ready-to-use lesson is perfect for non-specialist teachers, newly qualified teachers and teachers who are teaching Python for the first time.
Please note: This lesson does assume the pupils have previously been taught the basic programming constructs of sequence, selection (if statements) and iteration (while and for loops) and just need a refresher.
Duration: 1 lesson.
This lesson helps pupils understand the following key skills:
Basic If statements
If…elif statements
Nested if statements
Using “and” and “or” in conditions
For loops
While loops
Flow diagrams
.
What are you waiting for? Take action straight away and grab your copy of this wonderful lesson today that will keep your pupils engaged and making real progress. Everything is done for you which will save you hours of preparation time.
FREE BONUS PRODUCT INCLUDED
As a special thank you for purchasing this product I am pleased to be able to also include a surprise FREE bonus gift. This gift is one of my complete resources for which I usually charge full price but is yours absolutely free when you purchase this product. Just my little way of saying thank you to my valued customers. I hope you enjoy it and get use out of it, with my compliments.
Click Here To See More Of My Great Python Lessons
Taking over a new year 10 GCSE computer science class? Wanting to find out your current classes Python programming skills? This resource contains a list of practical Python programming challenges which test key aspects of the KS3 national curriculum for text-based programming language.
Pupils are tested on:
Mathematical operators
Data types
Dealing with strings
Loops
If statements
Logical operators
Random numbers
Data structures (lists) and
Sub programs
The pupils are given a worksheet which contains 11 Python programming challenges. They need to work through them attempting the programs and sections they can. If they don’t know how to do something then ask them to move on and try to complete as much of the challenges as they can. This allows you to find out the gaps in their current knowledge.
The results are then entered into a an Excel spreadsheet using a simple system of 0 (not met the criteria) or 1 (met the criteria) that is then converted into a list showing you the pupils current understanding displayed as “Secure” or “Developing”. You can then use this to help you plan future lessons to fill the gaps in their skills.
This practical assessment can be used at the end of Key Stage 3 to help you and pupils when selecting their options or it can be used at the start of their GCSE to assess which areas need to be recapped.
This resource also includes the completed Python programs for all the challenges allowing you to see a possible answer for each challenge making this easier for non-specialists and NQTs who want to have a little more assistance as they build their confidence in Python programming.
FREE BONUS PRODUCT INCLUDED
As a special thank you for purchasing this product I am pleased to be able to also include a surprise FREE bonus gift. This gift is one of my complete resources for which I usually charge full price but is yours absolutely free when you purchase this product. Just my little way of saying thank you to my valued customers. I hope you enjoy it and get use out of it, with my compliments.
This free document outlines the lessons that can be used to teach Python programming covering the national curriculum requirements for a text based programming language for key stage 3. It outlines the lessons and provides links to make your job easier when searching for a comprehensive, high-quality set of lessons. It also includes a link to an end of unit assessment.
This assessment test allows you to assess your pupils against the national curriculum specification for Python programming. It should be used at the end of Key Stage 3 as a summative assessment rather than as a formative assessment.
The national curriculum specifies that by the end of Key stage 3 pupils should have been taught to “use two or more programming languages, at least one of which is textual, to solve a variety of computational problems; make appropriate use of data structures (for example, lists, tables or arrays); design and develop modular programs that use procedures or functions (for example, sub programs).”
This test allows you to assess if your pupils have met this criteria.
It includes a 6 page PDF document which should be printed and given to your pupils to complete under test conditions. There is no practical element to this test and is completed through a written test. This resource also includes a mark scheme to aid the teacher in marking the paper and even includes grade boundaries and descriptions that can assist the teacher when writing pupils’ long reports.
Duration: 1 lesson
This end of unit assessment does assume the pupils have been taught the following areas:
Data types
Syntax errors
Logical and sequence errors
Inputs and outputs
Sequence, selection and iteration
If…else statements
Drawing and understanding flow diagrams
Mathematical operators (+, -, * and /)
Comparison operators (>, <, >=, <=, == and !=)
For loops (count controlled loops)
While loops (condition controlled loops)
Simple lists and 2D lists (data structures)
Sub programs
Passing variables between sub programs and the main program
Local and global variables
FREE BONUS PRODUCT INCLUDED
As a special thank you for purchasing this product I am pleased to be able to also include a surprise FREE bonus gift. This gift is one of my complete resources for which I usually charge full price but is yours absolutely free when you purchase this product. Just my little way of saying thank you to my valued customers. I hope you enjoy it and get use out of it, with my compliments.
This complete Python programming lesson teaches pupils how to use subprograms including how to pass variables, call subprograms and use local and global variables.
Download this no-prep lesson now to help you take control of your workload.
This ready to use lesson is suitable for Key Stage 3 and GCSE computer science pupils.
This complete lesson includes an attractive dyslexia-friendly PowerPoint presentation including videos to teach the key skills and the easy-to-follow teacher’s lesson plan includes all the answers.
This ready-to-use lesson is perfect for non-specialist teachers, newly qualified teachers and teachers who are teaching Python for the first time.
Please note: This lesson does assume the pupils are confident with using basic programming constructs of sequence, selection (if statements) and iteration (while and for loops)
Duration: 1 lesson.
This lesson teaches pupils about:
Subprograms
Passing variable to a subprogram
Returning variables from a subprogram to the main program
Local and global variables
.
What are you waiting for? Take action straight away and grab your copy of this wonderful lesson today that will keep your pupils engaged and making progress and save you preparation time.
FREE BONUS PRODUCT INCLUDED
As a special thank you for purchasing this product I am pleased to be able to also include a surprise FREE bonus gift. This gift is one of my complete resources for which I usually charge full price but is yours absolutely free when you purchase this product. Just my little way of saying thank you to my valued customers. I hope you enjoy it and get use out of it, with my compliments.
[Click Here To See More Of My Great Python Lessons] (https://www.tes.com/resources/search/?authorId=835903&q=Python Lessons&shop=nwilkin)
Getting your classroom ready for back to school? Here is a fully editable PowerPoint presentation that contains 60 common computer science words in Welsh and simple student-friendly definitions. They can be displayed as a permanent wall display or you can pick the words to display to compliment your current teaching goals. It is like having a computing dictionary on the walls of your classroom for the students to quickly refer to and can help with spellings of common computer science terminology as well as acting as a reminder of the meanings of computing terms. As it is fully editable you can add to and alter the definitions yourself to make a truly personalised learning wall display for your classes.
These terms are suitable for KS3 computing and GCSE computer science classes.
Each slide has been adjusted to print on A4 paper and it is recommended you print them in colour for maximum effect.
The colours of the key terminology refer to the following categories:
Blue – Programming and Algorithms
Red – Networks
Purple – Computer Systems
Green – Cyber security
Orange – Binary, Data and Logic
With thanks to Dilwyn Owen for the kind translation into Welsh.
You can download the English version of this resource from here: https://www.tes.com/teaching-resource/computer-science-word-wall-display-12168842