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, vol.36, no.1, pp.251-260, 2018 (Peer-Reviewed Journal) identifier

  • Publication Type: Article / Article
  • Volume: 36 Issue: 1
  • Publication Date: 2018
  • Journal Name: SIGMA JOURNAL OF ENGINEERING AND NATURAL SCIENCES-SIGMA MUHENDISLIK VE FEN BILIMLERI DERGISI
  • Journal Indexes: Emerging Sources Citation Index (ESCI), Academic Search Premier, Directory of Open Access Journals
  • Page Numbers: pp.251-260
  • Keywords: Environmental modeling, education, neural networks, visual basic for applications, MODEL
  • Yıldız Technical University Affiliated: Yes

Abstract

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.