Category: Coding Interview Data

Student Linquistic abilities

6/30/2019

I am analyzing the interview data I collected from students for my PhD dissertation. Many of these students are amazing, especially in their linguistic abilities.

I'll let this excerpt from the transcript of one interview with a female student speak for itself. The student's name below is a pseudonym.

Paul: Okay. Uhm how many languages do you speak?
Mary: Four.
Paul: What are they?
Mary: Portuguese, Japanese, English and Spanish.
Paul: Wow!
Mary: Hmm.
Paul: That’s pretty impressive.
Mary: No, I wish I could be fluent in all of them. English and Spanish are the most challenging.

I should add that the student's English during two long interviews was flawless.

#smartstudents

0 Comments

Excel & Word for qualitative data analysis

6/16/2019

0 Comments

I have continued to experiment with the use of MS Excel and Word to analyze qualitative date -- in this case, interview data for my PhD dissertation. The method described by Ose (2016) is amazing, although it has a few disadvantages.

Disadvantages include having online one major code for each interviewee quote. In my spreadsheet, I have an additional column for a secondary code, but I do not include that column when going through Ose's (2016) steps to convert the Excel file for Word. I use the added column as a reference as I work with the Word file during my secondary coding, categorizing, and creation of themes.

If you use her method as described in her paper, you will need to enlarge the Figure 10 and 11 screen shots. The concatenation instructions are complex, but trust what she writes, and pay special attention to the following on page 9:
F1 cell: =CONCATENATE(D1;"(";A1;"_";B1;"_";C1;")")
The "_" underscore symbols represent spaces, not use of the symbol, and in my instance of Excel, the semicolons were commas when I used the Function feature to create this string.

This is what the formula looks like in my file:
=CONCATENATE(D1,"(",A1," ",B1," ",C1,")")

The screen shot below is Ose's (2016) Figure 6 image on page 9. Keep in mind that there are additional "Text" boxes that aren't visible in this image.

Reference
Ose, S. O. (2016). Using Excel and Word to Structure Qualitative Data. Journal of Applied Social Science, 10(2), 147–162. https://doi.org/10.1177/1936724416664948

#dataanalysis #qualitativedata #interviewdata

0 Comments

Student Linquistic abilities

Excel & Word for qualitative data analysis

Paul mcafee

Archives

Categories