Lessons Learned from Evaluating the Usability of Mobile Spreadsheet Applications

It is estimated that 90% of all the analysts in business perform calculations on spreadsheets. Due to advances in technology, spreadsheet applications can now be used on mobile devices and several such applications are available for platforms such as Android and iOS. Research on spreadsheets revolves around several themes, but little work has been done in evaluating the usability of such applications (desktop or mobile). This paper presents lessons learned and usability guidelines derived from laboratory usability testing of mobile spreadsheet applications. Twelve participants were given a task to be solved using a mobile spreadsheet application and based on the video recordings of their interactions with the application patterns of recurring actions and sequences of actions were derived. Navigation, selection, feedback, and transparency of features were some of the main themes in the results of the testing, pointing to a set of guidelines which are also generalizable across other types of mobile applications.

[1]  Luca Paolino,et al.  User requirements for a web based spreadsheet-mediated collaboration , 2010, AVI.

[2]  Adrian David Cheok,et al.  Proceedings of the 4th international conference on mobile technology, applications, and systems and the 1st international symposium on Computer human interaction in mobile technology , 2007 .

[3]  Manfred Tscheligi,et al.  Depth and breadth away from the desktop: the optimal information hierarchy for mobile use , 2006, Mobile HCI.

[4]  Martin Erwig,et al.  Inferring templates from spreadsheets , 2006, ICSE '06.

[5]  Steve Howard,et al.  Evaluating the usability of a mobile guide: The influence of location, participants and resources , 2005, Behav. Inf. Technol..

[6]  Luca Chittaro,et al.  Map, diagram, and web page navigation on mobile devices: the effectiveness of zoomable user interfaces with overviews , 2008, Mobile HCI.

[7]  Gregg Rothermel,et al.  A methodology for testing spreadsheets , 2001, TSEM.

[8]  Markus Seidl,et al.  Mobile phone web browsing: a study on usage and usability of the mobile web , 2009, Mobile HCI.

[9]  R. Abraham,et al.  How to communicate unit error messages in spreadsheets , 2005, WEUSE@ICSE.

[10]  Sujan Shrestha.  Mobile web browsing: usability study , 2007, Mobility '07.

[11]  George Buchanan,et al.  Improving Web Interaction on Small Displays , 1999, Comput. Networks.

[12]  Margaret M. Burnett,et al.  Graphical definitions: expanding spreadsheet languages through direct manipulation and gestures , 1998, TCHI.

[13]  Rachel Harrison,et al.  Spreadsheets on the Move: An Evaluation of Mobile Spreadsheets , 2011, ArXiv.

[14]  Yirsaw Ayalew,et al.  An end-user oriented graph-based visualization for spreadsheets , 2008, WEUSE@ICSE.

[15]  Arie van Deursen,et al.  Supporting professional spreadsheet users by generating leveled dataflow diagrams , 2010, 2011 33rd International Conference on Software Engineering (ICSE).

[16]  Dongsong Zhang,et al.  Challenges, Methodologies, and Issues in the Usability Testing of Mobile Applications , 2005, Int. J. Hum. Comput. Interact..