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
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 Preparation, After Class Study, Research, Other Activities
2. Week Character Formatting, Paragraph Formatting Preparation, After Class Study, Research, Other Activities
3. Week MS Excel - Data manipulation. Interview, Presentation (Preparation), Practice
4. Week MS Excel - Row and column operations. Interview, Presentation (Preparation), 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. Interview, Presentation (Preparation), Practice
7. Week MS Excel - Formatting operations. Preparation, After Class Study, Interview, Presentation (Preparation), Practice
8. Week Formatting Worksheets, Managing Worksheets Preparation, After Class Study, Research, Other Activities
9. Week Working with Data and Macros, Using Advanced Formulas Preparation, After Class Study, Research, 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. Preparation, After Class Study, Interview, Practice
12. Week Designing a Presentation, Adding Tables to Slides, Using Graphics in a Presentation Preparation, After Class Study, Research, Other Activities
13. Week Create SmartArt Graphics, Add Graphics to a Presentation, Use Animation and Multimedia Preparation, After Class Study, Research, Other Activities
14. Week Preserving and Sharing the Presentation, Presenting the Presentation Preparation, After Class Study, Research, Other Activities
*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.
Relations with Education Attainment Program Course Competencies
Program Requirements DK1 DK2 DK3 DK4 DK5 DK6 DK7 DK8
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