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 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 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
Planning you first lesson to welcome your new year 7 computing class?
This lesson includes an attractive editable PowerPoint presentation which covers the following skills:
Logging on to the school network
Creating a strong password
Searching the internet
This allows you to get to your know classes a little easier, learn their names and make an initial judgment on their current ICT abilities.
This resource also includes teachers lesson plan, teachers observation form and a worksheet and answers.
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 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
Looking for a comprehensive and easy-to-use resource to help your students excel in AQA GCSE 8525 computer science? Look no further than our complete set of workbooks!
Written specifically to match the requirements of the AQA GCSE Computer Science exams, these workbooks ensure that you cover the entire specification and provide your students with all the information they need for successful revision and exam preparation.
But these workbooks are more than just a standard handout or textbook. They’re interactive and engaging, combining the best of both worlds to create a powerful addition to your teacher’s toolkit. With everything at their fingertips, your students will be able to focus on learning and achieving their best.
What is included?
Our interactive PDF workbooks make it easy to focus on specific sections of the AQA 8525 GCSE in Computer Science syllabus without overwhelming your students. Each workbook is designed to cover a single topic in depth, using student-friendly language and clear explanations of key terminology to help your pupils digest the knowledge and retain it for longer.
Throughout each workbook, tasks are included to reinforce learning and allow you to monitor your students’ progress. Answers are provided in a separate PDF workbook, giving you the option to issue workbooks without answers for assessment purposes.
To help your students take ownership of their learning, each workbook also includes a student checklist. This tool allows students to track their progress and identify areas where they may need more work, helping you make the most of the time you have with your students.
This bundle includes all of the following AQA workbooks:
Fundamentals of Algorithms
Programming using Python
Fundamentals of Data Representation
Computer Systems
Fundamentals of Computer Networks
Cyber Security
Relational Databases and Structured Query Language (SQL)
Ethical, Legal and Environmental Impacts of Digital Technology
The total individual price for all the computer science workbooks is £135.92 but when purchased as a bundle you can get all this for only £100 saving you more than 25% of the individual price.
How can they be used?
Our AQA 8525 GCSE in Computer Science workbooks are the perfect complement to your classroom teaching. They offer the flexibility to be completed either on-screen or printed and completed manually on paper, ensuring continuity both in the computer room and when your classroom is being used by another subject.
In addition, our workbooks can also be given to students as homework or self-study projects to complete on their own at home. This is a great option for students who may need extra practice or who want to reinforce their understanding of a particular topic.
The best part? When you purchase our workbooks, you’ll receive a PDF file that can be reused time and time again with no further costs or ongoing subscription fees. This means that you can continue to use them year after year, saving time and money in the process.
So whether you’re looking for an in-class supplement, a homework option, or a comprehensive revision tool, our AQA 8525 GCSE in Computer Science workbooks are an excellent choice.
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
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 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 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 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 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
This is a written test about how data is represented in a computer system.
It includes questions on binary, denary, hexadecimal, binary addition, logic gates, truth tables, ASCII, bitmaps and vector images and machine code.
Suitable for GCSE Computer Science classes and KS3 Computing classes. A useful revision tool to help GCSE pupils recognise gaps in their knowledge.
The test takes most students around 25 - 30 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.
This is a written test about computer networks.
It includes questions about LANs, the internet and the world wide web, network hardware, network topologies, data packets, MAC and IP addresses, network security and cloud storage.
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 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 it’s 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-led 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 is 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 practise your goblin roar for when it’s called upon.
Students therefore 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. 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 give your students a boost at the start of learning this topic.
Suitable for higher KS3 classes and GCSE Computer Science classes.
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.
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
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.
In this high-quality 6-lesson complete scheme of work, pupils will be introduced to the programming language “Scratch 2”.
Moving sprites using the mouse and keyboard as well as moving automatically around the screen
Repeat and forever loops
If statements and If…else statements
Use sensing tools so sprites can interact with each other
Use questions and answers in programs
Create and use variables to store and manipulate values during the running of programs
Create their own sprites and backgrounds
Use costumes
Apply broadcast messages
This unit is ideal if the pupils have never used Scratch before or have had only very limited experience.
Suitable for KS3 Computing and ICT classes.
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.
