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.
|
(KPLOs and SPLOs are the abbreviations for Key & Sub- Programme Learning Outcomes, respectively. )
|
Programme Learning Outcomes |
Contribution Level (from 1 to 5) |
1) |
Have basic, theoretical and applied knowledge about E-Commerce. |
|
|
1.1 Defines the e-commerce concept and basic concepts related to e-commerce. |
|
|
1.2 Knows the process of e-commerce. |
|
2) |
Have basic, theoretical and applied knowledge about Marketing. |
|
|
2.1 Have general knowledge about marketing practices. |
|
|
2.2 Have knowledge about marketing elements. |
|
|
2.3 understand the basic strategy of marketing. |
|
|
2.4 knows mobile marketing applications. |
|
|
2.5 Have knowledge about mobile commerce. |
|
|
2.6 can design a mobile marketing campaign. |
|
|
2.7 Have a good grasp of the important details of international marketing. |
|
|
2.8 knows digital advertising practices and strategies. |
|
|
2.9 can design a digital advertisement sample. |
|
|
2.10 Have knowledge about social media marketing and advertising. |
|
3) |
Learns the basics of web design. |
|
4) |
Applies the theoretical knowledge learned by being in business life for one semester. |
|
|
4.1 Experiences all processes in business life. |
|
|
4.2 It takes part in activities related to the field of education in an enterprise operating in its field. |
|
|
4.3 Compares the theoretical information with the application. |
|
|
4.4 They compile their knowledge and experience in the field. |
|
5) |
Gains at a basic level the competencies that develop in line with the expectations of the business world and society and are defined as the institutional outputs of our university. |
5 |
|
5.1 Gains the ability to analyze and solve problems. |
|
|
5.2 Has ethical and social responsibility awareness. |
|
|
5.3 Takes responsibility as a team member in works and transactions related to his/her field. |
|
|
5.4 Is aware of written and verbal communication and interaction. |
5 |
|
5.5 Gains awareness of lifelong learning. |
|
|
5.6 Evaluates the developments in the field with an entrepreneurial approach. |
|
|
5.7 Gains the ability to communicate in a Foreign Language (English) defined at least A2 level of the European Language Portfolio. |
|
|
|
|
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 |
10 |
10 |
Semester Final Exam |
1 |
15 |
15 |
Total Workload of Assesment & Evaluation Activities |
- |
- |
45 |
TOTAL WORKLOAD (Teaching & Learning + Assesment & Evaluation Activities) |
94 |
ECTS CREDITS OF THE COURSE (Total Workload/25.5 h) |
4 |