Hero image

Nichola Wilkin - Computer Science

Average Rating4.66
(based on 1179 reviews)

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!

216Uploads

908k+Views

1954k+Downloads

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!
Systems Software OCR GCSE Computer Science Workbook (J277)
nwilkinnwilkin

Systems Software OCR GCSE Computer Science Workbook (J277)

(0)
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
Sorting and Searching Algorithms Lessons
nwilkinnwilkin

Sorting and Searching Algorithms Lessons

(0)
A great introduction to understanding sorting and searching algorithms including bubble sort, insertion sort, merge sort, linear search and binary search. These ready to use sorting and searching algorithms lessons will save you hours of preparation and can easily be adapted to meet your own requirements. WHAT IS INCLUDED? In this unit you have 3 ready-to-use lessons: Bubble sort Insertion and merge sort Linear and binary search . These lessons include everything you need such as: a very high-quality accessible PowerPoint presentation for every lesson that effortlessly leads the teacher through the lesson and includes all the answers to the many questions and tasks the students need to complete an editable worksheet for every lesson an easy-to-follow editable lesson plan for every lesson . Not only have you got the complete lessons above but if you wanted to extend the unit I have made it extra easy by also including the Python programs (both with and without comments) for each of these algorithms. I have even created handouts for each algorithm written in pseudocode code using the specifics of OCR, AQA and Edexcel. You could use these Python programs to show the code to the pupils and ask them how it works and talk through the code with them comparing it to the algorithm, you could challenge them to add comments themselves to explain the code or use it to demo a working program. If you feel your pupils are able, you could set them the challenge of programming it themselves and use the completed programs as exemplar material to aid pupils who get stuck or even remove some of the code and ask them to complete key areas to make it work. PRIOR LEARNING This unit does expect pupils know what an algorithm is and be familiar with understanding written algorithms and flowcharts. EASY TO USE These ready to use resources are so straightforward that although I have included a lesson plan, most teachers can teach straight from the PowerPoint presentation without any further assistance. And best of all, the answers are included saving you time and energy. This makes these lessons suitable for experienced computing specialist teachers along with non-specialists and early career teachers. EDITABLE RESOURCES I understand that teachers want to adapt their resources, so I’ve made the bold decision to make these resources editable. Therefore, if you need to use a particular template style for your school or pupils with special educational needs, you can change the PowerPoint presentations, worksheets and lesson plans to suit your needs. These lessons are highly interactive and engage students straight from the start. Start reaping the benefits today of incredibly high-quality, professionally designed teaching resources that you can use with virtually no preparation. Just click on the BUY NOW button to download them straight away. You’ll wonder how you ever managed without them.
Christmas Computing Quiz Bundle
nwilkinnwilkin

Christmas Computing Quiz Bundle

5 Resources
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.
Scratch Flash Card Bundle
nwilkinnwilkin

Scratch Flash Card Bundle

4 Resources
Are you looking for a set of fun, hands-on activities which will reinforce how to use key programming skills in Scratch? These flash card coding challenges are easy to use and will keep your students engaged whist embedding how to use the Scratch coding blocks. Your students will be having so much fun they won’t even realise they’re learning! Each pack includes 20 different Scratch coding flash cards WITH THE ANSWERS. You have the option of printing in colour but we also include a black and white version to save you ink. Grab your copy now and either use them straight away or keep them as a handy addition to your teacher’s tool kit. HOW CAN I USE THESE FLASH CARDS IN MY CLASSROOM? Your students pick a card and create the programming challenge described on the front of the flash card. Once they have created their Scratch program, students test their completed program and turn over to see the suggested Scratch code answer on the reverse of the card. If they get stuck, they can always turn the card over to see the suggested solution they can copy. When they have their program working correctly, students swap their flash card for another and repeat the process. Students can work individually or in pairs for this activity and love the competitive nature of using these flash cards as they see how many they can complete. These flash cards are great when used as: a starter, a plenary, for early-finishers or as an easy, highly engaging in-class activity. . HOW DO I PREPARE THE CARDS? These flash cards are so easy to prepare. Simply print, glue the back and fold in half along the vertical guideline, before cutting to size. If you want to reuse them time and time again, it may be worth laminating your flash cards. Each set has 20 individual programming challenges so you may need to prepare more than one set for larger classes. These are an excellent addition to your computing teacher’s toolkit and you’ll wonder how you ever managed without them. Get your copy of these user-friendly, highly engaging Scratch flash cards before you forget. Go on, click on the “Buy Now” button straight away. If you don’t, you’ll regret it later. Click here to take a peek at my Computational Thinking Escape Room - a finalist in the Teach Secondary Awards.
Binary Calculations
nwilkinnwilkin

Binary Calculations

(0)
A great introduction to understanding binary addition, two’s complement, binary subtraction, binary shifts and binary multiplication. WHAT IS INCLUDED? In this unit you have 5 ready-to-use lessons: binary addition negative binary numbers using two’s complement binary subtraction using two’s complement binary shift and binary multiplication recapping lesson to consolidate consolidating the unit and embed the skills . Everything you need is included such as: a very high-quality accessible PowerPoint presentation for every lesson that effortlessly leads the teacher through the lesson and includes all the answers to the many questions and tasks the students need to complete a 2 or 3-sided editable worksheet for every lesson an easy-to-follow editable lesson plan for every lesson . PRIOR LEARNING This unit does expect pupils to know how to translate denary numbers into binary and binary numbers into denary. . If your students are unfamiliar with these concepts, I highly recommend purchasing my 2 lesson unit called “Understanding Binary” (https://www.tes.com/teaching-resource/resource-13042315) which covers all of these topics and will ensure your students are ready for this unit. WHO IS THIS FOR? This aligns with the iGCSE in computer science (0478) but is also useful for OCR J277, AQA 8525 and Pearson Edexcel computer science qualifications. EASY TO USE These ready to use resources are so straightforward that although I have included a lesson plan, most teachers can teach straight from the PowerPoint presentation without any further assistance. And best of all, the answers are included saving you time and energy. This makes these lessons suitable for experienced computing specialist teachers along with non-specialists and early career teachers (ECTs). EDITABLE RESOURCES I understand that teachers want to adapt their resources, so I’ve made the bold decision to make these resources editable. Therefore, if you need to use a particular template style for your school, you can change the PowerPoint presentation, worksheet and lesson plan to suit your needs. If you have students with specific educational needs, you can change the lesson to suit them. It gives you the flexibility to alter the lessons to suit your own particular needs. SCIENTIFICALLY PROVEN TEACHING TECHNIQUES These teaching resources have been specifically designed to aid pupils using educational psychology backed theories to ensure your students will have a higher retention rate and a deeper understanding of the subject. TEACHING TO THE TOP These lessons are designed to stretch all pupils. Instead of traditional differentiation which systematically underchallenges pupils, I raise the bar for everyone and then, as a teacher who knows your own students best, you can support individuals to reach their own full potential. Just click on the BUY NOW button to download them straight away. You’ll wonder how you ever managed without them.
Network Security OCR GCSE Computer Science Workbook (J277)
nwilkinnwilkin

Network Security OCR GCSE Computer Science Workbook (J277)

(0)
This network security 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.4 network security theory. Table of Contents: What is network security? Forms of attack Threats posed to networks Hackers and crackers Malware Social engineering Brute Force Attacks Denial of Service Attacks Data Interception Data theft SQL injection Poor network policy Identifying and preventing vulnerabilities Penetration testing Network forensics Network policies Anti-malware software Firewalls User access levels Passwords Encryption Physical security . 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 Systems Software Ethical, Legal, Cultural and Environmental Impacts Algorithms Programming Fundamentals Producing Robust Programs Boolean Logic Programming Languages and IDEs
Systems Architecture OCR GCSE Computer Science Workbook (J277)
nwilkinnwilkin

Systems Architecture OCR GCSE Computer Science Workbook (J277)

(0)
This systems architecture workbook is perfect for students studying for the OCR GCSE (9-1) in Computer Science and has been updated to completely cover the new specification J277. It can be used in the classroom as a teaching aid, for self-study or as a revision tool. In this resource you will receive an interactive PDF workbook so your students can either print it out and complete the activities by hand or fill it in electronically, making this an ideal workbook for use in school or for students studying at home. The answer booklet is provided as a separate PDF file so you can assign your students the workbook without including the answers. This 24 page workbook completely covers the new specification J277 1.1 systems architecture theory. Table of Contents: Systems Architecture Hardware Software The purpose of the CPU Von Neumann Architecture Memory Address Register (MAR) Memory Data Register (MDR) Program Counter (PC) Accumulator (AC) Common CPU Components Arithmetic / Logic unit (ALU) Control unit (CU) Cache Busses The Fetch-Execute cycle How common characteristics of CPUs affect their performance Clock speed Cache size Number of cores Purpose of embedded systems Examples of embedded systems . You may also be interested in these workbooks which have also been written to cover the J277 specification: Memory and Storage Computer networks, connections and protocols Network Security Systems Software Ethical, Legal, Cultural and Environmental Impacts Algorithms Programming Fundamentals Producing Robust Programs Boolean Logic Programming Languages and IDEs
Build Your Own Paper Computer
nwilkinnwilkin

Build Your Own Paper Computer

(1)
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.
Scratch Introduction Lesson Unit
nwilkinnwilkin

Scratch Introduction Lesson Unit

(1)
In this high-quality 6-lesson complete scheme of work, pupils will be introduced to the programming language “Scratch 2”. Moving sprites using the mouse and keyboard as well as moving automatically around the screen Repeat and forever loops If statements and If…else statements Use sensing tools so sprites can interact with each other Use questions and answers in programs Create and use variables to store and manipulate values during the running of programs Create their own sprites and backgrounds Use costumes Apply broadcast messages This unit is ideal if the pupils have never used Scratch before or have had only very limited experience. Suitable for KS3 Computing and ICT classes. FREE BONUS PRODUCT INCLUDED As a special thank you for purchasing this product I am pleased to be able to also include a surprise FREE bonus gift. This gift is one of my complete resources for which I usually charge full price but is yours absolutely free when you purchase this product. Just my little way of saying thank you to my valued customers. I hope you enjoy it and get use out of it, with my compliments.
Computer Systems AQA GCSE Computer Science Workbook (8525)
nwilkinnwilkin

Computer Systems AQA GCSE Computer Science Workbook (8525)

(0)
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
Computer Networks Lesson Bundle
nwilkinnwilkin

Computer Networks Lesson Bundle

6 Resources
This bundle of 6 lessons covers: Types of Networks Network Hardware What is the internet? Network Topologies Wireless Networks Network Protocols and the TCP/IP 4-Layer Model These lessons are suitable for teaching the new updated syllabus starting September 2020 including the OCR GCSE Computer Science (J277) and AQA GCSE Computer Science (8520). Each lesson includes an attractive dyslexia friendly PowerPoint presentation with differentiated lesson objectives, at lease one video and lots of tasks and questions. Each lesson also 3 differentiated exam style questions along with a comprehensive teacher’s lesson plan including all the answers.
Computer Room Display BUNDLE
nwilkinnwilkin

Computer Room Display BUNDLE

6 Resources
Here are all the packs needed to create 5 attractive displays in your computer room to instant impact and interest for your students. Buy this bundle of 6 display packs now and instantly brighten your computer room and get a free BONUS pack of word wall posters too. HOW CAN YOU USE THESE DISPLAY? This display works well when positioned: on a display board in your computer room in the corridor leading to the classroom or arranged in any other available space on your walls . PREPARING THE DISPLAYS There are 6 complete displays included in this bundle: Word wall of technical terms Computer Science room lettering Computer room rules posters Who’s who is computing timeline Rubber duck debugging What does your digital footprint say about you? . You have colour and black and white versions. Print only the relevant pages you need for your computer room display. Some pages may require more than one copy. It is best to print the pages in colour, if you can, but I have included black and white versions too to help you save on printing costs. If you are printing in black and white you may wish to print them onto coloured paper to add a bit of interest in your classroom. I suggest printing the pages on card or laminating each page before cutting out the sections to give a more professional finish. Carefully cut out the sections and add them to your display space (making sure the letters are the right way up and in the correct order). I’ve include suggested layouts to give you an idea of how you can display these sections in your computer room however you may want to display it slightly differently to fit the space you have. What are you waiting for? Buy these ready to use computer room display packs now and get your FREE bonus pack of word wall posters too. They are sure to brighten your classroom.
The CPU Lesson and Printable Bundle
nwilkinnwilkin

The CPU Lesson and Printable Bundle

7 Resources
A collection of full lessons, workbooks, handouts and knowledge organisers to teach GCSE Computer Science pupils about the CPU. These lessons are suitable for teaching the new updated syllabus starting September 2020 including the OCR GCSE Computer Science (J277) and AQA GCSE Computer Science (8520). Can be used in class, homework tasks and as revision. The bundle saves you 30% on the usual individual price.
Algorithms Bundle
nwilkinnwilkin

Algorithms Bundle

3 Resources
A great introduction to understanding computational thinking, algorithms and sorting and searching algorithms. Pupils learn about, decomposition, pattern recognition, writing algorithms, flowcharts, bubble sort, insertion sort, merge sort, linear search and binary search algorithms. These ready to use lessons will save you hours of preparation and can easily be adapted to meet your own requirements. WHAT IS INCLUDED? In this unit you have 9 ready-to-use lessons: 3 lessons on computational thinking (decomposition, pattern recognition and abstraction) 3 lessons on understanding algorithms (creating an algorithm, flowcharts, selection and iteration) 3 lessons on sorting and searching algorithms (bubble sort, insertion sort, merge sort, linear search and binary search) . These lessons include everything you need such as: a very high-quality accessible PowerPoint presentation for every lesson that effortlessly leads the teacher through the lesson and includes all the answers to the many questions and tasks the students need to complete an editable worksheet for every lesson an easy-to-follow editable lesson plan for every lesson . Not only have you got the complete lessons above but if you wanted to extend the searching and sorting algorithms unit I have made it extra easy by also including the Python programs (both with and without comments) for each of the searching and sorting algorithms along with the pseudocode covering the AQA, OCR and Edexcel syntax. PRIOR LEARNING Pupils do not need any prior learning for the first of these units “Computational thinking”. After the computational thinking unit pupils can progress immediately to “Understanding Algorithms” unit or you may want to split it up and use these units in separate year groups. Older pupils who are more familiar with Python will enjoy the “Sorting and Searching Algorithms” unit. EASY TO USE These ready to use resources are so straightforward that although I have included a lesson plan, most teachers can teach straight from the PowerPoint presentation without any further assistance. And best of all, the answers are included saving you time and energy. This makes these lessons suitable for experienced computing specialist teachers along with non-specialists and early career teachers. EDITABLE RESOURCES I understand that teachers want to adapt their resources, so I’ve made the bold decision to make these resources editable. Therefore, if you need to use a particular template style for your school or pupils with special educational needs, you can change the PowerPoint presentation, worksheet and lesson plan to suit your needs. These lessons are highly interactive and engage students straight from the start. Start reaping the benefits today of incredibly high-quality, professionally designed teaching resources that you can use with virtually no preparation. Just click on the BUY NOW button to download them straight away. You’ll wonder how you ever managed without them.
Computer Science Worksheets and Activites
nwilkinnwilkin

Computer Science Worksheets and Activites

5 Resources
Ready-to-use worksheets and activties you can immediately use in your classroom to help you teach the following topics: Inside a computer Binary, denary and Hex conversion Logic Gates and Truth Tables Suitable for GCSE Computer Science classes and KS3 Computing classes. All packs include an answer booklet making your life even easier. Saves you hours of work.
Intermediate Python With JUMP123
nwilkinnwilkin

Intermediate Python With JUMP123

(0)
This dynamic intermediate Python unit builds on foundational skills, empowering students to become more confident, capable programmers with enhanced problem-solving abilities. Through 8 fully editable lessons, the JUMP123 methodology ensures interactive and effective learning, using proven educational psychology to reduce cognitive load and accelerate mastery of Python. Designed for students who have completed the introductory Python course, this unit introduces new concepts while reinforcing previous knowledge, shifting the focus to tackling more complex challenges and deepening their programming experience. WHY CHOOSE JUMP123? Editable Resources: Each lesson comes with a fully customisable PowerPoint and lesson plan, so you can adapt them to your school’s requirements and your own teaching style. Teacher-Friendly: With built-in answers, these lessons support early-career teachers, non-specialists, and experienced educators, saving you time while ensuring that your students progress. Student-Focused: Lessons are interactive, with activities like paired programming, paired discussions, questions and hands-on exercises to keep students actively engaged. . SKILLS YOUR STUDENTS WILL LEARN By the end of the unit, students will confidently use: Lists (including using them with a loop and using append and pop) Trace tables Libraries Using functions and procedures including passing parameters and using tuples to return values . This unit places a stronger emphasis on problem-solving, incorporating more paired programming and discussions compared to the introductory Python course. It encourages students to develop real-world programming skills, such as finding solutions through repositories and adapting them to their own code. While the basics are revisited, it is highly recommended that students complete the Introduction to Python unit beforehand to fully benefit from these lessons. WHO IS THIS FOR? These lessons are perfect for: KS3 classes learning Python who already have confidence in using the basics GCSE students who are missing the above-mentioned programming skills . FLEXIBLE FOR ANY PROGRAMMING PLATFORM No matter which Python platform your school uses, this unit works seamlessly. All code can be copied into any environment for live coding demonstrations, so you can focus on teaching. EASY PROGRESS TRACKING The lessons follow the JUMP123 assessment methodology, making it simple to monitor and evaluate pupil progress. This ensures that all students are advancing their programming skills. WANT A SNEAK PEEK? Visit the JUMP123 programming website to download free sample lessons from our introduction unit and discover how this dynamic approach can revolutionise your Python teaching.
Relational databases and SQL AQA GCSE Computer Science Workbook (8525)
nwilkinnwilkin

Relational databases and SQL AQA GCSE Computer Science Workbook (8525)

(0)
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
Ethical, Legal, Cultural And Environmental Impacts OCR GCSE Computer Science Workbook (J277)
nwilkinnwilkin

Ethical, Legal, Cultural And Environmental Impacts OCR GCSE Computer Science Workbook (J277)

(0)
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
Fundamentals of Data Representation AQA GCSE Computer Science Workbook (8525)
nwilkinnwilkin

Fundamentals of Data Representation AQA GCSE Computer Science Workbook (8525)

(0)
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