COURSE SYLLABUS
COMPUTER PROGRAMMING AND VBA APPLICATION
| 1 |
Course Title: |
COMPUTER PROGRAMMING AND VBA APPLICATION |
| 2 |
Course Code: |
EKO2004 |
| 3 |
Type of Course: |
Compulsory |
| 4 |
Level of Course: |
First Cycle |
| 5 |
Year of Study: |
2 |
| 6 |
Semester: |
4 |
| 7 |
ECTS Credits Allocated: |
7 |
| 8 |
Theoretical (hour/week): |
3 |
| 9 |
Practice (hour/week) : |
0 |
| 10 |
Laboratory (hour/week) : |
0 |
| 11 |
Prerequisites: |
|
| 12 |
Recommended optional programme components: |
None |
| 13 |
Language: |
Turkish |
| 14 |
Mode of Delivery: |
Face to face |
| 15 |
Course Coordinator: |
Doç. Dr. ARZU EREN ŞENARAS |
| 16 |
Course Lecturers: |
|
| 17 |
Contactinformation of the Course Coordinator: |
arzueren@uludag.edu.tr
Uludağ University Faculty of Economics and Administrative Sciences A Block 16059 Nilüfer/Bursa |
| 18 |
Website: |
|
| 19 |
Objective of the Course: |
The aim of this course is to be able to use the students Visual Basic Application . |
| 20 |
Contribution of the Course to Professional Development |
Students produce more effective solutions to complex problems with VBA programming. |
| 21 |
Learning Outcomes: |
| 1 |
To be able to understand the programming logic;
|
| 2 |
To be able to create Algorithms;
|
| 3 |
To be able to create Flow Charts;
|
| 4 |
To be able to apply the If structure;
|
| 5 |
To be able to apply the case structure;
|
| 6 |
To be able to develop loop;
|
| 7 |
To be able to develop code in VBA;
|
|
| Week |
Theoretical |
Practical |
| 1 |
Introduction to Programming Logic |
|
| 2 |
Preparation of Algorithm, Flow Charts |
|
| 3 |
Introduction to VBA Development in Excel |
|
| 4 |
Subprograms, Defining variables |
|
| 5 |
Message Box, Input Box |
|
| 6 |
If structure |
|
| 7 |
Nested if structure |
|
| 8 |
Case Structure |
|
| 9 |
For loop |
|
| 10 |
nested for loops, for each loop |
|
| 11 |
Do loop, do while |
|
| 12 |
Indexed variables |
|
| 13 |
VBA Application Examples |
|
| 14 |
VBA Application Examples |
|
| 23 |
Textbooks, References and/or Other Materials: |
Hayrettin Kemal Sezen, 2010. Excel & VBA (2010-2013) Kullanım ve Programlama, Sentez Basım Yayım |
| 24 |
Assesment |
|
| TERM LEARNING ACTIVITIES |
NUMBER |
PERCENT |
| Midterm Exam |
1 |
40 |
| Quiz |
0 |
0 |
| Homeworks, Performances |
0 |
0 |
| Final Exam |
1 |
60 |
| Total |
2 |
100 |
| Contribution of Term (Year) Learning Activities to Success Grade |
40 |
| Contribution of Final Exam to Success Grade |
60 |
| Total |
100 |
| Measurement and Evaluation Techniques Used in the Course |
Homework, midterm and final exam |
| Information |
This course evaluated with a relative evaluation system. |
| 25 |
|
ECTS / WORK LOAD TABLE |
| Activites |
NUMBER |
TIME [Hour] |
Total WorkLoad [Hour] |
| Theoretical |
14 |
3 |
42 |
| Practicals/Labs |
0 |
0 |
0 |
| Self Study and Preparation |
0 |
0 |
0 |
| Homeworks, Performances |
0 |
25 |
75 |
| Projects |
0 |
0 |
0 |
| Field Studies |
0 |
0 |
0 |
| Midtermexams |
1 |
30 |
30 |
| Others |
0 |
0 |
0 |
| Final Exams |
1 |
60 |
60 |
| Total WorkLoad |
|
|
237 |
| Total workload/ 30 hr |
|
|
6,9 |
| ECTS Credit of the Course |
|
|
7 |
| 26 |
CONTRIBUTION OF LEARNING OUTCOMES TO PROGRAMME QUALIFICATIONS |
|
PQ1
|
PQ2
|
PQ3
|
PQ4
|
PQ5
|
PQ6
|
PQ7
|
PQ8
|
PQ9
|
PQ10
|
PQ11
|
PQ12
|
|
LO1
|
2
|
3
|
2
|
3
|
3
|
2
|
3
|
2
|
2
|
3
|
4
|
1
|
|
LO2
|
3
|
3
|
3
|
4
|
2
|
2
|
3
|
3
|
3
|
3
|
3
|
2
|
|
LO3
|
3
|
3
|
4
|
2
|
3
|
3
|
1
|
2
|
3
|
3
|
2
|
2
|
|
LO4
|
3
|
3
|
4
|
2
|
3
|
2
|
3
|
3
|
3
|
3
|
1
|
3
|
|
LO5
|
2
|
3
|
3
|
2
|
3
|
3
|
2
|
2
|
3
|
3
|
2
|
2
|
|
LO6
|
3
|
3
|
1
|
2
|
4
|
3
|
4
|
2
|
3
|
3
|
3
|
3
|
|
LO7
|
3
|
2
|
3
|
2
|
2
|
3
|
3
|
4
|
2
|
2
|
2
|
4
|
|
| LO: Learning Objectives |
PQ: Program Qualifications |
| Contribution Level: |
1 Very Low |
2 Low |
3 Medium |
4 High |
5 Very High |
