Course Name Code Semester T+U Hours Credit ECTS
Spreadsheets BYP 102 2 2 + 1 3 5
Precondition Courses
Recommended Optional Courses
Course Language Turkish
Course Level onlisans
Course Type Compulsory
Course Coordinator Öğr.Gör. GÜLTEKİN BÜYÜKŞENGÜR
Course Lecturers Doç.Dr. AHMET ÇAĞATAY ÇİLİNGİR,
Course Assistants
Course Category
Course Objective MS Office Excel Programme provides records which are used by various firms commonly, learning, arranging as data lists, abstract, comparing and presentation as a graphic making by various applications to the students who are responsible with this course.
Course Content Icons and their missions, various work pages, connection between cells/pages with formulas, conditional table and abstract tables, analysises, syntax rule of functions and working with formulas which appeared in the MS Office Excel Programme
# Course Learning Outcomes Teaching Methods Assessment Methods
1 Datas can be kept by saving. Lecture, Question-Answer, Self Study, Discussion, Testing, Homework,
2 Tables can be gained Professional view. Lecture, Discussion, Question-Answer, Self Study, Homework, Testing,
3 Tables can be gained Professional view. Lecture, Self Study, Question-Answer, Discussion, Testing, Homework,
4 Datas can be used active and quick. Discussion, Question-Answer, Self Study, Lecture, Homework, Testing,
5 Abstact can be obtained from tables. Lecture, Self Study, Question-Answer, Discussion, Testing, Homework,
6 Functions can be prepared by using formulas easily and in a litttle while. Discussion, Question-Answer, Self Study, Lecture, Homework, Testing,
7 Knowledge can be shared with sources in the firm and out of the firm. Lecture, Self Study, Question-Answer, Discussion, Testing, Homework,
Week Course Topics Preliminary Preparation
1 Major icons and missions which appeared in the Office button.
2 Working with various work book, page tabs, cell processes, raw and column processes, shortcut in the Excel and function buttons.
3 Cell format, data entry, using filling handle to fill cells.
4 Knowledge structure at the cells, adding explanation to the cells, general view to the formulas, formula elements, procedure at the formulas.
5 Working with formula pallete, arranging formulas, to find out failure value, possible reasons of failure messages and proposed actions.
6 Working with tables, working with conditional forming, cell form applications by using color scalas, clean of conditional forming.
7 Working with graphics (1), creating a new graphic, determining graphic type, changing graphics view.
8 Working with graphics (2), graphic type
9 Working with graphics (3), changing order and style of graphic, changing order of graphic element by hand, changing style of graphic element by hand, saving a graphic as a graphic template, remove or clean of a graphic template.
10 Working with functions (1), logical functions, usage of and, if function, examples.
11 Working with functions (2), usage of merge, capital, lower case, change, liras, convert to text, identical functions.
12 Working with functions (3), usage of to the left, to the right, length, righting order, replace, refresh functions.
13 Example
14 Solution of example
Resources
Course Notes
Course Resources
Order Program Outcomes Level of Contribution
1 2 3 4 5
1 X
2 X
3 X
4 X
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)
Mid-terms 1 10 10
Quiz 2 5 10
Assignment 1 10 10
Final examination 1 10 10
Course Duration (Including the exam week: 16x Total course hours) 16 3 48
Hours for off-the-classroom study (Pre-study, practice) 16 4 64
Total Workload 152
Total Workload / 25 (Hours) 6.08
dersAKTSKredisi 5