Learn/Teach Analytical Geometry on a Spreadsheet

Abstract

During the covid pandemic we moved to a mixture of online, hybrid and in person teaching. In doing so we faced problems in teaching various modules in analytical geometry and calculus online. A graphical user interface (GUI) teaching tool was therefore developed to teach several analytical geometry modules to college and undergraduate university students. These executable spreadsheets can help physics and mathematics students practice numerous principles of analytical geometry with few inputs and comprehensive solutions with a single click. Because spreadsheets are so widespread, they can be used to calculate equations of straight lines, planes, areas, and volumes in 3-directional geometry. Some online vector GUIs display the outcomes; however, this GUI illustrates the computation methods to get the results, making it easier to study the topic. The designed GUI also aids mentors in their lab work and tests by creaing various papers with answer keys.