Course Description
Course | Code | Semester | T+P (Hour) | Credit | ECTS |
---|---|---|---|---|---|
INFORMATION TECHNOLOGY | ITF1124520 | Fall Semester | 2+0 | 2 | 5 |
Course Program |
Prerequisites Courses | |
Recommended Elective Courses |
Language of Course | English |
Course Level | First Cycle (Bachelor's Degree) |
Course Type | Required |
Course Coordinator | Assist.Prof. Recep ÖZSÜRÜNÇ |
Name of Lecturer(s) | Assist.Prof. Recep ÖZSÜRÜNÇ |
Assistant(s) | |
Aim | To teach student fundamentals of hardware, operating systems, office programs and especially spreadsheet program (excel) in order to have them ability to use them for management and operational levels. |
Course Content | This course contains; History of Computer and Introduction to Office Programs,Creating a Worksheet and Charting Data in Excel,Creating a Worksheet and Charting Data in Excel,Creating a Worksheet and Charting Data in Excel,Using Functions, Creating Tables, and Managing Large Workbooks in Excel,Using Functions, Creating Tables, and Managing Large Workbooks in Excel,Using Functions, Creating Tables, and Managing Large Workbooks in Excel,Creating Documents with Microsoft Word,Creating Documents with Microsoft Word,Creating Cover Letters and Using Tables to Create Resumes,Creating Cover Letters and Using Tables to Create Resumes,Getting Started with Microsoft PowerPoint,Getting Started with Microsoft PowerPoint,Formatting PowerPoint Presentations. |
Dersin Öğrenme Kazanımları | Teaching Methods | Assessment Methods |
5.Will be able to use presentation programs. | 12, 14, 16, 4, 6, 9 | A, E, G |
1. will be able to explains the basic concepts of information technology. | 16, 9 | A, E |
1.1 Explains the general concepts. | ||
1.2 Displays hardware components. | ||
1.3 Explains the concept of software, examples of software types. | ||
2. Will be able to apply computer usage and file management. | 16, 8, 9 | A, E |
2.1 Turns on the computer device. | ||
2.2 Explains the concept of the desktop. | ||
2.3 Describes how to perform file management. | ||
3. Will be able to express how the word processor program is used. | 12, 14, 16, 9 | A, E, G |
3.1. Describes usage of the application. | ||
3.2. Explains Basic Operations. | ||
3.3. Explains formatting methods. | ||
4. Will be able to use a spreadsheet program. | 12, 14, 16, 4, 9 | A, E, G |
4.1. Describes the usage of the application. | ||
4.2. Explains cell concept. | ||
4.3. Describes the concept of the worksheet. | ||
4.4. Uses Formulas and Functions. | ||
4.5. Describes the types of formatting. | ||
4.6. Describes the use of graphics. | ||
5.1. Describes usage of the application. | ||
5.2. Describes creating a presentation. | ||
5.3. opens Text and Views . | ||
5.4. applies the use of Graphics and Drawing Objects (Auto Shape). | ||
5.5. Uses Screen Display Effects. |
Teaching Methods: | 12: Problem Solving Method, 14: Self Study Method, 16: Question - Answer Technique, 4: Inquiry-Based Learning, 6: Experiential Learning, 8: Flipped Classroom Learning, 9: Lecture Method |
Assessment Methods: | A: Traditional Written Exam, E: Homework, G: Quiz |
Course Outline
Order | Subjects | Preliminary Work |
---|---|---|
1 | History of Computer and Introduction to Office Programs | Related chapter in the course book should be read. |
2 | Creating a Worksheet and Charting Data in Excel | Related chapter in the course book should be read. |
3 | Creating a Worksheet and Charting Data in Excel | Related chapter in the course book should be read. |
4 | Creating a Worksheet and Charting Data in Excel | Related chapter in the course book should be read. |
5 | Using Functions, Creating Tables, and Managing Large Workbooks in Excel | Related chapter in the course book should be read. |
6 | Using Functions, Creating Tables, and Managing Large Workbooks in Excel | Related chapter in the course book should be read. |
7 | Using Functions, Creating Tables, and Managing Large Workbooks in Excel | Related chapter in the course book should be read. |
8 | Creating Documents with Microsoft Word | Related chapter in the course book should be read. |
9 | Creating Documents with Microsoft Word | Related chapter in the course book should be read. |
10 | Creating Cover Letters and Using Tables to Create Resumes | Related chapter in the course book should be read. |
11 | Creating Cover Letters and Using Tables to Create Resumes | Related chapter in the course book should be read. |
12 | Getting Started with Microsoft PowerPoint | Related chapter in the course book should be read. |
13 | Getting Started with Microsoft PowerPoint | Related chapter in the course book should be read. |
14 | Formatting PowerPoint Presentations | Related chapter in the course book should be read. |
Resources |
Evans, A., Martin, K., & Poatsy, M. A. (2018). Technology in Action Introductory. Pearson. |
Jelen, B. (2021). Microsoft Excel Inside Out (Office 2021 and Microsoft 365). Microsoft Press. Pearson MyLab Platform |
Course Contribution to Program Qualifications
Course Contribution to Program Qualifications | |||||||
No | Program Qualification | Contribution Level | |||||
1 | 2 | 3 | 4 | 5 | |||
1 | Uluslararası ticaret ve finansman alanında teorik bilgileri tanımlar. | X | |||||
2 | Uluslararası ticaret ve finansman alanında gerekli matematiksel ve istatistiki yöntemleri anlatır. | X | |||||
3 | Uluslararası ticaret ve finansman alanında gerekli en az bir bilgisayar programı kullanır. | X | |||||
4 | Uluslararası ticaret ve finansman alanında gerekli olan mesleki yabancı dil yeterliliğini gösterir. | X | |||||
5 | Uluslararası ticaret ve finansman alanında projeler hazırlar ve takım çalışmalarını yönetir. | X | |||||
6 | Mesleki alanda yaşam boyu öğrenmenin gerekliliği bilinciyle bilim ve teknolojideki gelişmeleri izleyerek kendini sürekli yenileyip edindiği bilgi ve becerileri eleştirel olarak değerlendirir. | X | |||||
7 | Uluslararası ticaret ve finansman alanında teorik ve uygulamaya yönelik bilgileri kullanır | X | |||||
8 | En az A1 düzeyinde bir yabancı dili kullanarak güncel teknolojileri takip eder, sözlü / yazılı iletişim kurar. | X | |||||
9 | Örgüt / kurumsal, iş ve toplumsal etik değerlerini benimser ve kullanır. | X | |||||
10 | Topluma hizmet duyarlılığı çerçevesinde, sosyal sorumluluk ilkelerini benimser ve gerektiğinde inisiyatif alır. | X | |||||
11 | Disiplinler arası çalışmalar yürütebilmek için farklı disiplinlerde (ekonomi, finans, sosyoloji, hukuk, işletme) temel bilgileri ve verileri analiz ederek alanında kullanır. | X | |||||
12 | Öğrenciler, küresel ticaret, ihracat-ithalat işlemleri, gümrük işlemleri ve dış ticaretin finansmanı alanlarında uzmanlık elde eder. | X |
Assessment Methods
Contribution Level | Absolute Evaluation | |
Rate of Midterm Exam to Success | 40 | |
Rate of Final Exam to Success | 60 | |
Total | 100 |
ECTS / Workload Table | ||||||
Activities | Number of | Duration(Hour) | Total Workload(Hour) | |||
Course Hours | 14 | 2 | 28 | |||
Guided Problem Solving | 3 | 7 | 21 | |||
Resolution of Homework Problems and Submission as a Report | 2 | 16 | 32 | |||
Term Project | 0 | 0 | 0 | |||
Presentation of Project / Seminar | 7 | 5 | 35 | |||
Quiz | 1 | 3 | 3 | |||
Midterm Exam | 1 | 7 | 7 | |||
General Exam | 1 | 14 | 14 | |||
Performance Task, Maintenance Plan | 0 | 0 | 0 | |||
Total Workload(Hour) | 140 | |||||
Dersin AKTS Kredisi = Toplam İş Yükü (Saat)/30*=(140/30) | 5 | |||||
ECTS of the course: 30 hours of work is counted as 1 ECTS credit. |
Detail Informations of the Course
Course Description
Course | Code | Semester | T+P (Hour) | Credit | ECTS |
---|---|---|---|---|---|
INFORMATION TECHNOLOGY | ITF1124520 | Fall Semester | 2+0 | 2 | 5 |
Course Program |
Prerequisites Courses | |
Recommended Elective Courses |
Language of Course | English |
Course Level | First Cycle (Bachelor's Degree) |
Course Type | Required |
Course Coordinator | Assist.Prof. Recep ÖZSÜRÜNÇ |
Name of Lecturer(s) | Assist.Prof. Recep ÖZSÜRÜNÇ |
Assistant(s) | |
Aim | To teach student fundamentals of hardware, operating systems, office programs and especially spreadsheet program (excel) in order to have them ability to use them for management and operational levels. |
Course Content | This course contains; History of Computer and Introduction to Office Programs,Creating a Worksheet and Charting Data in Excel,Creating a Worksheet and Charting Data in Excel,Creating a Worksheet and Charting Data in Excel,Using Functions, Creating Tables, and Managing Large Workbooks in Excel,Using Functions, Creating Tables, and Managing Large Workbooks in Excel,Using Functions, Creating Tables, and Managing Large Workbooks in Excel,Creating Documents with Microsoft Word,Creating Documents with Microsoft Word,Creating Cover Letters and Using Tables to Create Resumes,Creating Cover Letters and Using Tables to Create Resumes,Getting Started with Microsoft PowerPoint,Getting Started with Microsoft PowerPoint,Formatting PowerPoint Presentations. |
Dersin Öğrenme Kazanımları | Teaching Methods | Assessment Methods |
5.Will be able to use presentation programs. | 12, 14, 16, 4, 6, 9 | A, E, G |
1. will be able to explains the basic concepts of information technology. | 16, 9 | A, E |
1.1 Explains the general concepts. | ||
1.2 Displays hardware components. | ||
1.3 Explains the concept of software, examples of software types. | ||
2. Will be able to apply computer usage and file management. | 16, 8, 9 | A, E |
2.1 Turns on the computer device. | ||
2.2 Explains the concept of the desktop. | ||
2.3 Describes how to perform file management. | ||
3. Will be able to express how the word processor program is used. | 12, 14, 16, 9 | A, E, G |
3.1. Describes usage of the application. | ||
3.2. Explains Basic Operations. | ||
3.3. Explains formatting methods. | ||
4. Will be able to use a spreadsheet program. | 12, 14, 16, 4, 9 | A, E, G |
4.1. Describes the usage of the application. | ||
4.2. Explains cell concept. | ||
4.3. Describes the concept of the worksheet. | ||
4.4. Uses Formulas and Functions. | ||
4.5. Describes the types of formatting. | ||
4.6. Describes the use of graphics. | ||
5.1. Describes usage of the application. | ||
5.2. Describes creating a presentation. | ||
5.3. opens Text and Views . | ||
5.4. applies the use of Graphics and Drawing Objects (Auto Shape). | ||
5.5. Uses Screen Display Effects. |
Teaching Methods: | 12: Problem Solving Method, 14: Self Study Method, 16: Question - Answer Technique, 4: Inquiry-Based Learning, 6: Experiential Learning, 8: Flipped Classroom Learning, 9: Lecture Method |
Assessment Methods: | A: Traditional Written Exam, E: Homework, G: Quiz |
Course Outline
Order | Subjects | Preliminary Work |
---|---|---|
1 | History of Computer and Introduction to Office Programs | Related chapter in the course book should be read. |
2 | Creating a Worksheet and Charting Data in Excel | Related chapter in the course book should be read. |
3 | Creating a Worksheet and Charting Data in Excel | Related chapter in the course book should be read. |
4 | Creating a Worksheet and Charting Data in Excel | Related chapter in the course book should be read. |
5 | Using Functions, Creating Tables, and Managing Large Workbooks in Excel | Related chapter in the course book should be read. |
6 | Using Functions, Creating Tables, and Managing Large Workbooks in Excel | Related chapter in the course book should be read. |
7 | Using Functions, Creating Tables, and Managing Large Workbooks in Excel | Related chapter in the course book should be read. |
8 | Creating Documents with Microsoft Word | Related chapter in the course book should be read. |
9 | Creating Documents with Microsoft Word | Related chapter in the course book should be read. |
10 | Creating Cover Letters and Using Tables to Create Resumes | Related chapter in the course book should be read. |
11 | Creating Cover Letters and Using Tables to Create Resumes | Related chapter in the course book should be read. |
12 | Getting Started with Microsoft PowerPoint | Related chapter in the course book should be read. |
13 | Getting Started with Microsoft PowerPoint | Related chapter in the course book should be read. |
14 | Formatting PowerPoint Presentations | Related chapter in the course book should be read. |
Resources |
Evans, A., Martin, K., & Poatsy, M. A. (2018). Technology in Action Introductory. Pearson. |
Jelen, B. (2021). Microsoft Excel Inside Out (Office 2021 and Microsoft 365). Microsoft Press. Pearson MyLab Platform |
Course Contribution to Program Qualifications
Course Contribution to Program Qualifications | |||||||
No | Program Qualification | Contribution Level | |||||
1 | 2 | 3 | 4 | 5 | |||
1 | Uluslararası ticaret ve finansman alanında teorik bilgileri tanımlar. | X | |||||
2 | Uluslararası ticaret ve finansman alanında gerekli matematiksel ve istatistiki yöntemleri anlatır. | X | |||||
3 | Uluslararası ticaret ve finansman alanında gerekli en az bir bilgisayar programı kullanır. | X | |||||
4 | Uluslararası ticaret ve finansman alanında gerekli olan mesleki yabancı dil yeterliliğini gösterir. | X | |||||
5 | Uluslararası ticaret ve finansman alanında projeler hazırlar ve takım çalışmalarını yönetir. | X | |||||
6 | Mesleki alanda yaşam boyu öğrenmenin gerekliliği bilinciyle bilim ve teknolojideki gelişmeleri izleyerek kendini sürekli yenileyip edindiği bilgi ve becerileri eleştirel olarak değerlendirir. | X | |||||
7 | Uluslararası ticaret ve finansman alanında teorik ve uygulamaya yönelik bilgileri kullanır | X | |||||
8 | En az A1 düzeyinde bir yabancı dili kullanarak güncel teknolojileri takip eder, sözlü / yazılı iletişim kurar. | X | |||||
9 | Örgüt / kurumsal, iş ve toplumsal etik değerlerini benimser ve kullanır. | X | |||||
10 | Topluma hizmet duyarlılığı çerçevesinde, sosyal sorumluluk ilkelerini benimser ve gerektiğinde inisiyatif alır. | X | |||||
11 | Disiplinler arası çalışmalar yürütebilmek için farklı disiplinlerde (ekonomi, finans, sosyoloji, hukuk, işletme) temel bilgileri ve verileri analiz ederek alanında kullanır. | X | |||||
12 | Öğrenciler, küresel ticaret, ihracat-ithalat işlemleri, gümrük işlemleri ve dış ticaretin finansmanı alanlarında uzmanlık elde eder. | X |
Assessment Methods
Contribution Level | Absolute Evaluation | |
Rate of Midterm Exam to Success | 40 | |
Rate of Final Exam to Success | 60 | |
Total | 100 |