CEV319 Computer Applications in Environmental Engineering (2022)

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 (2022)

Textbooks:

• Liengme’s Guide to Excel 2016 for Scientists and Engineers: Windows and Mac. 2019. Bernard V. Liengme and Keith Hekman. Elsevier.
  • Book companion website
• MATLAB: An Introduction with Applications. 2017. Amos Gilat. Wiley.

Reference Books:

• Excel 2013 for Scientists. 2014. Gerard Verschuuren. Holy Macro! Books.
• 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, 2^nd 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, 5^th Edition. 2013. Hahn, B. and Valentine, D.
• Environmental Data Analysis with MATLAB. 2nd Edition. 2016. William Menke & Joshua Menke. Elsevier.

from Coursera:

• Introduction to Data Science in Python

Web Resources:

• Kocaeli Üniversitesi Office 365 Talep Sistemi
• http://www.engineers-excel.com/index.htm
  • Excel examples for engineering applications
• ExcelUser
  • Useful information on Excel with a focus on business and economics
• MATLAB Basics from the blog of Hans-Petter Halvorsen
• GNU Octave: MATLAB-like open-source scientific programming language

LECTURE NOTES

Week 1 (23 Sep 2022) – Introduction to the course

Syllabus (2022)

Week 2 (30 Sep 2022) – Introduction to Excel & Introduction to Octave/MATLAB

Welcome to Microsoft Excel 2016 (Chapter 1 in Liengme & Hekman)

Starting with MATLAB (Chapter 1 in Gilat)

Week 3 (7 Oct 2022) – Variables and Script Files in Octave/MATLAB

Defining Scalar Variables (Section 1.6 in Gilat)

Useful Commands for Managing Variables (Section 1.7 in Gilat)

Script Files (Section 1.8 in Gilat)

Examples of MATLAB Applications (Section 1.9 in Gilat)

Problems (Section 1.10 in Gilat)

Week 4 (14 Oct 2022) – Basic Operations in Excel

Basic Operations (Chapter 2 in Liengme & Hekman)

Week 5 (21 Oct 2022) – Creating Arrays in MATLAB/Octave

Creating Arrays (Chapter 2 in Gilat)

Week 6 (28 Oct 2022) – Strings in MATLAB/Octave & Printing in Excel & Mathematical Operations with Arrays in MATLAB/Octave

Strings and Strings as Variables (Section 2.10 in Gilat)

Printing in Excel (Chapter 3 in Liengme & Hekman)

Mathematical Operations with Arrays (Chapter 3 in Gilat)

Week 7 (4 Nov 2022) – Mathematical Operations with Arrays in MATLAB/Octave

Array Division (Section 3.3 in Gilat)

Element-by-Element Operations (Section 3.4 in Gilat)

Using Arrays in MATLAB Built-in Math Functions (Section 3.5 in Gilat)

Built-in Functions for Analyzing Arrays (Section 3.6 in Gilat)

Generation of Random Numbers (Section 3.7 in Gilat)

Examples of MATLAB Applications (Section 3.8 in Gilat)

Problems (Section 3.9 in Gilat)

Week 8 (11 Nov 2022) – Using Functions in Excel

Using Functions (Chapter 4 in Liengme & Hekman)

Week 9 (18 Nov 2022) – Array Functions in Excel & Input/Output Commands in MATLAB/Octave

Array Formulas (pp. 71-75 in Chapter 4 of Liengme & Hekman)

The MATLAB Workspace and the Workspace Window (Section 4.1 in Gilat)

Input to a Script File (Section 4.2 in Gilat)

Output Commands (Section 4.3 in Gilat)

Week 10 (25 Nov 2022) – Saving Data to and Loading Data from Files in MATLAB/Octave

The fprintf Command (Section 4.3.2 in Gilat)

The save and load Commands (Section 4.4 in Gilat)

Importing and Exporting Data (Section 4.5 in Gilat)

Examples of MATLAB Applications (Section 4.6 in Gilat)

Problems (Section 4.7 in Gilat)

Week 11 (2 Dec 2022) – Conditional Functions in Excel

Conditional Functions (Chapter 5 of Liengme & Hekman)

Week 12 (9 Dec 2022) – Lookup Functions and Conditional Arithmetic in Excel

Table Lookup Functions (Chapter 5 in Liengme & Hekman)

Exercise 6: A Simple Lookup (Chapter 5 in Liengme & Hekman)

Exercise 7: A Two-Valued Lookup (Chapter 5 in Liengme & Hekman)

Exercise 8: Conditional Arithmetic (Chapter 5 in Liengme & Hekman)

Exercise 9: Array Formulas (Chapter 5 in Liengme & Hekman)

Exercise 10: The SUMPRODUCT Function (Chapter 5 in Liengme & Hekman)

Week 13 (16 Dec 2022) – Two Dimensional Plots in MATLAB/Octave

Two-Dimensional Plots (Chapter 5 in Gilat)

Week 14 (23 Dec 2022) – Charts in Excel

Charts (Chapter 7 in Liengme & Hekman)