i'm going to pull up an excel spreadsheet here in a minute um i wanted to share one of the ways that i tracked the literature that i was reading for my literature review i didn't want to pull it up quite yet because it can be overwhelming and i just want to brace you that it's a lot of information but i'm going to talk you through what all's included and how i actually pulled all this information up okay so what i did is all of my let me go through the top row so you can see what information i pulled from the research in column a i'm a geek i need paper so i printed all of these articles and put them in binders based on topics so i have a binder on virtual work one on psychological capital work engagement one just on work engagement etc so that's what that first row is all about then i went through with each of the articles let me be clear this is all cut and paste from pdf documents okay none of this is anything that i wrote it's just stuff that i pulled out so that i could quickly go through it and find things as i was writing and quickly do some analysis so here's the year of the article here's the author the theoretical framework that they used so kind of a mix i wanted to be able to filter if they were using the same theoretical framework that i used the research method was it quantitative was it qualitative was it a meta-analysis literature review etc the research design who the target population was and a lot of this information you can pull straight from the abstract what country it was conducted in what the sample size was what instruments they used this was really helpful when you want to talk about especially in chapter 3 when you want to talk about other studies that use the instruments that you used then what did they find again this you can pull this all from the abstract if you want more details you can go uh to the discussion at the end of the article and then future research suggestions okay again these are all cut and paste you can find them and pull them out from the discussion and at the end of the articles okay now how did i use this this is a lot of work put a lot of time into it but when i was writing chapter through two and chapter three here's how i use this and and why it was so helpful if i wanted to just look at quantitative studies you can see i've got my filter options on if you don't know how to turn on your filters you go up to the tab go to data and you'll click on the filter button okay it'll turn those on and off you just leave them on and you can filter so if i want to look at just quantitative studies i'm going to select the filter button and i'm going to deselect everything i only want to look at quantitative studies this will automatically filter everything that i've got in this matrix so that i can quickly look at okay did we have any studies in the us that were quantitative here's one um or maybe let's do let's filter down one more let's look at specifically let's look at correlational and clearly i had a typing issue so there's a couple of different things in here let's pull up all of these okay so everything that's here and you'll see down in the bottom left 34 out of the 167 records that i have here are quantitative studies that are correlational to some degree okay well let's dig down further maybe i only want to look at those that used the psychological capital questionnaire the 24 item oh look there's only one okay so if i wanted to talk about a quantitative study that used the pcq 24 i have filtered all the way down and i can look at this and if i need to go and look at the full article i can grab it because i know it's kim at all 2019. okay then you just go back in here select all well let me just deselect everything select all and you'll see it's cleared select all and it's going to put everything back okay so this is just my tool and my way of working uh with the matrix and working with the literature and being able to quickly flip back and forth to find certain things if this would be helpful for you uh feel free to reach out to me you can comment here on the video or you can reach out to me via email i'm happy to send you this excel file i'll clean it out so you don't have my notes in there but you're welcome to use this it's you can set it up similarly or i can send you my template i'm happy to do that and hopefully it's something that you'd be able to use and will be helpful as you're writing your dissertation