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 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.
Do your students need a little extra help with understanding using lists in Python programming? Are you looking for some ready to use programming challenges that can be easily incorporated into your lessons?
This worksheet can be used as a classroom activity, for a homework task or as a ready-to-use task for quick finishers, making this an invaluable resource to have in your teacher kit.
Download this ready to use worksheet now and take control of your workload. Use it immediately or simply keep it in reserve for when you need it.
WHAT IS INCLUDED?
This 2-page PDF printable handout includes:
example code,
a tasks to read code,
a task to correct code and
3 practical challenges.
.
You even have a separate PDF with possible answers.
The diversity of these lists programming challenges allow pupils to develop a variety of useful programming skills. This resource is perfect for established computer science teachers, non-specialist teachers or newly qualified teachers.
What are you waiting for? Take action straight away and grab your copy of this wonderful worksheet today that will keep your pupils engaged and making real progress. Everything is done for you which will save you hours of preparation time.
Please note: This resource is a non-editable PDF
FREE BONUS PRODUCT INCLUDED
As a special thank you for purchasing this product I am pleased to be able to also include a surprise FREE bonus gift. This gift is one of my complete resources for which I usually charge full price but is yours absolutely free when you purchase this product. Just my little way of saying thank you to my valued customers. I hope you enjoy it and get use out of it, with my compliments.
Click Here To See More Of My Great Python Challenges
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).
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 FREE programming languages and IDEs 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 free 12-page workbook completely covers the new specification J277 2.5 Programming Logic and Integrated Development Environments (IDE) theory.
Table of Contents:
Characteristics and purpose of different levels of programming languages
Machine Code
Assembly language
High-level languages
The purpose of translators
Source code
Compilers
Integrated development environments (IDEs)
Editors
Error diagnostics
Run-time environments
Translators
.
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
Programming Fundamentals
Producing Robust Programs
Boolean Logic
This FREE Boolean logic 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.
BONUS RESOURCE: This resource also includes a PowerPoint presentation that allows pupils to easily create neat logic circuits by simply dragging the options into the desired position. Clear instructions are given in the presentation on how to use it.
This free 12-page workbook completely covers the new specification J277 32.4 Boolean Logic theory.
Table of Contents:
Simple logic diagrams using the operators AND, OR and NOT
Truth tables
Combining Boolean operators using AND, OR and NOT
Applying logical operators in truth tables to solve problems
.
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
Programming Fundamentals
Producing Robust Programs
Programming Languages and IDEs
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 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
.
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
Cyber Security
Relational databases and SQL
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 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 Fundamentals of Computer Networks 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 33-page workbook completely covers the new specification 8525 3.5 Fundamentals of Computer Networks theory.
Table of Contents:
PAN, LAN and WAN
Lan topologies (star and bus)
Network protocols (Ethernet, Wi-Fi, TCP, UDP, IP, HTTP, HTTPS, FTP, SMTP and IMAP)
Network security (authentication, encryption, firewall and MAC address filtering)
4-layer TCP/IP model (application layer, transport layer, internet layer and link layer)
.
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
Cyber Security
Relational databases and SQL
Ethical, Legal and Environmental Impacts
This computer systems 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.
BONUS RESOURCE: This resource also includes a PowerPoint presentation that allows pupils to easily create neat logic circuits by simply dragging the options into the desired position. Clear instructions given in the presentation on how to use it.
This 54-page workbook completely covers the new specification 8525 3.4 Computer Systems theory.
Table of Contents:
Hardware and software
Boolean logic (NOT, AND, OR and XOR)
Truth tables
Logic circuits
Boolean expressions
Software Classification (System software and application software)
Functions of the operating system
Low-level languages
High-level languages
Interpreter, compiler and assembler translators
Systems architecture
Von Neumann architecture
CPU
Fetch-Execute cycle
Memory (ROM, RAM, Cache and Registers)
Secondary memory (Solid state, optical and magnetic)
Cloud storage
Embedded systems
.
You may also be interested in these workbooks which have also been updated for the new specification:
Algorithms
Python Programming
Fundamentals of Data Representation
Fundamentals of Computer Networks
Cyber Security
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 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
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 OCR GCSE J277 computer science? Look no further than our complete set of workbooks!
Written specifically to match the requirements of the OCR 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 OCR J277 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 OCR workbooks:
Systems architecture
Memory and storage
Computer networks, connections and protocols
Network security
Systems software
Ethical, legal, cultural and environmental impacts of digital technology
Algorithms
Programming fundamentals (using Python)
Producing robust programs (using Python)
Boolean logic
Programming Languages and Integrated Development Environments (IDE)
The total individual price for all the computer science workbooks is £177.87 but when purchased as a bundle you can get all this for only £150 a saving of over £25.
How can they be used?
Our OCR J277 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 OCR JS22 GCSE in Computer Science workbooks are an excellent choice.
This “producing robust programs” 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 21-page workbook completely covers the new specification J277 2.3 producing robust programs theory.
Table of Contents:
Defensive Design Considerations
Input validation
Maintainability (sub programs, naming conventions, indentation, commenting)
The purpose of testing
Types of testing (iterative, final/terminal)
Identifying syntax and logical errors
Selecting and using suitable test data
Refining algorithms
.
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
Programming Fundamentals
Boolean Logic
Programming Languages and IDEs
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 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 lesson is perfect to for students learning how to create their own SQL databases using DB Browser and SQLite.
In this lesson the pupils create an SQL database using DB Browser (free software) which helps them understand what tables are, the importance of field names and the data types used in an SQL database. It also introduces them to the concept of primary keys.
Although pupils are not using Python at all in this lesson and are instead using DB Browser it sets them up for the next lesson in the series (available from here) which does allow them to start interrogating an SQL database using Python. Please note this lesson will NOT teach them how to interrogate an SQL database using Python and it instead teaches them how to create an external database using DB Browser.
Download this no-prep lesson now to help you take control of your workload.
This teaching resource includes an attractive dyslexia friendly PowerPoint presentation and the teachers lesson plan that includes the answers.
This ready-to-use lesson is perfect for non-specialist teachers, newly qualified teachers and teachers who are teaching Python for the first time.
Please note: In order to use this lesson you MUST download and install DB Browser on every computer prior to the lesson. You can download the latest version of DB Browser for free from https : // sqlitebrowser . org /
Duration: 1 lesson
This lesson teaches pupils about:
What is a database
Tables
Fields and records
Primary key
Setting up a database using DB Bowser
SQL data types
Adding data to a table in DB Browser
Filtering data in a table in DB Browser
.
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.
What are you waiting for? Take action straight away and grab your copy of this wonderful lesson today that will keep your pupils engaged and making progress and save you preparation time.
** [Click Here To See More Of My Great Python Lessons] (https://www.tes.com/resources/search/?authorId=835903&q=Python Lessons&shop=nwilkin)**
