ECTS - Computers and Information Systems
Computers and Information Systems (CMPE104) Course Detail
| Course Name | Course Code | Season | Lecture Hours | Application Hours | Lab Hours | Credit | ECTS |
|---|---|---|---|---|---|---|---|
| Computers and Information Systems | CMPE104 | 2. Semester | 1 | 2 | 0 | 3 | 3 |
| Pre-requisite Course(s) |
|---|
| - |
| Course Language | English |
|---|---|
| Course Type | Service Courses Taken From Other Departments |
| Course Level | Bachelor’s Degree (First Cycle) |
| Mode of Delivery | |
| Learning and Teaching Strategies | Demonstration. |
| Course Lecturer(s) |
|
| Course Objectives | The objective of this course is to develop skills in creating spreadsheets, analyzing data using various functions, displaying data in graphical form, and designing and managing a database. |
| Course Learning Outcomes |
The students who succeeded in this course;
|
| Course Content | Introduction to spreadsheets: creating, and formatting a worksheet; formulas and functions; graphs and charts; ?what-if? analysis; overview of database and database management systems; relational database model; database objects; tables, queries, forms, and reports; storing, sorting, and updating information; querying database tables; integrating a |
Weekly Subjects and Releated Preparation Studies
| Week | Subjects | Preparation |
|---|---|---|
| 1 | Introduction to Microsoft Excel – Creating a Spreadsheet | Chapter 3.1-3.2 (main text) |
| 2 | Formatting and Enhancing Spreadsheet’s Appearance | Chapter 3.3 |
| 3 | Analyzing your Data – Spreadsheets in Decision Making | Chapter 3.6 |
| 4 | Using Formulas and Built-in Functions | Chapter 3.5-3.7 |
| 5 | Graphs and Charts | Chapter 3.8 |
| 6 | Analyzing Financial and Statistical Data using Add-in features (Solver Add-in: A Tool for Optimization) | Chapter 3.9 |
| 7 | Overview of Database and Database Systems | Chapter 4.1-4.3 |
| 8 | Relational Database Model | Chapter 4.4 |
| 9 | Designing and Creating a Database | Chapter 4.5 |
| 10 | Tables and Forms: Design, properties, views, wizards | Chapter 4.5-4.7 |
| 11 | Organizing and retrieving data – Queries | Chapter 4.6 |
| 12 | Presenting and Managing Data: Form and reports | Chapter 4.8-4.9 |
| 13 | Presenting and Managing Data: Form and reports (Continue) | Chapter 4.10 |
| 14 | Integrating and Sharing Information Between Applications | Lecture Notes |
| 15 | Review | |
| 16 | Review |
Sources
| Course Book | 1. Computer and Information Systems Laboratory Manual, 2004, Atılım University Publication, Department of Computer Engineering, Nevzat Sezer, Gül Tokdemir, Bülent G. Emiroğlu, Meltem G. Eryılmaz |
|---|---|
| Other Sources | 2. Bilişim Teknolojileri, ECDL + Microsoft Office, 2005, TOBB Ekonomi ve Teknoloji Üniversitesi Yayınları, Ali Yazıcı, Y. Murat Erten, Erdoğan Doğdu, Anıl Üstün. |
| 3. The O'Leary Series: Office XP, Volume I, Timothy J O'Leary, Linda I. O'Leary, McGraw-Hill/Irwin, 1st Edition, 2001. |
Evaluation System
| Requirements | Number | Percentage of Grade |
|---|---|---|
| Attendance/Participation | 1 | 10 |
| Laboratory | - | - |
| Application | - | - |
| Field Work | - | - |
| Special Course Internship | - | - |
| Quizzes/Studio Critics | - | - |
| Homework Assignments | 2 | 10 |
| Presentation | - | - |
| Project | - | - |
| Report | - | - |
| Seminar | - | - |
| Midterms Exams/Midterms Jury | 2 | 40 |
| Final Exam/Final Jury | 1 | 40 |
| Toplam | 6 | 100 |
| Percentage of Semester Work | 60 |
|---|---|
| Percentage of Final Work | 40 |
| Total | 100 |
Course Category
| Core Courses | |
|---|---|
| Major Area Courses | X |
| Supportive Courses | |
| Media and Managment Skills Courses | |
| Transferable Skill Courses |
The Relation Between Course Learning Competencies and Program Qualifications
| # | Program Qualifications / Competencies | Level of Contribution | ||||
|---|---|---|---|---|---|---|
| 1 | 2 | 3 | 4 | 5 | ||
| 1 | The skills of understanding, explaining, and using the fundamental concepts of tourism management | |||||
| 2 | Analyzing and designing management techniques and practices in tourism organizations | X | ||||
| 3 | Understanding the planning, organizing, executing, coordinating and control functions of tourism management, along with explanation and implementation of them | |||||
| 4 | Understanding the strategic, tactical and operational dimensions of the tourism management | |||||
| 5 | Ability to use the modern techniques and technological devices of tourism industry | X | ||||
| 6 | Improving the ability to effectively implement the knowledge and skills in alternative tourism areas | |||||
| 7 | Concentrating practice along with theoretical frame of tourism management | |||||
| 8 | Developing the skills of communication | |||||
| 9 | Understanding the trends in the tourism industry | |||||
| 10 | Having the quality consciousness in the tourism industry | |||||
| 11 | Adopting work ethic and social responsibility in the tourism industry | |||||
| 12 | Ability to effectively implement the business knowledge and skills in at least one of the following fields: service, marketing, finance, human resources and accounting in tourism management | X | ||||
ECTS/Workload Table
| Activities | Number | Duration (Hours) | Total Workload |
|---|---|---|---|
| Course Hours (Including Exam Week: 16 x Total Hours) | 16 | 1 | 16 |
| Laboratory | |||
| Application | |||
| Special Course Internship | |||
| Field Work | |||
| Study Hours Out of Class | 16 | 3 | 48 |
| Presentation/Seminar Prepration | |||
| Project | |||
| Report | |||
| Homework Assignments | 2 | 1 | 2 |
| Quizzes/Studio Critics | |||
| Prepration of Midterm Exams/Midterm Jury | 2 | 4 | 8 |
| Prepration of Final Exams/Final Jury | 1 | 4 | 4 |
| Total Workload | 78 | ||