Nevşehir Hacı Bektaş Veli University Course Catalogue
|
|||||
| Year/Semester of Study | 1 / Fall Semester | ||||
| Level of Course | Short Cycle Degree Programme | ||||
| Type of Course | Compulsory | ||||
| Department | COMPUTER PROGRAMMING | ||||
| Pre-requisities and Co-requisites | None | ||||
| Mode of Delivery | Face to Face | ||||
| Teaching Period | 14 Weeks | ||||
| Name of Lecturer | FETHULLAH MUSTAFA AKALP (fmakalp@nevsehir.edu.tr) | ||||
| Name of Lecturer(s) | MEHMET KIRTAY, | ||||
| Language of Instruction | Turkish | ||||
| Work Placement(s) | None | ||||
| Objectives of the Course | |||||
| The aim of this course is to gain the competencies related to the use of office programs in every branch of information technologies. | |||||
| Learning Outcomes | PO | MME | |
| The students who succeeded in this course: | |||
| LO-1 | can write and edit documents and texts used in daily life using a word processing program |
PO-1 Has basic, current, and practical knowledge related to his/her profession PO-3 Follows current developments and practices for his/her profession and uses them effectively PO-4 Uses information technologies related to his/her profession (software, programs, animations, etc.) effectively PO-7 Takes responsibility as a team member to solve unforeseen and complex problems encountered in applications related to his/her field |
Examination |
| LO-2 | can perform spreadsheet operations. |
PO-1 Has basic, current, and practical knowledge related to his/her profession PO-3 Follows current developments and practices for his/her profession and uses them effectively PO-4 Uses information technologies related to his/her profession (software, programs, animations, etc.) effectively PO-6 Effectively presents thoughts at the level of knowledge and skills through written and verbal communication and understandably expresses him/her |
Examination |
| LO-3 | can make necessary corrections and formatting on the created documents |
PO-1 Has basic, current, and practical knowledge related to his/her profession PO-3 Follows current developments and practices for his/her profession and uses them effectively PO-4 Uses information technologies related to his/her profession (software, programs, animations, etc.) effectively PO-6 Effectively presents thoughts at the level of knowledge and skills through written and verbal communication and understandably expresses him/her |
Examination |
| LO-4 | can perform table and document operations and handle printing tasks. |
PO-1 Has basic, current, and practical knowledge related to his/her profession PO-3 Follows current developments and practices for his/her profession and uses them effectively PO-4 Uses information technologies related to his/her profession (software, programs, animations, etc.) effectively PO-6 Effectively presents thoughts at the level of knowledge and skills through written and verbal communication and understandably expresses him/her |
Examination |
| LO-5 | can create presentations on a computer |
PO-1 Has basic, current, and practical knowledge related to his/her profession PO-3 Follows current developments and practices for his/her profession and uses them effectively PO-4 Uses information technologies related to his/her profession (software, programs, animations, etc.) effectively PO-6 Effectively presents thoughts at the level of knowledge and skills through written and verbal communication and understandably expresses him/her |
Examination |
| PO: Programme Outcomes MME:Method of measurement & Evaluation |
|||
| Course Contents | ||
| 1. Use word processing program 2. To use electronic spreadsheet program 3. Presentations to use design tool 4. Internet use and e-mail management programs | ||
| Weekly Course Content | ||
| Week | Subject | Learning Activities and Teaching Methods |
| 1 | Basic topics related to different office programs | Lecture Method, Question Answer, Discussion Method, Individual Study Method |
| 2 | Working with basic features of a word processing program such as fonts, styles, and paragraphs; performing find and replace operations | Lecture Method, Question Answer, Discussion Method, Individual Study Method |
| 3 | Adding pages, tables, drawings, plugins, links, comments, headers and footers, text, and symbols to a word processing program | Lecture Method, Question Answer, Discussion Method, Individual Study Method |
| 4 | Document formatting and page background settings in a word processing program | Lecture Method, Question Answer, Discussion Method, Individual Study Method |
| 5 | Page layout and arrangement operations in a word processing program | Lecture Method, Question Answer, Discussion Method, Individual Study Method |
| 6 | Creating a table of contents, footnotes, citations and bibliography, captions, index, and performing spelling checks in a word processing program | Lecture Method, Question Answer, Discussion Method, Individual Study Method |
| 7 | Basic topics of presentation software and key points to consider while presenting on a computer | Lecture Method, Question Answer, Discussion Method, Individual Study Method |
| 8 | mid-term exam | |
| 9 | Slide transitions and timing operations in a presentation program | Lecture Method, Question Answer, Discussion Method, Individual Study Method |
| 10 | Animation and master slide operations in a presentation program | Lecture Method, Question Answer, Discussion Method, Individual Study Method |
| 11 | Operations related to slide shows in a presentation program | Lecture Method, Question Answer, Discussion Method, Individual Study Method |
| 12 | Basic topics of spreadsheet software and working with alignment, number formats, styles, and cells | Lecture Method, Question Answer, Discussion Method, Individual Study Method |
| 13 | Working with pivot tables and charts in spreadsheet software | Lecture Method, Question Answer, Discussion Method, Individual Study Method |
| 14 | Working with formulas in spreadsheet software | Lecture Method, Question Answer, Discussion Method, Individual Study Method |
| 15 | Importing and transforming external data, applying sorting and filters, and performing forecasting in spreadsheet software, Working with the developer menu in spreadsheet software | Lecture Method, Question Answer, Discussion Method, Individual Study Method |
| 16 | final exam | |
| Recommend Course Book / Supplementary Book/Reading | ||
| 1 | Joyce, C. (2011). Adım adım Microsoft Office Professional 2010. Arkadaş. | |
| 2 | Şencan, E. (2011). Bilgisayar ve Ofis Programları Kullanımı. Bursa:Alfa Aktüel | |
| 3 | https://acikders.ankara.edu.tr/course/view.php?id=8659 | |
| 4 | https://birecik.harran.edu.tr/tr/ogrenci/ofis-programlari-ders-notlari-ogr-gor-serkan-korkmaz/ | |
| 5 | https://web.itu.edu.tr/~toros/ofis/ofis.pdf | |
| 6 | https://www.btkakademi.gov.tr/portal/course/microsoft-word-temelleri-13241 | |
| 7 | https://www.btkakademi.gov.tr/portal/course/microsoft-excel-temelleri-13897 | |
| 8 | https://www.btkakademi.gov.tr/portal/course/microsoft-powerpoint-13365 | |
| Required Course instruments and materials | ||
| Auxiliary textbook, projection, computer | ||
| 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 | 3 | 10 | 30 |
| b) Search in internet/Library | 3 | 10 | 30 |
| c) Performance Project | 0 | ||
| d) Prepare a workshop/Presentation/Report | 2 | 2 | 4 |
| e) Term paper/Project | 0 | ||
| Oral Examination | 0 | ||
| Quiz | 0 | ||
| Laboratory exam | 0 | ||
| Own study for mid-term exam | 2 | 7 | 14 |
| mid-term exam | 1 | 1 | 1 |
| Own study for final exam | 2 | 14 | 28 |
| final exam | 1 | 1 | 1 |
| 0 | |||
| 0 | |||
| Total work load; | 150 | ||