- 1
- 33 651
One Year Dissertation
เข้าร่วมเมื่อ 7 เม.ย. 2021
This channel provides advice and instructions to doctoral students to help them quickly complete their dissertations. Many of the videos help to identify pitfalls that waste time in the dissertation process. Other videos provide simple instructions on qualitative and quantitative analytical techniques.
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, TH-cam, etc.
มุมมอง: 33 664
In fact you did everything except showing us how to create the automatic table you're using! So, we get this. It's marketing!
Can you attach link to your spread sheet so we can download, and follow your format? Thank you and God bless
Can you please tell how to create table, which formula did you use to count automatically?
READ THIS!! If you replicate the Excel file the way he does in the video, you simply need to insert (copy and paste) these formulas in these cells to make it work: (1) in Cell E2 --> =A1, (2) in Cell E4 --> =UNIQUE(B2:B8), (3) in Cell G4 --> =COUNTIF(B2:B8,E4), and (4) in Cell H4 --> =COUNTIF($B$2:$B$8,E4)/COUNTA($B$2:$B$23). You can modify the Excel file later to suit your own needs without messing up the formulas. In other words, if you add columns, the formulas will adjust accordingly. Good luck!
Do you have anything more complex and realistic as an example
How about if I have a thousand responses? Do I need to check one by one?
Thanks, this video was very helpful.
How do I cite this video? I need the Arthur name atleast
Is this Qualitative research study ?
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. 😩
I didn't hear how to create that table on excel please can you help🙏
Brilliant
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?
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
@@KKmovesToMars Thanks
I can't seem to get the link to work to purchase this spreadsheet.
TH-cam won't let me comment a URL. Just delete the spaces if you want to access either resource
have you managed to find the spreadsheet?
How to do the table in excel????
Hello, is this still available to purchase?
Hello, is this also called thematic analysis?
how to make this table in a spreadsheet?
where can this time-saving spreadsheet be purchased?
Have you published this coding scheme in a research paper? secondly, how to create the first excel sheet where you have incorporated the data?