I’m looking at ways to summarize patron comments to the open-ended questions and finding the “Analyzing Qualitative Data” framework in the Resources section very helpful. I have 2 questions for those of you who are coding and summarizing your open-ended responses:
- Has anyone developed standard categories for survey question 6, which asks about what the library can do to assist in learning? Sample categories are provided in the Qualitative worksheet for survey question 5, but not 6 (unless I missed them). I can see how they may vary from the “what did you like” categories.
- The process of coding the responses in Excel, then transferring descriptions and responses to a Word document seems cumbersome. Has anyone found a way to streamline this process, for example by coding and summarizing in the same Excel spreadsheet?
Thanks in advance!