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 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 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 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 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 cyber security workbook is perfect for students studying for the AQA GCSE (9-1) in computer science and has been updated to completely cover the new specification 8525.
It can be used in the classroom as a teaching aid, for self-study or as a revision tool. In this resource you will receive an interactive PDF workbook so your students can either print it out and complete the activities by hand or fill it in electronically making this an ideal workbook for use in school or for students studying at home.
The answer booklet is provided as a separate PDF file so you can assign your students the workbook without including the answers.
This 32-page workbook completely covers the new specification 8525 3.6 Cyber Security theory.
Table of Contents:
The purposes of cyber security
Social Engineering techniques (blagging, phishing, pharming and shouldering)
Malicious code / malware (computer virus, trojan and spyware)
Penetration testing
Security measures (biometric measures, password systems, CAPTCHA, using email confirmations and automatic software updates)
.
FREE BONUS PRODUCT INCLUDED
As a special thank you for purchasing this product I am pleased to be able to also include a surprise FREE bonus gift. This gift is one of our complete resources which we will usually charge full price for but is yours absolutely free when you purchase this product. Just our little way of saying thank you to our valued customers. I hope you enjoy it and get use out of it, with my compliments.
You may also be interested in these workbooks which have also been updated for the new specification:
Algorithms
Python Programming
Fundamentals of Data Representation
Computer Systems
Fundamentals of Computer Networks
Relational databases and SQL
Ethical, Legal and Environmental Impacts
This data representation workbook is perfect for students studying for the AQA GCSE (9-1) in computer science and has been updated to completely cover the new specification 8525.
It can be used in the classroom as a teaching aid, for self-study or as a revision tool. In this resource you will receive an interactive PDF workbook so your students can either print it out and complete the activities by hand or fill it in electronically making this an ideal workbook for use in school or for students studying at home.
The answer booklet is provided as a separate PDF file so you can assign your students the workbook without including the answers.
This 66-page workbook completely covers the new specification 8525 3.3 Fundamentals of Data Representation theory.
Table of Contents:
Number bases (decimal, binary and hexadecimal)
Converting between number bases
Units of information
Adding together binary numbers
Binary shift
Character encoding
Representing bitmap images
Colour depth and image size
Representing sound
Sampling rate and sample resolution
Calculate file sizes
Data compression
Huffman code
Run length encoding (RLE)
.
FREE BONUS PRODUCT INCLUDED
As a special thank you for purchasing this product I am pleased to be able to also include a surprise FREE bonus gift. This gift is one of our complete resources which we will usually charge full price for but is yours absolutely free when you purchase this product. Just our little way of saying thank you to our valued customers. I hope you enjoy it and get use out of it, with my compliments.
You may also be interested in these workbooks which have also been updated for the new specification:
Algorithms
Python Programming
Computer Systems
Fundamentals of Computer Networks
Cyber Security
Relational databases and SQL
Ethical, Legal and Environmental Impacts
This “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 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
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