| Course Objectives: |
The aim of this course is to equip students with basic information technology skills, enabling them to effectively use Microsoft Excel, Word, and PowerPoint. |
| Course Content: |
Throughout the course, students will explore the fundamental functions of Excel, such as data organization, creating tables, and charts; the essential features of Word, including text formatting, editing, and document preparation; and the core areas of PowerPoint usage, such as creating presentations and editing slides. Through these programs, students will enhance their ability to work efficiently in digital environments and acquire problem-solving skills for various digital challenges they may encounter in daily life. |
Course Learning Outcomes (CLOs) are those describing the knowledge, skills and competencies that students are expected to achieve upon successful completion of the course. In this context, Course Learning Outcomes defined for this course unit are as follows:
|
|
|
|
| Knowledge
(Described as Theoritical and/or Factual Knowledge.)
|
1) Students will be able to organize data and create tables using Microsoft Excel.
|
2) Students will acquire the skills to identify and troubleshoot basic computer issues.
|
3) Students will develop essential information technology skills required for efficient work in digital environments.
|
| Skills
(Describe as Cognitive and/or Practical Skills.)
|
1) Students will gain the ability to format text and prepare professional documents using Microsoft Word.
|
2) Students will be able to create effective presentations and improve their slide editing skills with Microsoft PowerPoint.
|
| Competences
(Described as "Ability of the learner to apply knowledge and skills autonomously with responsibility", "Learning to learn"," Communication and social" and "Field specific" competences.)
|
| Week |
Subject |
Materials Sharing * |
|
Related Preparation |
Further Study |
| 1) |
Introduction to Information Technologies and Basic Computer Concepts |
None
|
None |
| 2) |
Introduction to Microsoft Excel: Basic Features and Interface |
None.
|
None. |
| 3) |
Formulas and Functions in Excel. |
None.
|
None. |
| 4) |
Data Visualization in Excel: Charts and Graphs. |
None.
|
None. |
| 5) |
Data Analysis and Pivot Tables in Excel. |
None.
|
None. |
| 6) |
Advanced Excel Functions and Data Management. |
None.
|
None. |
| 7) |
Midterm Exam |
None.
|
None. |
| 8) |
Introduction to Microsoft Word: Basic Features and Interface |
None.
|
None |
| 9) |
Text Formatting and Editing in Word |
None.
|
None. |
| 10) |
Creating Professional Documents in Word |
None.
|
None. |
| 11) |
Introduction to Microsoft PowerPoint: Basic Features and Interface |
None.
|
None. |
| 12) |
Creating Effective Presentations |
None.
|
None. |
| 13) |
Advanced PowerPoint Features |
None.
|
None. |
| 14) |
Integrating Excel, Word, and PowerPoint for Professional Use.
How to integrate the three programs, such as importing data from Excel into a Word document or incorporating a Word document into a PowerPoint presentation. Additionally, practical exercises will be conducted for creating professional reports and presentations. |
None.
|
None. |
| Course Notes / Textbooks: |
Ders notları "onlinebeykoz" platformunda mevcuttur. / The course notes are available on the "onlinebeykoz" platform.
Materyal
|
| References: |
1- Bilgisayar ve İnternet Kullanımı - Atilla Bıyık, Seçkin Yayıncılık, 2021.
2- Microsoft Office 365 & Office 2019 - Uğur Gelişken, Kodlab Yayıncılık, 2020.
3- Excel Öğreniyorum - Nermin Şen, Dikeyeksen Yayıncılık, 2019.
4- Microsoft Word ve PowerPoint: Adım Adım - Aslı Doğan, Pusula Yayıncılık, 2022.
5- Temel Bilgi Teknolojileri - Faruk Doğan, Nobel Yayıncılık, 2023.
|
| |
Programme Learning Outcomes |
Contribution Level (from 1 to 5) |
| 1) |
Can explain the fundamental concepts, theories, and processes of logistics and supply chain management, and identify the roles and responsibilities of the parties involved. |
|
| 2) |
Can plan, execute, and evaluate logistics operations such as warehouse management, order processing, transportation, packaging, and labeling. |
|
| 3) |
Can explain the basic knowledge of foreign trade, marketing, and customs regulations, and apply it in foreign trade processes (INCOTERMS, delivery and payment methods, etc.). |
|
| 4) |
Can analyze the internal and external environment of logistics enterprises in terms of economic indicators and interpret sectoral developments. |
|
| 5) |
Can identify and analyze complex problems in logistics and develop innovative solutions by synthesizing different perspectives. |
|
| 6) |
Can effectively use theoretical knowledge and information technologies in design, planning, and decision-making processes. |
|
| 7) |
Can integrate theoretical knowledge with practical experience gained through internship or workplace practice and demonstrate professional competence. |
|
| 8) |
Can act in accordance with ethical values, social responsibility principles, and labor law regulations, and demonstrate professional ethical awareness. |
|
| 9) |
Can make decisions and manage processes by considering sustainability, green logistics, and environmental sensitivity principles. |
|
| 10) |
Can work effectively in a team, demonstrate leadership skills, and communicate effectively with various stakeholders using written and verbal communication skills. |
|
| 11) |
Can follow new developments and technological innovations in logistics and continuously improve themselves through lifelong learning. |
|
| WORKLOAD OF TEACHING & LEARNING ACTIVITIES |
| Teaching & Learning Activities |
# of Activities per semester |
Duration (hour) |
Total Workload |
| Course |
14 |
2 |
28 |
| Laboratory |
0 |
0 |
0 |
| Application |
3 |
7 |
21 |
| Special Course Internship (Work Placement) |
0 |
0 |
0 |
| Field Work |
0 |
0 |
0 |
| Study Hours Out of Class |
0 |
0 |
0 |
| Presentations / Seminar |
0 |
0 |
0 |
| Project |
0 |
0 |
0 |
| Homework Assignments |
0 |
0 |
0 |
| Total Workload of Teaching & Learning Activities |
- |
- |
49 |
| WORKLOAD OF ASSESMENT & EVALUATION ACTIVITIES |
| Assesment & Evaluation Activities |
# of Activities per semester |
Duration (hour) |
Total Workload |
| Quizzes |
2 |
10 |
20 |
| Midterms |
1 |
15 |
15 |
| Semester Final Exam |
1 |
18 |
18 |
| Total Workload of Assesment & Evaluation Activities |
- |
- |
53 |
| TOTAL WORKLOAD (Teaching & Learning + Assesment & Evaluation Activities) |
102 |
| ECTS CREDITS OF THE COURSE (Total Workload/25.5 h) |
4 |