Nevşehir Hacı Bektaş Veli University Course Catalogue
|
|||||
| Year/Semester of Study | 2 / Spring Semester | ||||
| Level of Course | 1st Cycle Degree Programme | ||||
| Type of Course | Optional | ||||
| Department | ULUSLARARASI TİCARET VE LOJİSTİK | ||||
| Pre-requisities and Co-requisites | None | ||||
| Mode of Delivery | Face to Face | ||||
| Teaching Period | 14 Weeks | ||||
| Name of Lecturer | KÜRŞAT İLHAN (kursat@nevsehir.edu.tr) | ||||
| Name of Lecturer(s) | |||||
| Language of Instruction | Turkish | ||||
| Work Placement(s) | None | ||||
| Objectives of the Course | |||||
| To give basic information about computer systems, computer systems, Internet and commonly used services, and to improve the usage skills of operating system (Windows 10) and office application programs (MS Word, Excel, PowerPoint, Access). | |||||
| Learning Outcomes | PO | MME | |
| The students who succeeded in this course: | |||
| LO-1 | Knows the basic concepts of computer system. |
PO-3 Mastering of basic statistics and modeling methods applied in decision-making |
Examination |
| LO-2 | Can create advanced formulas in the workbook created in the MS Excel application program, organize these formulas as he wishes, sort and filter, and work with graphics by performing data operations. |
PO-3 Mastering of basic statistics and modeling methods applied in decision-making PO-6 Following up international economic developments PO-13 Have detailed knowledge of geography and culture as well as the historical of Turkey and the world. |
Examination |
| LO-3 | Can prepare a presentation for himself in the MS Powerpoint application program, add multimedia tools and graphics to this presentation, arrange his slides as he wishes and apply animations and special effects to slide transitions. |
PO-4 Efficiency in human relations, organizational behavior and communication PO-9 Ability of communication with international commercial organizations PO-15 Establish effective communication, oral and written; at least one foreign language in general use at the level of the European language portfolio B1. |
Examination |
| PO: Programme Outcomes MME:Method of measurement & Evaluation |
|||
| Course Contents | ||
| Computer Basic Concepts, Internet and Services, Windows 10, MS Word, MS Excel, MS Powerpoint, MS Access, advanced excel applications | ||
| Weekly Course Content | ||
| Week | Subject | Learning Activities and Teaching Methods |
| 1 | Information about Cloud Technologies | Method of Narration Case Study Method |
| 2 | Use of office applications with cloud technologies and sample applications | Method of Narration Case Study Method |
| 3 | Introduction of Microsoft online office applications and use of cloud storage technologies such as OneDrive and GoogleDrive | Method of Narration Case Study Method |
| 4 | Getting to Know PowerPoint, Creating a New Presentation, Working with Text, Working with Graphics. | Method of Narration Case Study Method |
| 5 | Working with Tables and Graphs, Drawing Shapes, Creating Custom Themes and Quick Styles. Applying slide transitions. Using slide themes. | Method of Narration Case Study Method |
| 6 | Creating Animations | Method of Narration Case Study Method |
| 7 | Working with Multimedia, Applying Transitions and Animations, Presenting Your Presentation, Packaging the presentation | Method of Narration Case Study Method |
| 8 | mid-term exam | |
| 9 | MS Excel - Editing a Worksheet and Printing Documents, Using Formulas and Field Logic, cell, worksheet, workbook. Excel shortcut keys etc. Basic calculation methods. Arithmetic operation priority. | Method of Narration Case Study Method |
| 10 | MS Excel -Logical Comparisons, logical Functions (and, or, not, true, if, if, if, etc.) | Method of Narration Case Study Method |
| 11 | MS Excel -Functions (Arithmetic, statistical, date, text functions) | Method of Narration Case Study Method |
| 12 | MS Excel - Working with data, data operations and subtotals, cell references (absolute, relative). Do not reference cells on other pages or books. | Method of Narration Case Study Method |
| 13 | MS Excel - Searching and Filtering Data, Data Entry in Form Structure, Validating the entered data (Data validation). pivot table | Method of Narration Case Study Method |
| 14 | MS Excel -Target Search, Working with Charts, Chart Operations | Method of Narration Case Study Method |
| 15 | MS Excel -New Worksheets, Transferring Data and Information Between Pages | Method of Narration Case Study Method |
| 16 | final exam | |
| Recommend Course Book / Supplementary Book/Reading | ||
| 1 | Temel Bilgi Teknolojisi Kullanımı, İsmail Özkaya, Data Yayınları, İstanbul, 2013. | |
| 2 | Temel Bilgi Teknolojisi Kullanımı, Ömer Bağcı, İsmail Sarı, Seçkin Yayıncılık, Ankara, 0 | |
| Required Course instruments and materials | ||
| Assessment Methods | |||
| Type of Assessment | Week | Hours | Weight(%) |
| mid-term exam | 8 | 1 | 40 |
| Other assessment methods | |||
| 1.Oral Examination | |||
| 2.Quiz | |||
| 3.Laboratory exam | |||
| 4.Presentation | |||
| 5.Report | |||
| 6.Workshop | |||
| 7.Performance Project | |||
| 8.Term Paper | |||
| 9.Project | |||
| final exam | 16 | 1 | 60 |
| Student Work Load | |||
| Type of Work | Weekly Hours | Number of Weeks | Work Load |
| Weekly Course Hours (Theoretical+Practice) | 3 | 14 | 42 |
| Outside Class | |||
| a) Reading | 2 | 8 | 16 |
| b) Search in internet/Library | 2 | 8 | 16 |
| c) Performance Project | 0 | ||
| d) Prepare a workshop/Presentation/Report | 0 | ||
| e) Term paper/Project | 0 | ||
| Oral Examination | 0 | ||
| Quiz | 0 | ||
| Laboratory exam | 0 | ||
| Own study for mid-term exam | 4 | 7 | 28 |
| mid-term exam | 1 | 1 | 1 |
| Own study for final exam | 4 | 7 | 28 |
| final exam | 1 | 1 | 1 |
| 0 | |||
| 0 | |||
| Total work load; | 132 | ||