Course Name Code Semester T+U Hours Credit ECTS
Excel Vba Programming YBS 253 3 1 + 1 2 5
Precondition Courses
Recommended Optional Courses
Course Language Turkish
Course Level Bachelor's Degree
Course Type Optional
Course Coordinator Dr.Öğr.Üyesi ÇAĞLA EDİZ
Course Lecturers Dr.Öğr.Üyesi ÇAĞLA EDİZ,
Course Assistants
Course Category
Course Objective

Gaining writing and reporting small-scale projects for businesses using excel vba applications

Course Content

Macros,userforms and model implementations.

# Course Learning Outcomes Teaching Methods Assessment Methods
1 To have information about visual basic applications with using Excel Lecture, Question-Answer, Discussion, Drilland Practice, Problem Solving, Testing, Homework,
2 Question-Answer, Homework, Testing,
3 To have model implemenatations which can be developed in business organizations Project Based Learning, Drilland Practice, Discussion, Question-Answer, Lecture, Homework, Testing, Project / Design,
4 Project Based Learning, Project / Design,
Week Course Topics Preliminary Preparation
1 Functions in excel,
2 Macros and userforms in excel,
3 Comparing and combining two reports,
4 Preparing customer cards automatically,
5 Preparing supplier evaluation system,
6 Preparing ordering system,
7 Preparing work distribution according to production schedules
8 Midterm
9 Preparing inventory tracking program
10 Tracking material from the production records
11 MRP-1
12 MRP-2
13 Preparing graphical reports with macros
14 Overall assesment
Resources
Course Notes
Course Resources
Order Program Outcomes Level of Contribution
1 2 3 4 5
1 Can follow new and current technologies and evaluate them
2 Can understand the operation of Corporate Information Systems and use these systems at a basic level X
3 Constructs numerical models of basic business problems. X
4 Solves modeled business problems with the help of information technologies and interprets the solutions X
5 Contributes to informatics oriented projects as a member of the team
6 Effectively uses information technology tools that support teamwork in project management.
7 Master basic business functions and information technologies and establishes the link between them
8 Contributes to the design, development and implementation processes of corporate information systems. X
9 Can produce and present quality documentation for all kinds of projects, including entrepreneurship projects. X
10 Prepares informative, effective and interesting presentations and presents these presentations. X
Evaluation System
Semester Studies Contribution Rate
1. Ara Sınav 70
1. Ödev 10
2. Ödev 10
3. Ödev 10
Total 100
1. Yıl İçinin Başarıya 60
1. Final 40
Total 100
ECTS - Workload Activity Quantity Time (Hours) Total Workload (Hours)
Course Duration (Including the exam week: 16x Total course hours) 16 3 48
Hours for off-the-classroom study (Pre-study, practice) 16 3 48
Mid-terms 1 15 15
Final examination 1 25 25
Total Workload 136
Total Workload / 25 (Hours) 5.44
dersAKTSKredisi 5