Cover Image

Application of Excel-VBA for computation of water quality index and air pollutant index [Penggunaan Excel-VBA untuk pengiraan indeks kualiti air dan indeks pencemaran udara]

In Malaysia, there are two main indices which are Water Quality Index (WQI) and Air Pollutant Index (API). These indices are used as an indicator for the water quality and ambient air quality status of the environment. In conducting research regarding water and air quality, lots of time has been use...

Full description

Saved in:
Bibliographic Details
Main Authors: Azman, Azid, Hafizan, Juahir, Ismail, Zainal Abidin
Format: Article
Language:English
Published: Malaysian Society of Analytical Sciences 2015
Subjects:
GE Environmental Sciences
Online Access:http://eprints.unisza.edu.my/6750/1/FH02-ESERI-15-04078.jpg
http://eprints.unisza.edu.my/6750/
Tags: Add Tag
No Tags, Be the first to tag this record!
id my-unisza-ir.6750
record_format eprints
spelling my-unisza-ir.67502022-09-13T04:29:03Z http://eprints.unisza.edu.my/6750/ Application of Excel-VBA for computation of water quality index and air pollutant index [Penggunaan Excel-VBA untuk pengiraan indeks kualiti air dan indeks pencemaran udara] Azman, Azid Hafizan, Juahir Ismail, Zainal Abidin GE Environmental Sciences In Malaysia, there are two main indices which are Water Quality Index (WQI) and Air Pollutant Index (API). These indices are used as an indicator for the water quality and ambient air quality status of the environment. In conducting research regarding water and air quality, lots of time has been used to conduct other activities, an application to calculate the indices might come in handy. This project aims to construct an application for the computation of WQI and API using Visual Basic for Applications (VBA) available in Microsoft Excel. VBA is actually a programming language of Microsoft Excel and can be used to write programming and run through in an Excel workbook. The user only required to enter the value for each parameter and then press “OK” to automatically calculate the index. This will provide instance result without wasting time just to refer to the class standard and other formula. The application also has been used as a teaching tool for the secondary students. An environmental based race game called Young Environmental Scientist (YES) Explorace was conducted by Environmental East Coast Research Institute (ESERI) where secondary student are invited as the participant. The application not only provides early exposure to the environmental pollution, but also exposure to the application of computer sciences to the student. Malaysian Society of Analytical Sciences 2015 Article PeerReviewed image en http://eprints.unisza.edu.my/6750/1/FH02-ESERI-15-04078.jpg Azman, Azid and Hafizan, Juahir and Ismail, Zainal Abidin (2015) Application of Excel-VBA for computation of water quality index and air pollutant index [Penggunaan Excel-VBA untuk pengiraan indeks kualiti air dan indeks pencemaran udara]. Malaysian Journal of Analytical Sciences, 19 (5). pp. 1056-1064. ISSN 13942506
institution Universiti Sultan Zainal Abidin
building UNISZA Library
collection Institutional Repository
continent Asia
country Malaysia
content_provider Universiti Sultan Zainal Abidin
content_source UNISZA Institutional Repository
url_provider https://eprints.unisza.edu.my/
language English
topic GE Environmental Sciences
spellingShingle GE Environmental Sciences
Azman, Azid
Hafizan, Juahir
Ismail, Zainal Abidin
Application of Excel-VBA for computation of water quality index and air pollutant index [Penggunaan Excel-VBA untuk pengiraan indeks kualiti air dan indeks pencemaran udara]
description In Malaysia, there are two main indices which are Water Quality Index (WQI) and Air Pollutant Index (API). These indices are used as an indicator for the water quality and ambient air quality status of the environment. In conducting research regarding water and air quality, lots of time has been used to conduct other activities, an application to calculate the indices might come in handy. This project aims to construct an application for the computation of WQI and API using Visual Basic for Applications (VBA) available in Microsoft Excel. VBA is actually a programming language of Microsoft Excel and can be used to write programming and run through in an Excel workbook. The user only required to enter the value for each parameter and then press “OK” to automatically calculate the index. This will provide instance result without wasting time just to refer to the class standard and other formula. The application also has been used as a teaching tool for the secondary students. An environmental based race game called Young Environmental Scientist (YES) Explorace was conducted by Environmental East Coast Research Institute (ESERI) where secondary student are invited as the participant. The application not only provides early exposure to the environmental pollution, but also exposure to the application of computer sciences to the student.
format Article
author Azman, Azid
Hafizan, Juahir
Ismail, Zainal Abidin
author_facet Azman, Azid
Hafizan, Juahir
Ismail, Zainal Abidin
author_sort Azman, Azid
title Application of Excel-VBA for computation of water quality index and air pollutant index [Penggunaan Excel-VBA untuk pengiraan indeks kualiti air dan indeks pencemaran udara]
title_short Application of Excel-VBA for computation of water quality index and air pollutant index [Penggunaan Excel-VBA untuk pengiraan indeks kualiti air dan indeks pencemaran udara]
title_full Application of Excel-VBA for computation of water quality index and air pollutant index [Penggunaan Excel-VBA untuk pengiraan indeks kualiti air dan indeks pencemaran udara]
title_fullStr Application of Excel-VBA for computation of water quality index and air pollutant index [Penggunaan Excel-VBA untuk pengiraan indeks kualiti air dan indeks pencemaran udara]
title_full_unstemmed Application of Excel-VBA for computation of water quality index and air pollutant index [Penggunaan Excel-VBA untuk pengiraan indeks kualiti air dan indeks pencemaran udara]
title_sort application of excel-vba for computation of water quality index and air pollutant index [penggunaan excel-vba untuk pengiraan indeks kualiti air dan indeks pencemaran udara]
publisher Malaysian Society of Analytical Sciences
publishDate 2015
url http://eprints.unisza.edu.my/6750/1/FH02-ESERI-15-04078.jpg
http://eprints.unisza.edu.my/6750/
_version_ 1744358566259589120
score 13.211869

Similar Items