A series of spreadsheets to support the teaching of Binary and Hexadecimal for GCSE Computer Science. Each takes a different aspect and allows students to automatically generate questions, these are then self marking. Macros will need enabling.

This is a CSI style Hit and Run murder to be solved using SQL. There is a database of evidence and suspects and the clues are on the worksheet. As the analyst it is the students job to prepare a report based on the evidence, therefore the clues narrow down to two possibilities after which it becomes informed conjecture … this allows discussion of using data in isolation to draw conclusions. To be fair big people with tiny feet are rare, but the police really need to visit both suspects. The hyperlinks on the worksheet did not survive export from the original Linux format, so a links file has been provided. I will attempt uploading the original database file csi.db if this fails the file named csidb.txt will need renaming to csi.db for use with sqlite. This works well at A level too, in this case the database can be interrogated from within Python using the sqlite library. NB: The numbering system does not indicate difficulty or teaching order, it simply lets me keep track of resources. Following a request a CSV version of the tables from the SQL database have been added – the .txt will need to be changed to .csv in the filename to use.