COURSE SYLLABUS
OFFICE PROGRAMS -CALCULATION
| 1 |
Course Title: |
OFFICE PROGRAMS -CALCULATION |
| 2 |
Course Code: |
EKO2003 |
| 3 |
Type of Course: |
Optional |
| 4 |
Level of Course: |
First Cycle |
| 5 |
Year of Study: |
2 |
| 6 |
Semester: |
3 |
| 7 |
ECTS Credits Allocated: |
5 |
| 8 |
Theoretical (hour/week): |
3 |
| 9 |
Practice (hour/week) : |
0 |
| 10 |
Laboratory (hour/week) : |
0 |
| 11 |
Prerequisites: |
No |
| 12 |
Recommended optional programme components: |
None |
| 13 |
Language: |
Turkish |
| 14 |
Mode of Delivery: |
Face to face |
| 15 |
Course Coordinator: |
Doç. Dr. VESİLE SİNEM ARIKAN KARGI |
| 16 |
Course Lecturers: |
Doç.Dr.V.Sinem arıkan Kargı
|
| 17 |
Contactinformation of the Course Coordinator: |
vesa@uludag.edu.tr
Uludağ University Faculty of Economics and Administrative Sciences A Block 16059 Nilüfer/Bursa
|
| 18 |
Website: |
http://homepage.uludag.edu.tr/~kemal/ |
| 19 |
Objective of the Course: |
The aim of this course is to be able to use the students a spreasheet program. |
| 20 |
Contribution of the Course to Professional Development |
|
| 21 |
Learning Outcomes: |
| 1 |
To be able to use a spreadsheet program;
|
| 2 |
To be able to apply the file tab in a spreadsheet;
|
| 3 |
To be able to apply the input tab in a spreadsheet;
|
| 4 |
To be able to apply the add tab in a spreadsheet;
|
| 5 |
To be able to apply the formulas tab in a spreadsheet;
|
| 6 |
To be able to apply the data tab in a spreadsheet;
|
| 7 |
To be able to apply the view tab in a spreadsheet;
|
| 8 |
To be able to do Programming in a spreadsheet;
|
|
| Week |
Theoretical |
Practical |
| 1 |
Introduction to Excel and data entry |
|
| 2 |
Excel file tab |
|
| 3 |
Excel introduction tab |
|
| 4 |
Excel add tab |
|
| 5 |
Excel page layout and formulas tab |
|
| 6 |
Excel data, revise tab |
|
| 7 |
Excel view tab (Midterm Exam) |
|
| 8 |
Introduction to VBA |
|
| 9 |
Object hierarchy, programming logic |
|
| 10 |
With structure, range command |
|
| 11 |
Logical control and cycles |
|
| 12 |
Work with other Excel objects |
|
| 13 |
Variables with index |
|
| 14 |
Subprograms |
|
| 23 |
Textbooks, References and/or Other Materials: |
1. Osman Gürkan, Microsoft Excel 2016, Nirvana Yayınları,2016 |
| 24 |
Assesment |
|
| TERM LEARNING ACTIVITIES |
NUMBER |
PERCENT |
| Midterm Exam |
1 |
40 |
| Quiz |
1 |
10 |
| Homeworks, Performances |
1 |
10 |
| Final Exam |
1 |
40 |
| Total |
4 |
100 |
| Contribution of Term (Year) Learning Activities to Success Grade |
60 |
| Contribution of Final Exam to Success Grade |
40 |
| Total |
100 |
| Measurement and Evaluation Techniques Used in the Course |
|
| Information |
|
| 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 |
14 |
5 |
70 |
| Homeworks, Performances |
1 |
5 |
5 |
| Projects |
0 |
0 |
0 |
| Field Studies |
0 |
0 |
0 |
| Midtermexams |
1 |
30 |
30 |
| Others |
0 |
0 |
0 |
| Final Exams |
1 |
30 |
30 |
| Total WorkLoad |
|
|
177 |
| Total workload/ 30 hr |
|
|
5,9 |
| ECTS Credit of the Course |
|
|
6 |
| 26 |
CONTRIBUTION OF LEARNING OUTCOMES TO PROGRAMME QUALIFICATIONS |
|
PQ1
|
PQ2
|
PQ3
|
PQ4
|
PQ5
|
PQ6
|
PQ7
|
PQ8
|
PQ9
|
PQ10
|
PQ11
|
PQ12
|
|
LO1
|
2
|
2
|
4
|
3
|
4
|
3
|
4
|
2
|
3
|
3
|
2
|
4
|
|
LO2
|
2
|
3
|
4
|
4
|
3
|
4
|
4
|
3
|
4
|
4
|
5
|
3
|
|
LO3
|
3
|
4
|
4
|
3
|
5
|
3
|
4
|
4
|
3
|
3
|
4
|
3
|
|
LO4
|
4
|
4
|
3
|
4
|
3
|
3
|
4
|
4
|
5
|
5
|
4
|
4
|
|
LO5
|
3
|
5
|
4
|
3
|
4
|
4
|
4
|
3
|
4
|
3
|
1
|
5
|
|
LO6
|
3
|
4
|
2
|
3
|
3
|
3
|
4
|
4
|
3
|
5
|
3
|
4
|
|
LO7
|
3
|
3
|
3
|
4
|
2
|
5
|
3
|
4
|
3
|
3
|
4
|
3
|
|
LO8
|
3
|
3
|
4
|
4
|
3
|
3
|
4
|
3
|
3
|
3
|
3
|
3
|
|
| LO: Learning Objectives |
PQ: Program Qualifications |
| Contribution Level: |
1 Very Low |
2 Low |
3 Medium |
4 High |
5 Very High |
