Data storage and transmission
This topic covers examines how data is stored in large quantities, and how it is compressed for storage and transmission. It considers the physical media used to store local and distributed databases; how these databases can be interacted with, and how data is reliably transferred across networks using encoding and error checking.
Compression and encryption theory
This resource consists of two documents. One is a theory sheet and the other a structured workbook for students to complete. This would form a useful independent learning resource so could be issued as a homework task.
Database Management Systems (DBMS) and distributed databases
Two topics that support the database topic are covered in this presentation. The emphasis at A level is investigating the technical architecture rather than application. These are two important topics often tricky to find resources for.
Relational databases
It is often very helpful to reiterate vocabulary and definitions associated with database technology. This resource can be used as a starter or a plenary activity to reinforce key terminology.
Compression, encryption and hashing delivery guide
This document provides teacher topic guidance with useful links plus two activities. The first is a compression research activity about video and audio codecs.
Python and SQL
Databases are a fundamental part of modern organisations. This resource consists of an activity sheet, answer sheet and a highly usable utility for using SQLite with Python. The activities enable students to produce implement what they have learned from the theoretical content.
Units of data storage calculator
Students can find it difficult to remember the relationship between the units of data storage. This useful online calculator not only gives units as powers of ten (Kilobyte, Megabyte, Gigabyte etc.) but also powers of two (kibibyte, mebibyte, gibibyte) which is required for the AQA specification.
SQLZoo online tutorial
This is a great resource for self-paced learning for students where they can learn SQL and practise coding via interactive resources. A key advantage of using an online interpreter is that it negates the need for additional software or elevated permissions.
Data storage technologies
This is a comprehensive presentation covering a wide range of data storage topics. The level is appropriate for A level so could be used to develop a comprehension activity to cover the theory content.
Huffman coding
Compression algorithms are very interesting and this presentation explores the topic in a very accessible way. This presentation could form the basis of a practical activity or could be used to enable students to tackle examination questions or prepare their own revision resource.
Huffman coding activity
This activity could be given to students after reviewing the Huffman coding powerpoint. The theme is word analysis and slows students to practically implement the Huffman algorithm.
Hamming codes
Students will have encountered simple error correction such as parity bits but this interesting activity from Stanford University will allow them to investigate the Hamming code method to provide additional stretch and challenge.