ECTS - Computer Aided Analysis and Design in Structural Engineering

Computer Aided Analysis and Design in Structural Engineering (CE567) Course Detail

Course Name Course Code Season Lecture Hours Application Hours Lab Hours Credit ECTS
Computer Aided Analysis and Design in Structural Engineering CE567 Area Elective 3 0 0 3 5
Pre-requisite Course(s)
N/A
Course Language English
Course Type Elective Courses
Course Level Natural & Applied Sciences Master's Degree
Mode of Delivery Face To Face
Learning and Teaching Strategies Lecture, Drill and Practice, Problem Solving, Project Design/Management.
Course Coordinator
Course Lecturer(s)
  • Asst. Prof. Dr. Halit Cenan MERTOL
Course Assistants
Course Objectives To understand concepts in structural analysis and design with the aid of a computer. To familiarize students on the state-of-the-art software and use the software in structural engineering applications.
Course Learning Outcomes The students who succeeded in this course;
  • Students will be able to use Excel as a programming tool.
  • Students will be able to develop algorithms used in designing structural elements.
  • Students will be able to use Visual Basic to execute and control various programs in different platforms.
  • Students will be able to develop honesty when they apply computer-aided analysis and design.
  • Students will be able to develop patience and perseverance in students as they learn how to use the structural engineering software.
Course Content Introduction to Excel and Visual Basic, Excel and Visual Basic programming, fundamentals of Excel, database and pivot tables, design of reinforced concrete beams, design of reinforced concrete columns, userforms, analysis of reinforced concrete beams, design of steel beams and columns, introduction to SAP2000, simultaneous use of Excel with other p

Weekly Subjects and Releated Preparation Studies

Week Subjects Preparation
1 Introduction to Excel
2 Excel Basics
3 Databases and Pivot Tables
4 Programming in Excel
5 Programming in Excel
6 Userforms
7 Analysis of Structures
8 Analysis of Reinforced Concrete Beams
9 Design of Reinforced Concrete Beams
10 Design of Reinforced Concrete Columns
11 Design of Reinforced Concrete Columns
12 Use of Excel with Other Programs
13 Use of Excel with Other Programs
14 Use of Excel with Other Programs
15 Final Exam Period
16 Final Exam Period

Sources

Other Sources 1. Introduction to VBA for Excel, Steven C. Chapra, Prentice Hall, 2010.
2. Excel 2010 Power Programming with VBA, John Walkenbach, Wiley Publishing, 2010.
3. Excel for Scientists and Engineers, E. Joseph Billo, 2007.

Evaluation System

Requirements Number Percentage of Grade
Attendance/Participation - -
Laboratory - -
Application - -
Field Work - -
Special Course Internship - -
Quizzes/Studio Critics - -
Homework Assignments 7 40
Presentation - -
Project 1 10
Report - -
Seminar - -
Midterms Exams/Midterms Jury 1 20
Final Exam/Final Jury 1 30
Toplam 10 100
Percentage of Semester Work 70
Percentage of Final Work 30
Total 100

Course Category

Core Courses
Major Area Courses X
Supportive Courses
Media and Managment Skills Courses
Transferable Skill Courses

The Relation Between Course Learning Competencies and Program Qualifications

# Program Qualifications / Competencies Level of Contribution
1 2 3 4 5
1 Gains the ability to have in-depth knowledge of mathematics, science, and engineering, and to use this knowledge in solving Civil Engineering problems. X
2 Gains the ability to design and produce Civil Engineering systems under economic, environmental sustainability, and manufacturability constraints.
3 Gains the ability to identify, define, formulate, and solve complex engineering problems, and acquires the ability to select and apply appropriate analysis and modeling methods for this purpose. X
4 Gains the ability to develop an approach to solve encountered engineering problems, and to design and conduct models and experiments. X
5 Gains the ability to effectively use modern engineering tools, techniques, and capabilities necessary for design and other engineering applications.
6 Gains the ability to independently conduct fundamental research in the field, report research results effectively, and present them at scientific meetings. X
7 Acquires sufficient verbal and written English skills to follow scientific developments in the field and to communicate with colleagues.
8 Gains the ability to effectively use the knowledge acquired in intra-disciplinary and interdisciplinary teams, and to take leadership roles in such teams. X
9 Gains awareness of the necessity of lifelong learning, personal development, and continuous self-renewal in the field; follows developments in science and technology; acquires awareness of entrepreneurship and innovation.
10 Recognizes the importance of considering social, scientific, and ethical values in the stages of collecting, interpreting, disseminating, and applying data related to civil engineering problems. X
11 Gains the competence to critically examine, develop, and, when necessary, take action to change social relations and the norms that govern them.

ECTS/Workload Table

Activities Number Duration (Hours) Total Workload
Course Hours (Including Exam Week: 16 x Total Hours) 16 3 48
Laboratory
Application
Special Course Internship
Field Work
Study Hours Out of Class 14 2 28
Presentation/Seminar Prepration
Project 1 10 10
Report
Homework Assignments 7 3 21
Quizzes/Studio Critics
Prepration of Midterm Exams/Midterm Jury 1 8 8
Prepration of Final Exams/Final Jury 1 10 10
Total Workload 125