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 visually appealing knowledge organiser is a quick summary to recap systems software. It can help pupils revise for end-of-unit tests or GCSE computer science exams by including small straightforward facts that can be learned in minutes.
A powerful revision aid that your students will love.
What are you waiting for? Grab your copy now and together we can boost your pupils’ confidence in understanding systems software.
WHAT IS INCLUDED?
This PDF knowledge organiser includes the important facts and a separate PDF document includes revision tips and an exam style question including a possible answer.
HOW CAN I USE IT?
This resource makes an ideal homework task, can be used as part of a lesson or given to pupils to help them with their revision.
WHAT DOES IT COVER?
This knowledge organiser includes easy-to-digest facts on the following topics:
The purpose and functionality of systems software
Operating systems
User interfaces
Memory management and multi-tasking
Peripheral management
Drivers
User management
File management
Utility systems
Encryption software
Defragmentation
Data compression
Full and incremental backups
.
Get your copy of this fantastic knowledge organiser now. You’ll wonder how you ever managed without it.
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 my other computer science knowledge organisers
This lesson is perfect to for students learning about using SQL databases. In this lesson the pupils interrogate an SQL database using Python. They use the SELECT statements to fetch specific data from a flat file DB Browser SQL database.
Download this ready to use lesson now and take control of your workload.
It is important that pupils are familiar with using and creating databases in DB Browser and we STRONGLY RECOMMEND that this lesson is used in conjunction with the previous lesson in this series (Creating an SQL Database). It is also essential that pupils have DB Browser installed on every computer prior to the lesson starting which can be downloaded for free from https : // sqlitebrowser . org / .
This lesson includes an attractive dyslexia friendly PowerPoint presentation and the teachers lesson plan that includes the answers. It also includes 2 databases that are already populated with data for the pupils to interrogate and it includes a mini project which involves the pupils creating a single table database and interrogating it using Python.
Duration: 1 lesson.
This lesson helps pupils understand the following key skills:
Filtering a database in DB Browser
Identifying fields and file properties in a database
Using Python to link to an SQL database
SELECT …
FROM …
WHERE …
.
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 our complete resources which we will usually charge full price for but is yours absolutely free when you purchase this product. Just our little way of saying thank you to our 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 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 cyber security workbook is perfect for students studying for the AQA GCSE (9-1) in computer science and has been updated to completely cover the new specification 8525.
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 32-page workbook completely covers the new specification 8525 3.6 Cyber Security theory.
Table of Contents:
The purposes of cyber security
Social Engineering techniques (blagging, phishing, pharming and shouldering)
Malicious code / malware (computer virus, trojan and spyware)
Penetration testing
Security measures (biometric measures, password systems, CAPTCHA, using email confirmations and automatic software updates)
.
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 our complete resources which we will usually charge full price for but is yours absolutely free when you purchase this product. Just our little way of saying thank you to our valued customers. I hope you enjoy it and get use out of it, with my compliments.
You may also be interested in these workbooks which have also been updated for the new specification:
Algorithms
Python Programming
Fundamentals of Data Representation
Computer Systems
Fundamentals of Computer Networks
Relational databases and SQL
Ethical, Legal and Environmental Impacts
This data representation workbook is perfect for students studying for the AQA GCSE (9-1) in computer science and has been updated to completely cover the new specification 8525.
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 66-page workbook completely covers the new specification 8525 3.3 Fundamentals of Data Representation theory.
Table of Contents:
Number bases (decimal, binary and hexadecimal)
Converting between number bases
Units of information
Adding together binary numbers
Binary shift
Character encoding
Representing bitmap images
Colour depth and image size
Representing sound
Sampling rate and sample resolution
Calculate file sizes
Data compression
Huffman code
Run length encoding (RLE)
.
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 our complete resources which we will usually charge full price for but is yours absolutely free when you purchase this product. Just our little way of saying thank you to our valued customers. I hope you enjoy it and get use out of it, with my compliments.
You may also be interested in these workbooks which have also been updated for the new specification:
Algorithms
Python Programming
Computer Systems
Fundamentals of Computer Networks
Cyber Security
Relational databases and SQL
Ethical, Legal and Environmental Impacts
This end of unit test is part of the Scratch Introduction unit and can be used to assess the pupils’ understanding of Scratch basics.
This resource includes the test (part written test and part practical element) and the answers to assist with marking.
This test takes most students 40 - 60 mins to complete.
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 end of unit test can be used to assess the pupils’ understanding of Scratch advanced features.
This resource includes the test (part written test and part practical test) and the answers to assist with marking.
This test takes most students 40 - 60 mins to complete.
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 algorithms workbook is perfect for students studying for the AQA GCSE (9-1) in computer science and has been updated to completely cover the new specification 8525.
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 55-page workbook completely covers the new specification 8525 3.1 Fundamentals of Algorithms theory.
Table of Contents:
Algorithms
Decomposition
Abstraction
Systematic problem solving
Pseudo-code
Python
Flowcharts
Efficiency of algorithms
Linear search
Binary search
Merge sort
Bubble sort
.
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 our complete resources which we will usually charge full price for but is yours absolutely free when you purchase this product. Just our little way of saying thank you to our valued customers. I hope you enjoy it and get use out of it, with my compliments.
You may also be interested in these workbooks which have also been updated for the new specification:
Python Programming
Fundamentals of Data Representation
Computer Systems
Fundamentals of Computer Networks
Cyber Security
Relational databases and SQL
Ethical, Legal and Environmental Impacts
This is a written test about the legal, ethical and environmental issues in computing.
It includes questions about Data Protection Act, Computer Misuse Act, Copyright, environmental issues and moral issues of technology.
Useful revision tool to help GCSE pupils recognise gaps in their knowledge.
Suitable for GCSE Computer Science classes and KS3 Computing classes.
This test takes most students 25 - 40 mins to complete.
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 our complete resources which we will usually charge full price for but is yours absolutely free when you purchase this product. Just our little way of saying thank you to our valued customers. I hope you enjoy it and get use out of it, with my compliments.
This is a written test about the inside workings of a computer.
It includes questions about the CPU, computer speed, multi-core processors, virtual memory, solid state and magnetic storage, ROM, RAM, user requirements and Moor’s law.
Useful revision tool to help GCSE pupils recognise gaps in their knowledge.
Suitable for GCSE Computer Science classes and KS3 Computing and ICT classes.
This test takes most students 25 - 40 mins to complete.
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 our complete resources which we will usually charge full price for but is yours absolutely free when you purchase this product. Just our little way of saying thank you to our valued customers. I hope you enjoy it and get use out of it, with my compliments.
Workbook, Python printable challenges and a glossary to help pupils learn Python programming. Suitable for KS3 and GCSE Computer Science.
Purchasing this bundle saves you 29% on the usual individual price.
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
A collection of full lessons, workbooks, handouts and knowledge organisers to teach GCSE Computer Science pupils about the CPU.
These lessons are suitable for teaching the new updated syllabus starting September 2020 including the OCR GCSE Computer Science (J277) and AQA GCSE Computer Science (8520).
Can be used in class, homework tasks and as revision.
The bundle saves you 30% on the usual individual price.
A great introduction to understanding Moore’s law and how to convert between different memory sizes. This ready to use lesson will save you hours of preparation and can easily be adapted to meet your own requirements.
WHAT IS INCLUDED?
Everything you need is included such as:
a very high-quality accessible PowerPoint presentation that effortlessly leads the teacher through the lesson and includes all the answers to the many questions and tasks the students need to complete
a 2 sided editable worksheet
an easy-to-follow editable lesson plan
.
PRIOR LEARNING
This unit does not expect pupils to know about binary but most teachers use this after students have been introduced to the concepts of converting binary to denary.
EASY TO USE
These ready to use resources are so straightforward that although I have included a lesson plan, most teachers can teach straight from the PowerPoint presentation without any further assistance. And best of all, the answers are included saving you time and energy.
This makes this lesson suitable for experienced computing specialist teachers along with non-specialists and early career teachers (ECTs).
EDITABLE RESOURCES
I understand that teachers want to adapt their resources, so I’ve made the bold decision to make these resources editable.
Therefore, if you need to use a particular template style for your school, you can change the PowerPoint presentation, worksheet and lesson plan to suit your needs.
If you have students with specific educational needs, you can change the lesson to suit them.
It gives you the flexibility to alter the lessons to suit your own particular needs.
SCIENTIFICALLY PROVEN TEACHING TECHNIQUES
These teaching resources have been specifically designed to aid pupils using educational psychology backed theories to ensure your students will have a higher retention rate and a deeper understanding of the subject.
TEACHING TO THE TOP
This lesson is designed to stretch all pupils. Instead of traditional differentiation which systematically underchallenges pupils, I raise the bar for everyone and then, as a teacher who knows your own students best, you can support individuals to reach their own full potential.
Start reaping the benefits today of an incredibly high-quality, professionally designed teaching resource that you can use with virtually no preparation.
Just click on the BUY NOW button to download it straight away. You’ll wonder how you ever managed without it.
Looking for some ready-made Python files to help your pupils learn about the bubble sort, insert sort, merge sort, linear search and binary search in more detail. Here they are.
WHAT IS INCLUDED?
In this unit you have 10 ready-to-use Python programs:
2 Bubble sort programs (one with comments and one without comments)
2 Insertion sort programs (one with comments and one without comments)
2 Merge sort programs (one with comments and one without comments)
2 Linear search programs (one with comments and one without comments)
2 Binary search programs (one with comments and one without comments)
Not only that, but you also have 20 further editable handouts allowing you the flexibility to use these with either OCR, AQA and Edexcel exam boards.:
1 handout for each of the sorting and searching algorithms that includes the written algorithm and the flowchart.
3 editable handouts for each of the sorting and searching algorithms showing the pseudocode for either OCR, AQA or Edexcel
.
HOW CAN I USE THEM?
You can use these ready-to-use Python programs and handouts in any number of ways.
You could use these Python programs to show the code to the pupils and ask them how it works and talk through the code with them comparing it to the algorithm.
You could challenge your students to add comments themselves to explain the code or use it to demo a working program.
If you feel your pupils are able, you could set them the challenge of programming it themselves and use the completed programs as exemplar material to aid pupils who get stuck or even remove some of the code and ask them to complete key areas to make it work.
You can give them the pseudocode and ask them to write the program from that.
.
PRIOR LEARNING
This unit does expect pupils know what an algorithm is and be familiar with understanding written algorithms and flowcharts. It is also advantageous to have spent some time looking at each of the algorithms (bubble sort, insertion sort, merge sort, linear search and binary search) to only use these programs and handouts as an extension of earlier learning they have done with you to familiarise them with the algorithms and comparison of the algorithms.
I have created a unit which includes 3 lessons that can be used to teach your classes about the algorithms. You can find out more about this unit here.
#EDITABLE RESOURCES
I understand that teachers want to adapt their resources, so I’ve made the bold decision to make these resources editable.
Therefore, if you need to use a particular template style for your school or pupils with special educational needs, you can change the programs and handouts to suit your needs.
Start reaping the benefits today of incredibly high-quality, professionally designed teaching resources that you can use with virtually no preparation.
Just click on the BUY NOW button to download them straight away. You’ll wonder how you ever managed without them.
This visually appealing knowledge organiser is a quick summary to recap wired and wireless networks. It can help pupils revise for end of unit tests or GCSE computer science exams by including small straightforward facts that can be learnt in minutes.
A powerful revision aid that your students will love.
What are you waiting for? Grab your copy now and together we can boost your pupil’s confidence in understanding of wired and wireless networks.
WHAT IS INCLUDED?
This PDF knowledge organiser includes the important facts and a separate PDF document includes revision tips and an exam style question including a possible answer.
HOW CAN I USE IT?
This resource makes an ideal homework task, can be used as part of a lesson or given to pupils to help them with their revision.
WHAT DOES IT COVER?
This knowledge organiser includes easy to digest facts on the following topics:
LAN and WAN
Factors that affect eh performance of the network
Hardware needed to connect a stand-alone computer to a LAN
Client-server and peer-to-peer networks,
Domain Name servers (DNS)
Hosting
The cloud and
Virtual networks
.
Get your copy of this fantastic knowledge organiser now. You’ll wonder how you ever managed without it.
Click here to see my other computer science knowledge organisers
Looking for a computing activity that will make that last lesson of the school year a little bit extra special? Look no further.
My hotly anticipated Computing Summer Quiz 2021 is here and ready for you to download for free.
After the year you and your students have had, you deserve a fun (and slightly educational) computing quiz. Grab your copy today and rest assured knowing that your last lesson of the academic year is sorted.
Suitable for year 7 to year 10.
HOW IS IT USED?
Simply download the quiz and inside the zip file you’ll find a PowerPoint presentation and a PDF document. Print out one PDF document per team and run through the presentation with your class.
NO OTHER PREPARATION IS REQUIRED MAKING THIS AN INCREDIBLY EASY ACTIVITY TO USE.
WHAT IS INCLUDED?
The quiz is made up of several rounds and each round contains 5 questions.
At the end of the round you’ll see the answers allowing you to cut the quiz short if you need to.
The 9 rounds this year include:
Round 1 – Text Abbreviations
Round 2 – Data Representation
Round 3 – News Stories (2020 – 2021)
Round 4 – Computational Thinking
Round 5 – Hidden Celebrities
Round 6 – What’s the truth?
Round 7 – Computer Game Characters
Round 8 – Multiple Choice Questions
Round 9 – Song Lyrics, Next Line
Also watch out for the sneaky bonus question which could change the scores right at the end of the quiz!
What are you waiting for? Download this free quiz today and give your students a last lesson of the school year they will love.
Here are just some of the reviews from happy computing teachers for last year’s Christmas quiz…
These quizzes are becoming a bit of a tradition within our academy Computer Science lessons. Thanks for creating again and sharing
I have used this quiz with a few classes so far and they have all really enjoyed it. Fun with a bit of computing thrown in. Thank you for sharing.
So glad I’ve found your Christmas quiz resources this year, thank you!
Absolutely fantastic! Thanks for sharing.
This quiz is great fun, thank you very much!
After a tough year for teachers and students you can relax and enjoy your last lessons of the year when you use this computing summer quiz.
This computing summer quiz is so easy to use with virtually no preparation needed. All you need to do is print/photocopy one answer sheet per team and then run the PowerPoint presentation with your class as they compete in 9 fun and interesting question rounds.
At the end of each round the answers are displayed allowing you to cut the quiz short if you need to.
This quiz includes both computing rounds (to keep your management happy) and some “just for fun” rounds (to keep your students happy).
The rounds this year include:
Films
Hardware
News Stories From 2021 And 2022
Network Security
Logic Puzzles
Country Size
Computing Facts
Where Will The Robot End Up?
Song Lyrics
What are you waiting for? This quiz if completely FREE. Download your copy now and give your class some end of year excitement that will leave you looking like a hero.
Because you are a hero and deserve a break.
Click here to take a peek at my Python lesson bundle that can save you hours of preparation time.
A great lesson to consolidate basic programming skills whilst helping your pupils learn good programming habits.
The totally FREE lesson teaches your students about following good programming habits.
This this lesson involves students consolidating their previous programming skills using fun and interactive programming task cards, which are ideal for pupils who struggle with the basics or the syntax of the three basic programming constructs (sequence, selection and iteration). This high-energy activity asks pupils to create several programs in which they will be utilising the good programming habits they have been taught at the start of the lesson.
Download this ready to use lesson now and become more confident in teaching programming to your pupils. It’s free so what have you got to lose?
Please note: students should be familiar with basic input and print statements, using simple mathematical operators, if statements and iteration, although there is plenty of practice opportunities in this lesson.
This ready to use lesson is suitable for KS3 and GCSE computer science pupils.
It includes an attractive dyslexia friendly PowerPoint presentation that includes differentiated lesson objectives, a video and lots of practical programming practice. It also includes a comprehensive 2-page teacher’s lesson plan.
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
In this lesson your students will learn about:
Why comments are used by programmers
How to add a comment to a single line of code
How to block out larger sections of Python code using comments
How empty lines can be used both in the code and in the output
Re-enforces the importance of good variable names.
.
What are you waiting for? Take action straight away and download your FREE copy of this wonderful low-prep lesson today that will keep your pupils engaged and making progress.
Click Here To See More Of My Great Python Lessons
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