Laboratory qualitative analysis excel spreadsheet free download

View cached version text only here. Eliot, S. The Listening Resource, Using excel for qualitative data analysis. Here's a link to step by step instructions for setting up your own excel template. Login Login and comment as BetterEvaluation member or simply fill out the fields below. Source Eliot, S. No votes yet. Analyse data , Visualise data. A special thanks to this page's contributors. Alan Mountain. Share RSS Print version. Robin Herrmann Rating:.

I would like a copy of the excel template. Maryanne Rating:. Hey there, is there a way you could email me the spreadsheet template? Emma Smith Rating:. We have used different word processors and our preference for working with transcriptions is to use MS Word. We provide detailed steps in De Felice and Janesick on p. Our main reason for this choice is that there is no way to show formatting marks in Google Docs see Figure 3 for a list of formatting marks available in MS Word.

These features are not visible in Google Docs. These formatting marks are essential in properly preparing the transcription for importation. There is hope for an eventual add-on to correct this oversight in Google Docs, but there is currently no workaround. Once your text file is ready for import, you can use the spreadsheet as an analysis tool.

For phenomenological studies, we outline a few ways of using Excel in this capacity in De Felice and Janesick What works for one project may not be best for another. De Felice, D. Understanding the marriage of technology and phenomenological research: From design to analysis. The Qualitative Report, 20 10 , Giorgi, A. The descriptive phenomenological method in psychology. A modified Husserlian approach. Meyer, D. Excel as a qualitative data analysis tool.

Field Methods, 21, DOI: Thank you I have been looking for stuff on using Google Sheets to help with Phenomenographical data analysis and came across your blog!

Like Like. You are commenting using your WordPress. You are commenting using your Google account. You are commenting using your Twitter account. You are commenting using your Facebook account. Notify me of new comments via email. Notify me of new posts via email. Figure 1: Screenshot of the options available for importing a file into Google Sheets.

Figure 2: Screenshot of Google docs file that we downloaded as plain text. Figure 3: Screenshot of formatting marks within MS Word. References De Felice, D. Phenomenological research methods. Thousand Oaks, CA: Sage. Leave a Reply Cancel reply Enter your comment here Fill in your details below or click an icon to log in:. Email required Address never made public. Name required.