IMPLEMENTATION OF AN MS EXCEL TOOL FOR BACKPROPAGATION NEURAL NETWORK ALGORITHM IN ENVIRONMENTAL ENGINEERING EDUCATION


DEMİR S., MANAV DEMİR N., KARADENİZ A., CİVELEK YÖRÜKLÜ H.

SIGMA JOURNAL OF ENGINEERING AND NATURAL SCIENCES-SIGMA MUHENDISLIK VE FEN BILIMLERI DERGISI, cilt.36, sa.1, ss.251-260, 2018 (ESCI) identifier

  • Yayın Türü: Makale / Tam Makale
  • Cilt numarası: 36 Sayı: 1
  • Basım Tarihi: 2018
  • Dergi Adı: SIGMA JOURNAL OF ENGINEERING AND NATURAL SCIENCES-SIGMA MUHENDISLIK VE FEN BILIMLERI DERGISI
  • Derginin Tarandığı İndeksler: Emerging Sources Citation Index (ESCI), Academic Search Premier, Directory of Open Access Journals
  • Sayfa Sayıları: ss.251-260
  • Anahtar Kelimeler: Environmental modeling, education, neural networks, visual basic for applications, MODEL
  • Yıldız Teknik Üniversitesi Adresli: Evet

Özet

This paper presents the implementation of an MS Excel tool for backpropagation neural networks in environmental engineering education. A number of test cases, Darcy friction factor and oxygen solubility, were also provided to test the performance of the tool. Relative mean square errors and coefficients of determination for Darcy friction factor were calculated as 1.53*10(-3)+/- 0.59*10(-3) and 0.9983 +/- 0.0003 while they were calculated as 4.78*10(-4)+/- 2.33*10(-4) and 0.9998 +/- 0.0000 for oxygen solubility. Results suggested that the tool's performance is satisfactory. The tool produces satisfactorily fast and reliable results and can be used for environmental education in undergraduate/graduate level.