Back in December I posted a link to ALT’s annual survey on the current use of learning technologies and their development priorities as an organisation. The results are now in and their report, along with anonymised survey data, has been posted to http://repository.alt.ac.uk/2358/.
A complex report for a simple request – how many people are using PebblePad per faculty? Complex because the user data in PebblePad doesn’t contain any information beyond key, username, forename, surname, email and a few other non-pertinent bits and bobs. But I am not easily daunted.
One of these ‘non-pertinent’ bits of information is a ‘last login’ date so I was able to restrict the report to people who had logged in during the past thirty days. I ran a query on the PebblePad database to get all relevant username data for this time period, and then ran a query in Blackboard to get all user data full stop. Why? Because the ‘user’ table in Blackboard does have a field for Faculty. Well, actually it is in a different field because of the way the user accounts are imported from Active Directory, but it was sufficient. Then it was simply a case of importing both resulting CSV files into an Access database and running a join on the username.
Unsurprisingly our Faculty of Health, Community and Education Studies were the biggest users, but it wasn’t as clear cut as I had suspected. They accounted for just under half of all usage, with Engineering and Environment accounting for around a quarter, and the remaining two faculties and service departments sharing the remainder.