>> This is the 6th video in our series showing you how
to use the CDC Excel Tool for Qualitative Analysis.
This video will review the example thematic analysis
provided to you in the tool.
As a note, thematic analysis is a very subjective process
and interpretation of the codes will heavily depend upon your
analytic questions.
You may interpret this example that we've provided differently
than we do and that's okay.
This is purely to show you how the thematic example workspace
can be used.
So the first thing that we need to do is copy a pivot table
into this thematic analysis workspace sheet.
And we've provided you
with 2 blank thematic analysis workspace sheets and a worked
out thematic analysis example.
If you require more space or want
to do more thematic analyses
than this space provided allows you, you can simply make copies
of these blank sheets and continue to work in them.
So the first thing that we need
to do is copy a pivot table into this sheet.
For this example, we're interested
in how people are dealing with the epidemic, so we'll go back
to Pivot Table #1, which we reviewed in the previous video,
and we will copy all the codes and text segments
that appear below the "About people dealing
with the epidemic" code
and we will also copy the counts of the data.
So we will copy it and paste it into Column B
of the thematic analysis workspace.
Now in order to read all of these, we may want to go in
and just have the text wrap so that we can see all
of the information in the segments.
In Step 2, we'll read through each of these text segments
and their codes and work on categorizing and regrouping them
so that similar codes and text segments are together.
Again, this is the subjective part of the process
and you may decide to group them differently than we have.
So we may decide that while reading through the "Challenges
in protecting self or others' code
and the "reporting others self-protective steps"
that these codes are both related to self-protection
and we want to group them together.
So we will copy over the "Challenges in protecting self
or others" and then the "action reporting other'
self-protective steps."
At the top of this, we want to make a note
as to why we're making this decision.
And then we may decide that codes related to "action of how
to protect oneself," excuse me, "strategy of how
to protect oneself" also should go within this group.
So I've gone ahead and created 2 more groups using codes related
to concern grouped together and then codes related
to information grouped together.
Next in Step 3, I'm going
to keep those same categories from Step 2--
just copy those over into the next column.
And then I'm going to read through each quote
and write a sentence or 2 about what this segment means
in the context of the group that I've put it with.
So for this text segment here, I will write a sentence
or 2 about what this means in the context of self-protection.
So as I'm making this interpretation, I might realize
that actually this particular text segment fits better
with the category that I've already created,
which was information category.
And so I'll want to note that somewhere--
And then I may want to copy both of these down so that they are
under the information grouping.
You may have to add rows or cells to rows as you go
so that you can organize this information,
or you may also need to create new groupings if the groupings
that you created in Step 2 don't fully cover all of the things
that are being talked about in here.
So again, I skipped ahead and added all my interpretations
for each of the codes here into Column E. Then on to Step 4
and here I'm going to read my own summaries for each
of the groups, so I'm going to read through all the summaries
that I've written for the codes related to self-protection.
And then I'm going to write a few sentences that help
to summarize the entire group.
If I've moved some quotes around, like I've removed,
I've moved this quote down to fits better
with information and this quote.
I may want to bold the quotes that are remaining just
so that it's easier or quicker to see,
you could also make them a different color,
whatever your preferences as you're doing this.
So I'm going to copy over my group headings.
And then I'm going to write in my interpretation of all
of the things that I've written for this group.
And I also want to identify what I think is a representative
quote, so I may want to go back to what I have here in Step 2,
which were the original quotes from the people
who were actually interviewed
and identify representative quotes
that I think will best represent this category as a whole.
I'm just going to pick one quote
but you can pick as many as you like.
So I've gone ahead now and done this for each category,
so I have a short sentence
that summarizes what I had already found in the groups
from the previous step, and then a representative quote
for each of the groups.
Now in Step 5, we're going to bring the summaries together
with information about how common the codes were
in our text.
And for Steps 5 and 6, you may find it easier to write
up your thoughts in a Word document
as it can be somewhat tedious to edit a narrative
or long codes of text in Word.
This is a personal preference as to whether you complete Steps 5
and 6 in Excel or Word.
So if you start in Excel and you are having a hard time
and going back to edit a lot and finding it tedious to do
within Excel, feel free to move this into Word
and reference what you've already done in the Excel sheet.
In Step 5, we'll add information from Column C
with the counts of each code.
So we may start with the overall detail code about people dealing
with the epidemic and how common it was.
And we can look back at Pivot Table #1, so we can see
that within this code, there is 13 text segments
that are related to people dealing with the epidemic.
But it would also be useful information
to know how many codes were applied in total.
And to do that, we can very quickly just go back
to Pivot Table #1 which has our broad coding scheme.
And we can see this has the same information, it has 13.
And if we go all the way down to the bottom of the table,
we can see that a grand total of 37 segments of text were coded.
So this may be helpful context to provide
in when we're synthesizing this information.
So within this synthesis--
we will then add information
about each theme using the sentences that we wrote
in Step 4 and representative quotes
that we identified in Step 4.
Finally, once we've synthesized the information,
we can add some interpretation in Step 6.
Here we will want to revisit our analytic questions.
If you listed analytic questions on the analysis objective sheet,
just all the way back here, so if you listed any questions
in these cells of B10, B11, and B12, it will automatically show
up in Column I so that you can remember what your original
goals were.
Questions to consider while interpreting this data will
depend a lot on your actual analytic goals.
However, you may want
to consider what actionable information is contained
in these themes that you've identified
and what future steps you or others may want to take
in response to this information.
So once you've added your interpretation of this data,
you've now completed a thematic analysis of text data.
You can continue to copy in other pivot tables,
so we have space in this first thematic analysis workspace
to do another thematic analysis in the same sheet
and then there's another workspace.
And as I said at the beginning of the video,
you can just continue to copy blank sheets to get
as many thematic analysis workspaces as you might need.
So thank you for watching our series
on using the CDC Excel Tool for Qualitative Analysis.
For additional information about the tool,
including advanced user options,
such as customizing the coding scheme or using the tool
with multiple coders, please see our user guide
that has some more advanced options.