Staff ICT Skills Audit Tool

Following yesterday's Eastern Region E-learning Forum I have had lots of requests to use this tool in institutions of all shapes and sizes. That's great and I shall be doing my best over the next few weeks. However, there's some help I need. Maybe someone at Google Docs can help or is there anyone out there with a bright idea?

The form collects data wonderfully and stores it all in a nice spreadsheet. So far so good. I can analyse this data using some formulae but it takes a while and sometimes I do like to watch tv or even teach students or mark their work. So what I really want is a tool or an application which will gather up whatever the user fills in and do the analysis for me then display it for them to see. I guess they'd need to click a Show Me My Results button or something to activate the extra feature and it needs some kind of health warning that, as I haven't seen the results myself and had a chance to spot some errors, they shouldn't get either over-excited or unduly depressed should the results appear impossibly good or embarrassingly bad.

The form is available here if you want to take a look.

A colleague at the Forum did mention something that I wrote down as 'flambaroo' but a search for that or variations of the name came up with nothing relevant. Now I know that someone who loves playing with PHP code and SQL could probably knock me up something and I have two possible sources of help for that but it's still a big job and, as I can imagine that different organisations will want slight tweaks made to things like the titles or department names and possibly even the question bank too and how it is compared to a benchmark, I would be forever bothering them with what sounds like a simple change but which actually takes them away from sleeping for several days in order to revise all their code.

If I can tweak things myself and get some magic application to do the night shift work instead of an ex-student who deserves some chance to get a life or a real job then I can survey the whole damn country and see if I can get Michael Gove to appoint me as an E-learning Tzar or something with a nice title and a bit of useful income. Or just gets some E-learning, ILT or ICT training work.

Answers on a postcard to design@andrewx.com or however you prefer!