Course Detail
Course Description
| Course | Code | Semester | T+P (Hour) | Credit | ECTS |
|---|---|---|---|---|---|
| INFORMATION TECHNOLOGY | - | 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) | Assoc.Prof. Özge DOĞUÇ |
| 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 | Defines the theoretical issues in the field of business administration | X | |||||
| 2 | Describes the necessary qualitative and quantitative methods in the field of business and management. | X | |||||
| 3 | Uses at least one computer program in the field of business and management | X | |||||
| 4 | Sustains proficiency in a foreign language required for business and management. | X | |||||
| 5 | Prepares managerial investment projects and work in a team. | X | |||||
| 6 | Constantly renews himself / herself by following developments in business and management with an understanding of the importance of lifelong learning through critically evaluating the knowledge and skills that s/he has got. | X | |||||
| 7 | Uses theoretical and practical expertise in the field of business administration | X | |||||
| 8 | Follows up-to-date technology using a foreign language at least A1 level, holds verbal / written communication. | X | |||||
| 9 | Adopts organizational / institutional and social ethical values. | X | |||||
| 10 | Within the framework of service responsiveness, adopts social responsibility principles and takes initiative when necessary. | X | |||||
| 11 | Uses and analyses basic facts and data in different disciplines (economics, finance, sociology, law, business) in order to conduct interdisciplinary studies. | X | |||||
| 12 | Uses and Analyses the fundamental and advanced techniques in the field to enhance business performance, productivity, sustainability,innovation and research, efficiency and effectiveness. | 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 | - | 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) | Assoc.Prof. Özge DOĞUÇ |
| 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 | Defines the theoretical issues in the field of business administration | X | |||||
| 2 | Describes the necessary qualitative and quantitative methods in the field of business and management. | X | |||||
| 3 | Uses at least one computer program in the field of business and management | X | |||||
| 4 | Sustains proficiency in a foreign language required for business and management. | X | |||||
| 5 | Prepares managerial investment projects and work in a team. | X | |||||
| 6 | Constantly renews himself / herself by following developments in business and management with an understanding of the importance of lifelong learning through critically evaluating the knowledge and skills that s/he has got. | X | |||||
| 7 | Uses theoretical and practical expertise in the field of business administration | X | |||||
| 8 | Follows up-to-date technology using a foreign language at least A1 level, holds verbal / written communication. | X | |||||
| 9 | Adopts organizational / institutional and social ethical values. | X | |||||
| 10 | Within the framework of service responsiveness, adopts social responsibility principles and takes initiative when necessary. | X | |||||
| 11 | Uses and analyses basic facts and data in different disciplines (economics, finance, sociology, law, business) in order to conduct interdisciplinary studies. | X | |||||
| 12 | Uses and Analyses the fundamental and advanced techniques in the field to enhance business performance, productivity, sustainability,innovation and research, efficiency and effectiveness. | X | |||||
Assessment Methods
| Contribution Level | Absolute Evaluation | |
| Rate of Midterm Exam to Success | 40 | |
| Rate of Final Exam to Success | 60 | |
| Total | 100 | |