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
Keywords
Google Apps Script, synthetic method, automation, education sector, data analysis, digital tools
References
1. Al-Emran, M., & Malik, S.I. (2016). The impact of Google Apps at work: Higher educational perspective. International Journal of Interactive Mobile Technologies, 10(4), 85-88.
2. Cannon-Bowers, J.A., & Bowers, C.A. (2007). Synthetic learning environments. In J.M. Spector, M.D. Merrill, J. van Merrienboer, & M. P. Driscoll (Eds.), Handbook of research on educational communications and technology (pp. 317-327). Mahwah: Lawrence Erlbaum.
3. Conner, N. (2008). Google Apps: The missing manual. USA: O’Reilly Media, Inc.
4. Ferreira, J. (2014). Google Apps Script: Web application development essentials. USA: O’Reilly Media, Inc.
5. Gabet, S. (2014). Google Apps Script for beginners. Birmingham: Packt Publishing Ltd.
6. Ganapathy, R. (2016). Learning Google Apps Script. Birmingham: Packt Publishing Ltd.
7. Gendron, M.S. (2014). BI and the cloud: Strategic implementation guide. New Jersey: John Wiley and Sons.
8. Google Workspace. (n.d.). Apps Script. Retrieved from https://developers.google.com/apps-script.
9. Horváth, G., & Menyhárt, L. (2014). Teaching introductory programming with JavaScript in higher education. Proceedings of the 9th International Conference on Applied Informatics, 1, 339-350. doi: 10.14794/ICAI.9.2014.1.339.
10. Nguyen, P. (2023). Google workspace for education: A study and case usage of Google Apps in the classroom. Research Bulletin of Keiwa Gakuen University, 23, 105-119.
11. Sclater, N. (2010). Cloud computing in education: Policy brief for UNESCO Institute for Information Technologies in Education. moscow.
12. Shiohara, K. (2014). Using cloud computing platforms for developing software applications at low cost. In Proceedings of the International Conference on Applied Computing (pp. 3-10).
13. Voitovych, I.S., et al. (2019). Cloud technologies in educational institutions: Monograph. Kyiv: RPV NPU named after M. P. Drahomanov.
14. Vouk, M. A. (2008). Cloud computing: Issues, research and implementations. Journal of Computing and Information Technology, 16(4), 235-246. doi: 10.2498/cit.1001391.
