Seventeen SQL tasks covering the creation and modification of a database structure and querying or modifying data in a table. There is a separate worksheet with the tasks and model answers. This resource is the last of three resources which have been developed for the A level Computer Science course. All the three resources have been used successfully in the classroom.

Understand how selection affects the sequence of instructions. Programming is not about syntax it is about breaking problems down into simple steps that can be coded. This resource teaches the concepts and has syntax for pseudocode, Python and Visual Basic.

This presentation covers VB string,formatting and random functions. It covers most of the VB.NET 2010 which are useful for the CIE, AQA and other examination boards for A Level.

This presentation covers data security, privacy and integrity. How to protect computer systems - user accounts and firewalls. It also covers authentication methods, digital certificates and signatures, backups and disk mirroring (raid 1).

This presentation covers different addressing modes such as direct, immediate, indirect and indexed. It also covers symbolic addressing, assembly language instructions and two-pass assembler.

This resource is suitable for key stage 3 and key stage 4. It covers the different web layers and introduces HTML using Brackets a lightweight

This presentation covers parallel and serial data transmission, simplex, half-duplex and duplex transmission. It also covers error checking with parity bits using odd, even and parity blocks and checksums.

This resource covers Structured English, Pseudocode and Flowcharts. Each of the three topics is explained in detail with some worked examples to reinforce the concepts. There are additional exercises for practice and revision.

This resource covers the binary, BCD and hexadecimal number system. It also covers the conversion from one number system to another and the expression of positive or negative integers in two's complement form.

This presentation has examples of SQL statements with exercises. It explains what DDL and DML are. It also has questions on E-R diagrams and Relational databases. It is suitable for CIE, AQA and OCR examination boards.

Learn terminology associated with bitmap and vector graphics such as file header, colour depth, image resolution, drawing object and drawing list. Perform calculations to estimate file size for bitmapped images.

This resource covers flat files and relational databases. It explains access rights, advantages of relational databases and features of a relational database management systems.It also has an example of a program being used to connect to a relational database.

This resources explains what algorithms are, and explains the basics of pseudocode including variables, selection, loops, counting and totaling. It introduces the concepts of variables, selection, loops, counting and totaling with worked examples for each topic and challenge topics which combine two or more of the concepts explained. Scaffolding has been used to introduce each topic so it is not daunting for students. The resource could be used for at least 4 lessons after which your students should be very confident.

Lesson plan and presentation on how to use online technology safely and responsibly. This is a complete lesson suitable for key stage 3 computer science classes.

Learn terminology associated with bitmap and vector images such as file header, colour depth, drawing list and drawing objects and perform calculations to estimate file size for bitmapped images.

This is the first of 8 lessons introducing programming to students. Teaching programming should not be about teaching the language - its should be about the ability of students to breakdown a problem into simple instructions that they can write program code for. This unit teaches students about variables, selection If.., If...Else.., Case..., Loops (count-controlled, pre & post condition loops), arrays and subroutines. This resource covers pseudocode, Visual Basic and Python syntax.

This resource is a whole unit of work suitable for years 7. 8 or 9. It consists of 4 one hour lessons with Presentations and tasks, including worked examples. It covers python numbers, selection and iteration and includes tasks for each lesson. The activities for each lesson are scaffolded to make it easy for students to follow and understand. This resource has worked very well with our year 7 classes in our school.

This unit covers everything your students need to learn the basics of python programming. There are extension tasks for each lesson and the worked solutions for each task written in Python (zipped folder). The worked solutions from the second lesson upwards in the unit has comments explaining things like string.lower() and when it is used etc. This lesson covers selection starting from checking one condition only, then 2 conditions progressing to 5 conditions. The presentation scaffolds the topic making it easy for students to understand the concepts used.

This resource is an introductory lesson for databases. It is suitable for KS3 or even KS4 students who are being introduced to databases as it explains the concepts of fields, records and primary keys. There are three activities (including a homework activity) that students can complete to enhance their understanding of these concepts.

GCSE Binary addition. This resource teaches how to add binary numbers using two different methods. Each method is described and a demonstration of how it is used to add binary numbers follows . This is followed by exercises to reinforce the learning. I have used it with my year 9 classes and it worked very well even for less able pupils.