| 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) |
Possesses fundamental, up-to-date, and practical knowledge related to their profession. |
|
| 2) |
They are knowledgeable about occupational health and safety, environmental awareness, and quality processes. |
|
| 3) |
Keeps up with current developments and applications in their profession and uses them effectively. |
|
| 4) |
Effectively uses information technologies (software, programs, animation, etc.) related to their profession. |
|
| 5) |
Possesses the ability to independently evaluate professional problems and issues using an analytical and critical approach and to propose solutions. |
|
| 6) |
Can effectively present their thoughts in writing and verbally at the level of knowledge and skills, expressing themselves clearly. |
|
| 7) |
Takes responsibility as a team member to resolve complex and unforeseen issues encountered in applications related to the field. |
|
| 8) |
Has awareness of career management and lifelong learning. |
|
| 9) |
The collection, application, and dissemination of data related to the field are guided by social, scientific, cultural, and ethical values. |
|
| 10) |
Uses a foreign language to keep up with developments in their field and communicate with colleagues. |
|
| 11) |
It creates algorithms and data structures and performs mathematical calculations. |
|
| 12) |
Explains and applies web programming technologies. |
|
| 13) |
Performs database design and management. |
|
| 14) |
Tests software and fixes bugs. |
|
| 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 |