Civil Engineering (English)
Bachelor TR-NQF-HE: Level 6 QF-EHEA: First Cycle EQF-LLL: Level 6

General course introduction information

Course Code: BST152
Course Name: Bilişim Uygulamaları
Course Semester: Spring
Course Credits:
Theoretical Practical Credit ECTS
3 0 3 6
Language of instruction: TR
Course Requisites:
Does the Course Require Work Experience?: No
Type of course: University Elective
Course Level:
Bachelor TR-NQF-HE:6. Master`s Degree QF-EHEA:First Cycle EQF-LLL:6. Master`s Degree
Mode of Delivery: Face to face
Course Coordinator : Dr.Öğr.Üyesi İLKER CALAYOĞLU
Course Lecturer(s):



Course Assistants:

Course Objective and Content

Course Objectives: The aim is to prepare professional documents using computer use, file management, word processing, presentation and number processing software.
Course Content: Creating text, formatting, creating and managing tables, pictures and shapes using word processing programs; addressing with number processing programs, calculating with formulas, basic data analysis, performing pivot table and graphic operations.

Learning Outcomes

The students who have succeeded in this course;
Learning Outcomes
1 - Knowledge
Theoretical - Conceptual
2 - Skills
Cognitive - Practical
1) Can use word processing software effectively.
2) Can use presentation processor software effectively.
3) Can use number processing software effectively.
3 - Competences
Communication and Social Competence
Learning Competence
1) Compiles, organizes and summarizes data.
2) To analyzes the data by reaching the desired ones from the mass data.
Field Specific Competence
Competence to Work Independently and Take Responsibility

Lesson Plan

Week Subject Related Preparation
1) Word 2019 – File and View Tab, Window Applications
2) Word 2019 – Home, Insert and Design Tab
3) Word 2019 – Page Layout, References and Mail Tab
4) Word 2019 – Review, View and Developer Tab
5) Power Point 2019 – Insert, Design, Transitions and Animation Tabs
6) Excel 2019 - Basic Excel Usage, Creating Tables and Formatting Cells
7) Excel 2019 - Doing Four Operations/Working with Worksheets and Books and Absolute Addressing
8) Excel 2019 - Logical and Mathematical Functions
9) Excel 2019 – Working with Search Formulas
10) Excel 2019 – Working with Data Lists, Data Validation, and Conditional Formatting
11) Excel 2019 – Working with Data Lists, Data Validation, and Conditional Formatting
12) Excel 2019 - Chart Types, Creation and Formatting
13) Excel 2019 – Pivot Chart and Advanced Charting
14) Excel 2019 – Working with Solver

Sources

Course Notes / Textbooks: Öğretim üyesinin belge paylaşımları
References: Microsoft Office 2016, Osman Gürkan, Nirvana Yayınları
Microsoft Word 2010 Step by Step (Step By Step (Microsoft)) by Joyce Cox and Joan Lambert III (Jun 23, 2010)

Course-Program Learning Outcome Relationship

Learning Outcomes

1

2

3

4

5

Program Outcomes
1) Adequate knowledge in mathematics, science and engineering subjects pertaining to the relevant discipline; ability to use theoretical and applied information in these areas to model and solve engineering problems.
2) Ability to identify, formulate, and solve complex engineering problems; ability to select and apply proper analysis and modelling methods for this purpose.
3) Ability to design a complex system, process, device or product under realistic constraints and conditions, in such a way so as to meet the desired result; ability to apply modern design methods for this purpose. (Realistic constraints and conditions may include factors such as economic and environmental issues, sustainability, manufacturability, ethics, health, safety issues, and social and political issues according to the nature of the design.)
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.
5) Ability to design and conduct experiments, gather data, analyze and interpret results for investigating complex engineering problems or discipline specific research questions.
6) Ability to work efficiently in intra-disciplinary and multi-disciplinary teams; ability to work individually.
7) Ability to communicate effectively, 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 instructions.
8) Recognition of the need for lifelong learning; ability to access information, to follow developments in science and technology, and to continue to educate him/herself.
9) Knowledge on behavior according ethical principles, professional and ethical responsibility and standards used in engineering practices.
10) Knowledge about business life practices such as project management, risk management, and change management; awareness in entrepreneurship, innovation; knowledge about sustainable development.
11) Knowledge about contemporary issues and the global and societal effects of engineering practices on health, environment, and safety; awareness of the legal consequences of engineering solutions.

Course - Learning Outcome Relationship

No Effect 1 Lowest 2 Low 3 Average 4 High 5 Highest
           
Program Outcomes Level of Contribution
1) Adequate knowledge in mathematics, science and engineering subjects pertaining to the relevant discipline; ability to use theoretical and applied information in these areas to model and solve engineering problems.
2) Ability to identify, formulate, and solve complex engineering problems; ability to select and apply proper analysis and modelling methods for this purpose.
3) Ability to design a complex system, process, device or product under realistic constraints and conditions, in such a way so as to meet the desired result; ability to apply modern design methods for this purpose. (Realistic constraints and conditions may include factors such as economic and environmental issues, sustainability, manufacturability, ethics, health, safety issues, and social and political issues according to the nature of the design.)
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.
5) Ability to design and conduct experiments, gather data, analyze and interpret results for investigating complex engineering problems or discipline specific research questions.
6) Ability to work efficiently in intra-disciplinary and multi-disciplinary teams; ability to work individually.
7) Ability to communicate effectively, 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 instructions.
8) Recognition of the need for lifelong learning; ability to access information, to follow developments in science and technology, and to continue to educate him/herself.
9) Knowledge on behavior according ethical principles, professional and ethical responsibility and standards used in engineering practices.
10) Knowledge about business life practices such as project management, risk management, and change management; awareness in entrepreneurship, innovation; knowledge about sustainable development.
11) Knowledge about contemporary issues and the global and societal effects of engineering practices on health, environment, and safety; awareness of the legal consequences of engineering solutions.

Learning Activity and Teaching Methods

Lesson
Homework

Assessment & Grading Methods and Criteria

Homework
Application

Assessment & Grading

Semester Requirements Number of Activities Level of Contribution
Homework Assignments 1 % 40
Final 1 % 60
total % 100
PERCENTAGE OF SEMESTER WORK % 40
PERCENTAGE OF FINAL WORK % 60
total % 100

Workload and ECTS Credit Grading

Activities Number of Activities Duration (Hours) Workload
Course Hours 15 3 45
Study Hours Out of Class 14 6 84
Homework Assignments 1 24 24
Final 1 12 12
Total Workload 165