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 TRAVEL SERVICES | ||||
| 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) | KADİR ABA, SUAD BAŞBUĞ, EBUBEKİR KAYA, | ||||
| Language of Instruction | Turkish | ||||
| Work Placement(s) | None | ||||
| Objectives of the Course | |||||
| This course is intended to do with the student's bank transactions and accounting records. | |||||
| 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 professional innovations and improve themselves constantly. |
Examination Performance Project |
| LO-2 | Can create documents about his / her field using Excell office program formulas. |
PO-21 Follow professional innovations and improve themselves constantly. |
Examination Term Paper |
| LO-3 | Can format Excel pages as desired. |
PO-21 Follow professional innovations and improve themselves constantly. |
Examination Term Paper |
| LO-4 | Can create and format tables with Excell office program. |
PO-21 Follow professional innovations and improve themselves constantly. |
Examination Term Paper |
| PO: Programme Outcomes MME:Method of measurement & Evaluation |
|||
| Course Contents | ||
| To understand the Office program Excel. | ||
| Weekly Course Content | ||
| Week | Subject | Learning Activities and Teaching Methods |
| 1 | Running the Excel Program | Excel Applications |
| 2 | The use of menus and toolbars | Excel Applications |
| 3 | Formatting cells | Excel Applications |
| 4 | Formatting cells | Excel Applications |
| 5 | Cell, Row, Column Properties | Excel Applications |
| 6 | Cell, Row, Column and Page Selection, Cut, Copy, Addition | Excel Applications |
| 7 | The use of a formula or function | Excel Applications |
| 8 | mid-term exam | |
| 9 | Filtering data and Use of data base | Excel Applications |
| 10 | Filtering data and Use of data base | Excel Applications |
| 11 | Add graphics and formatting | Excel Applications |
| 12 | Adding Graphics and Applications of the formula | Excel Applications |
| 13 | Formula Applications Creating Graphic and Database | Excel Applications |
| 14 | Formula and Function Applications | Excel Applications |
| 15 | Formula and Function Applications | Excel Applications |
| 16 | final exam | |
| Recommend Course Book / Supplementary Book/Reading | ||
| 1 | Adım Adım Microsoft Office Professional 2010, Curtis Frye , Joyce Cox , Joan Lambert | |
| Required Course instruments and materials | ||
| 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) | 4 | 14 | 56 |
| Outside Class | |||
| a) Reading | 4 | 1 | 4 |
| b) Search in internet/Library | 2 | 14 | 28 |
| 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 | 2 | 8 | 16 |
| mid-term exam | 1 | 1 | 1 |
| Own study for final exam | 1 | 14 | 14 |
| final exam | 1 | 1 | 1 |
| 0 | |||
| 0 | |||
| Total work load; | 120 | ||