TÜRKÇE
ENGLISH
Information
| Unit | TECHNICAL SCIENCES VOCATIONAL SCHOOL |
| GEOGRAPHICAL INFORMATION SYSTEMS PR. | |
| Code | CBS111 |
| Name | Transactional Tables -I |
| Term | 2021-2022 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 | 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
(Güz)
(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
Resources
Notes
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 | - | In mathematics, science, and issues related to their areas to have adequate infrastructure. | 3 |
| PLO02 | - | Using the basic level knowledge and skills in the field, interpret and evaluate data, identify problems, develop solutions to have the ability. | 4 |
| PLO03 | - | Knows the concepts related to Geographic Information Systems, Knows the use of GIS software | 2 |
| PLO04 | - | Awareness of the need for life-long learning, to follow developments in science and technology and continuous self-renewal with the skill. | 5 |
| PLO05 | - | Following the application of production processes in industrial and service sector to have the ability. | 5 |
| PLO06 | - | The ability to perform drawings of vocational plans and projects related to the field wins. | 4 |
| PLO07 | - | To recognize the corporate structure of the company for the profession and have the entrepreneurial spirit. | 3 |
| PLO08 | - | 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. | 3 |
| PLO09 | - | Modern techniques that are necessary on the field, and specify the information technologies and effective tools to use. | 4 |
| PLO10 | - | To have knowledge of GIS and produce project and apply knowledge. | 3 |
| PLO11 | - | 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. | 5 |
| PLO12 | - | Respect for historical values, social responsibility, global, to have a social and professional ethics. | 4 |
| PLO13 | - | Innovations in the field of effective communication techniques and be able to follow the judge to have knowledge of a foreign language. | 3 |
| PLO14 | - | 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. | 4 |
| PLO15 | - | Occupational safety, health and environmental protection, and to be conscious. | 3 |
| PLO16 | - | Required by the field to be able to use basic computer software and hardware. | 4 |
Week Plan
| Week | Topic | Preparation | Methods |
|---|---|---|---|
| 1 | What is the transectional tables. Introduction to Excel. | None | |
| 2 | Screen view, toolbars | Repeating the first week. | |
| 3 | Worksheets | Repeating previous weeks. | |
| 4 | Data input to the tables | Repeating previous weeks. | |
| 5 | Operate on tables | Repeating previous weeks. | |
| 6 | Formating, page setup | Repeating previous weeks. | |
| 7 | Print and print preview of the tables | Repeating previous weeks. | |
| 8 | Mid-Term Exam | Studying on subjects of the first seven weeks | |
| 9 | Prepare and use formula | Repeating previous weeks. | |
| 10 | To prepare graphics | Repeating previous weeks. | |
| 11 | Chart types 1 | Repeating previous weeks. | |
| 12 | Chart types 2 | Repeating previous weeks. | |
| 13 | To prepare database | Repeating previous weeks. | |
| 14 | Database applications | Repeating previous weeks. | |
| 15 | General applications | Repeating previous weeks. | |
| 16 | Term Exams | Studying on subjects of the fifteen weeks | |
| 17 | Term Exams | Studying on subjects of the fifteen weeks |
Assessment (Exam) Methods and Criteria
| Assessment Type | Midterm / Year Impact | End of Term / End of Year Impact |
|---|---|---|
| 1. Midterm Exam | 100 | 40 |
| General Assessment | ||
| Midterm / Year Total | 100 | 40 |
| 1. Final Exam | - | 60 |
| Grand Total | - | 100 |
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 | ||