How to structure Microsoft Excel documents for systematic reviews.

IF 16.4 1区化学 Q1 CHEMISTRY, MULTIDISCIPLINARY Accounts of Chemical Research Pub Date : 2023-03-08 Epub Date: 2023-03-01 DOI:10.7748/nr.2023.e1866

Lea Godino

{"title":"How to structure Microsoft Excel documents for systematic reviews.","authors":"Lea Godino","doi":"10.7748/nr.2023.e1866","DOIUrl":null,"url":null,"abstract":"Background: Systematic reviews are complex and involve time-consuming, deep research in the academic literature to search, extract data, assess their quality and report the results. Digital tools and software have been developed to simplify different phases of this process but some of these are not free to use. Microsoft Excel is typically accessible to a great many researchers free of charge, so using it involves no further costs.Aim: To explain how to use Microsoft Excel to create transparent and complete reports for systematic reviews.Discussion: The author's method includes six steps: downloading the references, preparing worksheets, removing any duplicate references, screening the references by title and abstract, screening the full text of references, and listing the articles for inclusion in the review.Conclusion: The Excel method is efficient and free and can produce transparent and complete reports of systematic reviews. It is a valid alternative to the systematic reviews produced by advanced tools and software.Implications for practice: The documents produced by this method are a good source for the direct production of scientific texts.","PeriodicalId":1,"journal":{"name":"Accounts of Chemical Research","volume":null,"pages":null},"PeriodicalIF":16.4000,"publicationDate":"2023-03-08","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"1","resultStr":null,"platform":"Semanticscholar","paperid":null,"PeriodicalName":"Accounts of Chemical Research","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.7748/nr.2023.e1866","RegionNum":1,"RegionCategory":"化学","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"2023/3/1 0:00:00","PubModel":"Epub","JCR":"Q1","JCRName":"CHEMISTRY, MULTIDISCIPLINARY","Score":null,"Total":0}

引用次数: 1

Abstract

Background: Systematic reviews are complex and involve time-consuming, deep research in the academic literature to search, extract data, assess their quality and report the results. Digital tools and software have been developed to simplify different phases of this process but some of these are not free to use. Microsoft Excel is typically accessible to a great many researchers free of charge, so using it involves no further costs.

Aim: To explain how to use Microsoft Excel to create transparent and complete reports for systematic reviews.

Discussion: The author's method includes six steps: downloading the references, preparing worksheets, removing any duplicate references, screening the references by title and abstract, screening the full text of references, and listing the articles for inclusion in the review.

Conclusion: The Excel method is efficient and free and can produce transparent and complete reports of systematic reviews. It is a valid alternative to the systematic reviews produced by advanced tools and software.

Implications for practice: The documents produced by this method are a good source for the direct production of scientific texts.

查看原文

微信好友朋友圈 QQ好友复制链接

本刊更多论文

如何为系统综述构建 Microsoft Excel 文档。

背景：系统性综述非常复杂，需要耗费大量时间深入研究学术文献，以搜索、提取数据，评估其质量并报告结果。为了简化这一过程的各个阶段，人们开发了一些数字工具和软件，但其中有些工具和软件并不是免费使用的。许多研究人员通常都可以免费使用 Microsoft Excel，因此使用它无需额外费用。目的：解释如何使用 Microsoft Excel 为系统综述创建透明、完整的报告：作者的方法包括六个步骤：下载参考文献、准备工作表、删除重复的参考文献、按标题和摘要筛选参考文献、筛选参考文献全文、列出纳入综述的文章：Excel 方法高效、免费，可生成透明、完整的系统综述报告。结论：Excel 方法是一种高效、免费的方法，可以生成透明、完整的系统综述报告，是高级工具和软件生成的系统综述报告的有效替代方法：对实践的意义：该方法生成的文件是直接生成科学文本的良好来源。

本文章由计算机程序翻译，如有差异，请以英文原文为准。

求助全文

约1分钟内获得全文去求助

来源期刊

Accounts of Chemical Research 化学-化学综合

CiteScore

31.40

自引率

1.10%

发文量

312

审稿时长

2 months

期刊介绍： Accounts of Chemical Research presents short, concise and critical articles offering easy-to-read overviews of basic research and applications in all areas of chemistry and biochemistry. These short reviews focus on research from the author’s own laboratory and are designed to teach the reader about a research project. In addition, Accounts of Chemical Research publishes commentaries that give an informed opinion on a current research problem. Special Issues online are devoted to a single topic of unusual activity and significance. Accounts of Chemical Research replaces the traditional article abstract with an article "Conspectus." These entries synopsize the research affording the reader a closer look at the content and significance of an article. Through this provision of a more detailed description of the article contents, the Conspectus enhances the article's discoverability by search engines and the exposure for the research.