| _version_ |
1860797370995834880
|
| building |
INTELEK Repository
|
| collection |
Online Access
|
| collectionurl |
https://intelek.unisza.edu.my/intelek/pages/search.php?search=!collection407072
|
| date |
2015-11-05 09:44:54
|
| format |
Restricted Document
|
| id |
12447
|
| institution |
UniSZA
|
| internalnotes |
1. Gazzaz, N. M., Yusoff, M. K., Aris, A. Z., Juahir, H. and Ramli, M. F. (2012). Artificial neural network modeling of the water quality index for Kinta River (Malaysia) using water quality variables as predictors. Marine Pollution Bulletin (64): 2409-2420. 2. Toriman, M. E., Kamarudin, M. K. A., Gasim, M. B., Jaafar, M., Aziz, N. A. A. and Lun, P. I., (2012). Water quality status and hydrological analysis in upper tropical river, Malaysia. International Journal of Agriculture and Crop Sciences 4(2): 33-39. 3. Minhas, P. S. and Samra, J. S. (2004). Wastewater Use in Peri-urban Agriculture: Impacts and Opportunities. Central Soil Salinity Research Institute, Karnal, India, pp. 75. 4. Minhas, P. S., Lal, K., Yaday, R. K., Dubey, S. K. and Chaturvedi, R. K. (2014). Long term impact of waste water irrigation and nutrient rates: I. Performance, sustainability and produce quality of peri urban cropping systems. Agricultural Water Management (156): 100-109. 5. Zandbergen, P. A. and Hall, K. G. (1998). Analysis of the British Columbia water quality index for watershed managers: a case study of two small watersheds. Water Quality Research Journal of Canada 33 (4): 519–549. 6. Tsuzuki, Y. (2015) Relationships between pollutant discharge and water quality in the rivers from “better” to “worse” water quality. Ecological Indicators (52): 256-269. 7. Kaurish, F.W. and Younos, T. (2007). Developing a standardized water quality index for evaluating surface water quality. Journal of the American Water Resources Association 43 (2): 533–545. 8. Afroz, R., Hassan, M. N. and Ibrahim, N. A. (2003). Review of air pollution and health impacts in Malaysia. Environment Research 92: 71-77. 9. Dominick, D., Juahir, H., Latif, M. T., Zain, S. M. and Aris, A. Z. (2012). Spatial assessment of air quality patterns in Malaysia using multivariate analysis. Atmospheric Environment 60: 172-181. 10. Hughes, G. (1997). Can the Environment Wait? Priority Issues for East Asia. World Bank, Washington, DC, United States. 11. Mabahwi, N. A., Leh, O. L. H. and Omar, D. (2014). Human Health and Wellbeing: Human health effect of air pollution. Procedia – Social and Behavioral Sciences (153): 221-229. 12. United Nations (UN) – Department of Economic and Social Affairs, Population Division. (2001). World Population Monitoring 2001– Population, environment and development. New York: UN
|
| originalfilename |
6750-01-FH02-ESERI-15-04078.jpg
|
| person |
norman
|
| recordtype |
oai_dc
|
| resourceurl |
https://intelek.unisza.edu.my/intelek/pages/view.php?ref=12447
|
| spelling |
12447 https://intelek.unisza.edu.my/intelek/pages/view.php?ref=12447 https://intelek.unisza.edu.my/intelek/pages/search.php?search=!collection407072 Restricted Document Article Journal image/jpeg inches 96 96 norman 1417 31 31 773 2015-11-05 09:44:54 1417x773 6750-01-FH02-ESERI-15-04078.jpg UniSZA Private Access 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 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. 19 5 Malaysian Society of Analytical Sciences Malaysian Society of Analytical Sciences 1056-1064 1. Gazzaz, N. M., Yusoff, M. K., Aris, A. Z., Juahir, H. and Ramli, M. F. (2012). Artificial neural network modeling of the water quality index for Kinta River (Malaysia) using water quality variables as predictors. Marine Pollution Bulletin (64): 2409-2420. 2. Toriman, M. E., Kamarudin, M. K. A., Gasim, M. B., Jaafar, M., Aziz, N. A. A. and Lun, P. I., (2012). Water quality status and hydrological analysis in upper tropical river, Malaysia. International Journal of Agriculture and Crop Sciences 4(2): 33-39. 3. Minhas, P. S. and Samra, J. S. (2004). Wastewater Use in Peri-urban Agriculture: Impacts and Opportunities. Central Soil Salinity Research Institute, Karnal, India, pp. 75. 4. Minhas, P. S., Lal, K., Yaday, R. K., Dubey, S. K. and Chaturvedi, R. K. (2014). Long term impact of waste water irrigation and nutrient rates: I. Performance, sustainability and produce quality of peri urban cropping systems. Agricultural Water Management (156): 100-109. 5. Zandbergen, P. A. and Hall, K. G. (1998). Analysis of the British Columbia water quality index for watershed managers: a case study of two small watersheds. Water Quality Research Journal of Canada 33 (4): 519–549. 6. Tsuzuki, Y. (2015) Relationships between pollutant discharge and water quality in the rivers from “better” to “worse” water quality. Ecological Indicators (52): 256-269. 7. Kaurish, F.W. and Younos, T. (2007). Developing a standardized water quality index for evaluating surface water quality. Journal of the American Water Resources Association 43 (2): 533–545. 8. Afroz, R., Hassan, M. N. and Ibrahim, N. A. (2003). Review of air pollution and health impacts in Malaysia. Environment Research 92: 71-77. 9. Dominick, D., Juahir, H., Latif, M. T., Zain, S. M. and Aris, A. Z. (2012). Spatial assessment of air quality patterns in Malaysia using multivariate analysis. Atmospheric Environment 60: 172-181. 10. Hughes, G. (1997). Can the Environment Wait? Priority Issues for East Asia. World Bank, Washington, DC, United States. 11. Mabahwi, N. A., Leh, O. L. H. and Omar, D. (2014). Human Health and Wellbeing: Human health effect of air pollution. Procedia – Social and Behavioral Sciences (153): 221-229. 12. United Nations (UN) – Department of Economic and Social Affairs, Population Division. (2001). World Population Monitoring 2001– Population, environment and development. New York: UN
|
| spellingShingle |
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]
|
| summary |
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.
|
| 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_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_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_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]
|