| Course Title | Code | Semester | L+U Hour | Credits | ECTS |
|---|---|---|---|---|---|
| Introduction to Computer II | RTS116 | 2. Semester | 2 + 0 | 2.0 | 2.0 |
| Prerequisites | None |
| Language of Instruction | Turkish |
| Course Level | Undergraduate |
| Course Type | |
| Mode of delivery | Face to Face |
| Course Coordinator |
Lect. Murat USLU |
| Instructor(s) |
Murat USLU |
| Assistants | |
| Goals | To provide students to use the computer more effectively by giving basic computer knowledge and application. |
| Course Content | Introduction to Microsoft Excel 2007 Formatting Workbooks Worksheets Data Entry Operations Formulas and Functions Graphs Data Lists PivotTable and Summary Graph Reports Preparing Visual Presentation Web Publishing Using Office Programs in Web Publishing Links with Other Office Programs |
| Learning Outcomes |
- Recognizes computer hardware and software. - Recognizes Windows operating system items and uses them effectively. - Creates texts in the word processing program that can meet your professional needs. - Prepares presentations that can meet professional needs by using the presentation program. - Uses the internet effectively and safely. - Apply copyright and ethical rules related to information technologies. |
| Week | Topics | Learning Methods |
|---|---|---|
| 1. Week | Getting started and exploring common uses for Excel | Practice Course Hours Verbal Expression |
| 2. Week | Creating a worksheet | Preparation, After Class Study Course Hours Verbal Expression Practice |
| 3. Week | Entering data and techniques for copying and pasting | Verbal Expression Preparation, After Class Study Practice Course Hours |
| 4. Week | Understanding formulas and functions | Verbal Expression Practice Preparation, After Class Study Course Hours |
| 5. Week | Graphics | Course Hours Preparation, After Class Study Practice Verbal Expression |
| 6. Week | Data Lists | Practice Verbal Expression Preparation, After Class Study Course Hours |
| 7. Week | Summary Table and Summary Graphics Reports | Practice Verbal Expression Preparation, After Class Study Course Hours |
| 7. Week | Web Publishing | Practice Course Hours Preparation, After Class Study Verbal Expression |
| 8. Week | Midterm | Practice Course Hours |
| 9. Week | Preparing a Visual Presentation | Course Hours Practice Visual Presentation Verbal Expression Preparation, After Class Study |
| 11. Week | Web Publishing | Verbal Expression Preparation, After Class Study Practice Course Hours |
| 12. Week | Use of Office Programs in Web Publishing | Verbal Expression Course Hours Preparation, After Class Study Practice |
| 13. Week | Use of Office Programs in Web Publishing | Preparation, After Class Study Practice Verbal Expression Course Hours |
| 14. Week | Applications in the department area | Practice Preparation, After Class Study Verbal Expression Course Hours |
| 15. Week | Final | Course Hours Practice |
| H. Üçüncü, Yeni Başlayanlar İçin Bilgisayar Windows Vista ve Ofis 2007, İstanbul, Alfa Basım Yayım Dağıtım, 2008 |
| Program Requirements | Contribution Level | DK1 | DK2 | DK3 | DK4 | DK5 | DK6 | Measurement Method |
|---|---|---|---|---|---|---|---|---|
| PY1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 40,60 |
| PY2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 40,60 |
| PY3 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 40,60 |
| PY4 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 40,60 |
| PY5 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 40,60 |
| PY6 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 40,60 |
| PY7 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 40,60 |
| PY8 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 40,60 |
| PY9 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 40,60 |
| PY10 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 40,60 |
| PY11 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 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 | 15 | 1 | 15 |
| Preparation, After Class Study | 1 | 1 | 1 |
| Midterm 1 | 1 | 2 | 2 |
| Homework 1 | 2 | 1 | 2 |
| Homework 2 | 2 | 1 | 2 |
| Quiz 1 | 4 | 2 | 8 |
| Final | 1 | 2 | 2 |
| Practice | 3 | 3 | 9 |
| Classroom Activities | 5 | 2 | 10 |
| Total Workload | 51 | ||
| ECTS Credit of the Course | 2.0 | ||
