Applying Google Sheet for Action Plan of Sirindhorn College of Public Health Chonburi

Authors

  • Pinkamon Sompeewong Department of Strategy and QA, Sirindhorn College of Public Health Chonburi
  • Saritchai Predawan Department of Strategy and QA, Sirindhorn College of Public Health Chonburi

Keywords:

cloud system, Google Sheet, action plan

Abstract

Background & Rationale: The previous format of data collection to formulate an action plan had many problems and obstacles. While the features of Google Sheet as a tool in Google for Education on the cloud system are fascinating. The purpose of this research was to develop an application for importing budget plan data on projects for the preparation of the annual fiscal action plan of the Sirindhorn College of Public Health Chonburi for the faculty of Public Health and Allied Health Sciences. Methodology: The process of system development life cycle (SDLC) was applied in 6 steps. 1. Google Sheet application development meeting was first launched to the planning and strategy committee of the college administrators (planning). 2. Set the scope of the system in detail covering the system re­quirements in terms of access and security of the system and data management functions to allow the system to collect and export data (defining). 3. Detailed information of the program was analyzed to design the work order and verify data integrity at the system boundaries (designing). 4. Created the database in Google Sheet as designed in the action plans with HTML, CSS, and JavaScript languages (building). 5. Evaluated the usability and functions of the program to improve the program (testing). 6. Installed the program, created user manuals for hands-on training, trained and evaluated user satisfaction for the final improvement of the system (deployment). Result: The developed web application had user interfaces for data import, data processing, data storage, and result presentation. The program used the Google Apps Script language that needed no installation of servers and database systems to the server. However, users were able to access it and collaborate simultaneously at any location with Internet connection. The overall satisfaction rating was high (average 4.1) for the efficiency of using Google Sheet to deliver the action plan of the College. Conclusion: The Google Sheet made it easy to import data, update and edit project plan information to create an action plan for Sirindhorn College of Public Health Chonburi. The process was simple, suitable, reduced duplicate work, and done with the same database consistent with the digital policy of the Faculty of Public Health and Allied Health Sciences, Praboro­marajchanok Institute.

References

Jirapunyachoti P. Applying Google Apps in the management of eduction information. [blog on the Internet]; 2016 [cited 2020 May 2]. Available from: http://nakhonnayok.dusit.ac.th/2016/02/5606.html. (in Thai)

Intichit K, Arreerard W, Sarach C. Development of the application model of Google applications to support educational guidance for higher education institutions. itm.j [Internet]. 2019 Jan 31 [cited 2021 Mar 17];5(2):83-93. Available from: https://ph02.tci-thaijo.org/index.php/itm-journal/article/view/126372. (in Thai)

Plainbangyang S. Effectiveness of information system service of Rajamagala University of Technology Rattanakosin. Veridian E-Journal 2017;10(1):1351-65. (in Thai)

Ferreira J. Google Apps Script, 2nd ed. USA: O’Reilly Media; 2014.

Ganapathy R. Learning Google Apps Script Birmingham, UK: Packt Publishing; 2016.

Faculty of Public Health and Allied Health Science. Strategic plan of Faculty of Public Health and Allied Health Science, 2020-2024. Nonthaburi: Praboromarajchanok Institute, Ministry of Public Health; 2020. (in Thai)

Google. Privacy & terms – Google. Privacy policy [Internet]. 2021 [cited 2021 Feb 2]. Available from: https://support.google.com/a/topic/7556782?hl=th&ref_topic=10012113.

Wongta N. Attendance management system on cloud architecture using Google App Engine (master’s thesis). Chiangmai: Chiangmai University; 2014. (in Thai)

Chaiyasong C, Tiyapak P, Taratai K, Na Rajsima S, Chaiyasong S. Research and development of computerized program to prevent therapeutic duplicate prescription in Mahasarakham Hospital. Journal of Health Systems Research 2020;14(4):405-16. (in Thai)

Srewichai C. E-Document archival and retrieval system on cloud architecture using Google Apps Scripts (master’s thesis). Chiangmai: Chiangmai University; 2014. (in Thai)

Chaemsai C, Sriprachan P. Efficiency of using Google applications in office management, Suan Sunandha Rajaphat University. IJBTS Journal 2019;48-53.

Sommanus C. Supplies and inventory management system on cloud architecture using Google App Scripts (master’s thesis). Chiangmai: Chiangmai University; 2015. (in Thai)

Downloads

Published

30-12-2021

How to Cite

1.
Sompeewong P, Predawan S. Applying Google Sheet for Action Plan of Sirindhorn College of Public Health Chonburi. J Health Syst Res [internet]. 2021 Dec. 30 [cited 2025 Jul. 12];15(4):490-51. available from: https://he04.tci-thaijo.org/index.php/j_hsr/article/view/3306

Issue

Section

original article