[Accessed 6 April 2020].
Kind regards,
Thank u Derek Your lectures are effectively informative and easily understood. They are clear and organized.
I’m so glad I came across this website. Thank you Derek !!!
You’re welcome, Rabia 🙂
Dear Derek,
Thanks for your extremely useful video tutorials. Please can you send me a link to open your Lit Review Excel Templates.
Thanks for your feedback. You can download the template following the instructions in the orange box.
All the best with your studies!
great effort
Thank you for this document. I am in the beginning stages of the dissertation process.
You’re welcome, Jerry 🙂
The video on literature review was very useful. I especially like the cataloging suggestion.
Great to hear that, Rishi. All the best for your research!
I`m busy writing my minor dissertation my master’s in engineering. I’m following your videos on youtube for writing a literature review. I’m looking for the excel sheet to save a list of references.
The literature video was helpful. Thank you. I haven’t received the excel template its been a week now . Please assist me .
Hi Morakane
That’s very unusual. At most, it should take a few minutes. Please re-attempt the download (use an alternative address if need be).
Thank you for the template. it seems useful to organize my literature review.
You’re very welcome.
Thank you for this informative site and all the tips. Very useful for my research.
You’re welcome, Feyi.
Currently writing a dissertation for a masters in social sciences. Found the youtube videos which are of great help.
You’re most welcome 🙂 Good luck with your literature review.
Thank you very much for the support!!
your videos are great helpful.
Glad to hear that! Good luck with your lit review.
You are the BEST
Thanks for the feedback, Annie. I wish you best of luck with your literature review.
where is the download link for the excel template?
Hi Lebogang
The download is below the first image. Good luck with your literature review!
Your videos literally saved me!!!! Due to recent issues, most of my classes were cancelled and i was completely lost. No words can explain how much grateful i am to you!!
Glad to hear we helped you! Good luck with your literature review.
You guys are the kinds of people who should survive covid-19. You are the type of people we really need in this planet. You are a star. You really saved me from many headaches. Thank you very much for the useful videos and the literature organisation spreadsheet.
Thanks for the kind words, Abel. All the best for your literature review!
Thanks so much for your video. I have consistently received comments that my arguments don’t flow well and I could never figure out how to successfully fix this issue. Now I feel I have a plan and someone to help me and provide feedback if I still don’t get it quite well. Looking forward to getting an improved mark on my next Lit review Thank you
Great to hear that, Helen. Good luck with your future literature reviews!
Excellent lecture
Thanks Biren – good luck with your literature review
i have watched your video on three steps to write a literature review and i found it very useful. thank you for sharing. keep it up.
Thanks again
Thank you for providing such excellent information and sources. Your videos helped me so much. I was on the verge of quitting. Thank you again for your videos and recommended tools.
Great to hear that, Tanya. All the best for your literature review, and for your research.
The video was very informative and timely for me. I am about to start, so Gradcoach is a source I will be revisiitng
Thanks, Nina – glad to hear that. Good luck with your literature review 🙂
hey your video is awesome I had to make an assignment on literature Review and it helped me to get an outline on how I should start ! i was fed of reading books and online articles. Your video served as a boon and clarified my thought process – how I should move forward .Thank you so much!
Great to hear that, Kavita. All the best with your literature review!
Hi Derek, I have tried unsuccessfully to download the Excel template but it keeps bringing me back to this comment section. Is it a technical issue? Kindly help.
Sorry about that. Can you please send me a screenshot of what you’re seeing – [email protected] . I will send you the template as well.
Best of luck with your literature review.
This is so very helpful!! I am writing my first lit review within a proposal (rather last minute, yikes) and this is so helpful to stay organized!
Pleasure. Good luck with your lit review 🙂
Hi i like the video,it is very helpful especially now that I am working on my proposal for thesis project….Hope I will be able to use the excel template to organize for my literature review
Great to hear that, Faith. All the best with your literature review!
hey Derek this video is absolutely amazing. One problem though I’m one of the few that are struggling to download excel. I keep clicking on it and nothing happens.
Thanks for letting us know. Please email me a screenshot of your error and I’ll sort you out – [email protected]
Thanks, Derek
Thanks a lot! Very well explained and easy to follow…now I guess I have no excuse to actually do the work 😉
Thanks for your comment! Good luck with your literature review.
Your video is very informative and useful. Thanks a lot. I also want to try the template but I can’t the find the download link…
The download button is below the main image.
Very helpful thank you
Hi! It is a big help for beginners, such as me. Thanks a lot for sharing!
Thank you. All the best with your literature review.
This is brilliant, Pls sir, in writing a review article, how deep can u go. Is it necessary to go down to the inception of your area of research?
How do I know the country/region of research article?
This will usually be covered somewhere in the article itself.
I would like this free resource
You’re welcome to download it. The download button is below the main image. Good luck with your literature review 🙂
I’d love to have this resource pls. Thank you so much
You’re welcome to download it. The download button is below the main image.
Thanks for the you tube videos. they are very informative
Thank you so much for the full tutorial with so much detailed information. I’m a Ph.D. Candidate in China. The whole syllabus of the Ph.D. program sucks. Thanks again for sharing all this helpful information. I hope your team will getting better in the future!
You’re very welcome. Good luck writing your literature review.
It’s such a big help for me. Thank you!
I’ve watched your video on writing a research proposal. I am interested in the lit review excel template.
I have watched your lecture video on writing a research proposal. I am interested in the literature review excel template and the book write smarter not harder.
It is very helpful. Thank you for your experience sharing.
You’re welcome – good luck with your literature review 🙂
Good afternoon, I recall listening/seeing in 1 of your videos *of saving the abstract (PDF) together with the excel database. How do you do this? is it also with this excel sheet
Thank you ..your videos are a confidence booster
*How To Write A Literature Review In 3 Steps (Full Tutorial)
Wonderful work !!! Please share more !!!! I will be very happy.
Thanks so much for your precision in your presentation. I have not yet started practicing but it’s one of the best I have come across. More grease to your elbows.
I love every video on research that you ve made so far. Thanks a lot
انت رائع جدا
You’re welcome. Good luck with your literature review 🙂
Excellent work. Very helpful. I am starting in this beautiful activity of writing papers with my research . I am learning a lot. Thank you very much.
Glad to hear that. Good luck writing up your research papers!
Thank you so much for the free Excel document! It’s such a huge time-saver!
You’re most welcome, Rebecca. Good luck writing your literature review 🙂
I am so grateful that I have found you on YouTube!
In the meantime, is it better to make another excel file for another variable of the same thesis or just put all articles of all variables in 1 excel file?
Thank you very much!
The notes have been very helpful to me thank you very much for sharing
You’re most welcome, Juan 🙂
Just recently seen your youtube video. Its very information. I usually gets running out of words while writing literature review. Example: XX et al investigated, YY et al shown that, ZZ et al demonstrated…….. After 4-5 references, I feels like again am repeating the words investigated, demonstrated… Could you please shoe some references with a set of vocabularies that can be used while writing literature review section.
Thank you in advance
Thank you so much. Amazing tutorial. Am feeling educated now. Lol…
Glad to hear that, Frank. Good luck with your literature review!
Very helpful stuff, thank you so much for the free Excel! I’m going to use it for my DBA and get your YT channel.
Hi, thank you for the great insights! I was unable download the template even though I completed the form. Would you be able to help me?
Derek thanks for sharing your sacrifices. I love the clarity and confidence, it takes experience to do such.
I just downloaded the excel template for LR coupled with the explanation on how to use. I found it useful, thank you!
Do you have any recommendations for adding Key quotes from a reference ?
Great content. Template very useful
Awesome! An answer to my prayer. I found this in time I need it most. Thank you for the spirit of service.
You’re most welcome, Jojo. Good luck with your literature review.
I am really impressed. This discussion helped me a lot to reconsider a lot of issues.
Thanks for the kind words. Good luck with your literature review!
This is amazing! I really like the guidance you are giving here. However, can you throw more light on the ‘category’ columns for me? I’m really nit clear on that. Thanks
Thanks for your comment. Please see my reply to Sasquia’s question re the same thing.
Good luck with your research!
I have been sitting on an enormous amount of articles for months with difficulties in organizing them until i discovered your video on literature review (YouTube). It brought me to this page where you also had a free template for us. Research process is so much bearable now than i expected. Highly recommended for all researchers. Thank you very much.
Great template. Quick question: Are the categories KEYWORDS that I draw from each source? or pre-planned TOPICS that I come up with to organize the source content?
Thanks for your comment. You can use the category columns in whichever way works for you. It would be different for each student depending on the nature of their research and their research objectives.
Hi there, can you suggest how the corresponding literature resources are best saved into a document folder for retrieval later.
I have seen some suggesting using a unique identifier in a master tab in the spreadsheet so as to be able to create a separate tab for quotes or similar thus using the id as the link
But no one has gone on to say if they are also saving the source document in a folder and naming it 57 or author last name, title or other.
I checked out your Literature Kickstarter and the screen shot of the articles didn’t look to correspond with the catalogue. Have been meaning to sort out my reference folders for sometime and am inspired by the use of an excel spreadsheet but not sure what to name files (currently saved in theme folders) Any help would be gratefully received. Thanks
I am happy if I get a catalogue excel template on the research are of zeolite synthesis from local clay for water treatment mechanism. I need help.
I love the template! But I would like to change the name of some of the headings, used in the dropdown, i.e. change “Audio Recording” to “Podcast”. How could I do that?
Very helpful!
Great!!! Very handy.
Thankyou so much. The excel file is really helpful. This really means and is helping a lot for me.
Hello, please, how can i get your excel document to catacogue the ideas for my literature review. Can you also assist on how to build the methodology section of my literature review? Thank you in advance.
I’m a student from Indonesia..This is very useful for me.. Thank you Derek..
What is the better, download all literatures and then log them into the excel sheet or do that for one by one?
Dear Derek.
I was utterly stressed when taking on an MSc Educational Leadership distance learning degree after 30 years of no academic studying. However, I found your literature review tutorial on Youtube and I immediately experienced a sense of calm direction. I am working full time in the Cayman Islands and am native Afrikaans speaking, so it was such a great help with my literature review for my first assignment. However, I have to write an evaluative essay for my second module and can not find any tutorial done by you about this. Do you perhaps have a template I could use? I have also used your services for editing and proofreading and am super grateful for the amazing help I have received! THANK YOU!
Hi Mr Derek,
It really really helps me to summarise my LR in Excel form and start-up writing
Hi Derek I have tried to download the template and it has failed to. I am not receiving the email either, could this be network issues.
Hi Derek I have been able to download the template. thank you for all your support. let me get started
I have downloaded the template. I would like to print out the guide so I can easily follow. Hope that is fine with you.
THANKS A LOTTTTT This template is exactly the one I needed when reading the literature review for my Bachelor’s dissertation
Thank you so much for your support ,I have downloaded your template and it is amazing .
Derek, The products you and the team members have put together continue to provide exemplary help as I finish the journey toward completing my dissertation! I wish I would have known of GradCoach during both of my MBAs. It could have helped alleviate a lot of time and frustration! I look forward to learning and seeing new things as I complete the dissertation.
Thanks for the kind words 🙂
Can data will be entered in excel sheet automatically like in Mendeley or i have to enter manually, pl?
Thank you GRADCOACH, I’m keenly following your tutorials as I’m about to start my literature review. These videos have been very helpful. So for the literature review you recommend only checking abstract, introduction and conclusion of the relevant literature?
Thanks for providing such an amazing resource.
I wish I knew about this when I was doing my masters. I’m doing my PhD now and sitting on Word files of reference lists and quotes I made for my MEd. This catalog will help me to keep everything more organized in one place. I’ve already started making your template my own by adding additional columns that are important for my research topic. One of the best features of your template is the Literature summary page. My question is how do I get the information I put into my new columns to auto-populate with descriptive statistics on the Literature Summary page?
Hi, I still don’t understand what you would put as ‘Category 1’, ‘Category 2’, ‘Category X’. Are they like the sort of big topics covered in the paper?
This is very helpful
Your email address will not be published. Required fields are marked *
Save my name, email, and website in this browser for the next time I comment.
These steps for conducting a systematic literature review are listed below .
Also see subpages for more information about:
Consider the PICO Format: Population/Problem, Intervention, Comparison, Outcome
Focus on defining the Population or Problem and Intervention (don't narrow by Comparison or Outcome just yet!)
"What are the effects of the Pilates method for patients with low back pain?"
A "scoping search" investigates the breadth and/or depth of the initial question or may identify a gap in the literature.
Eligible studies may be located by searching in:
When searching, if possible, translate terms to controlled vocabulary of the database. Use text word searching when necessary.
Use Boolean operators to connect search terms:
Search: pilates AND ("low back pain" OR backache )
Video Tutorials - Translating PICO Questions into Search Queries
Expand your search strategy with synonymous search terms harvested from:
(pilates OR exercise movement techniques) AND ("low back pain" OR backache* OR sciatica OR lumbago OR spondylosis)
As you develop a final, reproducible strategy for each database, save your strategies in a:
Use database filters to limit your results based on your defined inclusion/exclusion criteria. In addition to relying on the databases' categorical filters, you may also need to manually screen results.
NOTE: Many databases allow you to filter to "Full Text Only". This filter is not recommended . It excludes articles if their full text is not available in that particular database (CINAHL, PubMed, etc), but if the article is relevant, it is important that you are able to read its title and abstract, regardless of 'full text' status. The full text is likely to be accessible through another source (a different database, or Interlibrary Loan).
Selected citations and/or entire sets of search results can be downloaded from the database into a citation management tool. If you are conducting a systematic review that will require reporting according to PRISMA standards, a citation manager can help you keep track of the number of articles that came from each database, as well as the number of duplicate records.
In Zotero, you can create a Collection for the combined results set, and sub-collections for the results from each database you search. You can then use Zotero's 'Duplicate Items" function to find and merge duplicate records.
Covidence is a web-based tool that enables you to work with a team to screen titles/abstracts and full text for inclusion in your review, as well as extract data from the included studies.
The PRISMA (Preferred Reporting Items for Systematic reviews and Meta-Analyses) flow diagram is a visual representation of the flow of records through different phases of a systematic review. It depicts the number of records identified, included and excluded. It is best used in conjunction with the PRISMA checklist .
Example from: Stotz, S. A., McNealy, K., Begay, R. L., DeSanto, K., Manson, S. M., & Moore, K. R. (2021). Multi-level diabetes prevention and treatment interventions for Native people in the USA and Canada: A scoping review. Current Diabetes Reports, 2 (11), 46. https://doi.org/10.1007/s11892-021-01414-3
There are a number of reporting guideline available to guide the synthesis and reporting of results in systematic literature reviews.
It is common to organize findings in a matrix, also known as a Table of Evidence (ToE).
Cook, D. A., & West, C. P. (2012). Conducting systematic reviews in medical education: a stepwise approach. Medical Education , 46 (10), 943–952.
IMAGES
VIDEO
COMMENTS
Sheet1 What is the author studying? (research question/ hypothesis),How does the author study the issue? (methodology),What did the author find? (analysis/discussion),Unanswered questions about the article (for further research) Article/Author 1 Article/Author 2 Article/Author 3 Article/Author 4...
The Major Spreadsheet. In her post called " How I Use Excel to Manage My Literature Review," Elaine Campbell outlines her approach to using a spreadsheet to manage literature. I call her approach the Major Spreadsheet, because she is mapping out a very large body of literature for her doctorate in a single spreadsheet.
The literature review template includes the following sections: Before you start - essential groundwork to ensure you're ready. The introduction section. The core/body section. The conclusion /summary. Extra free resources. Each section is explained in plain, straightforward language, followed by an overview of the key elements that you ...
Even though Excel can get complicated if you set up formulas or other customizations, for a literature review spreadsheet you usually can just use it as a simple table. So far, the advantages listed apply to Word as well, but Excel and Citavi have one crucial advantage over Word: it lets you search, sort, and filter.
Notion is an organization application that allows you to make various pages and databases. It's kind of like your own personal wiki- you can link your pages and embed databases into another page, adding filters and sorting them using user-set properties. The databases are what I use the most.
Examples of literature reviews. Step 1 - Search for relevant literature. Step 2 - Evaluate and select sources. Step 3 - Identify themes, debates, and gaps. Step 4 - Outline your literature review's structure. Step 5 - Write your literature review.
Okay - with the why out the way, let's move on to the how. As mentioned above, writing your literature review is a process, which I'll break down into three steps: Finding the most suitable literature. Understanding, distilling and organising the literature. Planning and writing up your literature review chapter.
To enable screen reader support, press Ctrl+Alt+Z To learn about keyboard shortcuts, press Ctrl+slash
Institutional Manuscript Paper A Comprehensive Guide For Academic Writing. View our free and editable Literature review templates for Excel or Google Sheets. These Literature review spreadsheet templates are easy to modify and you can customize the design, the header, table, formulas to suit your needs. Download now to finish your work in minutes.
Demonstrate your knowledge of the research topic. Identify the gaps in the literature and show how your research links to these. Provide the foundation for your conceptual framework (if you have one) Inform your own methodology and research design. To achieve this, your literature review needs a well-thought-out structure.
2. Scope the Literature. A "scoping search" investigates the breadth and/or depth of the initial question or may identify a gap in the literature. Eligible studies may be located by searching in: Background sources (books, point-of-care tools) Article databases; Trial registries; Grey literature; Cited references; Reference lists
Here are some examples of different review matrices and templates: Evidence Synthesis Matrix Template, Jane Schmidt, Toronto Metropolitan University (Google Sheets) The Matrix Method for Literature Reviews, Brandeis University, Writing Resources. Literature Review Synthesis Matrix, Concordia University (MS Word) Write a Literature Review ...
Step 1: Select the Ideal Literature. Start by locating all the existing research on your topic that could help answer your primary questions. Some strategies for this step include: Scanning Google Scholar - Google's academic search engine - for the articles that apply to your research. Use keywords for the best results.
This is called a review matrix. When you create a review matrix, the first few columns should include (1) the authors, title, journal, (2) publication year, and (3) purpose of the paper. The remaining columns should identify important aspects of each study such as methodology and findings. Click on the image below to view a sample review matrix.
A literature review is a critical analysis of published research on a particular topic. It involves reviewing and analyzing a range of sources, such as academic articles, books, and reports. Students conduct a literature review before writing a research paper or dissertation to gain an understanding of the existing knowledge and recognize areas for further exploration.
A literary review template is a type of written work that discusses published information about a specific subject matter. The length of the review doesn't matter. It can be as simple as a summary of sources or can be as long as several pages. An outline for literature review can also evaluate these sources and advise to the readers regarding ...
By Dr. Juniper Katz, Ph.D. January 30, 2018. In this post, I discuss using Google Forms to organize a literature review with co-authors. Google Forms is designed to be used as survey software, but I have found it works for article reviews as well. Google Forms gathers responses to form fields and sends that data to a Google Sheet.
Doing the conceptual synthesis Excel dump as you do your reading allows you to create a nice map of the literature. It also helps reach conceptual saturation during the literature review." Pacheco-Vega's blog post includes screen captures and shows how columns in the spreadsheet are organized.
make the task any easier, and indeed for many, writing a literature review is one of the most challenging aspects of their academic writing. In this study guide, I will begin by clearing up some misconceptions about what a literature review is and what it is not. Then, I will break the process down into a series of simple steps, looking at
This template is pre-loaded with a small sample of articles so you can get a feel for how everything works, how the tables are connected, and the different template features. When you're ready to get started with your own review, you can delete all the example data with the following button:
We developed a template, just for you. Now you can keep on top of your literature using our intuitive literature review spreadsheet-based catalogue template. The spreadsheet will not only keep everything organized; it will also provide a summary of key metrics. Download The Literature Catalogue Template (Free)
The PRISMA (Preferred Reporting Items for Systematic reviews and Meta-Analyses) flow diagram is a visual representation of the flow of records through different phases of a systematic review. It depicts the number of records identified, included and excluded. It is best used in conjunction with the PRISMA checklist.
2. MOTIVATE YOUR RESEARCH in addition to providing useful information about your topic, your literature review must tell a story about how your project relates to existing literature. popular literature review narratives include: ¡ plugging a gap / filling a hole within an incomplete literature ¡ building a bridge between two "siloed" literatures, putting literatures "in conversation"