|
YBS1007 | FUNDEMENTALS OF INFORMATION TECHNOLOGIES | 2+1+0 | ECTS:5 | Year / Semester | Fall Semester | Level of Course | First Cycle | Status | Compulsory | Department | DEPARTMENT of MANAGEMENT INFORMATION SYSTEMS | Prerequisites and co-requisites | None | Mode of Delivery | | Contact Hours | 14 weeks - 2 hours of lectures and 1 hour of practicals per week | Lecturer | Dr. Öğr. Üyesi Fatih GÜRCAN | Co-Lecturer | | Language of instruction | Turkish | 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 Outcomes | CTPO | TOA | 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,4 | 1, | LO - 2 : | Can work effectively with operating systems. | 1,4 | 1, | LO - 3 : | Can create text in a variety of formats in word processing programs. | 1,4 | 1, | LO - 4 : | Can make advanced applications with word processing programs. | 1,4 | 3, | LO - 5 : | Can add, edit, format and calculate the data in spreadsheet programs. | 1,4 | 3, | LO - 6 : | Can calculate, search, convert, and export the data using formulas in spreadsheet programs | 1,4 | 3, | LO - 7 : | Can work with macros in spreedsheet programs | 1,4 | 1, | LO - 8 : | Can use presentation programs to prepare effective and interactive presentations. | 1,4 | 5, | 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 | |
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 | Week | Subject | Related Notes / Files | Week 1 | Introduction to information technologies | | Week 2 | Fundamentals of computer hardware | | Week 3 | Computer systems and working principles | | Week 4 | Foundations of operating systems | | Week 5 | Word processing programs: Formatting text and paragraphs, working with pictures, figures, tables and graphics | | Week 6 | Word processing programs: Page structure and formatting operations | | Week 7 | Advanced word processing program applications | | Week 8 | Spreadsheet programs: Basic components, formatting operations, selecting data, filtering, using formulas, and basic arithmetic operations | | Week 9 | Midterm Exam | | Week 10 | Spreadsheet programs: Basic components, formatting operations, selecting data, filtering, using formulas, and basic arithmetic operations | | Week 11 | Spreadsheet programs: Using formulas for searching operations | | Week 12 | Spreadsheet programs: Using formulas with condition structures | | Week 13 | Spreadsheet programs: Working with macros | | Week 14 | Presentation programs: Effective presentation design and presentation principles | | Week 15 | Presentation programs: Basic components, formatting processes and preparing interactive presentations | | Week 16 | Final Exam | | |
Method of Assessment | Type of assessment | Week No | Date | 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 work | Duration (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 load | | | 130 |
|