Teach Computing

Revision notes, activities, lesson plans, teaching ideas, and other resources for GCSE, A-Level, and IB Computer Science teachers and students.

What's New

Boolean logic worksheet pack

These three Boolean logic worksheets have exam style questions on logic sta...

Edexcel Computer Science (9-1)

by Ann Weidmann et al Amazon.com | Amazon.co.uk | Book Depository This bo...

Dijkstra's algorithm video

This video is probably the best explanation of Dijkstra's algorithm for IB ...

Input-Process-Output (IPO) Model

The Input-Process-Output model is a simple topic but some students sometime...

Hexadecimal

A comprehensive review of hexadecimal. The video covers not only how to u...

Subprograms, Local Variables & Structured Programming

Subprograms are known by several different names - methods, functions, proc...

Utility Software and Models

Some students find the difference between operating system software and ut...

Data Structures

This video explains different types of data structures - 1 dimensional ar...

Operating System (OS) - GCSE Computer Science

A detailed overview of operating systems, starting with the general tasks t...

2.1.5 Databases

Click here for recommended OCR GCSE Computer Science textbooks.

The Database Concept

Databases revision

Databases

A good overview of database theory, which is sufficient to cover the syllabus for most GCSE courses, and is a good introduction to the topic for A Level and IB courses. The differences between structured and unstructured data are covered, along with database basics (fields, records, tables). The second half of the video explains relationships in more detail, including 1-to-1 and 1-to-many relationships.


Updated: 2018-02-17