|
|
| YBS2029 | Transaction Table Programming | 2+1+0 | ECTS:5 | | Year / Semester | Fall Semester | | Level of Course | First Cycle | | Status | Elective | | 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 Gizem Dilan BOZTAŞ | | Co-Lecturer | | | Language of instruction | Turkish | | Professional practise ( internship ) | None | | | | The aim of the course: | | Process spreadsheet programs are software that allow you to perform mathematical and logical operations on cells containing formulas or data, within a certain structure. It can create basic programming and computational models. This course aims to transfer many activities in daily life to the computer environment and to establish relationships between the data in these activities, which can be easily accomplished using spreadsheet programs. |
| Learning Outcomes | CTPO | TOA | | Upon successful completion of the course, the students will be able to : | | | | LO - 1 : | Data Entry and Editing Skills | | | | LO - 2 : | Competence in Using Formulas and Functions | | | | LO - 3 : | Data Visualization and Analysis Capability | | | | LO - 4 : | Automation and Efficiency Increasing Ability | | | | 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 | | |
| This course aims to teach the basics of spreadsheet programs, starting from their history to fundamental programming concepts and predefined functions. Students will learn about macro operations, security issues, and the basic code structures of VBA (Visual Basic for Applications). The course also covers advanced topics such as debugging, variables, functions, and creating user forms. In addition to topics like API and database operations, practical subjects such as file operations and automation are also addressed. Throughout the term, students will enhance their ability to manage their workload efficiently by applying their theoretical knowledge into practice. |
| |
| Course Syllabus | | Week | Subject | Related Notes / Files | | Week 1 | Transaction Table Programming History | | | Week 2 | Process Table Programming Concepts | | | Week 3 | Predefined Functions | | | Week 4 | Macro Operations | | | Week 5 | Security in Macros | | | Week 6 | VBA Working Fundamentals, VBA Window Features | | | Week 7 | VBA Basic Code Structures | | | Week 8 | Finding and Fixing Errors | | | Week 9 | MIDTERM | | | Week 10 | Variables | | | Week 11 | Functions | | | Week 12 | User Forms Features, Creating User Forms and Controls | | | Week 13 | API, API operations with VBA | | | Week 14 | Database Operations, Database Operations with VBA | | | Week 15 | File Operations with VBA | | | Week 16 | END OF TERM EXAM | | | |
| Method of Assessment | | Type of assessment | Week No | Date | Duration (hours) | Weight (%) | | | | | | | | |
| 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 | 2 | 10 | 20 | | Arasınav için hazırlık | 15 | 1 | 15 | | Arasınav | 1 | 1 | 1 | | Ödev | 2 | 8 | 16 | | Dönem sonu sınavı için hazırlık | 30 | 1 | 30 | | Dönem sonu sınavı | 1 | 1 | 1 | | Total work load | | | 125 |
|