• DocumentCode
    3120402
  • Title

    Using MS Excel to Learn general Chemistry

  • Author

    Arifin, B. ; Yeop, U.P.

  • Author_Institution
    Fac. of Appl. Sci., Univ. Teknol. MARA, Shah Alam, Malaysia
  • fYear
    2012
  • fDate
    23-26 Sept. 2012
  • Firstpage
    766
  • Lastpage
    770
  • Abstract
    MS Excel VBA (Visual Basic for Application) has been used to develop GChem, an application to help students learn basic concepts in Chemistry. This application which contains seven modules, is an improved version of the same application developed previously which only has five modules. In addition to electrochemistry, pH of acid base, molecular weight calculator, empirical formula and thermochemistry, two new modules; ideal and Van der Waals gas and chemical equilibrium have been added. The ease of storing data in worksheets and the ability to link these data to the commands of the visual basic editor makes Excel VBA an attractive tool to develop application that allows students of general chemistry to use this as a learning aid. The modules developed so far focus on chemistry concepts that involve calculations. This application is suitable to students taking undergraduate general chemistry course. We are also encouraged by the positive response of a survey given to a group of our students.
  • Keywords
    Visual BASIC; chemical equilibrium; computer aided instruction; educational courses; electrochemistry; further education; information storage; molecular weight; pH; quasimolecules; thermochemistry; GChem; MS Excel VBA; Van der Waals gas; Visual Basic for application; acid base pH; chemical equilibrium; chemistry concepts; data link; data storage; electrochemistry; general chemistry; learning aid; molecular weight calculator; thermochemistry; undergraduate general chemistry course; visual basic editor; Chemicals; Computers; Education; Equations; Mathematical model; Visual BASIC; Chemical Equilibrium; Equilibrium constant; Excel VBA; Ideal and Van der Waals gas;
  • fLanguage
    English
  • Publisher
    ieee
  • Conference_Titel
    Business, Engineering and Industrial Applications (ISBEIA), 2012 IEEE Symposium on
  • Conference_Location
    Bandung
  • Print_ISBN
    978-1-4577-1632-4
  • Type

    conf

  • DOI
    10.1109/ISBEIA.2012.6422994
  • Filename
    6422994