Course Information

Course Information
Course Title Code Language Type Semester L+U Hour Credits ECTS
- BIT1101 Turkish Compulsory 1. Semester 1 + 1 2.0 2.0
Prerequisite Courses
Course Level Associate
Mode of delivery Face to Face
Course Coordinator Öğr. Gör. Sıdıka YILDIRIM GÜLTEKİN
Instructor(s) Öğr. Gör. Sıdıka YILDIRIM GÜLTEKİN (Güz)
Goals To provide the ability to use office application programs at a basic level.
Course Content Basic level use of office application
Learning Outcomes
# Öğrenme Kazanımı
1 Using the computer effectively and efficiently.
2 Computer literacy
3 Creating tables, drawing graphs.
4 Presentation and product demonstration.
5 It handles the editing and printing of spreadsheets and business documents used in professional settings.
Lesson Plan (Weekly Topics)
Week Topics/Applications Method
1. Week Understanding Microsoft Word, Basic Editing Interview
2. Week Understanding Microsoft Word, Basic Editing Practice, Interview, Presentation (Preparation)
3. Week Managing Text Flow, Creating Tables Practice, Interview, Presentation (Preparation)
4. Week Managing Text Flow, Creating Tables Practice, Interview, Presentation (Preparation)
5. Week Working with Themes, Style Sets, Backgrounds, Quick Panes, and Text Boxes, Using Drawings and Charts, Formatting a Research Paper Practice, Interview, Presentation (Preparation)
6. Week Creating a table of contents Practice, Interview, Presentation (Preparation)
7. Week Creating a table of contents Preparation, After Class Study, Practice, Interview, Presentation (Preparation)
8. Week MS POWERPOINT - Basic Settings, Creating Presentations, Text, Images and Table Preparation, After Class Study, Practice, Interview, Presentation (Preparation)
9. Week MS POWERPOINT - Graphics and Drawing Objects, Screen Show Effects, Slide Show and Printout Preparation, Practice, Interview, Presentation (Preparation)
10. Week MS Excel - Introduction to Excel, sheet and cell concepts, cursor types. Preparation, After Class Study, Practice, Interview
11. Week MS Excel - Interface elements of the spreadsheet program, getting acquainted with toolbars, working with files, navigating the worksheet. Preparation, After Class Study, Practice, Interview, Presentation (Preparation)
12. Week MS Excel - Formula writing, use of existing formulas and mathematical functions. Preparation, After Class Study, Practice, Interview
13. Week MS Excel - Statistical functions, date lookup and text functions. Practice, Interview, Presentation (Preparation)
14. Week MS Excel- Graphic operations. Preparation, After Class Study, Practice, Interview, Presentation (Preparation)
*Midterm and final exam dates are not specified in the 14-week course operation plan. Midterm and final exam dates are held on the dates specified in the academic calendar with the decision of the University Senate.
The Matrix for Course & Program Learning Outcomes
No Program Requirements Level of Contribution
1 2 3 4 5
3 3. Follows current developments and applications for his/her profession and uses them effectively.
4 4. Effectively uses information technologies (software, program, animation etc.) related to his/her profession.
5 5. Has the ability to evaluate professional problems and issues independently with an analytical and critical approach and present solution proposals.
6 6. Can effectively present his/her thoughts through written and verbal communication at the level of knowledge and skills and express them in an understandable manner.
Relations with Education Attainment Program Course Competencies
Program Requirements DK1 DK2 DK3 DK4 DK5
PY3 3 3 3 3 3
PY4 3 3 3 3 3
PY5 2 2 2 2 2
PY6 3 3 3 3 3
Recommended Sources
Ders Kitabı veya Notu Ders Kitabı veya Ders Notu bulunmamaktadır.
Diğer Kaynaklar
  • Excel for Engineers, Seçkin Publishing. / Excel for Everyone, Abaküs Kitap.
Evaluation Method
Güz Dönemi
Responsible Personnel Grup Evaluation Method Percentage
Öğr. Gör. Sıdıka YILDIRIM GÜLTEKİN A Vize 40.00
Öğr. Gör. Sıdıka YILDIRIM GÜLTEKİN A Final 60.00
Toplam 100.00
Öğr. Gör. Sıdıka YILDIRIM GÜLTEKİN B Vize 40.00
Öğr. Gör. Sıdıka YILDIRIM GÜLTEKİN B Final 60.00
Toplam 100.00
ECTS credits and course workload
ECTS credits and course workload Quantity Duration (Hour) Total Workload (Hour)
Ders İçi
Class Hours 14 2 28
Ders Dışı
Preparation, After Class Study 14 1.5 21
Sınavlar
Midterm 1 1 1 1
Final 1 1 1
Total Workload 51
*AKTS = (Total Workload) / 25,5 ECTS Credit of the Course 2.0