These 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 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!
These 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 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 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.
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.
Here are all the packs needed to create 5 attractive displays in your computer room to instant impact and interest for your students.
Buy this bundle of 5 display packs now and instantly brighten your computer room and get a free BONUS pack of word wall posters too.
HOW CAN YOU USE THESE DISPLAY?
This display works well when positioned:
on a display board in your computer room
in the corridor leading to the classroom or
arranged in any other available space on your walls
.
PREPARING THE DISPLAYS
There are 5 complete displays included in this bundle:
Computer Science room lettering
Computer room rules posters
Who’s who is computing timeline
Rubber duck debugging
What does your digital footprint say about you?
.
You have colour and black and white versions. Print only the relevant pages you need for your computer room display. Some pages may require more than one copy.
It is best to print the pages in colour, if you can, but I have included black and white versions too to help you save on printing costs. If you are printing in black and white you may wish to print them onto coloured paper to add a bit of interest in your classroom.
I suggest printing the pages on card or laminating each page before cutting out the sections to give a more professional finish. Carefully cut out the sections and add them to your display space (making sure the letters are the right way up and in the correct order).
I’ve include suggested layouts to give you an idea of how you can display these sections in your computer room however you may want to display it slightly differently to fit the space you have.
What are you waiting for? Buy these ready to use computer room display packs now and get your FREE bonus pack of word wall posters too. They are sure to brighten your classroom.
Ready-to-use worksheets and activties you can immediately use in your classroom to help you teach the following topics:
Inside a computer
Binary, denary and Hex conversion
Logic Gates and Truth Tables
Suitable for GCSE Computer Science classes and KS3 Computing classes.
All packs include an answer booklet making your life even easier. Saves you hours of work.
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 practise 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
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 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 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 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 programming fundamentals 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 70-page workbook completely covers the new specification J277 2.2 programming fundamentals theory.
Table of Contents:
The use of variables, constants, operators, inputs, outputs and assignments
Sequence
Selection
Iteration (count-controlled and condition-controlled loops)
Common arithmetic operators
Common Boolean operators (AND, OR and NOT)
Data types (integer, real, Boolean, character, string and casting)
Basic string manipulation
File handling operations (open, read, write and close)
The use of records to store data
The use of SQL to search for data
The use of arrays (1D and 2D arrays)
How to use sub programs (functions and procedures)
Random number generation
.
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
Ethical, Legal, Cultural and Environmental Impacts
Algorithms
Producing Robust Programs
Boolean Logic
Programming Languages and IDEs
This algorithms 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 78-page workbook completely covers the new specification J277 2.1 algorithms theory.
Table of Contents:
Principles of computational thinking
Identify inputs, processes and outputs for a problem
Structure diagrams
Pseudocode
Flow diagrams
Refine programs using Python
Identify common errors
Trace tables
Binary search
Linear search
Bubble sort
Merge sort
Insertion sort
.
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
Ethical, Legal, Cultural and Environmental Impacts
Programming Fundamentals
Producing Robust Programs
Boolean Logic
Programming Languages and IDEs
This bundle contains 12 PDF worksheets containing 65 Python coding challenges focusing on specific skills which help pupils to focus on one skill at a time. It also includes 12 PDF worksheets which contain the answers.
These worksheets can be used as classroom activities, for homework tasks or as ready-to-use tasks for quick finishers, making these an invaluable resource to have in your teacher kit.
Download these ready to use worksheets now and take control of your workload.
Use them immediately or simply keep them in reserve for when you need them.
Areas covered:
01 - Python Basics (includes 6 challenges)
02 - If Statements (includes 5 challenges)
03 - For Loops (includes 6 challenges)
04 - While Loops (includes 5 challenges)
05 - Random Functions (includes 6 challenges)
06 - Mathematical Operators (includes 7 challenges)
07 - Lists (includes 5 challenges)
08 - Turtle (includes 5 challenges)
09 - 2D Lists (includes 5 challenges)
10 - Text Files (includes 5 challenges)
11 - CSV Files (includes 5 challenges)
12 - Subprograms (includes 5 challenges)
This makes 65 programming challenges which are perfect for use in the classroom or as homework tasks.
Saves you hours of preparation and planning time.
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
These refreshingly different attractive PDF knowledge organisers can be used for computer science revision. Also included are revision tips and practise exam questions including marks to allow pupils to practise answering exam type questions.
Includes the following topics:
Systems Architecture
Memory and Storage
Wired and wireless networks
Network topologies, protocols and layers
System security
System software
Ethical, legal, cultural and environmental concerns
Algorithms
Programming techniques
Producing robust programs
Computational logic
Translators and facilities of programming languages
Data representation
This Python programming 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 88-page workbook completely covers the new specification 8525 3.2 Programming theory and gives pupils plenty of practical Python challenges to complete.
Table of Contents:
Data types
Variables and constants
Iteration
Selection
Subroutines (procedures and functions)
Nested selection and iteration structures
Arithmetic operations
Relational operations
Boolean operations
Data structures (1D and 2D arrays)
Use of records
String handling
Random number generation
A structures approach to programming
Robust and secure programming
Syntax and logic errors
.
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.
You may also be interested in these workbooks which have also been updated for the new specification:
Algorithms
Fundamentals of Data Representation
Computer Systems
Fundamentals of Computer Networks
Cyber Security
Relational databases and SQL
Ethical, Legal and Environmental Impacts
Have you ever stayed awake at night wondering about the next computer science lesson you need to teach?
Wouldn’t to be wonderful to have 16 dazzling easy to run lessons right at your fingertips?
Imagine the relief as you can forget about the hours of planning and preparation and you can get on with doing something you really enjoy.
Here’s how it works:
Step 1: Purchase and download this bundle of 15 lessons
Step 2:Open them up and giggle excitedly at all the work that has been done for you
Step 3: Plan when you will use them
Step 4: Sit back, smile to yourself and watch another episode of your favourite box set knowing your planning is done
This bundle of 16 ready to use lessons includes everything you need to teach the following:
The purpose of the CPU
Von Neumann Architecture
CPU Performance
Embedded Systems
ROM, RAM and Virtual memory
Secondary Storage
Network Types
Network Hardware
What is the internet?
Network topologies
Wireless networks
Network Protocols and TCP/IP
Malware
Identifying and Preventing Network Vulnerabilities
and Computer Science Exam Technique Revision Lesson
.
Each lesson includes a high-quality dyslexia friendly PowerPoint presentation, videos to teach key skills, interesting activities to keep the class engaged and to help you monitor progress and understanding and teacher plans which include ALL THE ANSWERS!
They even include practice questions to help pupils prepare for their exams – I know this is really spoiling you but hey, you deserve it!
The lessons are suitable for newly qualified teachers, non-specialist teachers and experienced computer science teachers who are looking to add a sprinkle of zesty brilliance to their lessons.
Go on, treat yourself…you deserve it
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.
Take a giant step towards regaining control over your workload and teach Python programming with confidence.
These ready to use Python lessons will save you hours of planning by providing you with comprehensive, engaging content you can use in your classes with next to no preparation.
This bundle provides attractive dyslexia-friendly PowerPoint presentations, videos to teach key skills and plenty of opportunities for students to practise their Python programming skills. You will also get easy to follow teacher’s guides including ALL THE ANSWERS!
These 20 lessons are suitable for teaching pupils about the joys of Python programming, from the very basics to confidently writing and using subprograms and writing to and reading from external files.
It even includes a fun interactive computational thinking escape room game to introduce them to the problem-solving skills involved in Python programming.
It uses a proven scaffolding technique that empowers pupils to make progress and gain confidence in their programming skills.
Lessons:
Getting Started with Input and Output statements
If Statements
More Advanced If Statements
For and While Loops
Strings and Numbers
Random Values
Drawing with the Turtle
Creating Robust Programs
Good Programming Habits
Writing and Using Lists
Writing and Using 2D Lists
Using Subprograms
Recapping Programming Constructs
Recapping Subprograms
Recapping Lists and 2D lists
Recapping Good Programming Practice
Using External Text Files
Creating SQL Databases using DB Browser
Interrogating SQL database using Python
Using Structure Diagrams to Plan Larger Programs
The lessons are suitable for newly qualified teachers, non-specialist teachers and experienced computer science teachers who are looking to add a sprinkle of zesty brilliance to their lessons.
This unit uses every day examples along with lots of practical hands-on and unplugged challenges to bring the theory of computational thinking to life. Although this unit does refer to Scratch and Python as examples the pupils do not require any prior programming knowledge in these languages.
This resources includes:
• 6 attractive PowerPoint presentations including lots of challenges to complete
• 6 differentiated homework tasks
• an end of unit written test
• an easy to use “I can” style pupil self-marking sheet
• answer book
• all the files and worksheets that the pupils need to work through
• easy to follow lesson plans
The lessons cover:
Lesson 1: Decomposition
Lesson 2: Pattern Recognition
Lesson 3: Abstraction
Lesson 4: Algorithms and creating flow charts using selection and iteration
Lesson 5: Pseudocode including INPUT, OUTPUT, IF…THEN, IF…THEN…ELSE, IF…THEN…ELSEIF…ELSE statements
Lesson 6: Pseudocode including FOR, WHILE and REPEAT UNTIL loops
Suitable for KS3 Computing pupils as well as GCSE Computer Science pupils.
Please note: this unit does not include specific algorithms for sorting and searching as these are covered elsewhere.
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.
A top quality, highly interactive, ready to use set of lesson resources allows teacher to easily cover this truly fascinating and thought provoking topic of “ethical, environmental and legal issues with technology”.
Traditionally, this area was thought of as dry, difficult to teach and dull by many teachers but with this set of resources, that is now a thing of the past. These lessons provoke interesting group discussions where your classes will really engage with the subject matter and look at the issues from different perspectives. The fun activities reinforce the learning and homework tasks allow students to consolidate what they have learnt in the lesson and take their thoughts further into this ever-evolving area.
Suitable for GCSE Computer Science classes and KS3 Computing and ICT classes.
This set of resource includes:
• 6 attractive PowerPoint presentations which lead the class through each of the lessons
• Fun and thought provoking activities and discussion starters, worksheets and questions to reinforce the learning
• 6 differentiated homework tasks
• A mark sheet which allows pupils to track their own progress
• An end of unit test to prepare the students for exams or can be used as a form of assessment
• A complete teacher’s guide including easy to follow lesson plans
• An answer booklet to help the teacher along
The lessons are:
Lesson 1 – Looking into ethical and moral dilemmas such as driverless cars and the impact of technology on modern life
Lesson 2 – More ethical dilemmas including the ratings culture, medical apps, sharing personal data and cyber bullying
Lesson 3 – Environmental issues with technology and how organisations and individuals can reduce these effects
Lesson 4 – The Computer Misuse Act 1990
Lesson 5 – The Data Protection Act 1998
Lesson 6 – Copyright Designs and Patents Act 1988
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.
