Information Sharing Among Disaster Responders - An Interactive Spreadsheet-Based Collaboration Approach

Recent natural disasters have led crisis management organizations to revise their protocols so as to rely on the contribution of a wider range of actors, including simple citizens as well as expert operators, to support decision making activities. Reliable and timely information sharing among members of distributed teams of disaster responders has become paramount for the success of the overall crisis management process. In this paper we propose a crisis management system based on spreadsheet-mediated collaboration among on-site responders and decision makers. To share data a common spreadsheet artifact has been developed by using a participatory design approach which is accessed through mobile user interfaces. The evaluation results showed that the use of the spreadsheet artifact has resulted in more effective decision making relating to set of earthquake management scenarios in high-risk areas located in Italy.

[1]  M. Turoff,et al.  Session details: Emergency response information systems: emerging trends and technologies , 2007 .

[2]  David B. Martin,et al.  Patterns of cooperative interaction: linking ethnomethodology and design , 2004, INTR.

[3]  Murray E. Jennex,et al.  Exercise 24: Using Social Media for Crisis Response , 2011, Int. J. Inf. Syst. Crisis Response Manag..

[4]  Helena M. Mentis,et al.  Supporting common ground and awareness in emergency management planning: A design research project , 2011, TCHI.

[5]  Genny Tortora,et al.  A Collaborative Environment for Spreadsheet-Based Activities , 2010, 2010 IEEE Symposium on Visual Languages and Human-Centric Computing.

[6]  John M. Carroll,et al.  Supporting Community Emergency Management Planning through a Geocollaboration Software Architecture , 2007, Computer Supported Cooperative Work (CSCW).

[7]  M. Careem,et al.  Sahana: Overview of a Disaster Management System , 2006, 2006 International Conference on Information and Automation.

[8]  Bo Yu,et al.  Facilitating participatory decision-making in local communities through map-based online discussion , 2009, C&T.

[9]  James H. Martin,et al.  A vision for technology-mediated support for public participation & assistance in mass emergencies & disasters , 2010 .

[10]  Mary Beth Rosson,et al.  Usability Engineering: Scenario-based Development of Human-Computer Interaction , 2001 .

[11]  Connie M. White,et al.  Social Media, Crisis Communication, and Emergency Management: Leveraging Web 2.0 Technologies , 2011 .

[12]  Siobhán Clarke,et al.  Improving Communication for Mobile Devices in Disaster Response , 2007, Mobile Response.

[13]  Murray Turoff,et al.  Human-computer interaction , 2007, Commun. ACM.

[14]  Murray E. Jennex,et al.  Emergency Response Systems: The Utility Y2k Experience , 2004 .

[15]  Genny Tortora,et al.  Framy – visualising geographic data on mobile interfaces , 2008, J. Locat. Based Serv..

[16]  Xiang Yao,et al.  The Design of a Dynamic Emergency Response Management Information System (DERMIS) , 2004 .

[17]  Rajeev Sharma,et al.  GeoCollaborative Crisis Management: Using Maps to Mediate EOC-Mobile Team Collaboration , 2004, DG.O.

[18]  M. Goodchild.  Citizens as sensors: the world of volunteered geography , 2007 .

[19]  W. Petak.  Emergency Management: A Challenge for Public Administration , 1985 .

[20]  Philip Fei Wu,et al.  Community response grids: E-government, social networks, and effective emergency management , 2007 .

[21]  Marco Romano,et al.  Supporting citizens 2.0 in disasters response , 2013 .

[22]  Lorne Olfman,et al.  Wiki Technology and Emergency Response: An Action Research Study , 2010, Int. J. Inf. Syst. Crisis Response Manag..

[23]  Murray E. Jennex,et al.  Achieving Electric Restoration Logistical Efficiencies During Critical Infrastructure Crisis Response: A Knowledge Management Analysis , 2010, Int. J. Inf. Syst. Crisis Response Manag..

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

[25]  Murray E. Jennex,et al.  Knowledge Management , Emergency Response , and Hurricane Katrina , 2007 .

[26]  Mary Beth Rosson,et al.  End-user oriented strategies to facilitate multi-organizational adoption of emergency management information systems , 2010, Inf. Process. Manag..

[27]  Starr Roxanne Hiltz,et al.  The Past as the Future of Emergency Preparedness and Management , 2009, Int. J. Inf. Syst. Crisis Response Manag..

[28]  Rui Chen,et al.  Coordination in emergency response management , 2008, CACM.

[29]  Alan Cooper,et al.  About Face 3: the essentials of interaction design , 1995 .

[30]  Ben Shneiderman,et al.  Community Response Grids: E-government, social networks, and effective emergency response , 2007 .

[31]  Jonas Landgren,et al.  A study of emergency response work: patterns of mobile phone interaction , 2007, CHI.

[32]  Raymond R. Panko,et al.  Two Experiments in Reducing Overconfidence in Spreadsheet Development , 2007, J. Organ. End User Comput..

[33]  Craig A. Knoblock,et al.  Building geospatial mashups to visualize information for crisis management , 2010, ISCRAM.

[34]  David S. Ebert,et al.  Visual Analytics on Mobile Devices for Emergency Response , 2007, 2007 IEEE Symposium on Visual Analytics Science and Technology.

[35]  Dino Bouchlaghem,et al.  A scenario-based study on information flow and collaboration patterns in disaster management. , 2009, Disasters.