All papers in a series of 20 mark tests covering Unit 3.7: Relational Databases and SQL of the AQA syllabus for Computer Science 8525 (2020) Written in the style of a GCSE exam, with accompanying marks scheme. Suitable test time: 30 minutes each Only need one paper? First paper can be found here: https://www.tes.com/teaching-resource/-12654092 Second paper can be found here: https://www.tes.com/teaching-resource/-12749922

First paper in a series of 20 mark tests covering Unit 3.7: Relational Databases and SQL of the AQA syllabus for Computer Science 8525 (2020) Written in the style of a GCSE exam, with accompanying marks scheme. Suitable test time: 30 minutes Second paper can be found here: https://www.tes.com/teaching-resource/-12749922 Save and buy the whole series (more being added in future): https://www.tes.com/teaching-resource/-12749923

This is a lesson which can be used by a teacher or as a cover lesson and can be extended out to two if you work it that way! it can even be used for remote learning. This a computer based lesson and requires the Internet to research components. I use this with my Year 10 class as they begin to learn about the hardware components of a computer for their GCSE but it could equally be used for any class from Year 9 to 13. The kids generally love this lesson and have great fun bragging about their creations!

Learn the secrets of flowcharts and pseudo-code for GCSE Computer Science. This booklet format guide takes pupils, step-by-step through simple flowchart constructs and their equivalent pseudo-code, using VB.Net code as support. This guide looks at “Assignment, Outputs, Concatenation and Selection”. Answers for all the exercises are included at the back. This is ideal as way of introducing classes to the concepts before making full-size flowcharts, or writing pseudo-code. This was written originally for my year 10 class but i have used it with year 9 classes. Uses it in lessons for starters or give it the pupils to use as an independent guide. A second booklet for iteration and nested iteration will be produced soon. (New version updated 19th Nov for typos)

Second paper in a series of 20 mark tests covering Unit 3.7: Relational Databases and SQL of the AQA syllabus for Computer Science 8525 (2020) Written in the style of a GCSE exam, with accompanying marks scheme. Suitable test time: 30 minutes First paper can be found here: https://www.tes.com/teaching-resource/-12654092 Save and buy the whole series (more being added in future): https://www.tes.com/teaching-resource/-12749923

A short exercise where pupils are given a boolean expression and are expected to draw the boolean logic circuit diagram for it. The first 9 use the format A.B The last 3 use the format A AND B Handrwitten answer sheet also included. Suitable for a starter after teaching the topic, as a revision resource or as a 15 minute plenary. (maybe longer, depending on the ability of your class)

These worksheets were written for, and used in my Year 10 GCSE class to practice Huffman Coding. There are 4 worksheets, some being hand-written. Creating Huffman trees from frequency tables (starting at 2 items in the table and increasing in difficulty) Creating tables of Huffman codes from trees Calculating the differences in bits between using ASCII and Huffman coding Extension task (which goes beyond the remit of GCSE) These were designed specifically for the AQA Computing GCSE, but can be used for any level or board that teaches data compression.

4 lessons that use a simple VB.Net programming task to explore how bitmap images are encoded. These lessons can be used as a set of cover lessons for a more able class who are able to debug and manage their own code , or as a set of guided lessons for other groups. I have succesfully used these lessons with most of Year 9 groups and my Year 10 GCSE class. They were extremely excited in the last lesson to be able to read each others’ bitmap files. Lesson 1: Shows how a bitmap is encoded using a spreadsheet to do it (A paper version is also included). The pupils will end up with a text file full of binary to represent a bitmap Lesson 2: Has the pupils read data from the file in their VB.Net program and iterate through each line Lesson 3: The pupils will use nested iteration to be able to access each separate bit Lesson 4: The pupils will use procedures and selection to use the bits and “draw pixels” on a console screen Also included with this pack of lessons: Bonus extension tasks - increasing colour-depth or changing the image resolution Final project source code Spreadsheet model to refer to Paper version of spreadsheet task Basic spreadsheet guide in lesson 1 to be able to complete the lesson I will update these lessons with C# and Python code listings at a later date. If you find these lessons useful please leave a review. If you have any feedback on how to improve the lessons, please let me know; I appreciate the thought.

Learn what an algorithm is and how to construct a simple flowchart **Target Pupils ** Year 7 (though will work with KS2/3 pupils depending on literacy skills) Typical Use This set of five lessons can be used as way of supporting learning in the classroom, as a standalone set of cover lessons or as a package for remote learning. Learning objectives “Design, use and evaluate computational abstractions that model the state and behaviour of real-world problems and physical systems” (Computing programmes of study: key stages 3 and 4, Department of Education) Understand what an algorithm is Be able to order instructions to complete a task successfully Be able to generate a sequence of instructions Understand how to use a flow chart Know the basic symbols for a flowchart Be able to construct a flowchart

This homework is intended for use with Computing or ICT A-Level students. Pupils create a webpage for a geeky crafters guild. They have a choice of jobs to complete depending on their time and ability. They earn experience points (XP) for each task and accumulate these points to earn a rank. They are then awarded a certificate with their rank on. (The certificate will be added soon). The Grandmaster award is reserved for the best website and is entirely subjective....this means it doesn't necessarily have to go to the best programmer, but the hardest worker.

This is a homework I designed that encourages Computing pupils. It sets them the task of developing an application that converts binary values to denary. There are different levels they can programme to and are encourage to go further to gain better titles. Afterwards they receive certificates with their titles on. The medals on the certificate can be removed/added as required. This worked very well with my most recent group.