Database of Criminals

This self-guided series of lessons is based around a database of school criminality - missing homework, incorrect uniform, lateness and foul language. A shocking collection of crimes against school rules awaits investigation.

Pupils manage their own learning with step-by-step tasks where they learn the language of databases, how to edit data, validate information and run queries.

The lessons become increasingly sophisticated, culminating in the pupils using filters to sift through information and finally to them creating their own database of criminality, learning how to control lists, parameters and devise their own queries for their friends to try out.

This fun, irreverent sequence of lessons is a contained in a fully locked-down Excel document - so you can’t break it by accident! At the end of the course, pupils are awarded a certificate as proof of their new detective status.