{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Vigenere","MarkingList"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":32,"n_cols":1,"rows_kept":32,"cut":false,"hidden":false,"merged":[[22,0,22,10],[12,0,12,10],[14,0,14,10],[4,0,4,10],[6,0,6,10],[8,0,8,10],[10,0,10,10],[16,0,16,10],[20,0,20,10]]}
["AnonyMark Instructions"]
[]
["To generate encrypted student numbers (using the Vigenere worksheet)"]
[]
["If you want to generate a new shuffling of the rows in the Vigenere-type table, first click the button \"Shuffle rows in table\" (only do this before you have generate the encrypted numbers for an assignment)."]
[]
["Choose your key (this can be two digits, three digits, or four digits) and enter it in the Key boxes - leave some cells blank if you are using a key with fewer than four digits."]
[]
["Copy your list of student ID numbers into column N from row 2 onwards - these must consist only of digits, but can contain as many digits as necessary. If the first digit is 0 then replace it with -, e.g. -11011 instead of 011011."]
[]
["Copy the accompanying list of student e-mail addresses into column Q for possible mail merge to inform students of their number. "]
[]
["Copy your list of student names into column O for ease of reference later on. Note: the number of students will automatically update in cell F17."]
[]
["Enter the module code and assignment number into the relevant cells (E19 and G21) - these will be used for the filename of an Excel file storing the original and generated numbers (and email addresses - for use with mail merge)."]
[]
["Click the button \"Generate anonymous numbers\" to create a list of encrypted numbers in column P, and to copy these to the sheet MarkingList (which is then sorted in order, to avoid retaining a likely existing alphabetical ordering of the students). Note that the key and the first column of the table are recorded at the top of column P."]
[]
["To decrypt anonymous student numbers (on the MarkingList worksheet)"]
[]
["The easiest way to decrypt the anonymous numbers is simply to copy them from the Vigenere worksheet where they sit alongside the student ID numbers and names (manually sort them first before matching them up to the list on the MarkingList sheet). Alternatively copy them from the Excel file that was created which contains these columns."]
[]
["If the MarkingList needs to be formally decrypted for some reason (i.e. the list on the Vigenere sheet or the Excel file has been lost) then ensure that the table is set to be as it was when the numbers were encrypted, ensure that the key is as it was, and then click the button \"Decrypt MarkingList sheet\" - the results are saved to column C of the MarkingList worksheet. Warning: the validity of this decryption depends completely on the validity of the table and the key given on the worksheet."]
[]
[]
["Note"]
["These macros were written by Karen Ayres (Department of Mathematics & Statistics, University of Reading)."]
["If they are run, they are run entirely at the risk of the user."]
["If the code is re-used it should be acknowledged."]
["A description of the method has been submitted to the British Journal of Educational Technology."]
["E-mail: k.l.ayres@reading.ac.uk"]
["July 2011"]

{"sheet":"Vigenere","index":1,"n_rows":21,"n_cols":17,"rows_kept":21,"cut":false,"hidden":false,"merged":[[18,4,18,6]]}
["Vigenere-type table",null,null,null,null,null,null,null,null,null,null,null,null,"Student Number","Student Name","Anonymous Number","Email"]
["plain",1,2,3,4,5,6,7,8,9,0,null,null,12015423,"Bloggs, J",null,"j.bloggs@uni.ac.uk"]
[1,7,8,9,0,1,2,3,4,5,6,null,null,11042343,"Brown, S",null,"s.brown@uni.ac.uk"]
[2,4,5,6,7,8,9,0,1,2,3,null,null,12094321,"Jones, A",null,"a.jones@uni.ac.uk"]
[3,9,0,1,2,3,4,5,6,7,8,null,null,11078893,"Other, AN",null,"a.n.other@uni.ac.uk"]
[4,2,3,4,5,6,7,8,9,0,1,null,null,12041094,"Smith, C",null,"c.smith@uni.ac.uk"]
[5,5,6,7,8,9,0,1,2,3,4,null,null,12043421,"Thomas, D",null,"d.thomas@uni.ac.uk"]
[6,0,1,2,3,4,5,6,7,8,9,null,null,13013257,"Watson, WT",null,"t.w.watson@uni.ac.uk"]
[7,1,2,3,4,5,6,7,8,9,0,null,null,-2092129,"White, M",null,"m.white@uni.ac.uk"]
[8,3,4,5,6,7,8,9,0,1,2]
[9,6,7,8,9,0,1,2,3,4,5]
[0,8,9,0,1,2,3,4,5,6,7]
[]
[null,"KEY",1,2,3,null,null,"Enter 2-4 digits here"]
[]
[]
[null,"Number of students",null,null,null,{"$f":"COUNTA(N:N)-1","v":8},null,"(do not change this)"]
[]
[null,"Module Code",null,null,"ST1A1"]
[]
[null,"Assignment Number",null,null,null,null,1]

{"sheet":"MarkingList","index":2,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Anonymous Number","Mark"]