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.

This is a Christmas activity in which students are asked to generate the verses of the “Twelve Days of Christmas” (Partridge in a pear tree) Carol. The relevant data is given as lists, so they must NOT actually write any of the words. There is a link in the Power Point to a Trinket with the code, have them remix. I have also put the code on here and a direct link to the trinket. Feel free to reuse. If using the code directly you will need to change the file extension from txt to py or just copy and paste. Trinket is https://trinket.io/python/7ab15d025d41 The Gift(x,y) function isn’t efficient, but I use it as a discussion exercise and to remind students how the loop works in it.