|
|
| END3022 | Advanced Programming with Excel | 3+0+0 | ECTS:5 | | Year / Semester | Spring Semester | | Level of Course | First Cycle | | Status | Elective | | Department | DEPARTMENT of INDUSTRIAL ENGINEERING | | Prerequisites and co-requisites | None | | Mode of Delivery | | | Contact Hours | 14 weeks - 3 hours of lectures per week | | Lecturer | Dr. Öğr. Üyesi Kadir BÜYÜKÖZKAN | | Co-Lecturer | Dr. Kadir Büyüközkan | | Language of instruction | Turkish | | Professional practise ( internship ) | None | | | | The aim of the course: | | This course will help students in their daily lives and professional careers in basic computer use, computer programming skills, and the ability of aims. Carried out in the course of theoretical and practical.. |
| Learning Outcomes | CTPO | TOA | | Upon successful completion of the course, the students will be able to : | | | | LO - 1 : | Know and use basic properties and functions of MS Excel program. | 7,8 | 1, | | LO - 2 : | Teaching basic characteristics of programming. Design algorithms. Write programs at simple and average level.lems. | 7,8 | 1,3, | | 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 | | |
| MS Excel, Introduction to Visual Basic programming, basic programming and algorithm developing, data types, variables and constants, operators, decision structures, loop structures, functions, subscripted arrays. |
| |
| Course Syllabus | | Week | Subject | Related Notes / Files | | Week 1 | Basic Properties about MS Excel. | | | Week 2 | Preparing macros in Excel. | | | Week 3 | Introduction to Visual Basic Application (VBA) and Excel. | | | Week 4 | Working with environment and menus of Visual Basic. | | | Week 5 | Introduction to programming. Basic programming and algorithm development. | | | Week 6 | Data Types. Variables and constants and using of them. | | | Week 7 | Math operators, logical operators and comparison operators. | | | Week 8 | Problem solving with decision structures | | | Week 9 | Problem solving with decision structures | | | Week 10 | Midterm exam | | | Week 11 | Problem solving with loop structures. | | | Week 12 | Problem solving with loop structures. | | | Week 13 | Standard functions, user defined functions.
| | | Week 14 | Single & double subscripted arrays. | | | Week 15 | solution of sample questions and quiz | | | Week 16 | End-of-term exam | | | |
| 1 | Cenk İLTİR, Excel?de Makrolar: VBA, Seçkin yayınları, dördüncü baskı, 520 sayfa, 2014, ANKARA. | | | |
| Method of Assessment | | Type of assessment | Week No | Date | Duration (hours) | Weight (%) | | Mid-term exam | 09 | 16/04/2024 | 2 | 25 | | Homework/Assignment/Term-paper | 15 | 31/05/2024 | 2 | 25 | | End-of-term exam | 16 | 22/05/2019 | 2 | 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 | 3 | 14 | 42 | | Sınıf dışı çalışma | 4 | 13 | 52 | | Arasınav için hazırlık | 5 | 4 | 20 | | Arasınav | 2 | 1 | 2 | | Ödev | 2 | 1 | 2 | | Dönem sonu sınavı için hazırlık | 5 | 6 | 30 | | Dönem sonu sınavı | 2 | 1 | 2 | | Total work load | | | 150 |
|