| TYPE OF COURSE UNIT | Compulsory Course |
| LEVEL OF COURSE UNIT | Bachelor's Degree |
| YEAR OF STUDY | 1 |
| SEMESTER | First Term (Fall) |
| NUMBER OF ECTS CREDITS ALLOCATED | 5 |
| NAME OF LECTURER(S) | Assistant Professor Murat Tahir Çaldağ
|
| LEARNING OUTCOMES OF THE COURSE UNIT |
At the end of this course, the students;
1) Learn to use all the features of word processing software at a high level.
2) Learn to use all the features of the spreadsheet software at a high level.
3) Learn to use some statistical applications with spreadsheet software
4) They learn to use all the features of the Presentation software at a high level.
|
| MODE OF DELIVERY | Face to face |
| PRE-REQUISITES OF THE COURSE | No |
| RECOMMENDED OPTIONAL PROGRAMME COMPONENT | |
| COURSE DEFINITION | The aim of this course is; To provide students with problem solving and analysis skills by understanding the importance of advanced information technologies, to create an infrastructure for their research and learning needs, to develop their learning and application skills by understanding the importance of technology and science in education and professional life. |
| COURSE CONTENTS | | WEEK | TOPICS |
|---|
| 1st Week | Introduction, Introduction and Installation of Microsoft Office Applications | | 2nd Week | Word Processor - Introduction and basic applications | | 3rd Week | Word Processor - Advanced applications | | 4th Week | Spreadsheet Processing - Basic Applications, Formulas and Functions | | 5th Week | Spreadsheet Processing - Charts and Table Preparation | | 6th Week | Spreadsheet Processing - Advanced Formulas and Functions I | | 7th Week | Spreadsheet Processing - Examples and Applications I | | 8th Week | Midterm | | 9th Week | Spreadsheet Processing - Advanced Formulas and Functions II | | 10th Week | Spreadsheet Processing - Examples and Applications II | | 11th Week | Spreadsheet Processing - Some Statistical Applications | | 12th Week | Presentation Preparation - Introduction and Basic Applications | | 13th Week | Presentation Preparation - Advanced Presentation Applications | | 14th Week | General Review |
|
| RECOMENDED OR REQUIRED READING | İleri Düzey Excel 2019, Ömer Bağcı, Seçkin Yayıncılık, 9.Baskı, 2020.
Microsoft Excel 2019, Osman Gürkan, Nirvana Yayınları, 2020.
Bilgisayar ve İnternet Kullanımı (Windows 7 ? Ofice 2010), Dr. Hasan Çebi Bal, Ekin Basım Yayın, 2018. |
| PLANNED LEARNING ACTIVITIES AND TEACHING METHODS | Lecture,Practice |
| ASSESSMENT METHODS AND CRITERIA | | | Quantity | Percentage(%) |
|---|
| Mid-term | 1 | 30 | | Quiz | 3 | 30 | | Total(%) | | 60 | | Contribution of In-term Studies to Overall Grade(%) | | 60 | | Contribution of Final Examination to Overall Grade(%) | | 40 | | Total(%) | | 100 |
|
| ECTS WORKLOAD |
| Activities |
Number |
Hours |
Workload |
| Midterm exam | 1 | 2 | 2 | | Preparation for Quiz | 3 | 4 | 12 | | Individual or group work | 14 | 2 | 28 | | Preparation for Final exam | 1 | 30 | 30 | | Course hours | 14 | 3 | 42 | | Preparation for Midterm exam | 1 | 20 | 20 | | Laboratory (including preparation) | | | | | Final exam | 1 | 2 | 2 | | Homework | | | | | Quiz | 3 | 1 | 3 | | Total Workload | | | 139 |
|---|
| Total Workload / 30 | | | 4,63 |
|---|
| ECTS Credits of the Course | | | 5 |
|---|
|
| LANGUAGE OF INSTRUCTION | Turkish |
| WORK PLACEMENT(S) | No |
| | |
