ECTS - Computer Aided Analysis and Design in Structural Engineering

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

Course Name Course Code Season Lecture Hours Application Hours Lab Hours Credit ECTS
Computer Aided Analysis and Design in Structural Engineering CE447 Area Elective 3 0 0 3 6
Pre-requisite Course(s)
CE321 ve CE342
Course Language English
Course Type Elective Courses
Course Level Bachelor’s Degree (First Cycle)
Mode of Delivery Face To Face
Learning and Teaching Strategies Lecture, Question and Answer, Drill and Practice, Problem Solving.
Course Coordinator
Course Lecturer(s)
  • Assoc. 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, introduction to Excel and Visual Basic programming, programming in excel, design of reinforced concrete beams, design of reinforced concrete columns, deflection of reinforced concrete beams, design of steel beams, design of steel columns, introduction to SAP2000, use of Excel and SAP2000 simultaneously.

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 Analysis 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 Review
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 5 30
Presentation - -
Project - -
Report - -
Seminar - -
Midterms Exams/Midterms Jury 1 30
Final Exam/Final Jury 1 45
Toplam 7 105
Percentage of Semester Work 57
Percentage of Final Work 43
Total 100

Course Category

Core Courses X
Major Area Courses
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 Engineering Knowledge: Knowledge of mathematics, science, fundamental engineering, computational sciences, and related engineering disciplines; the ability to apply this knowledge to solve complex engineering problems. X
2 Problem Analysis: The ability to identify, formulate, and analyze complex engineering problems using fundamental scientific, mathematical, and engineering knowledge, considering the relevant UN Sustainable Development Goals.
3 Engineering Design: The ability to design creative solutions to complex engineering problems; the ability to design complex systems, processes, devices, or products to meet current and future requirements, considering realistic constraints and conditions. X
4 Techniques and Tool Usage: The ability to select and use appropriate techniques, resources, and modern engineering and computing tools, including estimation and modeling, for the analysis and solution of complex engineering problems, while being aware of their limitations. X
5 Research and Investigation: The ability to use research methods, including literature review, designing experiments, conducting experiments, collecting data, analyzing and interpreting results, to investigate complex engineering problems.
6 Global Impact of Engineering Applications: Information about the impacts of engineering applications on society, health and safety, the economy, sustainability and the environment within the framework of the UN Sustainable Development Goals; awareness of the legal consequences of engineering solutions.
7 Engineering Ethics: Knowledge of ethical responsibility and adherence to engineering professional principles; awareness of impartiality, lack of discrimination, and inclusivity.
8 Individual and Teamwork: The ability to work effectively individually and as a team member or leader in interdisciplinary and multidisciplinary teams (face-to-face, on-line, or hybrid). X
9 Oral and Written Communication: The ability to communicate effectively orally and in writing on technical topics, considering the diverse differences of the target audience (education, language, profession, etc.).
10 Project Management: Knowledge of business practices such as project management and economic feasibility analysis; awareness of entrepreneurship and innovation.
11 Lifelong Learning: The ability to learn independently and continuously, adapt to new and emerging technologies, and think critically about technological change.

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 3 42
Presentation/Seminar Prepration
Project
Report
Homework Assignments 5 7 35
Quizzes/Studio Critics
Prepration of Midterm Exams/Midterm Jury 1 10 10
Prepration of Final Exams/Final Jury 1 15 15
Total Workload 150