Hero image

Nichola Wilkin - Computer Science

Average Rating4.66
(based on 1083 reviews)

Helping computer science teachers take control of their workload. My refreshingly different teaching resources enable you to teach great lessons that help your pupils engage with the subject matter. I’m an experienced teacher and HoD and professionally create resources through my company Nichola Wilkin Ltd. My book “Python by Example” published by Cambridge University Press has been a runaway success. Download my free resources now to see why I am one of the most popular authors on TES.

196Uploads

470k+Views

1539k+Downloads

Helping computer science teachers take control of their workload. My refreshingly different teaching resources enable you to teach great lessons that help your pupils engage with the subject matter. I’m an experienced teacher and HoD and professionally create resources through my company Nichola Wilkin Ltd. My book “Python by Example” published by Cambridge University Press has been a runaway success. Download my free resources now to see why I am one of the most popular authors on TES.
Computational Thinking Escape Room
nwilkinnwilkin

Computational Thinking Escape Room

(4)
This highly interactive lesson that requires the pupils to work in teams and use computational thinking skills to solve a range of puzzles. This activity perfect for pupils about to learn Python programming and you want to show the importance of computational thinking skills. Your class need to work together to escape a locked laboratory in a spaceship and start the engines to avoid being sucked into a black hole by completing different challenges which will use a variety of computational thinking skills. They are given most of the lesson to work together and at the end of the lesson, time is dedicated to discuss the computational thinking skills they used during the activity. This gives them a practical application for the computational thinking theory rather than using the tired old “making a jam sandwich” or “getting up in the morning” scenarios which are commonly used. This activity is not a handout driven escape room, it involves using an interactive PowerPoint presentation and physical tasks that moves away from pupils filling in yet another worksheet, to working together in a team to solve interesting and challenging puzzles. Pupils enjoy the lesson and are fully engaged whilst developing the key computational thinking skills of decomposition, pattern recognition, abstraction and algorithms. Please note: This lesson does require teachers to prepare some props beforehand and it is highly recommended the teacher reads through the teacher’s instructions and creates the props well before they want to use the lesson. Written primarily for key stage 3, this activity can be used in a variety of situations: Introducing pupils to computational thinking skills before they are introduced to a text-based programming language Used as an end of term fun lesson which still has an education element A fun activity to use on a year 6 transition day Allow your new year 7s to get to know their new classmates and grow team sprit Helping a reluctant class see the benefits of learning programming skills . Find out what sort of computer science teacher you are with this FREE fun 10-minute quiz.
The Witch's Lair – A Sorting Algorithms Escape Room
nwilkinnwilkin

The Witch's Lair – A Sorting Algorithms Escape Room

(0)
This has got to be one of the most unusual and fun ways of introducing your students to the delights of the bubble, insert and merge sorting algorithms. Even if your exam board only teaches two of these sorting algorithms its still worth getting this activity and teaching all three as it is just so much fun! Using an escape room activity that involves a witch and a goblin (who doesn’t want that?) your students will learn the basics of how these three algorithms work. This is a student lead interactive escape room activity that is ideal for social distancing and does not require any student computers and they can remain at their individual desks and yet they will still be working together. The entire activity will last a single lesson. Your role it to not do a lot and put the emphasis on your students working together. Early on you will be turned into a goblin! Sorry (not really sorry) so you may want to practice your goblin roar for when its called on. Students, therefor, cannot rely on you to help them (because you’ll be a goblin) and they’ll have to work together (either as a whole class or in smaller teams if you prefer) to try and solve all the riddles in their “spell books” for themselves. The main activity is introduced via a whole class PowerPoint presentation which includes videos giving the students vital instructions and helping them if necessary and each pupil is given a printout of the spell book which contains all the challenges. This escape room style activity gives your students a great introduction to the three sorting algorithms (bubble sort, insert sort and merge sort) and will certainly help give your students a boost at the start of learning this topic. Suitable for higher KS3 classes and GCSE Computer Science classes.
Python Loops and Iteration
nwilkinnwilkin

Python Loops and Iteration

(3)
This Python lesson teaches pupils to programming about using iterations, namely for loops and while loops. It is suitable for KS3 computing and GCSE 9-1 computer science pupils. It also includes lots of practice with reading and drawing flow diagrams. It includes an attractive dyslexia friendly PowerPoint presentation that includes differentiated lesson objectives, videos to teach key skills and lots practical programming practice. It also includes a comprehensive teacher’s lesson plan including all the answers. Please note: This lesson does assume the pupils are familiar with using basic if and else statements in Python. Duration: 1 lesson This lesson teaches pupils about: For loops using the range statement and While loops The difference between count controlled and condition controlled loops . Find out what sort of computer science teacher you are with this FREE fun 10-minute quiz.
Exam Technique GCSE 9-1 Computer Science Revision
nwilkinnwilkin

Exam Technique GCSE 9-1 Computer Science Revision

(0)
This complete lesson includes a PowerPoint presentation, lesson plan, and lots of practice exam questions to teach computer science pupils about exam technique. It includes loads of questions and introduces your class to key terminology used in the GCSE 9-1 Computer Science exams. This lesson is suitable for teaching the new updated syllabus starting September 2020 including the OCR GCSE Computer Science (J277) and AQA GCSE Computer Science (8520). It helps your pupils gain exam confidence and shows them how to aim for top marks in those tricky long exam questions. This can be used for preparation to any exam board GCSE 9-1 in computer Science. There is over an hour of subject matter included so the final mini exam paper (used in the plenary) can be set as a homework task to be marked together in the next lesson if you are running out of time in your lesson. Included in this resource is: 29-slide PowerPoint presentation (editable) 1-page PDF teacher’s lesson plan (not-editable) 1-page PDF algorithms question handout (not-editable) 2-page PDF mini exam paper (not-editable) . Check out these other great revision resources from Nichola Wilkin (nwilkin) on TES: OCR Component 1 knowledge organisers OCR Component 2 knowledge organisers OCR Mock Exam Paper 1
Computer Networks
nwilkinnwilkin

Computer Networks

6 Resources
This bundle of 6 lessons covers: Types of Networks Network Hardware What is the internet? Network Topologies Wireless Networks Network Protocols and the TCP/IP 4-Layer Model 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). Each lesson includes an attractive dyslexia friendly PowerPoint presentation with differentiated lesson objectives, at lease one video and lots of tasks and questions. Each lesson also 3 differentiated exam style questions along with a comprehensive teacher’s lesson plan including all the answers.
Ethical, Legal and Environmental Impacts AQA GCSE Computer Science Workbook (8525)
nwilkinnwilkin

Ethical, Legal and Environmental Impacts AQA GCSE Computer Science Workbook (8525)

(0)
This ethical, legal and environmental impacts 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 27-page workbook completely covers the new specification 8525 3.8 Ethical, Legal and Environmental Impacts of Digital Technology on Wider society, Including Issues of Privacy theory. Table of Contents: Ethical impacts of digital technology Autonomous vehicles Asking ethical questions Legal issues The Data Protection Act 2018 (GDPR) Wireless networking Cloud Storage The Computer Misuse Act 1990 Hackers v crackers The Copyright, Designs and Patents Act 1988 Software licences Environmental issues Privacy issues Computer based implants . 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 Cyber Security Relational databases and SQL
Exam Technique Lesson and Mock Exams for OCR GCSE (9-1) Computer Science J276
nwilkinnwilkin

Exam Technique Lesson and Mock Exams for OCR GCSE (9-1) Computer Science J276

3 Resources
The lesson includes a PowerPoint presentation, lesson plan, and lots of practice exam questions to teach computer science pupils about exam technique. It includes loads of questions and introduces your class to key terminology used in the exams. It helps your pupils gain exam confidence and shows them how to aim for top marks in those tricky long exam questions. This can be used for preparation to any exam board GCSE 9-1 in Computer Science. There is over an hour of subject matter in the lesson so the final mini exam paper (used in the plenary) can be set as a homework task to be marked together in the next lesson if you are running out of time in your lesson. This bundle also includes two mock exams, one for OCR paper 1 (J276/1) and one for OCR paper 2 (J276/2) both lasting 1 and half hours each. These OCR PDF mock exam papers closely match the style of the OCR GCSE (9-1) in Computer Science J276 exam papers and will help your pupils prepare. It replicates the type of exam questions pupils could be getting in the OCR GCSE Computer Science exams. Please note the mock exam papers are supplied as PDF documents as and are therefore not editable. Each exam consists of 80 marks and is designed to last 1 hour 30 minutes and includes a mark scheme which closely follows the guidelines for the qualification and includes a sheet to explain the estimated grade boundaries you can use to give your pupils a grade for this paper. These are very realistic mock exams and are ideal for classes preparing for their final exams and is especially useful when you have exhausted the small number of past papers and are looking for something else along the same lines. It is also useful for tutors or teachers who are working outside a traditional school system who may not have access to past papers or the OCR exam builder system. Please note: although we attempt to make these papers similar to the OCR papers to give pupils a realistic exam experience we have simplified the marking schemes and pupils should be encouraged to read through the mark schemes in conjunction with their attempted papers to gain a better understanding of the requirements. The writer makes no claims that these mock papers are created or endorsed by OCR.
Identifying and preventing network vulnerabilities
nwilkinnwilkin

Identifying and preventing network vulnerabilities

(1)
This lesson on system security and cyber attacks is suitable for GCSE 9-1 Computer Science pupils. This lesson is suitable for teaching the new updated syllabus starting September 2020 including the OCR GCSE Computer Science (J277) and AQA GCSE Computer Science (8520). It includes an attractive dyslexia friendly PowerPoint presentation that includes differentiated lesson objectives, a video and lots of individual and paired tasks and questions. It also includes 3 differentiated exam style questions along with a comprehensive 3-page teacher’s lesson plan including all the answers. This lesson teaches pupils about: Denial of service (DoS) attacks Brute force attacks Data interception attacks SQL injection attacks Poor network security policy Penetration testing Network forensics Firewalls Passwords Duration: 1 lesson Have you checked out this great FREE lesson on cyber security created by Nichola Wilkin Ltd (nwilkin): Malware
Python Lists
nwilkinnwilkin

Python Lists

(0)
This lesson allows pupils to create and amend simple one-dimensional lists in Python. This lesson is suitable for KS3 computing and GCSE 9-1 computer science pupils. It includes an attractive dyslexia friendly PowerPoint presentation that includes differentiated lesson objectives, 2 videos to teach key skills and lots of practical programming practice. It also includes a comprehensive teacher’s lesson plan including the answers to all the programming challenges. 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 Please Note: This lesson deals with one-dimensional lists only. It does not teacher pupils about two-dimensional lists as that is covered in another lesson. This lesson teaches pupils about: Creating simple 1D lists Displaying the list Displaying the list with each item on a separate line Displaying single items in a list Adding data to the end of a list Adding data to a specific position in the list Altering data in a list Removing data from a list Finding the length of a list . Find out what sort of computer science teacher you are with this FREE fun 10-minute quiz.
Network Protocols and the TCP/IP 4-layer model
nwilkinnwilkin

Network Protocols and the TCP/IP 4-layer model

(0)
This lesson is about network protocols and the TCP/IP 4-layer model is suitable for GCSE Computer Science pupils. This lesson is suitable for teaching the new updated syllabus starting September 2020 including the OCR GCSE Computer Science (J277) and AQA GCSE Computer Science (8520). It includes an attractive dyslexia friendly PowerPoint presentation that includes differentiated lesson objectives, a video and lots of tasks and questions. It also includes 3 differentiated exam style questions along with a comprehensive 3-page teacher’s lesson plan including all the answers. This lesson teaches pupils: IP addresses MAC addresses Packet Switching TCP/IP 4-layer model HTTP HTTPS FTP POP IMAP SMTP Ethernet Duration: 1 lesson Check out these other useful lesson resources from Nichola Wilkin (nwilkin): What is the internet? Network Topologies Wireless Networks
Python Creating Robust Programs
nwilkinnwilkin

Python Creating Robust Programs

(0)
This lesson allows pupils to consolidate their Python programming skills they have learnt so far by giving them a challenging program to complete. They need to create a program that allows messages to be encoded and decode using a Caesar cypher. While they are doing this, they are acquiring valuable skills about creating robust programs and how to break a complex task into manageable chunks along with common techniques programmers use when tackling large programs. This lesson is suitable for KS3 computing and GCSE 9-1 computer science pupils. It includes an attractive dyslexia friendly PowerPoint presentation that includes differentiated lesson objectives, 2 videos to teach key skills and lots of practical programming practice. It also includes a comprehensive teacher’s lesson plan including the answer to the main programming challenge. 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: Using sensible variable names and user prompts Creating a menu system that works Creating a robust program that takes into account user errors to prevent them from crashing the program How to break a complex task into manageable chunks Caesar cypher Converting strings into ASCII code and converting ASCII code into strings . Find out what sort of computer science teacher you are with this FREE fun 10-minute quiz.
Von Neumann Architecture
nwilkinnwilkin

Von Neumann Architecture

(4)
This lesson on Von Neumann architecture is suitable for GCSE Computer Science pupils. This lesson is suitable for teaching the new updated syllabus starting September 2020 including the OCR GCSE Computer Science (J277) and AQA GCSE Computer Science (8520). It includes an attractive dyslexia friendly PowerPoint presentation that includes differentiated lesson objectives, a video and lots of tasks and questions. It also includes 3 differentiated exam style questions along with a comprehensive 3-page teacher’s lesson plan including all the answers. This lesson teaches pupils about: How cache memory is used by the CPU The three levels of cache memory The component parts of the CPU in the Von Neumann architecture model How the component parts of the CPU work in the fetch-decode-execute cycle Duration: 1 lesson Check out these other great resources by Nichola Wilkin (nwilkin): The purpose of the CPU CPU Performance Rom, Ram and Virtual Memory Embedded Systems Secondary Storage
Relational databases and SQL AQA GCSE Computer Science Workbook (8525)
nwilkinnwilkin

Relational databases and SQL AQA GCSE Computer Science Workbook (8525)

(0)
This is exceptional value as it includes my “Relational Databases and Structured Query Language (SQL)” workbook and answer book, clear instructions to walk you through installing DB Browser and two databases to practice with. This pack 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. As part of that workbook it also includes gives clear, easy to follow instructions for creating an SQL database using DB Browser. It also shows how Python can be used to insert, update and delete data in the SQL database as well as retrieving specific data from the SQL database using select, from, where and order by. A separate PDF answer booklet is provided giving you all the answers to the tasks in the workbook so you can assign your students the workbook without including the answers. The 39-page workbook completely covers the new specification 8525 3.7 Relational Databases and Structured Query Language (SQL) section of the AQA (8525) GCSE in Computer Science. Table of Contents: Explain the concepts of databases Relational databases Table Record Field Primary Key Foreign key SQL SELECT FROM WHERE ORDER BY … ASC / DESC INSERT INTO UPDATE DELETE FROM . 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 Cyber Security Ethical, Legal and Environmental Impacts
KS3 Python Programming Complete SoW
nwilkinnwilkin

KS3 Python Programming Complete SoW

14 Resources
12 ready to use lessons, you can use immediately to teach pupils how to program in Python. This bundle includes 12 lessons making a complete unit of work that teaches pupils how to program in Python and also includes two end of unit tests to assess their programming skills. The National Curriculum for England 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).” (National curriculum in England: computing programmes of study - key stages 3 and 4:) This complete unit of work teaches pupils how to programming in Python and takes them through the basics to using data structures and sub programs. Each lesson includes an attractive PowerPoint presentation and include videos to teach the key skills and loads of Python programming practice and questions. The teacher’s lesson plans include differentiated objectives and all the answers to the programming problems making this series of lessons ideal for specialist and non-specialist teachers. The recommended order of the lessons are as follows: Lesson 1 – Computational thinking escape room Lesson 2 – Input and output Lesson 3 – If statements Lesson 4 – More if statements Lesson 5 – Going loopy Lesson 6 – Text and numbers Lesson 7 – Random values Lesson 8 – Python turtle Lesson 9 – Creating robust programs Lesson 10 - Lists Lesson 11 – 2D lists Lesson 12 – Sub programs Python end of unit assessment (paper test) Python practical programming assessment Find out what sort of computer science teacher you are with this FREE fun 10-minute quiz.
Build Your Own Paper Computer
nwilkinnwilkin

Build Your Own Paper Computer

(0)
This highly engaging series of 3 lessons can be run with no student computers so is suitable for lessons in a standard non-ICT classroom, in a computer suite or when pupils are self-isolating at home. Each lesson comes with a dyslexia-friendly PowerPoint presentation that includes all the instructions and takes the teacher and class through each lesson making this resource suitable for specialist and non-specialist teachers. The students have a workbook they fill in each lesson as they progress, extending their knowledge and helping you monitor their progress. An answer book is provided which can be used by the teacher or issued to students as a self-marking aid. This is a hands-on enjoyable series of three lessons that help pupils understand the hardware in a computer along with common software. Written for KS3 this is suitable for years 7 to 9 and can even be used with GCSE groups if you wish. Equipment needed: pupils should have access to a pair of scissors, a glue stick and a sheet of colourful A4 (or letter sized) paper along with a print-out of the 7-page template and 13-page workbook each (oh, and they will also need a pen).
Python Lists
nwilkinnwilkin

Python Lists

(0)
Python Lists - ready to use practical challenges! A great 2 page handout for your pupils to practice creating lists in Python. Includes example code, a tasks to read code, a task to correct code and 3 practical challenges for them to practice writing Python code. It even includes a PDF containing the answers. Great for homework tasks, classroom activities or remote learning You may also be interested in these other Python challenges to add to your collection. Python Basics -https://www.tes.com/teaching-resource/python-basics-practical-challenges-11925892 Python If Statements -https://www.tes.com/teaching-resource/python-if-statements-practical-challenges-11925948 Python For Loop -https://www.tes.com/teaching-resource/python-for-loop-practical-challenges-11925972 Python While Loop -https://www.tes.com/teaching-resource/python-while-loop-practical-challenges-11926194 Python Random Values -https://www.tes.com/teaching-resource/python-random-values-practical-challenges-11929327 Python Mathematical Operators -https://www.tes.com/teaching-resource/python-mathematical-operators-practical-challenges-11929571 Python Turtle-https://www.tes.com/teaching-resource/python-turtle-11992208 Python 2D lists-https://www.tes.com/teaching-resource/python-2d-lists-11993856 Python Text Files-https://www.tes.com/teaching-resource/python-text-files-11994635 Python CSV files-https://www.tes.com/teaching-resource/python-csv-files-11995021 Python Subprograms-https://www.tes.com/teaching-resource/python-subprograms-11999426
History of Computers (GCSE Computer Science and KS3 Computing)
nwilkinnwilkin

History of Computers (GCSE Computer Science and KS3 Computing)

(91)
This lesson teaches the pupils about the history of computers. It uses animations to tell the story in an interesting and entertaining way. As the pupils learn the history they fill in a worksheet which you can go through with the whole class. They then complete a word search identifying the key people in developing technology and finally they play a game to recap what they have learnt. Suitable for GCSE Computer Science classes and KS3 Computing and ICT classes. For more high quality, ready-to-use computing lessons and units of work, visit www.nicholawilkin.com
Computing Christmas Quiz 2020
nwilkinnwilkin

Computing Christmas Quiz 2020

(21)
The one and only end of term Christmas Quiz 2020 from Nichola Wilkin Ltd. We’ve all had a demanding year, so why not end 2020 on a high note? My computing Christmas quizzes have become a tradition in many schools with thousands of students and teachers enjoying a fun (and slightly educational) quiz for their last lesson before they break up for Christmas. This year, maybe more than ever, a bit of jollity and normality is needed so I’m excited to be able to provide this quiz for free. I hope that it gives you a little piece of normality in what must be the most stressful teaching year in our lifetimes. For anyone who has not used this quiz before, let me just briefly explain what it entails. The zip file contains a non-editable PowerPoint presentation and a PDF answer sheet. Decide how many teams you want to split your class into (it is more fun in teams although if your school’s Covid safety measures prevent this, it will still work individually). Photocopy one answer sheet for each team before the lesson. That’s it, that’s all the preparation you need to do. To run the quiz, show the presentation to your class and work through each slide one at a time. This means you can play this quiz with your class remotely if you need to. The quiz is split into 9 rounds and each round has 5 questions. At the end of each round you will go through the answers so if you need to cut the lesson short for any reason, you can do so easily. Some rounds are just for fun and some are computer science related rounds which should be accessible for year 7 to year 11. The 9 rounds this year include: Round 1 – Guestimation Round 2 – Computing Emoji Round 3 – Float or Sink (honestly it was a toss-up between this and “Cheese or Service Station” which also went down very well in my lockdown Zoom quizzes) Round 4 – Computer Science Multiple Choice Round 5 – Hidden Celebrity Round 6 – Thinking Logically Round 7 – Visual Memory Round 8 – What am I? Round 9 – Next Lines Thank you for everything you are doing in the classrooms, you are true heroes and I just hope you get a chance to relax and enjoy your Christmas holiday. Happy Christmas Love Nicky x
Scratch
nwilkinnwilkin

Scratch

(239)
A complete 6 week Scratch unit (Using Scratch version 1) to teach pupils the basics of using this fantastic and easy programming language. If you want an improved SoW for Secondary pupils look at our unit https://www.tes.com/teaching-resource/6-lesson-scratch-introduction-complete-sow-secondary-pupils-11517550 (£15 ) which is updated for Scratch 2. This resource includes: Teacher guide (including lesson plans) PowerPoint presenation for every lesson, Place mats to keep pupils active even if they are sharing a computer Student self-assessment mark sheet A zip-file containing 4 Scratch files This SOW includes PowerPoint presentations with embedded videos, however, the videos can also be viewed through YouTube https://www.youtube.com/channel/UCxCer9Rb5WxU0_SR7vS9w8A For more high-quality resources visit www.nicholawilkin.com