LIA Method for the Application of Microsoft Excel in Data Tabulation in Systematic Reviews

Miñan G.S.; Moreno J.A.; Fernández X.D. · CEUR Workshop Proceedings (2023)

Resumen

The objective of this research was to design an office tool for data tabulation in systematic reviews with a quantitative approach. Therefore, in the methodological aspect, the research was applied, with a qualitative approach and a descriptive scope. A research/action design was used, which is a type of qualitative research that aims to solve everyday and immediate problems, and improve concrete practices, in this specific case, data management in systematic reviews. The results described the use of tables, dynamic tables, forms, code in Visual Basic, among other aspects. In that sense, a tool was designed in Microsoft Excel that was able to record research, process it orderly and extract information through graphs and tables for their respective bibliometric and content analysis. Finally, it was concluded that a computer solution based on Microsoft Excel is viable for the development of systematic reviews due to its low cost, flexibility and robust capacity for handling large amounts of data.

Instituciones: Universidad Tecnológica del Perú