Course Name Code Semester T+U Hours Credit ECTS
Office Application Development BYP 202 4 1 + 1 2 3
Precondition Courses
Recommended Optional Courses
Course Language Turkish
Course Level onlisans
Course Type Compulsory
Course Coordinator Dr.Öğr.Üyesi OSMAN HAMDİ METE
Course Lecturers Doç.Dr. AHMET ÇAĞATAY ÇİLİNGİR,
Course Assistants
Course Category
Course Objective It is aim to make various applications by telling effective usage methods giving necessary softwares and properties to supply business efficiency, on the computer systems which used each field of modern companies and computer programmes working at this systems.
Course Content Forms on the Microsoft Word, electronics forms, usage of Excel at the decision problems, MS Access sample tables, Macros at the MS Excel/ to create macro
# Course Learning Outcomes Teaching Methods Assessment Methods
1 To create forms on the Microsoft Word Lecture, Question-Answer, Self Study, Discussion, Testing, Homework,
2 To create electronics forms Discussion, Self Study, Question-Answer, Lecture, Homework, Testing,
3 To make mail merge Lecture, Question-Answer, Self Study, Discussion, Testing, Homework,
4 To solve decision problems by MS Excel. Discussion, Self Study, Question-Answer, Lecture, Homework, Testing,
5 To describe basic level of database concept Lecture, Question-Answer, Self Study, Discussion, Testing, Homework,
6 To create database by MS Access database application programme Discussion, Self Study, Question-Answer, Lecture, Homework, Testing,
7 To add table to the created database and define relations between tables Lecture, Question-Answer, Self Study, Discussion, Testing, Homework,
8 To add datas to the tables, create table for data entry Question-Answer, Discussion, Lecture, Self Study, Homework, Testing,
9 To create macro Lecture, Self Study, Question-Answer, Discussion, Testing, Homework,
10 To make macros made by MS Excel editor more effective by using Visual Basic editor Discussion, Question-Answer, Self Study, Lecture, Testing, Homework,
Week Course Topics Preliminary Preparation
1 To create forms on the Microsoft Word.
2 To create electronics forms
3 Mail merge
4 Usage of Excel at the decision problems
5 An example at the production purchasing decision making.
6 MS Access and basic concepts of database
7 To create table at the MS Access
8 MS Access sample tables
9 MS Access Keys, relations
10 MS Access to create form
11 Report preparation at the MS Access
12 Inquiry creating at the MS Access.
13 Macros at the MS Excel/ to create macro
14 Visual basic editor
Resources
Course Notes
Course Resources
Order Program Outcomes Level of Contribution
1 2 3 4 5
1
2 X
3 X
4
5 X
6
7
8 X
9
10
11
Evaluation System
Semester Studies Contribution Rate
1. Ara Sınav 50
1. Kısa Sınav 15
1. Ödev 20
2. Kısa Sınav 15
Total 100
1. Yıl İçinin Başarıya 20
1. Final 80
Total 100
ECTS - Workload Activity Quantity Time (Hours) Total Workload (Hours)
Course Duration (Including the exam week: 16x Total course hours) 16 2 32
Hours for off-the-classroom study (Pre-study, practice) 16 1 16
Mid-terms 1 4 4
Quiz 2 5 10
Assignment 1 15 15
Final examination 1 10 10
Total Workload 87
Total Workload / 25 (Hours) 3.48
dersAKTSKredisi 3