Creating a dropdown list in an Excel sheet, Part 2

This post will walk us through setting up a multiple item drop down selection list in an Excel spreadsheet using a bit of VB code from a vl...

read more "Creating a dropdown list in an Excel sheet, Part 2"

Creating a dropdown list in an Excel sheet, Part 1

I am a member of an organisation which requires me to log my PD each year, using a web portal. However, the web portal itself has made the l...

read more "Creating a dropdown list in an Excel sheet, Part 1"

Have you heard...?

When I am working with my students, I try to use only evidenced data, and to check that data carefully. So when a student suggested in a cla...

read more "Have you heard...?"

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"

Sticky naming for anonymising participants

Earlier this year, Pat Thomson of "Patters" fame wrote a great blog post on how to anonymise participants via a naming schema. She...

read more "Sticky naming for anonymising participants"

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"

Sports project data sources

The American Psychological Association regularly run webinars on style, referencing, data, and library services, which are then made public ...

read more "Sports project data sources"

Cross-group comparison where there is little data

When we are trying to evaluate something, such as an assessment, we need to know what the norms are for the base culture, to be able to make...

read more "Cross-group comparison where there is little data"

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"

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 "

Cleaning up Facebook activity

In July of this year I posted on how to delete our old Facebook activity ( here ), but Facebook themselves moved on with new platform update...

read more "Cleaning up Facebook activity"

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"

Stages of data analysis

In a previous post ( here ), I discussed four steps of Schutt's data analysis model. However, in his text, Schutt outlines five steps. ...

read more "Stages of data analysis"

Four data analysis steps

Flow Model of Qualitative Data Analysis Components (Schutt, 2011, p. 326) As I explained in a previous post ( here ), we can use Excel...

read more "Four data analysis steps"

Data wholes and holes

A kaleidoscope metaphor describing one approach to analyzing qualitative data (Suter, 2011, p. 349) I have recently had an undergraduat...

read more "Data wholes and holes"