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 complete Python programming lesson teaches pupils how to create and amend simple one-dimensional lists in Python.
This lesson deals with one-dimensional lists only. It does not teach pupils about two-dimensional lists as that is covered in another lesson available from here.
Download this no-prep lesson now to help you take control of your workload.
This complete lesson includes an attractive dyslexia friendly PowerPoint presentation including videos to teach the key skills and the easy to follow teachers lesson plan includes all 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: This lesson does assume the pupils are confident with using basic programming constructs of sequence, selection (if statements) and iteration (while and for loops).
Duration: 1 lesson.
This lesson teaches pupils about:
Creating simple 1D lists
Displaying the list
Displaying the list with each item on a separate line
Displaying single items in a list
Adding data to the end of a list
Adding data to a specific position in the list
Altering data in a list
Removing data from a list
Finding the length of a list
.
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.
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
Take a giant step towards regaining control over your workload and teach Python programming with confidence.
These ready to use Python lessons will save you hours of planning by providing you with comprehensive, engaging content you can use in your classes with next to no preparation.
This bundle provides attractive dyslexia-friendly PowerPoint presentations, videos to teach key skills and plenty of opportunities for students to practise their Python programming skills. You will also get easy to follow teacher’s guides including ALL THE ANSWERS!
These 20 lessons are suitable for teaching pupils about the joys of Python programming, from the very basics to confidently writing and using subprograms and writing to and reading from external files.
It even includes a fun interactive computational thinking escape room game to introduce them to the problem-solving skills involved in Python programming.
It uses a proven scaffolding technique that empowers pupils to make progress and gain confidence in their programming skills.
Lessons:
Getting Started with Input and Output statements
If Statements
More Advanced If Statements
For and While Loops
Strings and Numbers
Random Values
Drawing with the Turtle
Creating Robust Programs
Good Programming Habits
Writing and Using Lists
Writing and Using 2D Lists
Using Subprograms
Recapping Programming Constructs
Recapping Subprograms
Recapping Lists and 2D lists
Recapping Good Programming Practice
Using External Text Files
Creating SQL Databases using DB Browser
Interrogating SQL database using Python
Using Structure Diagrams to Plan Larger Programs
The lessons are suitable for newly qualified teachers, non-specialist teachers and experienced computer science teachers who are looking to add a sprinkle of zesty brilliance to their lessons.
This 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)**
Are you ready for an exhilarating and festive end of term Christmas activity? Look no further than our electrifying Christmas Computing Quiz, tailor-made for your Year 10 students!
Prepare to be dazzled with a captivating fusion of computing challenges specially crafted for Year 10, seamlessly intertwined with a medley of delightful and interactive Christmas activities that will leave both your SLT and your year 10 computing pupils in high spirits as the term concludes.
Students complete a number of computing and fun festive questions and activities using a multitude of formats. Along the way they collect letters which will be used to uncover a final message that they need to answer to win the game.
HOW DOES THE CHRISTMAS COMPUTING QUIZ WORK?
Once you’ve purchased the resource you get a PDF which contains a link. Share the provided link with your students and watch as it whisks them away to an enchanting digital realm filled with engaging questions and intriguing tasks.
Your year 10 computing students can embark on this journey of knowledge and fun on their own, or, for an added dose of excitement, encourage pairs of students to team up and tackle the quiz together. The joy multiplies as collaboration ignites their enthusiasm.
And the best part? The quiz is a self-guided adventure. As your students conquer each challenge, the next one automatically beckons, providing you with invaluable time to support those in need or attend to the myriad of other holiday season tasks tugging at your attention.
Fear not, for we’ve thought of everything. All the answers are readily available in the comprehensive teacher’s guide, ensuring you can rescue any students who find themselves in a puzzling predicament.
This captivating experience is designed to last around 60 minutes but you may wish to provide an additional activity in case you have any particularly speedy early finishers.
WHAT IS INCLUDED?
You get a single PDF file which contains the link to the activity and the answers to the quiz.
Don’t miss out on this fantastic opportunity! Grab your copy of the Year 10 Christmas Computing Quiz – a timeless gem that you can deploy year after year with a new wave of Year 10 computing students. Let the festivities begin!
COMPUTING TOPICS INCLUDE:
Cyber security
3D animation
Physical computing
Binary
Python programming
Computer logic
.
Click here to check out this amazing bundle to get all 5 Key Stage 3 Computing and GCSE Computer Science quizzes at a knock down price.
IMPORTANT NOTE:
In order to run the quizzes there are a few activities which require links to external websites. Here are the external sites that you will need to have unblocked on your school network.
view . genial . ly
jigsawexplorer . com
what3words . com
Are you ready for an exhilarating and festive end of term Christmas activity? Look no further than our electrifying Christmas Computing Quiz, tailor-made for your Year 9 students!
Prepare to be dazzled with this “Who done it?” style quiz specially crafted for Year 9. Solve the mystery by answering computing questions correctly in order to interview witnesses and suspects, seamlessly intertwined with a Christmas theme that will leave both your SLT and your year 9 computing pupils in high spirits as the term concludes.
HOW DOES THE CHRISTMAS COMPUTING QUIZ WORK?
Once you’ve purchased the resource you get a PDF which contains a link. Share the provided link with your students and watch as it whisks them away to an enchanting digital realm filled with engaging questions and an intriguing mystery to solve.
Your year 9 computing students can embark on this journey of knowledge and fun on their own, or, for an added dose of excitement, encourage pairs of students to team up and tackle the quiz together. The joy multiplies as collaboration ignites their enthusiasm.
And the best part? The quiz is a self-guided adventure. As your students conquer each stage, the next one automatically beckons, providing you with invaluable time to support those in need or attend to the myriad of other holiday season tasks tugging at your attention.
Fear not, for we’ve thought of everything. All the answers are readily available in the comprehensive teacher’s guide, ensuring you can rescue any students who find themselves in a puzzling predicament.
This captivating experience is designed to last between 30 to 40 minutes so you may need to provide a second activity for particularly speedy early finishers.
WHAT IS INCLUDED?
You get a single PDF file which contains the link to the activity and the answers to the computing questions along with the solution to the mystery.
Don’t miss out on this fantastic opportunity! Grab your copy of the Year 9 Christmas Computing Quiz – a timeless gem that you can deploy year after year with a new wave of Year 9 computing students. Let the festivities begin!
COMPUTING TOPICS INCLUDE:
Computer laws
Software (spreadsheets and graphics)
Networks and the internet
Algorithms and logic
Programming
Data representation
Hardware
Computer systems
.
Click here to check out this amazing bundle to get all 5 Key Stage 3 Computing and GCSE Computer Science quizzes at a knock down price.
IMPORTANT NOTE:
In order to run the quizzes there are a few activities which require links to external websites. Here are the external sites that you will need to have unblocked on your school network.
view . genial . ly
jigsawexplorer . com
PLEASE NOTE:
This game is intended to be used on a desktop or laptop computer and some of the features will not be available on an iPad or other mobile device.
Are you ready for an exhilarating and festive end of term Christmas activity? Look no further than our electrifying Christmas Computing Quiz, tailor-made for your Year 11 computer science students!
Prepare to be dazzled with a captivating fusion of computing challenges specially crafted for Year 11, seamlessly intertwined with a medley of delightful and interactive Christmas activities that will leave both your SLT and your year 11 computer science pupils in high spirits as the term concludes.
Students complete a number of computing and fun festive questions and activities using a multitude of formats. Along the way they collect numbers which will be used unlock a door and release Santa from the Krampus’ Prison and save Christmas!
HOW DOES THE CHRISTMAS COMPUTING QUIZ WORK?
Once you’ve purchased the resource you get a PDF which contains a link. Share the provided link with your students and watch as it whisks them away to an enchanting digital realm filled with engaging questions and intriguing tasks.
Your year 11 computer science students can embark on this journey of knowledge and fun on their own, or, for an added dose of excitement, encourage pairs of students to team up and tackle the quiz together. The joy multiplies as collaboration ignites their enthusiasm.
And the best part? The quiz is a self-guided adventure. As your students conquer each challenge, the next one automatically beckons, providing you with invaluable time to support those in need or attend to the myriad of other holiday season tasks tugging at your attention.
Fear not, for we’ve thought of everything. All the answers are readily available in the comprehensive teacher’s guide, ensuring you can rescue any students who find themselves in a puzzling predicament.
This captivating experience is designed to last around 60 minutes but you may wish to provide an additional activity in case you have any particularly speedy early finishers.
WHAT IS INCLUDED?
You get a single PDF file which contains the link to the activity and the answers to the quiz.
Don’t miss out on this fantastic opportunity! Grab your copy of the Year 11 Christmas Computing Quiz – a timeless gem that you can deploy year after year with a new wave of Year 11 computer science students. Let the festivities begin!
COMPUTING TOPICS INCLUDE:
Python programming
Hardware and software
Data representation
Searching and sorting algorithms
.
Click here to check out this amazing bundle to get all 5 Key Stage 3 Computing and GCSE Computer Science quizzes at a knock down price.
IMPORTANT NOTE:
In order to run the quizzes there are a few activities which require links to external websites. Here are the external sites that you will need to have unblocked on your school network.
view . genial . ly
jigsawexplorer . com
Are you ready for an exhilarating and festive end of term Christmas activity? Look no further than our electrifying Christmas Computing Quizzes. This bundle includes 2 quizzes: one for year 10 and one for year 11 meaning you are reuse them year after year without fear that your students will have done them before.
Prepare to be dazzled with these fun digital student-led quizzes specially crafted for each year group studying GCSE Computer Science. Decode the secret Christmas message or break Santa out of prison by answering computing questions correctly with a Christmas theme that will leave both your SLT and your GCSE Computer Science pupils in high spirits as the term concludes.
HOW DO THE CHRISTMAS COMPUTING QUIZZES WORK?
Once you’ve purchased the resource you get a PDF file for each quiz which contains a link. Share the provided link with your students and watch as it whisks them away to an enchanting digital realm filled with engaging questions and a different, fun Christmas theme for each quiz.
Your students can embark on this journey of knowledge and fun on their own, or, for an added dose of excitement, encourage pairs of students to team up and tackle the quiz together. The joy multiplies as collaboration ignites their enthusiasm.
And the best part? The quiz is a self-guided adventure. As your students conquer each stage, the next one automatically beckons, providing you with invaluable time to support those in need or attend to the myriad of other holiday season tasks tugging at your attention.
Fear not, for we’ve thought of everything. All the answers are readily available in the comprehensive teacher’s guides, ensuring you can rescue any students who find themselves in a puzzling predicament.
These captivating experiences are designed to last around 60 minutes but you may need to provide a second activity for particularly speedy early finishers.
WHAT IS INCLUDED?
You get two PDF files, one for each quiz, which contains the link to the activity and includes the answers.
Don’t miss out on this fantastic opportunity! Grab your copy of this great value GCSE Computer Science Christmas Quiz bundle – a timeless gem that you can deploy year after year with each new wave of GCSE Computer Science students. Let the festivities begin!
Click here to check out this amazing bundle to get all 5 Key Stage 3 Computing and GCSE Computer Science quizzes at a knock down price.
IMPORTANT NOTE:
In order to run the quizzes there are a few activities which require links to external websites. Here are the external sites that you will need to have unblocked on your school network.
view . genial . ly
jigsawexplorer . com
what3words . com
PLEASE NOTE:
This game is intended to be used on a desktop or laptop computer and some of the features will not be available on an iPad or mobile device.
Are you ready for an exhilarating and festive end of term Christmas activity? Look no further than our electrifying Christmas Computing Quizzes. This bundle includes 5 quizzes: one for year 7, 8, 9, 10 and even year 11 meaning you are reuse them year after year without fear that your students will have done them before.
Prepare to be dazzled with these fun digital student-led quizzes specially crafted for each year group studying computing or computer science. Help Santa fix his sleigh, decorate a Christmas tree, solve a mystery, decode the secret Christmas message or break Santa out of prison by answering computing and Christmas related questions correctly that will leave both your SLT and your Computing and Computer Science pupils in high spirits as the term concludes.
HOW DO THE CHRISTMAS COMPUTING QUIZZES WORK?
Once you’ve purchased the resource you get a PDF file for each quiz which contains a link. Share the provided link with your students and watch as it whisks them away to an enchanting digital realm filled with engaging questions and a different, fun Christmas theme for each quiz.
Your students can embark on this journey of knowledge and fun on their own, or, for an added dose of excitement, encourage pairs of students to team up and tackle the quiz together. The joy multiplies as collaboration ignites their enthusiasm.
And the best part? The quiz is a self-guided adventure. As your students conquer each stage, the next one automatically beckons, providing you with invaluable time to support those in need or attend to the myriad of other holiday season tasks tugging at your attention.
Fear not, for we’ve thought of everything. All the answers are readily available in the comprehensive teacher’s guides, ensuring you can rescue any students who find themselves in a puzzling predicament.
These captivating experiences are designed to last most of the lesson but you may need to provide a second activity for early finishers.
WHAT IS INCLUDED?
You get five PDF files, one for each quiz, which contains the link to the activity and includes the answers.
Don’t miss out on this fantastic opportunity! Grab your copy of this great value KS3 Computing and GCSE Computer Science Christmas Quiz bundle – a timeless gem that you can deploy year after year with each new wave of students. Let the festivities begin!
IMPORTANT NOTE:
In order to run the quizzes there are a few activities which require links to external websites. Here are the external sites that you will need to have unblocked on your school network.
view . genial . ly
jigsawexplorer . com
what3words . com
PLEASE NOTE:
This game is intended to be used on a desktop or laptop computer and some of the features will not be available on an iPad or mobile device.
Are you ready for an exhilarating and festive end of term Christmas activity? Look no further than our electrifying Christmas Computing Quizzes. This bundle includes 3 quizzes: one for year 7, one for year 8 and another for year 9 meaning you are reuse them year after year without fear that your students will have done them before.
Prepare to be dazzled with these fun digital student-led quizzes specially crafted for each year group in key stage 3. Help Santa fix his sleigh, decorate a Christmas tree or solve the mystery by answering computing questions correctly with a Christmas theme that will leave both your SLT and your key stage 3 computing pupils in high spirits as the term concludes.
HOW DO THE CHRISTMAS COMPUTING QUIZZES WORK?
Once you’ve purchased the resource you get a PDF file for each quiz which contains a link. Share the provided link with your students and watch as it whisks them away to an enchanting digital realm filled with engaging questions and a different, fun Christmas theme for each quiz.
Your students can embark on this journey of knowledge and fun on their own, or, for an added dose of excitement, encourage pairs of students to team up and tackle the quiz together. The joy multiplies as collaboration ignites their enthusiasm.
And the best part? The quiz is a self-guided adventure. As your students conquer each stage, the next one automatically beckons, providing you with invaluable time to support those in need or attend to the myriad of other holiday season tasks tugging at your attention.
Fear not, for we’ve thought of everything. All the answers are readily available in the comprehensive teacher’s guides, ensuring you can rescue any students who find themselves in a puzzling predicament.
These captivating experiences are designed to last between 30 to 40 minutes so you may need to provide a second activity for particularly speedy early finishers.
WHAT IS INCLUDED?
You get three PDF files, one for each quiz, which contains the link to the activity and includes the answers.
Don’t miss out on this fantastic opportunity! Grab your copy of this great value Key Stage 3 Christmas Quiz bundle – a timeless gem that you can deploy year after year with each new wave of Key Stage 3 computing students. Let the festivities begin!
Click here to check out this amazing bundle to get all 5 Key Stage 3 Computing and GCSE Computer Science quizzes at a knock down price.
IMPORTANT NOTE:
In order to run the quizzes there are a few activities which require links to external websites. Here are the external sites that you will need to have unblocked on your school network.
view . genial . ly
jigsawexplorer . com
PLEASE NOTE:
This game is intended to be used on a desktop or laptop computer and some of the features will not be available on an iPad or other mobile device.
Are you ready for an exhilarating and festive end of term Christmas activity? Look no further than our electrifying Christmas Computing Quiz, tailor-made for your Year 8 students!
Prepare to be dazzled with a captivating fusion of computing challenges specially crafted for Year 8, seamlessly intertwined with a medley of delightful and interactive Christmas activities that will leave both your SLT and your year 8 computing pupils in high spirits as the term concludes.
HOW DOES THE CHRISTMAS COMPUTING QUIZ WORK?
Once you’ve purchased the resource you get a PDF which contains a link. Share the provided link with your students and watch as it whisks them away to an enchanting digital realm filled with engaging questions and intriguing tasks.
Your year 8 computing students can embark on this journey of knowledge and fun on their own, or, for an added dose of excitement, encourage pairs of students to team up and tackle the quiz together. The joy multiplies as collaboration ignites their enthusiasm.
And the best part? The quiz is a self-guided adventure. As your students conquer each challenge, the next one automatically beckons, providing you with invaluable time to support those in need or attend to the myriad of other holiday season tasks tugging at your attention.
Fear not, for we’ve thought of everything. All the answers are readily available in the comprehensive teacher’s guide, ensuring you can rescue any students who find themselves in a puzzling predicament.
This captivating experience is designed to last between 30 to 40 minutes so you may need to provide a second activity for particularly speedy early finishers.
WHAT IS INCLUDED?
You get a single PDF file which contains the link to the activity and the answers to the quiz.
Don’t miss out on this fantastic opportunity! Grab your copy of the Year 8 Christmas Computing Quiz – a timeless gem that you can deploy year after year with a new wave of Year 8 computing students. Let the festivities begin!
COMPUTING TOPICS INCLUDE:
Computer networks
Scratch programming
Computer jargon (missing words)
Computer systems
.
Click here to check out this amazing bundle to get all 5 Key Stage 3 Computing and GCSE Computer Science quizzes at a knock down price.
IMPORTANT NOTE:
In order to run the quizzes there are a few activities which require links to external websites. Here are the external sites that you will need to have unblocked on your school network.
view . genial . ly
jigsawexplorer . com
PLEASE NOTE:
This game is intended to be used on a desktop or laptop computer and some of the features will not be available on an iPad or other mobile device.
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 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