Nevşehir Hacı Bektaş Veli University Course Catalogue
|
|||||
| Year/Semester of Study | 1 / Spring Semester | ||||
| Level of Course | 1st Cycle Degree Programme | ||||
| Type of Course | Compulsory | ||||
| Department | SOCIAL STUDIES TEACHING | ||||
| Pre-requisities and Co-requisites | None | ||||
| Mode of Delivery | Face to Face | ||||
| Teaching Period | 14 Weeks | ||||
| Name of Lecturer | OZAN COŞKUNSERÇE (coskunserce@nevsehir.edu.tr) | ||||
| Name of Lecturer(s) | |||||
| Language of Instruction | Turkish | ||||
| Work Placement(s) | None | ||||
| Objectives of the Course | |||||
| To teach basic information in the subjects such as using Spreadsheets in advanced level, the advanced techniques of preparing presentation, web design techniques and presentation of contents in HTML in computer aided teaching and preparing course materials in education by using these tools | |||||
| Learning Outcomes | PO | MME | |
| The students who succeeded in this course: | |||
| LO-1 | Define the logic of the data base |
PO-1 Being knowledgeable about teaching programs, teaching strategies, methods and techniques, and measurement and evaluation. PO-12 Informed idividuals and institutions on issue realted to the field. PO-21 Effective use of information and communication technologies. |
Examination Laboratory Exam Presentation |
| LO-2 | Use data fields for creation. |
PO-12 Informed idividuals and institutions on issue realted to the field. PO-18 Using ways to reach the information effectively. PO-21 Effective use of information and communication technologies. |
Examination Laboratory Exam Presentation |
| LO-3 | Establish relationship between data fields |
PO-10 Knows ways to access information. PO-18 Using ways to reach the information effectively. PO-21 Effective use of information and communication technologies. |
Examination Laboratory Exam Presentation |
| LO-4 | Interpret the basic principles of Web page |
PO-5 Being knowledgeable about students’ developmental and learning characteristics and also learning difficulties. PO-7 Ability to use information sources related to the field. PO-18 Using ways to reach the information effectively. |
Examination Laboratory Exam Presentation |
| LO-5 | Create Multi-page web page |
PO-10 Knows ways to access information. PO-18 Using ways to reach the information effectively. PO-21 Effective use of information and communication technologies. |
Examination Laboratory Exam Presentation |
| LO-6 | Create a web page with Flash. |
PO-10 Knows ways to access information. PO-19 Plans and implements activities and occupational projects for the social circle lived with the consciousness of the social resposiblity. PO-21 Effective use of information and communication technologies. |
Examination Laboratory Exam Presentation |
| LO-7 | Interpret the relationship between Web and Flash. |
PO-1 Being knowledgeable about teaching programs, teaching strategies, methods and techniques, and measurement and evaluation. PO-7 Ability to use information sources related to the field. PO-18 Using ways to reach the information effectively. |
Examination Laboratory Exam Presentation |
| PO: Programme Outcomes MME:Method of measurement & Evaluation |
|||
| Course Contents | ||
| Introduction to Microsoft Excel 2003 Workbooks Formatting Worksheets Data Input Processes Formulas and Functions Charts Data Lists PivotTable and PivotChart Reports Preparing Presentation Web Design Using Microsoft Office 2003 Tools in web Design Connections with Other Microsoft Office 2003 Tools | ||
| Weekly Course Content | ||
| Week | Subject | Learning Activities and Teaching Methods |
| 1 | Introduction to spreadsheet and charts software | |
| 2 | Wokbooks and formatting worksheets | |
| 3 | Data Input Processes | |
| 4 | Formulas and Functions | |
| 5 | Charts | |
| 6 | Data Lists | |
| 7 | PivotTable and PivotChart Reports | |
| 8 | mid-term exam | |
| 9 | Preparing Presentation | |
| 10 | Web Design | |
| 11 | Web Design | |
| 12 | Using Microsoft Office 2003 Tools in web Design | |
| 13 | Laboratory exam | |
| 14 | Using Microsoft Office 2003 Tools in web Design | |
| 15 | Connections with Other Microsoft Office 2003 Tools | |
| 16 | final exam | |
| Recommend Course Book / Supplementary Book/Reading | ||
| 1 | GELİŞKEN, Uğur (2010), FLASH CS5 & ActionScript, KodLab İSTABUL | |
| 2 | Doğu A., Mısır N., Güner A., Bingöl Ö., Sönmez S., Sönmez A., Oğuz Y., Yılmaz E., Akay A., Kocabaş A., Şimşek H., Şimşek M., İmamoğlu M., Karadeniz T., Kaya Y., Gürcan F.; 2007; Temel Bilgisayar; Derya Kitabevi; TRABZON | |
| 3 | SAVAŞ Tekin, (2009) Flash ve Yardımcı Programlar, Pusula Yayınevi | |
| 4 | Doğu A., Mısır N., Bingöl Ö., Sönmez S., Sönmez A., Oğuz Y., Yılmaz E., Akay A., Kocabaş A., Şimşek H., Şimşek M., İmamoğlu M., Karadeniz T., Kaya Y.; 2007;Uygulamalı İleri Excel 2003; Derya Kitabevi; TRABZON | |
| Required Course instruments and materials | ||
| computer, projector, | ||
| Assessment Methods | |||
| Type of Assessment | Week | Hours | Weight(%) |
| mid-term exam | 8 | 2 | 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 | 2 | 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 | 14 | 28 |
| b) Search in internet/Library | 0 | ||
| c) Performance Project | 2 | 14 | 28 |
| d) Prepare a workshop/Presentation/Report | 0 | ||
| e) Term paper/Project | 0 | ||
| Oral Examination | 0 | ||
| Quiz | 0 | ||
| Laboratory exam | 2 | 14 | 28 |
| Own study for mid-term exam | 1 | 8 | 8 |
| mid-term exam | 2 | 1 | 2 |
| Own study for final exam | 1 | 14 | 14 |
| final exam | 2 | 1 | 2 |
| 0 | |||
| 0 | |||
| Total work load; | 152 | ||