Easiest way to Code Open Ended Survey Responses

This video shows the fastest and simplest way to code open ended survey responses using MS Excel. You can purchase the time-saving spreadsheet at www.oneyeardissertation.com/time-saving-products, but this video will show you how to do it without the purchase as well. Other qualitative data analysis platforms are expensive, difficult to use, and do not provide as valuable of an end result. This video will show everything starting with taking data from survey platform data pulls (i.e. Qualtrics, Survey Monkey, Google Forms, etc.), how to code comments from respondents, and how to efficiently transform the coded data into a presentable table format. Most importantly, this video shows how to save a great deal of time, up to half of the time required to complete qualitative data analysis, by using a simple spreadsheet. The end result is an APA formatted table in a fraction of the time. This technique is useful for students, researchers, marketing professionals, survey professionals, or anyone who has comments from open-ended survey questions that they need to analyze. This technique will also work for unique applications such as coding comments to blog posts, Facebook, RUclips, etc.

[@is4290]

how to make this table in a spreadsheet?

[@Pmjdigiverse]

Have you published this coding scheme in a research paper? secondly, how to create the first excel sheet where you have incorporated the data?

[@musumassaquoi3719]

Thanks, this video was very helpful.

[@allaineescozar]

Hello, is this also called thematic analysis?

[@luz-patriciatorres6541]

where can this time-saving spreadsheet be purchased?

[@yamatanoorochi3149]

Do you have anything more complex and realistic as an example

[@ReginaMcAllen]

Well, this is just cruel. I got so excited about this beautiful template, but can't seem to access it anywhere. Please oh please Mr. One Year Dissertation - let us know where we can get this? It would save me so much time. 😩

[@aminayahiacherif7102]

How to do the table in excel????

[@busisiwemagadla9659]

I didn't hear how to create that table on excel please can you help🙏

[@marcoswenzel9729]

How about if I have a thousand responses? Do I need to check one by one?

[@agneswanjau178]

Brilliant

[@mmadimanyathi329]

How do I cite this video? I need the Arthur name atleast

[@irishcoleen]

Is this Qualitative research study ?

[@TheHk15]

Hello, is this still available to purchase?

[@fionabreytenbach8041]

What if someone lists multiple things in one response e.g. in your last example, what if one respondent had said "atmosphere and blue glass"? Do you then tally 1 point in each category? Is that not then duplicating the weight of that respondents opinion?

[@KKmovesToMars]

i have used 2 approaches (depending on study objectives, and typically budget) - only count the first mentioned 'thing', as typically people list the most significant 'thing' first. or if objective/budget allow, count both/all as separate entries, sometimes allocating less of a point to things mentioned later

[@fionabreytenbach8041]

@@KKmovesToMars Thanks

[@theodorawaters6115]

I can't seem to get the link to work to purchase this spreadsheet.

[@magskl672]

RUclips won't let me comment a URL. Just delete the spaces if you want to access either resource

[@anjakriel2740]

have you managed to find the spreadsheet?