Automating data analysis in scientific research of future education specialists using the Google Apps Script platform

Abstract

Abstract. The article focuses on the role and potential of using the Google Apps Script platform as a tool for automating data analysis in scientific research for future specialists in the educational sphere. Thus, the article aims to systematize and summarize information about the possibilities and advantages of using digital tools, particularly the Google Apps Script platform, for automating data analysis in scientific research. The following research methods were employed: analysis and summarization of technological capabilities and practical cases using the Google Apps Script platform based on existing scientific and methodological sources, modelling, and synthesis of obtained data. This contributed to understanding and assessing the potential of the designated tool for use by future specialists in the educational sphere. The possibility of optimizing various stages of scientific research using Google Apps Script was thoroughly analysed, particularly in data filtering and summarization, statistical analysis, creating graphs, and reporting. Considering the prospects of applying the synthetic method in the research process, the role of the specified tool in creating and expanding data for objective analysis is emphasized. The Google Apps Script platform facilitates the effective combination of analytical capabilities and automation, allowing researchers to better synthesize the obtained results and react promptly to the identified trends. Such a comprehensive approach to data processing creates unique opportunities for innovative research in the field of education, making it more accessible and interactive for use by researchers and practitioners. As a result of the study, the significance of digital tools, including the Google Apps Script platform, in preparing future education professionals was highlighted. The advantages and possibilities of this tool for implementing innovative approaches in data analysis in the field of scientific research were pointed out, emphasizing its potential for developing new methodologies and approaches in this field. In the context of the on-going evolution of educational approaches, the Google Apps Script platform serves not only as a data analysis tool but also as a catalyst for innovative thinking. In summary, it is worth noting that Google Apps Script is a powerful tool that provides opportunities for automating complex data processing processes in scientific research, even when employing the synthetic method. The use of this tool opens up possibilities for efficient analysis and processing of large volumes of information, even when it is critical, overcoming this challenge in modern scientific work. Its capabilities enable researchers to focus on essential aspects of research, reducing time spent on routine data processing operations.