Publications and Research

Document Type


Publication Date

Fall 2014


This article discusses how two members of the space planning committee at Lehman College library created a brief paper survey, distributed it to students in the library, and designed a Google spreadsheet to enable the committee to work as a group to compile results. We provide our survey tool as an example; explain how we simplified data compilation through a “quick and dirty” coding process; outline step-by-step instructions on how to design a Google spreadsheet that enables many librarians to input survey results consistently; and describe our mistakes and “lessons learned.” We believe our practical approach could be easily implemented as a space planning tool in any number of libraries—even those with small staffs and budgets.


This work was originally published in Library Leadership & Management.


To view the content in your browser, please download Adobe Reader or, alternately,
you may Download the file to your hard drive.

NOTE: The latest versions of Adobe Reader do not support viewing PDF files within Firefox on Mac OS and if you are using a modern (Intel) Mac, there is no official plugin for viewing PDF files within the browser window.