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.



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.