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, KZread, etc.

Пікірлер: 18

  • @musumassaquoi3719
    @musumassaquoi371912 күн бұрын

    Thanks, this video was very helpful.

  • @is4290
    @is42902 жыл бұрын

    how to make this table in a spreadsheet?

  • @mumtazdigiverse
    @mumtazdigiverse2 жыл бұрын

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

  • @luz-patriciatorres6541
    @luz-patriciatorres65412 жыл бұрын

    where can this time-saving spreadsheet be purchased?

  • @aminayahiacherif7102
    @aminayahiacherif7102 Жыл бұрын

    How to do the table in excel????

  • @allaineescozar
    @allaineescozar Жыл бұрын

    Hello, is this also called thematic analysis?

  • @agneswanjau178
    @agneswanjau178 Жыл бұрын

    Brilliant

  • @ReginaMcAllen
    @ReginaMcAllen3 ай бұрын

    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. 😩

  • @TheHk15
    @TheHk15 Жыл бұрын

    Hello, is this still available to purchase?

  • @busisiwemagadla9659
    @busisiwemagadla965910 ай бұрын

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

  • @mmadimanyathi329
    @mmadimanyathi329Ай бұрын

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

  • @irishcoleen
    @irishcoleen2 ай бұрын

    Is this Qualitative research study ?

  • @theodorawaters6115
    @theodorawaters6115 Жыл бұрын

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

  • @mkl5672

    @mkl5672

    Жыл бұрын

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

  • @anjakriel2740

    @anjakriel2740

    Жыл бұрын

    have you managed to find the spreadsheet?

  • @fionabreytenbach8041
    @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

    @KKmovesToMars

    9 ай бұрын

    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

    @fionabreytenbach8041

    9 ай бұрын

    @@KKmovesToMars Thanks

Келесі