At the end of every semester I have to input my students' grades into a database. Typically this means I go one by one down my list of grades from my excel spreadsheet and manually fill the grade into the db application. One way to check I have done things correctly is to compare the mean and standard deviation of the grades from my excel sheet and the application.
I realised that this would not capture the error of swapping over two grades: i.e. my excel sheet has the grades as: 4,4,4.5,6,4 and I put in 4,4.5,4,6,4.
Is there an simple numerical measure that takes into account the order of the list such that a quick comparison of that gives me confidence that all is well?
I suppose one could do some kind of Gödel numbering, but I see that as rather overkill.