SECTION I: GENERAL INFORMATION ABOUT THE COURSE

Course Code Course Name Year Semester Theoretical Practical Credit ECTS
50612METOZ-BLP0081 Temel Bilgi Teknolojileri 2 Spring 1 1 2 4
Course Type : Compulsory
Cycle: Associate      TQF-HE:5. Master`s Degree      QF-EHEA:Short Cycle      EQF-LLL:5. Master`s Degree
Language of Instruction: Turkish
Prerequisities and Co-requisities: N/A
Mode of Delivery: E-Learning
Name of Coordinator: Dr. Öğr. Üyesi ERSİN ŞAHİN
Dersin Öğretim Eleman(lar)ı:
Dersin Kategorisi: Programme Specific

SECTION II: INTRODUCTION TO THE COURSE

Course Objectives & Content

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 Specific Rules

Having basic computer literacy.






Course Learning Outcomes (CLOs)

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.)

Weekly Course Schedule

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.
*These fields provides students with course materials for their pre- and further study before and after the course delivered.

Recommended or Required Reading & Other Learning Resources/Tools

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.

SECTION III: RELATIONSHIP BETWEEN COURSE UNIT AND COURSE LEARNING OUTCOMES (CLOs)

(The matrix below shows how the course learning outcomes (CLOs) associates with programme learning outcomes (both KPLOs & SPLOs) and, if exist, the level of quantitative contribution to them.)

Relationship Between CLOs & PLOs

(KPLOs and SPLOs are the abbreviations for Key & Sub- Programme Learning Outcomes, respectively. )
CLOs/PLOs KPLO 1 KPLO 2 KPLO 4 KPLO 5
1 2 1 2 3 4 5 6 7 8 9 10 1 2 3 4 1 2 3 4 5 6 7
CLO1
CLO2
CLO3
CLO4
CLO5

Level of Contribution of the Course to PLOs

No Effect 1 Lowest 2 Low 3 Average 4 High 5 Highest
           
Programme Learning Outcomes Contribution Level (from 1 to 5)
1) Have basic, theoretical and applied knowledge about E-Commerce.
2) Have basic, theoretical and applied knowledge about Marketing.
3) Learns the basics of web design.
4) Applies the theoretical knowledge learned by being in business life for one semester.
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

SECTION IV: TEACHING-LEARNING & ASSESMENT-EVALUATION METHODS OF THE COURSE

Teaching & Learning Methods of the Course

(All teaching and learning methods used at the university are managed systematically. Upon proposals of the programme units, they are assessed by the relevant academic boards and, if found appropriate, they are included among the university list. Programmes, then, choose the appropriate methods in line with their programme design from this list. Likewise, appropriate methods to be used for the course units can be chosen among those defined for the programme.)
Teaching and Learning Methods defined at the Programme Level
Teaching and Learning Methods Defined for the Course
Lectures
Discussion
Case Study
Problem Solving
Demonstration
Views
Laboratory
Reading
Homework
Project Preparation
Thesis Preparation
Peer Education
Seminar
Technical Visit
Course Conference
Brain Storming
Questions Answers
Individual and Group Work
Role Playing-Animation-Improvisation
Active Participation in Class

Assessment & Evaluation Methods of the Course

(All assessment and evaluation methods used at the university are managed systematically. Upon proposals of the programme units, they are assessed by the relevant academic boards and, if found appropriate, they are included among the university list. Programmes, then, choose the appropriate methods in line with their programme design from this list. Likewise, appropriate methods to be used for the course units can be chosen among those defined for the programme.)
Aassessment and evaluation Methods defined at the Programme Level
Assessment and Evaluation Methods defined for the Course
Midterm
Presentation
Final Exam
Quiz
Report Evaluation
Homework Evaluation
Oral Exam
Thesis Defense
Jury Evaluation
Practice Exam
Evaluation of Implementation Training in the Workplace
Active Participation in Class
Participation in Discussions

Relationship Between CLOs & Teaching-Learning, Assesment-Evaluation Methods of the Course

(The matrix below shows the teaching-learning and assessment-evaluation methods designated for the course unit in relation to the course learning outcomes.)
LEARNING & TEACHING METHODS
COURSE LEARNING OUTCOMES
ASSESMENT & EVALUATION METHODS
CLO1 CLO2 CLO3 CLO4 CLO5
-Lectures -Midterm
-Discussion -Presentation
-Case Study -Final Exam
-Problem Solving -Quiz
-Demonstration -Report Evaluation
-Views -Homework Evaluation
-Laboratory -Oral Exam
-Reading -Thesis Defense
-Homework -Jury Evaluation
-Project Preparation -Practice Exam
-Thesis Preparation -Evaluation of Implementation Training in the Workplace
-Peer Education -Active Participation in Class
-Seminar - Participation in Discussions
-Technical Visit
-Course Conference
-Brain Storming
-Questions Answers
-Individual and Group Work
-Role Playing-Animation-Improvisation
-Active Participation in Class

Contribution of Assesment & Evalution Activities to Final Grade of the Course

Measurement and Evaluation Methods # of practice per semester Level of Contribution
Quizzes 2 % 20.00
Midterms 1 % 30.00
Semester Final Exam 1 % 50.00
Total % 100
PERCENTAGE OF SEMESTER WORK % 50
PERCENTAGE OF FINAL WORK % 50
Total % 100

SECTION V: WORKLOAD & ECTS CREDITS ALLOCATED FOR THE COURSE

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