| 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 | Providing basic level usage skills of MS Excel office application program. |
| Course Content | Basic level use of MS Excel. |
| # | Öğrenme Kazanımı |
| 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. |
| 3 | It carries out the editing and printing of tables and business letters used in business life. |
| Week | Topics/Applications | Method |
|---|---|---|
| 1. Week | MS Excel - Introduction to Excel, page and cell concepts, cursor types. | Interview |
| 2. Week | MS Excel - elements of the interface of the spreadsheet program, getting acquainted with the toolbars, working with files, navigating the worksheet. | Practice, Presentation (Preparation), Interview |
| 3. Week | MS Excel - Data manipulation. | Practice, Interview, Presentation (Preparation) |
| 4. Week | MS Excel - Row and column operations. | Practice, Interview, Presentation (Preparation) |
| 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. | Preparation, After Class Study, Presentation (Preparation), Practice, Interview |
| 8. Week | MS Excel - Page settings and printing options. | Presentation (Preparation), Preparation, After Class Study, Interview, Practice |
| 9. Week | MS Excel - Window settings. | Interview, Presentation (Preparation), Practice |
| 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. | Practice, Preparation, After Class Study, Interview |
| 12. Week | MS Excel - Statistical functions, date lookup and text functions. | Presentation (Preparation), Practice, Interview |
| 13. Week | MS Excel- Graphic operations. | Practice, Presentation (Preparation), Preparation, After Class Study, Interview |
| 14. Week | MS Excel - Data analysis. | Interview, Preparation, After Class Study, Practice, Presentation (Preparation) |
| Program Requirements | DK1 | DK2 | DK3 |
|---|
| Ders Kitabı veya Notu | Ders Kitabı veya Ders Notu bulunmamaktadır. |
|---|---|
| Diğer Kaynaklar |
|
| Güz Dönemi | |||
| Responsible Personnel | Grup | Evaluation Method | Percentage |
|---|---|---|---|
| Öğr. Gör. Dr. Emin ŞEŞEN | Metalurji -1 (Zorunlu) 3+1 | Vize | 40.00 |
| Öğr. Gör. Dr. Emin ŞEŞEN | Metalurji -1 (Zorunlu) 3+1 | Final | 60.00 |
| Toplam | 100.00 | ||
| ECTS credits and course workload | Quantity | Duration (Hour) | Total Workload (Hour) | |
|---|---|---|---|---|
|
Ders İçi |
Class Hours | 14 | 2 | 28 |
|
Ders Dışı |
Preparation, After Class Study | 4 | 1 | 4 |
| Other Activities | 4 | 1 | 4 | |
|
Sınavlar |
Midterm 1 | 1 | 1 | 1 |
| Final | 1 | 1 | 1 | |
| Classroom Activities | 13 | 1 | 13 | |
| Total Workload | 51 | |||
| *AKTS = (Total Workload) / 25,5 | ECTS Credit of the Course | 2.0 | ||
