Türkçe | English
FACULTY of ECONOMICS and ADMINISTRATIVE SCIENCES / DEPARTMENT of MANAGEMENT INFORMATION SYSTEMS

Course Catalog
Web: http://www.ktu.edu.tr/ybs
Phone: +90 0462 0462 377 29 64
İİBF
FACULTY of ECONOMICS and ADMINISTRATIVE SCIENCES / DEPARTMENT of MANAGEMENT INFORMATION SYSTEMS /
Katalog Ana Sayfa
  Katalog Ana Sayfa  KTÜ Ana Sayfa   Katalog Ana Sayfa
 
 

YBS1007FUNDEMENTALS OF INFORMATION TECHNOLOGIES2+1+0ECTS:5
Year / SemesterFall Semester
Level of CourseFirst Cycle
Status Compulsory
DepartmentDEPARTMENT of MANAGEMENT INFORMATION SYSTEMS
Prerequisites and co-requisitesNone
Mode of Delivery
Contact Hours14 weeks - 2 hours of lectures and 1 hour of practicals per week
LecturerDr. Öğr. Üyesi Fatih GÜRCAN
Co-Lecturer
Language of instructionTurkish
Professional practise ( internship ) None
 
The aim of the course:
To learn basic concepts of computer, how to work computer. To make application using popular softwares. To learn developing computer based instruction materials with office programmes. To develop computer aided instruction materials using MS Office applications.
 
Learning OutcomesCTPOTOA
Upon successful completion of the course, the students will be able to :
LO - 1 : Can define the fundamentals of computer systems, basic components of computer hardware and software.1,41,
LO - 2 : Can work effectively with operating systems.1,41,
LO - 3 : Can create text in a variety of formats in word processing programs.1,41,
LO - 4 : Can make advanced applications with word processing programs.1,43,
LO - 5 : Can add, edit, format and calculate the data in spreadsheet programs.1,43,
LO - 6 : Can calculate, search, convert, and export the data using formulas in spreadsheet programs1,43,
LO - 7 : Can work with macros in spreedsheet programs1,41,
LO - 8 : Can use presentation programs to prepare effective and interactive presentations.1,45,
LO - 9 : Can define the basic of safe Internet use, ethics and informatics crimes about information technologies.1,4
CTPO : Contribution to programme outcomes, TOA :Type of assessment (1: written exam, 2: Oral exam, 3: Homework assignment, 4: Laboratory exercise/exam, 5: Seminar / presentation, 6: Term paper), LO : Learning Outcome

 
Contents of the Course
Basic elements composing computer system: Processor, input-output units, storage and other units; Operating systems: Working with operating system effectively, manage and individualize the system, introduction of auxiliary software: archiving programs, sound and movie player programs, screen recording programs etc. Word processor programs: Editing and page layout, table, working with picture and graphics, form, envelope and label making. Customizing menus and toolbars. Macros and advanced applications. Electronic tabulating programs: Electronic tables, forming templates, with electronic tables, numbers, words and date, drawing graphics, conducting mathematical, logical and verbal operations, macros and standard and user defined functions. Data presentation programs: making a presentation. Inserting objects like sound, picture, music, movie etc. Animation and special effects. Publisher programs: Bulletin, leaflets, postcards; technical diagram and drawing programs. Computer and internet security; computer and ethics.
 
Course Syllabus
 WeekSubjectRelated Notes / Files
 Week 1Introduction to information technologies
 Week 2Fundamentals of computer hardware
 Week 3Computer systems and working principles
 Week 4Foundations of operating systems
 Week 5Word processing programs: Formatting text and paragraphs, working with pictures, figures, tables and graphics
 Week 6Word processing programs: Page structure and formatting operations
 Week 7Advanced word processing program applications
 Week 8Spreadsheet programs: Basic components, formatting operations, selecting data, filtering, using formulas, and basic arithmetic operations
 Week 9Midterm Exam
 Week 10Spreadsheet programs: Basic components, formatting operations, selecting data, filtering, using formulas, and basic arithmetic operations
 Week 11Spreadsheet programs: Using formulas for searching operations
 Week 12Spreadsheet programs: Using formulas with condition structures
 Week 13Spreadsheet programs: Working with macros
 Week 14Presentation programs: Effective presentation design and presentation principles
 Week 15Presentation programs: Basic components, formatting processes and preparing interactive presentations
 Week 16Final Exam
 
Textbook / Material
 
Recommended Reading
 
Method of Assessment
Type of assessmentWeek NoDate

Duration (hours)Weight (%)
Mid-term exam 9 11/2023 1 50
End-of-term exam 16 01/2024 1 50
 
Student Work Load and its Distribution
Type of workDuration (hours pw)

No of weeks / Number of activity

Hours in total per term
Yüz yüze eğitim 2 14 28
Sınıf dışı çalışma 3 14 42
Laboratuar çalışması 0 0 0
Arasınav için hazırlık 2 8 16
Arasınav 1 1 1
Uygulama 1 14 14
Klinik Uygulama 0 0 0
Ödev 1 14 14
Proje 0 0 0
Kısa sınav 0 0 0
Dönem sonu sınavı için hazırlık 1 14 14
Dönem sonu sınavı 1 1 1
Diğer 1 0 0 0
Diğer 2 0 0 0
Total work load130