Nevşehir Hacı Bektaş Veli University Course Catalogue
|
|||||
| Year/Semester of Study | 1 / Spring Semester | ||||
| Level of Course | Short Cycle Degree Programme | ||||
| Type of Course | Compulsory | ||||
| Department | TOURISM AND HOTEL MANAGEMENT | ||||
| Pre-requisities and Co-requisites | None | ||||
| Mode of Delivery | Face to Face | ||||
| Teaching Period | 14 Weeks | ||||
| Name of Lecturer | FURKAN SOYSALDI (furkansoysaldi@nevsehir.edu.tr) | ||||
| Name of Lecturer(s) | CEREN BAŞTEMUR KAYA, | ||||
| Language of Instruction | Turkish | ||||
| Work Placement(s) | None | ||||
| Objectives of the Course | |||||
| Using Office programs and internet. Solving physics problems with Office. Drawing charts by using experiment results, creating documents and statistics, interpreting the results. | |||||
| Learning Outcomes | PO | MME | |
| The students who succeeded in this course: | |||
| LO-1 | Using Excel ofice program on issues related to the profession. |
PO-21 Follow vocational innovations and improve themselves constantly on a continued basis. |
Examination |
| LO-2 | Student can use conditional statements |
PO-21 Follow vocational innovations and improve themselves constantly on a continued basis. |
Examination |
| LO-3 | Student know and can use text functions |
PO-21 Follow vocational innovations and improve themselves constantly on a continued basis. |
Examination |
| PO: Programme Outcomes MME:Method of measurement & Evaluation |
|||
| Course Contents | ||
| Studies computer operations by learning the history and development of computers, computers’ operating principles and structure. Studies filing, editing and documentation of experiment results with Word word-processing program. Creates tables of experiment results with the assistance of Excel, draws charts that display these results, solves problems with the help of formulas and functions, and analyzes them. | ||
| Weekly Course Content | ||
| Week | Subject | Learning Activities and Teaching Methods |
| 1 | Running the Excel Program | |
| 2 | The use of menus and toolbars | |
| 3 | Formatting cells | |
| 4 | Formatting cells | |
| 5 | Cell, Row, Column Properties | |
| 6 | Cell, Row, Column and Page Selection, Cut, Copy, Addition | |
| 7 | The use of a formula or function | |
| 8 | mid-term exam | |
| 9 | Filtering data and Use of data base | |
| 10 | Filtering data and Use of data base | |
| 11 | Add graphics and formatting | |
| 12 | Adding Graphics and Applications of the formula | |
| 13 | Formula Applications Creating Graphic and Database | |
| 14 | Formula and Function Applications | |
| 15 | Formula and Function Applications | |
| 16 | final exam | |
| Recommend Course Book / Supplementary Book/Reading | ||
| Required Course instruments and materials | ||
| 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) | 4 | 14 | 56 |
| Outside Class | |||
| a) Reading | 0 | ||
| b) Search in internet/Library | 3 | 14 | 42 |
| 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 | 1 | 7 | 7 |
| mid-term exam | 1 | 1 | 1 |
| Own study for final exam | 1 | 13 | 13 |
| final exam | 1 | 1 | 1 |
| 0 | |||
| 0 | |||
| Total work load; | 120 | ||