skip to main content
10.1145/3286689.3286697acmconferencesArticle/Chapter ViewAbstractPublication PagesihmConference Proceedingsconference-collections
research-article

Combination of tactile devices to interact with a spreadsheet on tablet

Published: 23 October 2018 Publication History

Abstract

Multi-touch interaction with spreadsheets on tablets is tedious and raises multiple interaction issues. In this paper, we present the design and evaluation of novel interaction techniques relying on the usage of an always-available device, the smartphone, to improve interaction with spreadsheets on tablets. The smartphone can be used as an additional screen, allowing to display more information or as a tangible interactor, thus extending the tactile interaction vocabulary through stacking gestures. Our techniques aim to facilitate the creation of pivot tables, a common task in data analysis on spreadsheets. We evaluate our stacking techniques against the tactile interactions provided by mobile spreadsheet apps. Our studies reveal that some of our interaction techniques are 23.1% faster than tactile for creating pivot tables.

References

[1]
Brian Albright. 2009. Mathematical Modeling with Excel (1st ed.). Jones and Bartlett Publishers, Inc., USA.
[2]
Monya Baker. 2015. Statisticians issue warning over misuse of P values. Nature 531, 7593 (March 2015), 151.
[3]
Nikola Banovic, Frank Chun Yat Li, David Dearman, Koji Yatani, and Khai N. Truong. 2011. Design of unimanual multi-finger pie menu interaction. In Proceedings of the ACM International Conference on Interactive Tabletops and Surfaces (ITS '11). ACM, New York, NY, USA, 120--129.
[4]
Dominikus Baur, Bongshin Lee, and Sheelagh Carpendale. 2012. TouchWave: kinetic multi-touch manipulation for hierarchical stacked graphs. In Proceedings of the 2012 ACM International Conference on Interactive Tabletops and Surfaces (ITS '12), 255--264.
[5]
Louis-Pierre Bergé, Emmanuel Dubois, and Mathieu Raynal. 2015. Design and Evaluation of an "Around the SmartPhone" Technique for 3D Manipulations on Distant Display. In Proceedings of the 3rd ACM Symposium on Spatial User Interaction (SUI '15). ACM, New York, NY, USA, 69--78.
[6]
Xiang 'Anthony' Chen, Tovi Grossman, Daniel J. Wigdor, and George Fitzmaurice. 2014. Duet: exploring joint interactions on a smart phone and a smart watch. In Proceedings of the SIGCHI Conference on Human Factors in Computing Systems (CHI '14). ACM, New York, NY, USA, 159--168.
[7]
Nicholas Chen, François Guimbretière, and Abigail Sellen. 2013. Graduate student use of a multi-slate reading system. In Proceedings of the SIGCHI Conference on Human Factors in Computing Systems (CHI '13). ACM, New York, NY, USA, 1799--1808.
[8]
Steven M. Drucker, Danyel Fisher, Ramik Sadana, and Jessica Herron. 2013. TouchViz: a case study comparing two interfaces for data analytics on tablets. In Proceedings of the SIGCHI Conference on Human Factors in Computing Systems (CHI '13), 2301--2310.
[9]
Excel sur Android: https://play.google.com/store/apps/details?id=com.microsoft.office.excel&hl=fr (Last visit 11/05/2018)
[10]
Excel sur Windows: https://products.office.com/fr-fr/excel (Dernière visite 11/05/2018)
[11]
Mark Gardener. 2015. Managing Data Using Excel. Pelagic Publishing, United Kingdom.
[12]
Alix Goguey, Géry Casiez, Thomas Pietrzak, Daniel Vogel, and Nicolas Roussel. 2014. Adoiraccourcix: multi-touch command selection using finger identification. In Proceedings of the 26th Conference on l'Interaction Homme-Machine (IHM '14). ACM, New York, NY, USA, 28--37.
[13]
Google Spreadsheet sur Android: https://play.google.com/store/apps/details?id=com.google.android.apps.docs.editors.sheets&hl=fr (Last visit 11/05/2018)
[14]
Peter Hamilton and Daniel J. Wigdor. 2014. Conductor: enabling and understanding cross-device interaction. In Proceedings of the SIGCHI Conference on Human Factors in Computing Systems (CHI '14). ACM, New York, NY, USA, 2773--2782.
[15]
Khalad Hasan, David Ahlström, and Pourang Irani. 2013. Ad-binning: leveraging around device space for storing, browsing and retrieving mobile device content. In Proceedings of the SIGCHI Conference on Human Factors in Computing Systems (CHI '13). ACM, New York, NY, USA, 899--908.
[16]
Seongkook Heo, Jiseong Gu, and Geehyuk Lee. 2014. Expanding touch input vocabulary by using consecutive distant taps. In Proceedings of the SIGCHI Conference on Human Factors in Computing Systems (CHI '14). ACM, New York, NY, USA, 2597--2606.
[17]
Seongkook Heo, Jingun Jung, and Geehyuk Lee. 2016. MelodicTap: fingering hotkey for touch tablets. In Proceedings of the 28th Australian Conference on Computer-Human Interaction (OzCHI '16). ACM, New York, NY, USA, 396--400.
[18]
Dandan Huang, Melanie Tory, Bon Adriel Aseniero, Lyn Bartram, Scott Bateman, Sheelagh Carpendale, Anthony Tang, and Robert Woodbury. 2015. Personal visualization and personal visual analytics. IEEE Transactions on Visualization and Computer Graphics (TVCG) 21, 3: 420--433.
[19]
Sungjae Hwang, Myungwook Ahn, and Kwang-yun Wohn. 2013. MagGetz: customizable passive tangible controllers on and around conventional mobile devices. In Proceedings of the 26th annual ACM symposium on User interface software and technology (UIST '13). ACM, New York, NY, USA, 411--416.
[20]
Jaemin Jo, Sehi L'Yi, Bongshin Lee, and Jinwook Seo. 2017. TouchPivot: Blending WIMP & Post-WIMP Interfaces for Data Exploration on Tablet Devices. In Proceedings of the 2017 CHI Conference on Human Factors in Computing Systems (CHI '17). ACM, New York, NY, USA, 2660--2671.
[21]
Club MAGEL: http://www.magel.asso.fr/ (Dernière visite 11/05/2018)
[22]
Gary Perelman, Marcos Serrano, Célia Picard, Mustapha Derras, Emmanuel Dubois. Interaction multi-dispositifs pour tableurs sur tablette. AFIHM. 29ème conférence francophone sur l'Interaction Homme-Machine, Aug 2017, Poitiers, France. ACM, IHM-2017, 12 p., 2017, . .
[23]
Ken Pfeuffer, Ken Hinckley, Michel Pahud, and Bill Buxton. 2017. Thumb + Pen Interaction on Tablets. In Proceedings of the 2017 CHI Conference on Human Factors in Computing Systems(CHI '17). ACM, New York, NY, USA, 3254--3266.
[24]
Tommaso Piazza, Morten Fjeld, Gonzalo Ramos, AsimEvren Yantac, and Shengdong Zhao. 2013. Holy smartphones and tablets, Batman!: mobile interaction's dynamic duo. In Proceedings of the 11th Asia Pacific Conference on Computer Human Interaction (APCHI '13). ACM, New York, NY, USA, 63--72.
[25]
QlikView: https://www.qlik.com/fr-fr/products/qlikview (Dernière visite 11/05/2018)
[26]
Jeffrey M. Rzeszotarski and Aniket Kittur. 2014. Kinetica: naturalistic multi-touch data visualization. In Proceedings of the SIGCHI Conference on Human Factors in Computing Systems (CHI '14), 897--906.
[27]
Ramik Sadana and John Stasko. 2014. Designing and implementing an interactive scatterplot visualization for a tablet computer. In Proceedings of the 2014 International Working Conference on Advanced Visual Interfaces (AVI '14), 265--272
[28]
Houssem Saidi, Marcos Serrano, and Emmanuel Dubois. 2016. Investigating the effects of splitting detailed views in Overview+Detail interfaces. In Proceedings of the 18th International Conference on Human-Computer Interaction with Mobile Devices and Services (MobileHCI '16). ACM, New York, NY, USA, 180--184.
[29]
Stephanie Santosa, Daniel Wigdor, A field study of multi-device workflows in distributed workspaces, Proceedings of the 2013 ACM international joint conference on Pervasive and ubiquitous computing, September 08--12, 2013, Zurich, Switzerland doi>
[30]
Christopher Scaffidi, Mary Shaw, and Brad Myers. 2005. Estimating the Numbers of End Users and End User Programmers. In Proceedings of the 2005 IEEE Symposium on Visual Languages and Human-Centric Computing (VLHCC '05). IEEE Computer Society, Washington, DC, USA, 207--214.
[31]
Katie A. Siek, Yvonne Rogers, and Kay H. Connelly. 2005. Fat finger worries: how older and younger users physically interact with PDAs. In Proceedings of the 2005 IFIP TC13 international conference on Human-Computer Interaction (INTERACT'05), Maria Francesca Costabile and Fabio Paternò (Eds.). Springer-Verlag, Berlin, Heidelberg, 267--280.
[32]
Md. Sami Uddin and Carl Gutwin. 2016. Rapid Command Selection on Multi-Touch Tablets with Single-Handed HandMark Menus. In Proceedings of the 2016 ACM on Interactive Surfaces and Spaces (ISS '16). ACM, New York, NY, USA, 205--214.
[33]
Vizable par Tableau: https://vizable.tableau.com/ (Dernière visite 11/05/2018)
[34]
Daniel Vogel and Géry Casiez. 2011. Conté: multimodal input inspired by an artist's crayon. In Proceedings of the 24th annual ACM symposium on User interface software and technology (UIST '11). ACM, New York, NY, USA, 357--366.
[35]
Julie Wagner, Eric Lecolinet, and Ted Selker. 2014. Multi-finger chords for hand-held tablets: recognizable and memorable. In Proceedings of the SIGCHI Conference on Human Factors in Computing Systems (CHI '14). ACM, New York, NY, USA, 2883--2892.
[36]
Paweł Woźniak, Lars Lischke, Benjamin Schmidt, Shengdong Zhao, and Morten Fjeld. 2014. Thaddeus: a dual device interaction space for exploring information visualisation. In Proceedings of the 8th Nordic Conference on Human-Computer Interaction: Fun, Fast, Foundational (NordiCHI '14). ACM, New York, NY, USA, 41--50.

Index Terms

  1. Combination of tactile devices to interact with a spreadsheet on tablet

    Recommendations

    Comments

    Information & Contributors

    Information

    Published In

    cover image ACM Conferences
    IHM '18: Proceedings of the 30th Conference on l'Interaction Homme-Machine
    October 2018
    275 pages
    ISBN:9781450360784
    DOI:10.1145/3286689
    Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

    Sponsors

    Publisher

    Association for Computing Machinery

    New York, NY, United States

    Publication History

    Published: 23 October 2018

    Permissions

    Request permissions for this article.

    Check for updates

    Author Tags

    1. interaction technique
    2. smartphone
    3. tablet

    Qualifiers

    • Research-article

    Conference

    IHM '18
    Sponsor:

    Acceptance Rates

    Overall Acceptance Rate 103 of 199 submissions, 52%

    Contributors

    Other Metrics

    Bibliometrics & Citations

    Bibliometrics

    Article Metrics

    • 0
      Total Citations
    • 73
      Total Downloads
    • Downloads (Last 12 months)7
    • Downloads (Last 6 weeks)0
    Reflects downloads up to 24 Dec 2024

    Other Metrics

    Citations

    View Options

    Login options

    View options

    PDF

    View or Download as a PDF file.

    PDF

    eReader

    View online with eReader.

    eReader

    Media

    Figures

    Other

    Tables

    Share

    Share

    Share this Publication link

    Share on social media