| Course Title | Code | Semester | L+U Hour | Credits | ECTS |
|---|---|---|---|---|---|
| OFFICE PROGRAMS II | BÜR202 | 2. Semester | 3 + 1 | 4.0 | 4.0 |
| Prerequisites | None |
| Language of Instruction | Turkish |
| Course Level | Associate |
| Course Type | |
| Mode of delivery | Face to face |
| Course Coordinator |
Lect. Nilgün EROĞLU |
| Instructor(s) |
Nilgün EROĞLU |
| Assistants | |
| Goals | In this course, it is aimed to gain competencies related to self-improvement by using informatics facilities. In addition, it is aimed that the students who take this course gain the necessary hardware in basic informatics software subjects. |
| Course Content | Personal Web Site Preparation Electronic Commerce Word Processor Program Curriculum Vitae Internet and Career Job Interview Preparation Process Table Formulas and Functions Graphs Presentation Preparation Introductory Material Preparation |
| Learning Outcomes |
- Communicate on the Internet - In the Internet environment to apply for a job - To edit numerical data - With ready-made templates to prepare promotional material |
| Week | Topics | Learning Methods |
|---|---|---|
| 1. Week | Word program menus general repetition | Verbal Expression Practice Course Hours |
| 2. Week | Working with the references tab in Word | Course Hours Verbal Expression Practice |
| 3. Week | Working with the references tab in Word | Course Hours Practice |
| 4. Week | Mail merge in Word program | Visual Presentation Course Hours Verbal Expression |
| 5. Week | Working with the Developer tab in Word | Visual Presentation Practice Course Hours Verbal Expression |
| 6. Week | Introduction to Excel program | Verbal Expression Visual Presentation Practice Course Hours |
| 7. Week | Formatting and analyzing data in Excel | Practice Course Hours Visual Presentation Verbal Expression |
| 8. Week | Creating tables and graphs in Excel program | Visual Presentation Practice Course Hours Verbal Expression |
| 9. Week | Conditional formatting exercises in Excel program | Verbal Expression Visual Presentation Practice Course Hours |
| 10. Week | Formulas in Excel program | Course Hours Verbal Expression Visual Presentation Practice |
| 11. Week | Date and Time functions in Excel program | Course Hours Verbal Expression Visual Presentation Practice |
| 12. Week | Search and Reference functions in Excel program | Course Hours Verbal Expression Visual Presentation Practice |
| 13. Week | Mathematical functions in Excel program | Verbal Expression Course Hours Visual Presentation Practice |
| 14. Week | Statistical functions in Excel program | Visual Presentation Practice Course Hours Verbal Expression |
| • Lecture Notes, • Internet |
| Program Requirements | Contribution Level | DK1 | DK2 | DK3 | DK4 | Measurement Method |
|---|---|---|---|---|---|---|
| PY1 | 5 | 5 | 5 | 5 | 5 | 40,60 |
| PY3 | 4 | 4 | 4 | 4 | 4 | 40,60 |
| PY5 | 5 | 5 | 5 | 5 | 5 | 40,60 |
| PY8 | 5 | 5 | 5 | 5 | 5 | 40,60 |
| PY12 | 5 | 5 | 5 | 5 | 5 | 40,60 |
| PY14 | 4 | 4 | 4 | 4 | 4 | 40,60 |
| 0 | 1 | 2 | 3 | 4 | 5 | |
|---|---|---|---|---|---|---|
| Course's Level of contribution | None | Very Low | Low | Fair | High | Very High |
| Method of assessment/evaluation | Written exam | Oral Exams | Assignment/Project | Laboratory work | Presentation/Seminar |
| Event | Quantity | Duration (Hour) | Total Workload (Hour) |
|---|---|---|---|
| Course Hours | 14 | 4 | 56 |
| Preparation, After Class Study | 1 | 11 | 11 |
| Research | 1 | 10 | 10 |
| Midterm 1 | 1 | 1 | 1 |
| Homework 1 | 1 | 10 | 10 |
| Final | 1 | 1 | 1 |
| Practice | 1 | 13 | 13 |
| Total Workload | 102 | ||
| ECTS Credit of the Course | 4.0 | ||
