TÜRKÇE
ENGLISH
Information
| Code | CBS111 |
| Name | Transactional Tables -I |
| Term | 2024-2025 Academic Year |
| Semester | 1. Semester |
| Duration (T+A) | 2-1 (T-A) (17 Week) |
| ECTS | 3 ECTS |
| National Credit | 2.5 National Credit |
| Teaching Language | Türkçe |
| Level | Ön Lisans Dersi |
| Type | Normal |
| Label | VK Vocational Knowledge Courses C Compulsory |
| Mode of study | Yüz Yüze Öğretim |
| Catalog Information Coordinator | Doç. Dr. MAHMUT DİNGİL |
| Course Instructor |
Doç. Dr. MAHMUT DİNGİL
(A Group)
(Ins. in Charge)
|
Course Goal / Objective
Use Excel more efficiently
Course Content
1.General features of Excel. 2. Basic commands in menus. 3. To start working with Excel. 4. Toolbars. 5. The use of worksheets. 6. To input data in the tables. 7. Prepare and use formula. 8. To prepare graphics. 9. Preapering and using datbase
Course Precondition
Mastering basic computer use
Resources
Publications and documents describing Excel software
Notes
Current publications describing Excel software with explanatory examples.
Course Learning Outcomes
| Order | Course Learning Outcomes |
|---|---|
| LO01 | Learning the basic logic of the Excel program and in which areas it is used. |
| LO02 | Have knowledge about common usage areas of the program. |
| LO03 | Learn how to use the Excel program in different areas. |
| LO04 | Learn the basic mathematical applications of the program. |
| LO05 | Learns how to use ready-made formulas within the program. |
| LO06 | Learn how to create different formulas in an Excel spreadsheet. |
| LO07 | Learn how to create and edit tables in Excel. |
| LO08 | Learn how to prepare different table contents. |
Relation with Program Learning Outcome
| Order | Type | Program Learning Outcomes | Level |
|---|---|---|---|
| PLO01 | Bilgi - Kuramsal, Olgusal | In mathematics, science, and issues related to their areas to have adequate infrastructure. | |
| PLO02 | Bilgi - Kuramsal, Olgusal | Using the basic level knowledge and skills in the field, interpret and evaluate data, identify problems, develop solutions to have the ability. | 2 |
| PLO03 | Bilgi - Kuramsal, Olgusal | Knows the concepts related to Geographic Information Systems, Knows the use of GIS software | |
| PLO04 | Bilgi - Kuramsal, Olgusal | Awareness of the need for life-long learning, to follow developments in science and technology and continuous self-renewal with the skill. | 1 |
| PLO05 | Bilgi - Kuramsal, Olgusal | The ability to perform drawings of vocational plans and projects related to the field wins. | |
| PLO06 | Bilgi - Kuramsal, Olgusal | To show what they have learned and can apply independently to learn in the field of GIS and have the ability to act independently to take risks. | |
| PLO07 | Beceriler - Bilişsel, Uygulamalı | Modern techniques that are necessary on the field, and specify the information technologies and effective tools to use. | |
| PLO08 | Beceriler - Bilişsel, Uygulamalı | To have knowledge of GIS and produce project and apply knowledge. | |
| PLO09 | Beceriler - Bilişsel, Uygulamalı | Design using simulation programs related to computer-aided drawing and field and professional plan and gain the ability to perform the drawings of the project. | |
| PLO10 | Yetkinlikler - Bağımsız Çalışabilme ve Sorumluluk Alabilme Yetkinliği | Innovations in the field of effective communication techniques and be able to follow the judge to have knowledge of a foreign language. | |
| PLO11 | Yetkinlikler - Bağımsız Çalışabilme ve Sorumluluk Alabilme Yetkinliği | To produce a solution for problems related to GIS, to take responsibility for the team or individual it will be equipped with the ability to work. | |
| PLO12 | Yetkinlikler - Öğrenme Yetkinliği | Occupational safety, health and environmental protection, and to be conscious. | |
| PLO13 | Yetkinlikler - Öğrenme Yetkinliği | Required by the field to be able to use basic computer software and hardware. | 3 |
Week Plan
| Week | Topic | Preparation | Methods |
|---|---|---|---|
| 1 | What is the transectional tables. Introduction to Excel. | Reviewing common computer commands | Öğretim Yöntemleri: Anlatım |
| 2 | Screen view, toolbars | Repeating the first week. | Öğretim Yöntemleri: Anlatım |
| 3 | Worksheets | Repeating previous weeks. | Öğretim Yöntemleri: Anlatım, Gösterip Yaptırma |
| 4 | Data input to the tables | Repeating previous weeks. | Öğretim Yöntemleri: Anlatım, Gösterip Yaptırma |
| 5 | Operate on tables | Repeating previous weeks. | Öğretim Yöntemleri: Gösterip Yaptırma |
| 6 | Formating, page setup | Repeating previous weeks. | Öğretim Yöntemleri: Anlatım, Gösterip Yaptırma |
| 7 | Print and print preview of the tables | Repeating previous weeks. | Öğretim Yöntemleri: Anlatım |
| 8 | Mid-Term Exam | Studying on subjects of the first seven weeks | Ölçme Yöntemleri: Yazılı Sınav |
| 9 | Prepare and use formula | Repeating previous weeks. | Öğretim Yöntemleri: Anlatım, Gösterip Yaptırma |
| 10 | To prepare graphics | Repeating previous weeks. | Öğretim Yöntemleri: Anlatım, Gösterip Yaptırma |
| 11 | Chart types 1 | Repeating previous weeks. | Öğretim Yöntemleri: Anlatım, Gösterip Yaptırma |
| 12 | Chart types 2 | Repeating previous weeks. | Öğretim Yöntemleri: Anlatım, Gösterip Yaptırma |
| 13 | To prepare database | Repeating previous weeks. | Öğretim Yöntemleri: Anlatım |
| 14 | Database applications | Repeating previous weeks. | Öğretim Yöntemleri: Gösterip Yaptırma |
| 15 | General applications | Repeating previous weeks. | Öğretim Yöntemleri: Alıştırma ve Uygulama |
| 16 | Term Exams | Studying on subjects of the fifteen weeks | Ölçme Yöntemleri: Yazılı Sınav |
| 17 | Term Exams | Studying on subjects of the fifteen weeks | Ölçme Yöntemleri: Yazılı Sınav |
Student Workload - ECTS
| Works | Number | Time (Hour) | Workload (Hour) |
|---|---|---|---|
| Course Related Works | |||
| Class Time (Exam weeks are excluded) | 14 | 3 | 42 |
| Out of Class Study (Preliminary Work, Practice) | 14 | 2 | 28 |
| Assesment Related Works | |||
| Homeworks, Projects, Others | 1 | 2 | 2 |
| Mid-term Exams (Written, Oral, etc.) | 1 | 5 | 5 |
| Final Exam | 1 | 10 | 10 |
| Total Workload (Hour) | 87 | ||
| Total Workload / 25 (h) | 3,48 | ||
| ECTS | 3 ECTS | ||