Training on Using Spreadsheets on the Topic of Waves for Physics Teachers in Yogyakarta

Google Apps is one of Google's online application-based products that provides online work management services. As an online service, Google Apps is easy to use, effective and efficient in driving digital transformation since the COVID-19 pandemic in the Department of Physics Education, Faculty of Mathematics and Natural Science (FMIPA), UNY. Apart from that, Google Apps services are cloud computing technology where users can reach Google Apps services anywhere and anytime via the internet. Google Apps services can be accessed for free at a low cost.

This Google Apps service can make it easier to share projects ranging from online documents, group management, task management, calendars and large-capacity emails. Several Google services have features that make it easier to manage administrative matters, namely Google Forms, Google Spreadsheet, Google Drive, and Google Calendar. Google Forms can be connected to Google spreadsheets. If the spreadsheet is associated with an automated response form, the response will be sent to the spreadsheet. Otherwise, users can view their responses in "Response Summary", accessed from the Responses menu. Spreadsheets can be used to help the physics learning process, such as the topic that waves can be simulated in a relatively easy and simple way. Finding numerical solutions to differential equations is done through the 'copy' and 'paste' processes in spreadsheet cells. The availability of mathematical functions for cells, graphic facilities and programming via macros form a complete and complementary learning environment.

 

As one of the 2023 Community Service Program (PPM) activities, the Master of Physics Education Study Program, Department of Physics Education, FMIPA UNY carried out Training on the Use of Spreadsheets on the Topic of Waves for Physics Teachers in Yogyakarta on Friday, August 18 2023 and Friday, August 25 2023. The Training was attended by several resource persons, namely lecturers from the Master of Physics Education Study Program, UNY, including Prof. Dr. Heru Kuswanto, M.Si (NIP. 196111121987021001), Dr. Kuncoro Asih Nugroho, S.Pd., M.Pd., M.Sc. (NIP. 19770615 200212 1003), and Dr. Supardi, S.Si., M.Si. (NIP. 197110151998021001). Two students, Diki Chen (NIM. 22326251041) and Wahyu Dilla Abdullah (NIM. 22326251044), also assisted in this PPM activity. It is hoped that this PPM activity can provide insight, experience and provisions for Physics Teachers in Yogyakarta in preparing physics learning media in the physics subject learning process.

Google Apps is one of Google's online application-based products that provides online work management services. As an online service, Google Apps is easy to use, effective and efficient in driving digital transformation since the COVID-19 pandemic in the Department of Physics Education, Faculty of Mathematics and Natural Science (FMIPA), UNY. Apart from that, Google Apps services are cloud computing technology where users can reach Google Apps services anywhere and anytime via the internet. Google Apps services can be accessed for free at a low cost.

 

This Google Apps service can make it easier to share projects ranging from online documents, group management, task management, calendars and large-capacity emails. Several Google services have features that make it easier to manage administrative matters, namely Google Forms, Google Spreadsheet, Google Drive, and Google Calendar. Google Forms can be connected to Google spreadsheets. If the spreadsheet is associated with an automated response form, the response will be sent to the spreadsheet. Otherwise, users can view their responses in "Response Summary", accessed from the Responses menu. Spreadsheets can be used to help the physics learning process, such as the topic that waves can be simulated in a relatively easy and simple way. Finding numerical solutions to differential equations is done through the 'copy' and 'paste' processes in spreadsheet cells. The availability of mathematical functions for cells, graphic facilities and programming via macros form a complete and complementary learning environment.

 

As one of the 2023 Community Service Program (PPM) activities, the Master of Physics Education Study Program, Department of Physics Education, FMIPA UNY carried out Training on the Use of Spreadsheets on the Topic of Waves for Physics Teachers in Yogyakarta on Friday, August 18 2023 and Friday, August 25 2023. The Training was attended by several resource persons, namely lecturers from the Master of Physics Education Study Program, UNY, including Prof. Dr. Heru Kuswanto, M.Si (NIP. 196111121987021001), Dr. Kuncoro Asih Nugroho, S.Pd., M.Pd., M.Sc. (NIP. 19770615 200212 1003), and Dr. Supardi, S.Si., M.Si. (NIP. 197110151998021001). Two students, Diki Chen (NIM. 22326251041) and Wahyu Dilla Abdullah (NIM. 22326251044), also assisted in this PPM activity. It is hoped that this PPM activity can provide insight, experience and provisions for Physics Teachers in Yogyakarta in preparing physics learning media in the physics subject learning process.