Excel formulas from concatenated data

If, like me, you have been trying for ages to create formulas from concatenated data in Excel, then this is the post for you! For those of y...

read more "Excel formulas from concatenated data"

TextJoin function in Excel

Where we have simple requirements, Excel can be very useful for analysing, grouping and clustering survey data. However, to get the most out...

read more "TextJoin function in Excel"

Conventions for transcriptions

When we are transcribing, we need to decide what conventions we are going to use. Will we do a verbatim transcript, and if so, how much of ...

read more "Conventions for transcriptions"

Career practice and the Privacy Act

When working in New Zealand, we need to ensure that we are working within the new Privacy Act (2020). Depending on the nature of our work, w...

read more "Career practice and the Privacy Act"

Clear methods writing: actual to plan

I had an interesting problem with a student recently, where they were writing the wrong elements in the wrong tense in their methods chapter...

read more "Clear methods writing: actual to plan"

Verifying transcripts

In some fields, it is fairly standard for researchers to have interview transcripts verified by the participant as part of ensuring data tru...

read more "Verifying transcripts"

Data collection questions framework

Where qualitative research is complex, with fragments of data being collected and confirmed across several different data collection questio...

read more "Data collection questions framework"

Transcripts and translations

I have a number of students who come to me suggesting that they will ask participants questions in one language, then simply transcribe the ...

read more "Transcripts and translations "

Creating a set of data collection questions

Data collection questions are largely created from the reading we have done for our literature review. From all the good quality research pa...

read more "Creating a set of data collection questions"

What to do with incomplete surveys

I had an undergraduate student ask recently what to do with incomplete surveys: should they include all their data, or not? This is an inter...

read more "What to do with incomplete surveys"

Preparing an Interview Script

As mentioned in other posts (here) the development of the data collection questions takes time, planning and care. We should have develope...

read more "Preparing an Interview Script"

The interview protocol

When interviewing, it is usually good idea to set up an interview protocol before starting, and prepare a script to print and take with us...

read more "The interview protocol"

Different types of interview questions

I have written about interview technique a number of times before ( here ), but haven't really explored the different types of data co...

read more "Different types of interview questions"

Different types of target questions

When planning data collection questions for interviews, there are a number of types of questions we have as tools to create our target que...

read more "Different types of target questions"

Different types of Interviews

When we are constructing interview questions, there are a range of question types that we can consider, depending on the types of intervie...

read more "Different types of Interviews"