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 | |
Supportive Courses | X |
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 | To have a comprehensive understanding of basic psychological perspectives and to examine the mental, affective, and behavioral processes of human beings within a scientific discipline | |||||
2 | To have a knowledge about the historical and philosophical developments, basic concepts, applications and schools of science of psychology as well as the subfields of psychology such as clinical, experimental, social, developmental, industrial, health, traffic and educational psychology | |||||
3 | To gain skills in identifying, describing, formulating, and solving the problems related to basic mental, emotional, and behavioral problems of human beings | |||||
4 | To develop new ideas through analytical, critical, and creative point of view by using abstract concepts and to gain skills in evaluating different psychological phenomena | X | ||||
5 | To gain knowledge and skills in transforming his/her theoretical knowledge into practice in different fields of psychology | |||||
6 | To have skills in accessing knowledge and using resources | X | ||||
7 | To have knowledge about basic principles of psychological assessment along with various quantitative, qualitative, and experimental research methods, to have skills in designing and conducting research by using these methods, and analyzing, reporting, and presenting research data | X | ||||
8 | To have awareness of interpersonal sensitivity, societal processes and problems | |||||
9 | To have efficient written and oral communication skills in Turkish and English | |||||
10 | To gain skills in following the developments in the field of expertise and renewing himself/herself with an awareness of life-span learning | X | ||||
11 | To have professional and ethical responsibility, knowledge, and awareness | 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 |