GUI of vector analysis on spreadsheets for students and teachers


  • Atteeq Razzak University of Karachi
  • Zaheer Uddin University of Karachi



Teaching mathematics, excel spreadsheet, GUI, vector algebra


A Graphical User Interface (GUI) teaching tool to teach different vectors modules to college and undergraduate students have been developed. The Physics and Mathematics students can benefit from these executable spreadsheets for practicing vector algebra with minimum inputs and through diagrams and answers as output. The spreadsheets are employed to calculate vectors resolution, addition, projection, and multiplication because they are ubiquitous. Some GUI on vectors available online gives the results, whereas this GUI shows the calculation steps to reach the results, which helps learn the subject effectively. The developed GUI also assists the mentors regarding their lab work and exams to make different papers with answer keys.


Almeida, T., R. Nogueira and P. André (2013). Graphical user interfaces for teaching and research in optical communications. Education and Training in Optics and Photonics, Optical Society of America.

Brand, L. (2012). Vector analysis, Courier Corporation.

Henry, S. G. (1979). "Chemical demagnetization: methods, procedures, and applications through vector analysis." Canadian Journal of Earth Sciences 16(9): 1832-1841.

Hinz, M. and A. Teplyaev (2013). "Vector analysis on fractals and applications." Contemp. Math 601: 147-163.

Iqbal, M., F. Ahmed, A. Iqbal and Z. Uddin (2020). "Teaching physics online through spreadsheets in a pandemic situation." Physics Education 55(6): 063006.

Machuca, R. and K. Phillips (1983). "Applications of vector fields to image processing." IEEE Transactions on Pattern Analysis and Machine Intelligence(3): 316-329.

Randhawa, G. S., K. A. Hill and L. Kari (2020). "MLDSP-GUI: an alignment-free standalone tool with an interactive graphical user interface for DNA sequence comparison and analysis." Bioinformatics 36(7): 2258-2259.

Rosadi, D. (2008). "Rplugin. Econometrics: R-GUI for teaching Time Series Analysis." COMPSTAT'2010 Book of Abstracts: 165.

Toby, B. H. (2001). "EXPGUI, a graphical user interface for GSAS." Journal of applied crystallography 34(2): 210-213.

Uddin, Z., M. Ahsanuddin and D. A. Khan (2017). "Teaching physics using microsoft excel." Physics Education 52(5): 053001.




How to Cite

A. Razzak and Z. Uddin, “GUI of vector analysis on spreadsheets for students and teachers”, Rev. Mex. Fis. E, vol. 20, no. 1 Jan-Jun, pp. 010208 1–, Jan. 2023.