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. İpek SOLAK
Instructor(s) Öğr. Gör. Dr. Emin ŞEŞEN (Güz)
Goals This course aims to teach students how to use word processing, spreadsheet and presentation software at a basic level in order to gain information literacy.
Course Content Create and manage documents, format text, paragraphs and sections, create tables and lists, create and manage references, add and format graphic elements with word processing software; spreadsheet software to create and manage worksheets and workbooks, manage data cells and ranges, create tables, perform operations with formulas and functions, create graphics and objects; presentation software to create and manage presentations, insert and format text, shapes and images, insert tables, graphics, SmartArt and media, apply transitions and animations, manage multiple presentations.
Learning Outcomes
# Öğrenme Kazanımı
1 The use of effective and efficient computer
1 The use of effective and efficient computer
1 Using MS Excel, you can create a workbook, enter data into cells, and add formulas.
2 Can create graphs of data using MS Excel and change properties of programs and workbooks and print the document.
2 Computer literacy
2 Computer literacy
3 creating tables, graphing
3 creating tables, graphing
3 It carries out the editing and printing of tables and business letters used in business life.
4 Made presentations and product demonstrations
4 Made presentations and product demonstrations
5 Using the internet efficiently
5 Using the internet efficiently
Lesson Plan (Weekly Topics)
Week Topics/Applications Method
1. Week Understanding Microsoft Word, Basic Editing Research, Preparation, After Class Study, Other Activities
2. Week Character Formatting, Paragraph Formatting Preparation, After Class Study, Research, Other Activities
3. Week MS Excel - Data manipulation. Presentation (Preparation), Interview, Practice
4. Week MS Excel - Row and column operations. Presentation (Preparation), Interview, Practice
5. Week MS Excel - Moving-copying and special paste operations. Interview, Presentation (Preparation), Practice
6. Week MS Excel - Autocorrect and fill options, find-replace-go, insert clip art and descriptions, use of image toolbar. Practice, Presentation (Preparation), Interview
7. Week MS Excel - Formatting operations. Presentation (Preparation), Practice, Preparation, After Class Study, Interview
8. Week Formatting Worksheets, Managing Worksheets Preparation, After Class Study, Other Activities, Research
9. Week Working with Data and Macros, Using Advanced Formulas Research, Preparation, After Class Study, Other Activities
10. Week MS Excel - Formula writing, use of existing formulas and mathematical functions. Preparation, After Class Study, Interview, Practice
11. Week MS Excel - Formula writing, use of existing formulas and mathematical functions. Interview, Practice, Preparation, After Class Study
12. Week Designing a Presentation, Adding Tables to Slides, Using Graphics in a Presentation Research, Other Activities, Preparation, After Class Study
13. Week Create SmartArt Graphics, Add Graphics to a Presentation, Use Animation and Multimedia Research, Other Activities, Preparation, After Class Study
14. Week Preserving and Sharing the Presentation, Presenting the Presentation Preparation, After Class Study, Other Activities, Research
*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
1 To be able to benefit from the communication and technical possibilities of his/her age.
2 To have knowledge of concepts and terms related to the field of art.
3 To have general knowledge of art history, aesthetics, sociology, psychology and philosophy in order to understand the relations between art and philosophy.
4 Discovering the possibilities of the environment in which they live, evaluating, criticizing and redesigning it within their own artistic sensitivity and aesthetic concerns.
5 To have the necessary material knowledge and technical equipment in art and design and to be able to apply this knowledge.
6 To be able to see, perceive, realize, express and bring these differences together for a new fiction and thought in the formation of creative thinking.
7 Participating in artistic formations and activities individually or as a group
8 To be able to produce new, original works of art that can go beyond the molds.
9 To be able to plan the process from the creation of a work to its presentation.
10 To educate individuals who are committed to the universal values in the contemporary world and the principles and reforms of the Republic of Turkey Atatürk, who have personal, artistic and professional values and act in line with these values
11 To gain the ability to be individuals who can express their ideas verbally and to be able to discuss and criticize their own work.
12 To be able to recognize styles related to art
13 To be able to apply basic techniques in traditional arts
14 To be able to create compositions related to traditional arts
Relations with Education Attainment Program Course Competencies
Program Requirements DK1 DK2 DK3 DK4 DK5 DK6 DK7 DK8
PY1 5 5 5 5 5 5 5 5
PY2 0 1 1 0 0 1 0 0
PY3 0 1 1 0 0 1 0 0
PY4 0 1 1 0 0 1 0 0
PY5 0 1 1 0 0 1 0 0
PY6 0 1 1 0 0 1 0 0
PY7 5 5 5 5 5 5 5 5
PY8 5 5 5 5 5 5 5 5
PY9 5 5 5 5 5 5 5 5
PY10 5 5 5 5 5 5 5 5
PY11 5 5 5 5 5 5 5 5
PY12 0 1 1 0 0 1 0 0
PY13 0 1 1 0 0 1 0 0
PY14 0 1 1 0 0 1 0 0
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.
  • Bilgisayarın Temelleri ve Office 2007, Yrd. Doç. Dr. Deniz Mertkan GEZGİ
  • Bilgisayarın Temelleri ve Office 2007, Yrd. Doç. Dr. Deniz Mertkan GEZGİ
Evaluation Method
Güz Dönemi
Responsible Personnel Grup Evaluation Method Percentage
Öğr. Gör. Dr. Emin ŞEŞEN 3+1 Vize 40.00
Öğr. Gör. Dr. Emin ŞEŞEN 3+1 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ışı
Homework 1 14 14
Preparation, After Class Study 1 6 6
Other Activities 1 1 1
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