Spreadsheet and Programming Applications for Civil Engineers
Course Code
Semester
Course Name
LE/RC/LA
Course Type
Language of Instruction
ECTS
CE0828
Spreadsheet and Programming Applications for Civil Engineers
2/2/0
DE
English
4
Course Goals
The course aims to give students a fundamental knowledge on the use spreadsheet software and programming tools to solve problems related to the field of Civil Engineering.
- Moore, H., (2017) MATLAB. for Engineers. Fifth Edition. Pearson.
- Attaway, S., (2017) MATLAB, A practical introduction to programming and problem solving, Elsevier.
Other Sources
-
Course Schedules
Week
Contents
Learning Methods
1. Week
Introduction. Engineering Problem Solving Process. Working with Flowcharts
Presentation + Computer Lab Session
2. Week
2. Overview of the MATLAB and Excel User Interfaces, Elementary Built-in Mathematical Functions in MATLAB and Excel
Presentation + Computer Lab Session
3. Week
Working with scripts and functions in MATLAB
Presentation + Computer Lab Session
4. Week
Decision structures in MATLAB and Excel
Presentation + Computer Lab Session
5. Week
Repetition Structures in MATLAB
Presentation + Computer Lab Session
6. Week
Importing and Exporting data in MATLAB and Excel
Presentation + Computer Lab Session
7. Week
Plotting data with MATLAB and Excel
Presentation + Computer Lab Session
8. Week
Midterm Exam
Exam
9. Week
Data analysis functions, curve fitting and interpolation in MATLAB and Excel
Presentation + Computer Lab Session
10. Week
Matrix Operations with MATLAB and Excel
Presentation + Computer Lab Session
11. Week
Solution of a system of linear equations with MATLAB and Excel + Symbolic Mathematics with Matlab
Presentation + Computer Lab Session
12. Week
Solution of differential equations with MATLAB
Presentation + Computer Lab Session
13. Week
Modal Analysis with Matlab, Introduction to Simulink
Presentation + Computer Lab Session
14. Week
Simulink (Continued)
Presentation + Computer Lab Session
15. Week
16. Week
17. Week
Assessments
Evaluation tools
Quantity
Weight(%)
Midterm(s)
1
40
Final Exam
1
60
Program Outcomes
PO-1
Adequate knowledge in mathematics, science and engineering subjects pertaining to the relevant discipline; ability to use theoretical and applied knowledge in these areas in the solution of complex engineering problems.
PO-2
Ability to formulate, and solve complex engineering problems; ability to select and apply proper analysis and modeling methods for this purpose.
PO-3
Ability to design a complex systemi process, device or product under realistic constraints and conditions, in such a way as to meet the desired results; ability to apply modern design methods for this purpose.
PO-4
Ability to select and use modern techniques and tools needed for analyzing and Solving complex problems encountered in engineering practice; ability to employ information technologies effectively.
PO-5
Ability to design and conduct experiments, gather data, analyze and interpret results for investing complex engineering problems or discipline specific research questions.
PO-6
Ability to work efficiently in intra-disciplinary and multi-disciplinary teams; ability to work individually.
PO-7
Ability to communicate effectivley, both orally and in writing; knowledge of a minimum of one foreign language; ability to write effective reports and comprehend written reports, prepare design and production reports, make effective presentations, and give and receive clear and intelligible instruction.
PO-8
Awareness of the need for lifelong learning; ability to access information, to follow developments in science and technology, and to continue to educate him/herself.
PO-9
Knowledge on behavior according ethical principles, professional and ethical responsibility and standards used in engineering practices.
PO-10
Knowledge about business life practices such as project management, risk management, and change management; awareness in entrepreneurship, innovation; knowledge about sustainable development.
PO-11
Knowledge about the global and social effects of engineering practices on health, environment, and safety, and contemporary issues of the century reflected into the field of engineering; awareness of the legal consequences of engineering solutions.
Learning Outcomes
LO-1
Understand the fundamentals of the engineering problem solving process (KNOWLEDGE)
LO-2
Use MATLAB and Excel to import, analyze and export data (SKILL)
LO-3
Use MATLAB and Excel to carry out matrix operations (SKILL)
LO-4
Use MATLAB to solve differential equations (SKILL)
LO-5
Use the programming features of MATLAB and Excel to solve engineering problems (SKILL)
