CBS111 Transactional Tables -I

3 ECTS - 2-1 Duration (T+A)- 1. Semester- 2.5 National Credit

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
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 They learn the contents of Excel.
LO02 They have about as common area of usage of the program.
LO03 Thery learn how to use the different areas of Excel.
LO04 They learn the basic mathematical implement the program.
LO05 They learn the use of ready-made formulas in Excel.
LO06 They learn about the creation of different formulas in Excel spreadsheet.
LO07 They learn creating and editing tables in Excel.
LO08 They learn preparing 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

Update Time: 14.05.2024 11:27