Course Information
SemesterCourse Unit CodeCourse Unit TitleT+P+LCreditNumber of ECTS CreditsLast Updated Date
2VFT112Information Technologies3+0+03505.10.2024

 
Course Details
Language of Instruction English
Level of Course Unit Associate Degree
Department / Program Foreign Trade (English)
Type of Program Formal Education
Type of Course Unit Compulsory
Course Delivery Method Face To Face
Objectives of the Course Use of word processors and spreadsheets and introduction to business intelligence programs
Course Content Word, Excel, Powerpoint, V-look up, operating systems, computer software,cyber security
Course Methods and Techniques Explanation, examples and exercises
Prerequisites and co-requisities None
Course Coordinator None
Name of Lecturers Asist Prof. Jülide ANDİÇ
Assistants None
Work Placement(s) No

Recommended or Required Reading
Resources Microsoft Excel& Access For Beginners Pros. 2024, Charles Sherer.
İltir, Cenk. Excel'de Makrolar: Vba Excel 2019, 2016 ve 2013'e Uyumlu. Seçkin Yayıncılık
Bağcı, Ömer (2021). İleri Düzey Excel 2019. Seçkin Yayıncılık
Course Notes udemy.com

Course Category
Mathematics and Basic Sciences %20
Engineering %20
Social Sciences %10
Field %50

Planned Learning Activities and Teaching Methods
Activities are given in detail in the section of "Assessment Methods and Criteria" and "Workload Calculation"

Assessment Methods and Criteria
In-Term Studies Quantity Percentage
Mid-terms 1 % 40
Quizzes 1 % 10
Assignment 1 % 10
Final examination 1 % 40
Total
4
% 100

 
ECTS Allocated Based on Student Workload
Activities Quantity Duration Total Work Load
Course Duration 14 3 42
Hours for off-the-c.r.stud 9 12 108
Assignments 3 1 3
Presentation 3 1 3
Mid-terms 1 3 3
Final examination 1 3 3
Total Work Load   Number of ECTS Credits 6 162

 
Course Learning Outcomes: Upon the successful completion of this course, students will be able to:
NoLearning Outcomes
1 Preparing reports in accordance with certain spelling rules with word processors
2 Report about presentation program
3 Using spreadsheets effectively
4 Understanding and familiarizing with operating systems
5 Understanding and familiarizing with computer systems
6 Gaining information about cybersecurity

 
Weekly Detailed Course Contents
WeekTopicsStudy MaterialsMaterials
1 History of computer systems and introduction to computer systems
2 Operating systems, computer software, Windows 10-11
3 Internet Technologies(Web browsers,search engines)
4 Internet technologies (E mail,Cloud technologies, E information applications)
5 Word processors (Word, Libre Office) İltir, Cenk. Excel'de Makrolar: Vba Excel 2019, 2016 ve 2013'e Uyumlu. Seçkin Yayıncılık
6 Shapes and tables in word processors Bağcı, Ömer (2021). İleri Düzey Excel 2019. Seçkin Yayıncılık
7 Presentation of Power Point
8 Mid-term Exam
9 Entry to calculation tables (Excel, Pivot tables)
10 Logical applications in calculation tables
11 Financial operations in financial tables
12 Macros in calculation tables
13 V look up applications
14 Mobil technologies (Mobil applications, mobile devices, mobile operating systems)
15 Cyber security and cryptology
16 Final Examination

 
Contribution of Learning Outcomes to Programme Outcomes
P1 P2 P3 P4 P5 P6 P7 P8 P9 P10 P11 P12
All 4 3 3 5 3 2 2 2 2 4 4 5
C1 4 3 3 5 2 2 2 2 1 4 4 5
C2 4 3 3 5 2 2 2 2 2 4 4 5
C3 4 2 4 5 3 2 2 2 2 4 4 5
C4 4 2 3 5 2 1 2 2 2 4 4 5
C5 4 3 3 5 2 2 2 2 2 4 4 5
C6 3 3 3 5 3 2 2 2 2 4 4 5

  bbb

  
  https://obs.gedik.edu.tr/oibs/bologna/progCourseDetails.aspx?curCourse=212005&curProgID=5636&lang=en