Use Word + Excel to Analyze Qualitative Data with Seth Tucker

AU Professional Studies
AU Professional Studies
17,713
0
Published 2023-01-27
Extracting meaningful findings from qualitative data requires an evaluator to have the right tools to able to organize, code, and immerse themselves in the data. This can be difficult when dealing with large amounts of data or when there is a lack of access, comfort level, or desire in using coding software. However, rigorous qualitative analysis can be done using tools that many people are already familiar with - Microsoft Word and Excel. In this interactive workshop, Seth demonstrated how to use Microsoft Word and Excel to define, organize, and analyze qualitative data in a way that is practical, efficient, rigorous, and fun.

Participants left this session with another tool in their qualitative data analysis toolbox without the need to buy or learn analysis software.

Seth Tucker is an alum of American University’s Project Monitoring and Evaluation Certificate Program. Seth is an evaluation analyst at TCC Group, where he uses qualitative and quantitative methods that incorporate machine learning, social network analysis, and natural language processing. Seth has previously coordinated, as well as managed and analyzed data, for evaluation projects in Latin America and the United States related to Fair Trade, Social Return on Investment, Property Formalization, Adult Education, and Sustainable Agriculture, among others.

For more information on Certificate and Masters Programs in Measurement & Evaluation at American University, visit bit.ly/AUMandE. Follow AU's program and get invitations to upcoming events on Facebook: www.facebook.com/profile.php?id=100089649586636

Links to Webinar support documents:
• Tucker: Qualitative Analysis Using Word & Excel: docs.google.com/document/d/1sljtkAT4281hu_11VAU4aw…
• Tucker: Slide Deck Qualitative Analysis: drive.google.com/file/d/1MHu3QLh_7saVF4SivDzu1Cuh7…
All Comments (21)
  • @ye5069
    Thank you! I saw so many videos but not one of them was so helpful!!!
  • @pamelam.2460
    Thank you for making this video public and accessible.
  • @alizia3475
    Putting my work aside I have sat to watch this.
  • @birgitodriscoll8315
    This has been such an amzingly informative session! Only started my qualitative data analysis last year and this will make it so much easier for me, and quicker! Wonderful, thank you
  • @trishalynn5964
    Thank you so much for putting this online. It's really helping me figure out how to do the coding for my Master's project.
  • @doreendesire9083
    I can say this video has made me to become better in my qualitative analysis of data, using Ms Word and Ms Excel, I really do appreciate this. I attended the webinar but not all of it, this video has helped me follow everything else I had missed. Thanks once again Dr Seth.
  • @doreendesire9083
    I have learnt something really new to me, that is transcribing using google docs. Thanks Dr Seth. I really appreciate this
  • @ranikatie
    Super session! Very clear, useful and concise. Thank you
  • @omondiphil3778
    👏👏👏👏👏 I didn't make it to the webinar because of the time difference, but this video is worth it. Learned a lot from the session. Thanks you guys for creating this !!!
  • @TheKarthhh
    Thanks for sharing your ideas and resources. It is a huge help for all of us.😊
  • @ceceidentity
    Sometimes we need to focus on the simple tools we have been using so far to do our work and not be chasing necessarily softwares which have additional cost and are complex to use. I wonder if there is any academic publication about this methodology, i would love to reference it for my analysis. Thank you, very very useful.
  • @haroldgoingsjr2989
    I am impressed with this process and its effectiveness. However, is there a method that utilizes MS Forms to encode data from the results of an MS Forms qualitative questionnaire, exported to an Excel spreadsheet, to create a codebook similar to what was produced from MS Word in your presentation?
  • @lallaveokenvensuensang7138
    Thank you. Very helpful. Regarding the step of copying the comments the option of Ctrl + shift+ end did not work for me. But if you put the cursor on the first comment and press shift+down arrow will highlight and allow you to copy all the comments. Your video open a new window for me to analysis my data but as well expanded immensely my research now :0)
  • @jenkoenplaylist
    Audio-transcription from a recording does not work on google-docs - I have tried numerous times. I think there may be something to the need for direct voice vibrations for it to work
  • @helenacookman1632
    When I copy & paste into Excel it only pastes the comment (coding) but not the text that has been highlighted/coded- can anyone help with this?
  • @kenbaratko9476
    The other lady is reading from the screen ... Her head moves left to right to left to right...
  • @kenbaratko9476
    The guy with the black glasses is also moving his head too much reading from screen notes...also does not set tone