{
    "ok": true,
    "doi": "10.46243/jst.2020.v5.i3.pp48-52",
    "doi_display": "10.46243/jst.2020.v5.i3.pp48-52",
    "doi_url": "https://doi.org/10.46243/jst.2020.v5.i3.pp48-52",
    "state": "registered",
    "url": "https://www.jst.org.in/index.php/pub/article/view/352",
    "title": "MS-Excel Spreadsheet Applications in Introductory UnderGraduate Physics-A Review",
    "version": 2,
    "registered_via": "crossref",
    "prefix": {
        "prefix": "10.46243",
        "status": "live"
    },
    "registrant": {
        "name": "Longman Publishers",
        "kind": "publisher",
        "country": "India"
    },
    "reserved_at": null,
    "registered_at": "2026-09-29 22:00:22",
    "updated_at": "2026-09-29 23:59:41",
    "withdrawn_at": null,
    "withdrawn_reason": null,
    "record": {
        "format": "smartscholars-doi-metadata/1.0",
        "doi": "10.46243/jst.2020.v5.i3.pp48-52",
        "referent": "Creation",
        "type": "JournalArticle",
        "structural_type": "Digital",
        "modes": [
            "Visual"
        ],
        "characters": [
            "Language"
        ],
        "titles": [
            {
                "value": "MS-Excel Spreadsheet Applications in Introductory UnderGraduate Physics-A Review",
                "type": "PrincipalTitle",
                "lang": "en"
            }
        ],
        "identifiers": [
            {
                "type": "DOI",
                "value": "10.46243/jst.2020.v5.i3.pp48-52"
            }
        ],
        "agents": [
            {
                "role": "publisher",
                "name": {
                    "org": "Longman Publishers"
                }
            }
        ],
        "dates": {
            "published": "2020-05-06",
            "date_type": "PublicationDate",
            "online": "2020-05-06"
        },
        "language": "en",
        "container": {
            "type": "Journal",
            "titles": [
                {
                    "value": "Journal of Science & Technology",
                    "type": "PrincipalTitle"
                }
            ],
            "identifiers": [
                {
                    "type": "ISSN",
                    "value": "2456-5660",
                    "medium": "electronic"
                }
            ],
            "volume": "5",
            "issue": "3",
            "pages": {
                "first": "48",
                "last": "52"
            }
        },
        "links": [
            {
                "url": "https://www.jst.org.in/index.php/pub/article/view/352",
                "return_type": "text/html",
                "primary": true
            },
            {
                "url": "https://www.jst.org.in/index.php/pub/article/download/352/309",
                "purpose": "text-mining",
                "return_type": "application/pdf"
            },
            {
                "url": "https://www.jst.org.in/index.php/pub/article/download/352/3125",
                "purpose": "text-mining",
                "return_type": "application/xml"
            }
        ],
        "abstract": {
            "value": "The role of information technology has been quite instrumental in bringing improvisations in the the field of pedagogy. The institutions are shifting to ICT based techniques, because teaching science subjects with ICT based simulations has partially replaced the requirements of laboratories along with enhancement of conceptual understanding of the students. Presently, many science teachers prefer to use self made spreadsheet computer simulations and virtual laboratories. For example, the most common MS-Excel spreadsheet can be programmed to imitate the movement of many physical systems such as a motion of projectile, trajectory of charged particle in electric and magnetic fields; and motion of particle in a box. Excel spreadsheet is frequently available on desktop computers, and because of their massive data manipulation functions and powerful plotting facilities they are finding increasing use in physics teaching. This review paper highlights the role of MS-Excel spreadsheet in simulating many real world problems in the teaching of Physics.",
            "lang": "en"
        },
        "license": {
            "url": "https://creativecommons.org/licenses/by/4.0",
            "start": "2020-05-06",
            "applies_to": "vor"
        },
        "references": [
            {
                "key": "ref1",
                "doi": "10.2308/tar-7096286",
                "unstructured": "R. Mattessich 1961 The Accounting Review Budgeting Models and System Simulation pp 384- 397"
            },
            {
                "key": "ref2",
                "doi": "10.1119/1.2136456",
                "unstructured": "Toback, D., Mershin, A. and Novikova, I. 2004 Department of Physics (Texas A& M University, USA) New Pedagogy for Using Internet-Based Teaching Tools in Physics Course"
            },
            {
                "key": "ref3",
                "unstructured": "Squire, K., Barnett, M., Grant, J. M.and Thomas Higginbotham 2004 School of Education (University of Wisconsin Madison, Madison, 2004) Electromagnetism Supercharged-Learning Physics with Digital Simulation Games"
            },
            {
                "key": "ref4",
                "doi": "10.1109/etcs.2009.523",
                "unstructured": "Yimin Ding and Hao Fang 2009 First International Workshop on Education Technology and Computer Science [ Wuhan, Hubei] Using a Simulation Laboratory to Improve Physics Learning: A Case Exploratory Learning of Diffraction Grating pp 3-6"
            },
            {
                "key": "ref5",
                "doi": "10.1080/0950069910130303",
                "unstructured": "G. Andaloro, V. Donzelli and R.M. Sperandeo Mineo 1991 International Journal of Science Education 13(3) Modeling in Physics teaching: The role of computer simulation pp 243-254"
            },
            {
                "key": "ref6",
                "doi": "10.1088/1361-6552/aacaea",
                "unstructured": "Sawormir Binek, Damian Kimla, Jerzy Jarosz Krzysztof Styc 2018 Phys. Edu. 53(5) Using computer simulation to aid the interactive learning of physics in secondary education pp 055006"
            },
            {
                "key": "ref7",
                "doi": "10.1063/1.881202",
                "unstructured": "Jack M. Wilson and Edward F. Redish 1989 Physics Today Using Computers in Teaching Physics pp 34-41"
            },
            {
                "key": "ref8",
                "unstructured": "D. Arganbright 1995 Mathematical Applications of Electronic Spreadsheets McGraw-Hill"
            },
            {
                "key": "ref9",
                "unstructured": "D. Piele 1990 Introductory Statistics With Spreadsheets Addison-Wesley"
            },
            {
                "key": "ref10",
                "unstructured": "D. Arganbright 1993 Practical Handbook of Spreadsheet Curves and Geometric Constructions CRC Press ISBN-13: 978- 0849389382"
            },
            {
                "key": "ref11",
                "unstructured": "R. Smith 1992 J. Excellence in College Teaching 3 Spreadsheets as a mathematical tool pp 131- 149"
            },
            {
                "key": "ref12",
                "unstructured": "S. Abramovich and G. Brown 1995 The Mathematics Educator 6(2) Teaching mathematics through spreadsheet-oriented problem solving pp 34-40"
            },
            {
                "key": "ref13",
                "unstructured": "S. Abramovich 1995 J. Computers in Mathematics and Science Education 14(3) Technology Motivated Teaching of Advanced Topics in Discrete Mathematics pp 391-418"
            },
            {
                "key": "ref14",
                "doi": "10.1111/j.1467-9639.1990.tb00127.x",
                "unstructured": "E. Neuwirth 1990 Teaching Statistics 12 Visualizing correlation with spreadsheet pp 86—89"
            },
            {
                "key": "ref15",
                "unstructured": "E. Neuwirth 1995 J. Computers in Mathematics and Science Education 14(3) Spreadsheet structures as a model for proving combinatorial identities pp 419-434"
            },
            {
                "key": "ref16",
                "doi": "10.1080/0020739950260305",
                "unstructured": "S. Abramovich 1995 Int. J. Mathematical Education in Science and Technology 26(3) Technology for deciding the convergence of series pp 347-366"
            },
            {
                "key": "ref17",
                "unstructured": "E. G. John 1998 Int. J. Eng. Ed. 14(5) Simplified curve fitting using spreadsheet add-ins pp 375-380"
            },
            {
                "key": "ref18",
                "unstructured": "K. Y. Kabalan A. El-Hajj, S. Khouri, and F. Yousuf 2002 Int. J. Eng Ed. 18(1) Root computations of real-coefficient polynomials using spreadsheets pp 89-97"
            },
            {
                "key": "ref19",
                "unstructured": "Dermot Diamond and Venita C. A. Hanratty 1997 Spreadsheet Applications in Chemistry Using Microsoft Excel ISBN: 978-0-471- 14087-0 Wiley-Blackwell"
            },
            {
                "key": "ref20",
                "doi": "10.1080/00219266.1987.9654856",
                "unstructured": "Ian Graham 1997 Journal of Biological Education 21 The Application of Spreadsheets to Data Analysis in Biology pp 51-56"
            },
            {
                "key": "ref21",
                "unstructured": "Krall, I. H. 1991 Excel Spreadsheets for Engineers and Scientists Prentice Hall, Englewood Cliffs, NJ"
            },
            {
                "key": "ref22",
                "doi": "10.1088/1361-6552/aa7919",
                "unstructured": "Zaheer Uddin, Muhammad Ahsanuddin and Danish Ahmed Khan 2017 Physics Education 52, 5 Teaching physics using Microsoft Excel"
            },
            {
                "key": "ref23",
                "doi": "10.1016/j.sbspro.2015.04.259",
                "unstructured": "Ionel Grigore and Emil Stefan Barnaa 2015 Procedia Social and Behavioral Sciences 191, 2 Using Excel Spreadsheets to Study the Vertical Motion in A Gravitational Field pp 2769-2775"
            },
            {
                "key": "ref24",
                "unstructured": "Popat S. Tambade 2011 European Journal of Physics Education Vol. 2 No. 2 Trajectory of Charged Particle in Combined Electric and Magnetic Fields Using Interactive Spreadsheets pp 49-59"
            },
            {
                "key": "ref25",
                "doi": "10.1088/978-1-627-05419-5",
                "unstructured": "Bernard V Liengme, Modelling Physics with Microsoft Excel®, Morgan & Claypool Publishers 2014 Online ISBN: 978-1-627-05419-5 Print ISBN: 978-1-627-05418-8"
            },
            {
                "key": "ref26",
                "unstructured": "Irnin Agustina Dwi Astuti and Yoga Budi Bhakti 2018 Indonesian Review of Physics 1-1 pp 7-11"
            },
            {
                "key": "ref27",
                "unstructured": "C. W. Misner and P. J. Cooney 1991 Spreadsheet Physics, Addison-Wesley"
            },
            {
                "key": "ref28",
                "unstructured": "D. I. Dykstra and R. G. Fuller 1988 Wondering About Physics...Using Spreadsheets to Find Out; Investigations in Physics, John Wiley & Sons"
            },
            {
                "key": "ref29",
                "unstructured": "Lee, Jaebong, Shin, K., Lee, S. 2007 Bulletin of the American Astronomical Society 38 Teaching Computational Physics Using Spreadsheets p 984. 51 | Page"
            },
            {
                "key": "ref30",
                "unstructured": "A. L. Subramaniyan 2013 Lat. Am. J. Phys. Educ. 7(3) Teaching basic physics through excel spread sheets pp 489-492"
            },
            {
                "key": "ref31",
                "doi": "10.1016/j.sbspro.2015.04.259",
                "unstructured": "Ionel Grigore and Emil Stefan Barna 2015 Procedia-Social and Behavioral Sciences 191 ( 2015) Using Excel Spreadsheets to Study The Vertical Motion in A Gravitational Field pp 2769–2775"
            },
            {
                "key": "ref32",
                "unstructured": "I. GRIGORE, CRISTINA MIRON1 and E.S. BARNA 2016 Romanian Reports in Physics 68(2) EXPLORING THE GRAPHIC FACILITIES OF EXCEL SPREADSHEETS IN THE INTERACTIVE TEACHING AND LEARNING OF DAMPED HARMONIC OSCILLATIONS pp 891–904"
            },
            {
                "key": "ref33",
                "unstructured": "Himawan Putranta and Heru Kuswanto 2018 International Journal of Recent Scientific Research 9 [5(G)] SPREADSHEET FOR PHYSICS: LISSAJOUS CURVE pp 26942-26948"
            },
            {
                "key": "ref34",
                "unstructured": "Anthony J. Ukwumonu, Ishiyaku A. Mbela and Laminu A. Song 2015 International Journal of Management Sciences, Research Academy of Social Sciences p6(1) Spreadsheet Simulation for Demonstrating Projectile Motion pp 32-38"
            },
            {
                "key": "ref35",
                "doi": "10.1016/j.sbspro.2015.04.259",
                "unstructured": "I. GRIGORE, CRISTINA MIRON1 and E. S. BARNA 2017 Romanian Reports in Physics 69 EXPLORING EXCEL SPREADSHEETS TO SIMULATE THE PROJECTILE MOTION IN THE GRAVITATIONAL FIELD 901"
            },
            {
                "key": "ref36",
                "doi": "10.1088/0143-0807/35/4/045016",
                "unstructured": "Jan Benacka 2014 European Journal of Physics 35(4) On planetary motion—a way to solve the problem and a spreadsheet simulation 045016"
            },
            {
                "key": "ref37",
                "unstructured": "I. GRIGORE, CRISTINA MIRON1 and E. S. BARNA 2015 Romanian Reports in Physics 67(2) USING MICROSOFT EXCEL IN TEACHING AND LEARNING RELATIVISTIC KINEMATICS pp 716–732"
            },
            {
                "key": "ref38",
                "unstructured": "Margarida Cristina Oliveira and Suzana N´apoles 2010 eJSiE 3(3) Using a spreadsheet to study the oscillatory movement of a massspring system Spreadsheets in Education Article 2"
            },
            {
                "key": "ref39",
                "unstructured": "Popat Tambade 2013 World Conference on E-Learning in Corporate, Government, Healthcare, and Higher Education Effectiveness of Spreadsheets Implementation and Cooperative Learning on Students’ Conceptual Understanding about Quantum Physics Publisher: Association for the Advancement of Computing in Education (AACE) pp 1417-1422"
            },
            {
                "key": "ref40",
                "unstructured": "Popat S. Tambade 2011 Lat. Am. J. Phys. Educ. 5(1) Harmonic oscillator wave functions and probability density plots using spreadsheets pp 43-48"
            },
            {
                "key": "ref41",
                "unstructured": "Popat Tambade 2017 European Journal of Physics Education 3(1) Spreadsheet Implementation for Momentum Representation of Gaussian Wave Packet and Uncertainty Principle pp 9-16"
            },
            {
                "key": "ref42",
                "unstructured": "Sunil Kumar Katoch 2020 IOSR-JAP 12,2,II Modeling and Simulating Radioactivity in the Physics Laboratory of Under-Graduate Students pp 58-63"
            },
            {
                "key": "ref43",
                "doi": "10.2514/6.2000-804",
                "unstructured": "Morishita, Y. Iwata, K. Yuki and H. Yoshida 2001 Int. J. Eng. Ed. 17(3) Spreadsheet fluid dynamics for aeronautical course problems pp 294-311"
            },
            {
                "key": "ref44",
                "doi": "10.1109/fie.1997.632669",
                "unstructured": "C. N. Reffold 1995 Int. J. Eng. Ed. 11(2) Spreadsheet Modeling of Turbojet Performance pp 103-110 [45] R. Kumar and A. O. Al-Shantaf 1997 Proc. Frontiers in Education Conf (FIE) 3 Spreadsheet analysis of fluid mechanics problems pp 1334-1337"
            },
            {
                "key": "ref45",
                "doi": "10.1109/semthe.1988.10595",
                "unstructured": "J. C. Eid 1988 Fourth Annual IEEE Semiconductor Thermal and Temperature Measurement Symposium Thermal modeling with PC spreadsheets pp 40-49"
            },
            {
                "key": "ref46",
                "unstructured": "Mohamed M. El-Awad and Ali M. Elseory 2012 International Conference on Automotive, Mechanical and Materials Engineering (ICAMME’2012) Penang (Malaysia) Excel as a Teaching Aid for Thermodynamics pp 19-20"
            },
            {
                "key": "ref47",
                "doi": "10.53332/uofkej.v3i1.120",
                "unstructured": "M. M. El-Awad and A. M. Elseory 2013 UofKEJ 3-1 Excel as a Modelling Platform for Thermodynamic Optimisation Analyses pp 12-18"
            },
            {
                "key": "ref48",
                "doi": "10.18260/1-2--15143",
                "unstructured": "Larry Caretto, David McDaniel and Tom Mincer 2005 Proceedings of the 2005 American Society for Engineering Education Annual Conference and Exposition Spreadsheet Calculations of Thermodynamic Properties p 1132"
            }
        ],
        "record": {
            "registrant": "Longman Publishers",
            "registered": "2020-05-06",
            "updated": "2026-09-17",
            "issue_number": 1,
            "source": "crossref-api",
            "source_agency": "Crossref (member 25296)"
        }
    },
    "record_sha256": "82604ef5eca2a9be4346432f9593afcde63082ad4211ca6c7f03ec47a6179cdd",
    "handle": {
        "synced_at": "2026-10-01 18:12:17",
        "url": "https://www.jst.org.in/index.php/pub/article/view/352"
    },
    "links": {
        "record_page": "https://registry.smartscholars.in/record.php?doi=10.46243%2Fjst.2020.v5.i3.pp48-52",
        "system_metadata": "https://registry.smartscholars.in/resolve.php?doi=10.46243%2Fjst.2020.v5.i3.pp48-52&as=system",
        "history": "https://registry.smartscholars.in/api.php?action=history&doi=10.46243%2Fjst.2020.v5.i3.pp48-52",
        "kernel_xml": "https://registry.smartscholars.in/resolve.php?doi=10.46243%2Fjst.2020.v5.i3.pp48-52&as=xml"
    }
}