Has anybody else tried to replicate the Sunday Times league table calculation of NSS data into a percentage? Their published percentage score (as opposed to the weighted league table points) is "the maximum mark possible if all students had been happy with every aspect of their higher education". This is based on answers to all 22 questions in the survey, each of which is of course answered on a scale of 1-5. I have tried to replicate this calculation using NSS data we had already. I took the weighted average response for all questions, all respondants: (sum of answers ranked '1' x 1) + (sum of answers ranked '2' x2) etc, the denominator of this calculation being 5 x the sum total answers to all questions by all respondants. I get a figure significantly higher than that published, but only have our own data to test this out with. Just curious as to whether anyone else has tried... Regards, Jim -----Original Message----- From: Academic, financial or space planning in UK universities [mailto:[log in to unmask]] On Behalf Of David Tucker Sent: 11 September 2006 16:06 To: [log in to unmask] Subject: Sunday Times University Guide Data 2006 Does anybody on this list have an electronic version of the Sunday Times University Guide data in an easily manipulative form such as an Excel file? Last year we were able to scan in the data and convert it to a table but this year that is proving problematic, it would appear somebody would like to make institutional analysis as difficult as possible! Any help on this would be much appreciated. Regards, Dave D G Tucker Assistant Planning Officer University of Surrey Tel : 01483 683855 Fax: 01483 689549 Email : [log in to unmask]