Systematic Literature Review – Managing duplicates
11/07/2024
![despaired-2261021_1200](https://blogs.cranfield.ac.uk/wp-content/uploads/2024/06/despaired-2261021_1200.jpg)
One of the questions which often comes up when discussing the SLR process is how do I manage my references in the most efficient way during the process of going from my search results to my final list of articles?
Each step of the SLR process has its own challenges. You need to identify your keywords, then construct your search strings, then work out the combinations of the search strings and which databases to use e.g., EBSCO Business Source Complete, ProQuest One Business, Scopus, Web of Science, in order to retrieve the articles which are key to your research topic.
Not all the articles retrieved will be relevant and you will need to filter your initial results sets according to the inclusion and exclusion criteria you defined in your protocol. You will begin by screening the title and abstract against your inclusion and exclusion criteria, and then against the full text. At each stage you will need to document:
- how many articles there were
- for each of your search string combinations
- from each of your chosen databases.
Sounds simple enough, until you realise that there will inevitably be duplication between the sources…
The good news is that you can export all of your references, with abstracts, directly from each of these resources. The download option to use for EBSCO Business Source Complete and Scopus is the CSV option. For ProQuest One Business it is XLS and for Web of Science it is Excel.
EBSCO Business Source Complete
Add your search results to a folder. Then go to your folder, select all the articles and use the Export function to export your results to a CSV file. Once exported, save your results as an Excel file.
ProQuest One Business
You can add your search results to a folder in ‘My research’ or export your results to Excel direct from the search results page. To do this, click on the three dots (ellipsis) to open the ‘All save & export options’ and select the XLS Microsoft Excel Format. Note you can export up to 100 articles at a time.
Scopus and Web of Science
You can export your results direct from the results page of both of these indexes by selecting the Export option and following the instructions given.
Once you have downloaded the information into Excel, you can then use the power of Excel to help you tag, filter and sort your references so that you can easily identify duplicates and also keep track of which references were found in each database.
ExcelDemy provides further guidance on how to use Excel to remove duplicates, which you may find useful.
Other blog posts you may find useful:
- Systematic Literature Review – Where do I begin?
- Systematic Literature Review – Selecting your Sources
- Systematic Literature Review – Identifying your search terms and constructing your search strings
- Systematic Literature Review – Combining your search strings to create your search strategy
Because of the complexity of this process, we recommend that before embarking on a systematic literature review you speak with your Librarian who will be happy to provide guidance.
Image by kirill_makes_pics from Pixabay
Categories & Tags:
Leave a comment on this post:
You might also like…
Bank holiday hours for Library Services: Monday 26 August
Library Services staff will be taking a break on Monday 26 August for the bank holiday. You will still be able to access all the resources and help you need via our library website. The 24/7 ...
MSc student Alessandra Khaing Oo: My experience as a woman in the motorsport industry
Alessandra Khaing Oo will graduate from Cranfield University with an MSc in Advanced Motorsport Mechatronics in September 2024. Here, Alessandra talks about her journey from Myanmar to the UK, how she ...
The practices of sustainability in banking are driven by a host of organisational factors
It is intriguing to know that the revenue potential for banks supporting the transition to a sustainable future could average $100 billion annually by 2030. [1] The concept of sustainability has been gaining popularity among banking leaders, ...
A celebration of life and Computational Fluid Dynamics
On Friday 28 June 2024, our Aerospace Integration Research Centre (AIRC) held a special afternoon event in memory of Stephen Billett, a cherished alumnus of the very first cohort of our MSc in ...
Is your airport ready for climate change?
Climate hazards are increasingly disrupting the normal functioning of airports worldwide, leading to damage, operational performance or safety issues, economic loss, and other business or environmental and social consequences. Widescale flooding ...
Coming to Cranfield as a local
"Cranfield used to be a place I’d drive by without knowing what happens there but now it is somewhere that has significant meaning to me. During my time here, I’ve been exposed to all ...