CEV319 Computer Applications in Environmental Engineering

ANNOUNCEMENTS

  • We are going to use EDESTEK provided by UZEM of Kocaeli University.
    • All the students enrolled to the course have been added to the course account on EDESTEK.
    • In order to access EDESTEK, use this link.
    • In order to get technical information regarding EDESTEK, use this link.

Syllabus (2023)

Books:

  • Excel
  • Python
    • “Python Programming and Numerical Methods: A Guide for Engineers and Scientists.” (2021). Kong, Q.; Siauw, T.; Bayen, A.M.; Academic Press.
    • “Programming for Computations – Python: A Gentle Introduction to Numerical Simulations with Python 3.6, Second Edition” by Svein Linge & Hans Petter Langtangen. Springer. 2020. (Open Access Book: https://www.springer.com/gp/book/9783030168766)
    • “A Primer on Scientific Programming with Python, 5th Edition” by Hans Petter Langtangen. Springer. 2016.
  • MATLAB
    • MATLAB: An Introduction with Applications. 2017. Amos Gilat. Wiley.
    • MATLAB: A Practical Introduction to Programming and Problem Solving, 4th Edition. 2017. Stormy Attaway. Elsevier.
      • Here is a link to the online version of the 2nd Edition at the KOÜ library.
    • A Guide to MATLAB for Beginners and Experienced Users, 2nd Edition. 2006. B.R. Hunt, R.L. Lipsman, J.M. Rosenberg, K.R. Coombes, J.E. Osborn, G.J. Stuck. Cambridge University Press.
    • Computer Programming with Matlab, 1st Revised PDF Edition. 2015. J. Michael Fitzpatrick and Akos Ledeczi.
    • Essential MATLAB for Engineers and Scientists, 5th Edition. 2013. Hahn, B. and Valentine, D.
    • Environmental Data Analysis with MATLAB. 2nd Edition. 2016. William Menke & Joshua Menke. Elsevier.

from Coursera:

Web Resources:

LECTURE NOTES

Week 1 (6 Oct 2023) – Introduction to the course & Basic operation in Excel

Syllabus (2023)

Basic Operations (Chapter 2 in Liengme & Hekman)

Week 2 (13 Oct 2023) – Using Functions & Plotting Functions (EXCEL)

Using Functions (Chapter 4 in Liengme & Hekman)

Charts (Chapter 7 in Liengme & Hekman)

Week 3 (20 Oct 2023) – Using Functions (Python) & Plotting Functions (Python) & General Spreadsheet Techniques

Python:

Functions (Chapter 3 in Kong et al.)

2D Plotting (Section 12.1 in Kong et al.)

Excel:

General Spreadsheet Techniques (Part I in Verschuuren)

Week 4 (27 Oct 2023) – Branching Statements in Python & Simple Statistics in Excel

Python:

Branching Statements (Chapter 4 in Kong et al.)

Excel:

Using Functions (Chapter 4 in Liengme & Hekman)

Week 5 (3 Nov 2023) – Conditional Functions in Excel & Excel-Python Interaction

Conditional Functions (Chapter 5 in Liengme & Hekman)

Working with Excel files using Pandas (geeksforgeeks.org)
Tutorial Using Excel with Python and Pandas (dataquest.io)

Week 6 (10 Nov 2023) – Working with Arrays and Matrices & Systems of Linear Equations (Excel)

Using Functions (Chapter 4 in Liengme & Hekman)

Week 7 (17 Nov 2023) – Working with Arrays and Matrices & Systems of Linear Equations (Python)

Linear Algebra and Systems of Linear Equations (Chapter 14 in Kong et al.)

Week 8 (24 Nov 2023) – Linear Regression

Regression Analysis (Chapter 7 in Liengme & Hekman)

Week 9 (1 Dec 2023) – Linear Regression

Regression Analysis (Chapter 7 in Liengme & Hekman)

Least Squares Regression (Chapter 16 in Kong et al.)

Week 10 (8 Dec 2023) – Linear Regression in Python

Least Squares Regression (Chapter 16 in Kong et al.)

Week 11 (15 Dec 2023) – Mass Balance Equations

Reactor Models (Section 5.A in Nazaroff & Alvarez-Cohen)

Week 12 (22 Dec 2023) – Solving Ordinary Differential Equations

The Euler Method (Section 22.3 in Kong et al.)

Week 13 (29 Dec 2023) – Solving ODEs in Python

The Euler Method (Section 22.3 in Kong et al.)

Week 14 (23 Dec 2022) – Python ODE Solvers

Python ODE Solvers (Section 22.6 in Kong et al.)