| 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 |
| Instructors |
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 | Course Hours Verbal Expression Practice |
| 2. Week | Creating a worksheet | Course Hours Preparation, After Class Study Verbal Expression Practice |
| 3. Week | Entering data and techniques for copying and pasting | Practice Verbal Expression Preparation, After Class Study Course Hours |
| 4. Week | Understanding formulas and functions | Verbal Expression Practice Course Hours Preparation, After Class Study |
| 5. Week | Graphics | Practice Verbal Expression Preparation, After Class Study Course Hours |
| 6. Week | Data Lists | Verbal Expression Practice Preparation, After Class Study Course Hours |
| 7. Week | Summary Table and Summary Graphics Reports | Verbal Expression Practice Preparation, After Class Study Course Hours |
| 7. Week | Web Publishing | Practice Preparation, After Class Study Course Hours Verbal Expression |
| 8. Week | Midterm | Course Hours Practice |
| 9. Week | Preparing a Visual Presentation | Verbal Expression Course Hours Visual Presentation Practice Preparation, After Class Study |
| 11. Week | Web Publishing | Course Hours Preparation, After Class Study Practice Verbal Expression |
| 12. Week | Use of Office Programs in Web Publishing | Course Hours Practice Verbal Expression Preparation, After Class Study |
| 13. Week | Use of Office Programs in Web Publishing | Course Hours Preparation, After Class Study Practice Verbal Expression |
| 14. Week | Applications in the department area | Verbal Expression Practice Course Hours Preparation, After Class Study |
| 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 | ||
