| School/Faculty/Institute | Faculty of Engineering | ||||||
| Course Code | IE 401 | ||||||
| Course Title in English | Information Systems | ||||||
| Course Title in Turkish | Bilişim Sistemleri | ||||||
| Language of Instruction | EN | ||||||
| Type of Course | Flipped Classroom,Lecture | ||||||
| Level of Course | Advanced | ||||||
| Semester | Fall | ||||||
| Contact Hours per Week |
|
||||||
| Estimated Student Workload | 134 hours per semester | ||||||
| Number of Credits | 5 ECTS | ||||||
| Grading Mode | Standard Letter Grade | ||||||
| Pre-requisites | None | ||||||
| Expected Prior Knowledge | none | ||||||
| Co-requisites | None | ||||||
| Registration Restrictions | none | ||||||
| Overall Educational Objective | To learn the basics of the development of information systems and databases. | ||||||
| Course Description | The course will give the students an understanding of creating, managing and manipulating databases. We will start by examining competitive business environment and enterprise reference architectures. Then we will learn business analysis methodologies and modeling languages. We will investigate the essentials of using SQL for data management. We will end the course with working on basic business application architectures such as client-server, N-tier, XML and web services. The course will have a theoretical component, but it will mainly focus on the use of technology for hands-on practice. | ||||||
| Course Description in Turkish | Bu ders, öğrencilere veritabanları oluşturma, yönetme ve değiştirme konusunda deneyim kazandıracaktır. Kurumsal referans yapıları ve işletme analiz metodolojileri inceleyerek derse giriş yapacağız. Veri yönetimi için SQL kullanmanın temellerini araştıracağız. Dersi, müşteri-sunucu, N-tier, XML ve web servisleri gibi işletme uygulama yapıları üzerine çalışarak bitireceğiz. Ders teorik bir bileşene sahip olacak, ancak esas olarak uygulamalı sekilde teknolojinin kullanılması üzerine odaklanacaktır. |
Course Learning Outcomes and CompetencesUpon successful completion of the course, the learner is expected to be able to:1) create an E-R diagram and a data flow diagram that show the design of the database and list the appropriate SQLs to be used; 2) propose elementary solutions by using information systems principles; 3) implement a prototype of an information system for a real or hypothetical company using a DB application and demonstrate its performance using real or synthetic data; 4) discuss the impact of the information system design that is proposed as a solution to a company’s problem; 5) discuss the need for developing new technologies in information systems area by analyzing current technologies; 6) organize and deliver effective verbal, written, virtual, and graphical communications; 7) function effectively as a member of a team. |
| Program Learning Outcomes/Course Learning Outcomes | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
|---|---|---|---|---|---|---|---|
| 1) Thorough knowledge of the major concepts, theoretical perspectives, empirical findings, and historical trends in psychology. | |||||||
| 2) Understanding of and ability to apply essential research methods in psychology, including research design, data analysis, and data interpretation. | |||||||
| 3) Competence to use critical and creative thinking, skeptical inquiry and a scientific approach to solving problems related to behavior and mental processes. | |||||||
| 4) Understanding and ability to apply psychological principles, skills and values in personal, social, and organizational contexts. | |||||||
| 5) Ability to weigh evidence, to tolerate ambiguity, and to reflect other values that underpin psychology as a discipline. | |||||||
| 6) Internalization and dissemination of professional ethical standards. | |||||||
| 7) Demonstration of competence in information technologies, and the ability to use computer and other technologies for purposes related to the pursuit of knowledge in psychology and the broader social sciences. | |||||||
| 8) Skills to communicate the knowledge of psychological science effectively, in a variety of formats, in both Turkish and in English (in English, at least CEFR B2 level). | |||||||
| 9) Recognition, understanding, and respect for the complexity of sociocultural and international diversity. | |||||||
| 10) Recognition for the need for, and the skills to pursue, lifelong learning, inquiry, and self-improvement. | |||||||
| 11) Ability to formulate critical hypotheses based on psychological theory and literature, and design studies to test those hypotheses. | |||||||
| 12) Ability to acquire knowledge independently, and to plan one’s own learning. | |||||||
| 13) Demonstration of advanced competence in the clarity and composition of written work and presentations. |
| N None | S Supportive | H Highly Related |
| Program Outcomes and Competences | Level | Assessed by | |
| 1) | Thorough knowledge of the major concepts, theoretical perspectives, empirical findings, and historical trends in psychology. | N | |
| 2) | Understanding of and ability to apply essential research methods in psychology, including research design, data analysis, and data interpretation. | N | |
| 3) | Competence to use critical and creative thinking, skeptical inquiry and a scientific approach to solving problems related to behavior and mental processes. | H | Exam,HW,Participation |
| 4) | Understanding and ability to apply psychological principles, skills and values in personal, social, and organizational contexts. | N | |
| 5) | Ability to weigh evidence, to tolerate ambiguity, and to reflect other values that underpin psychology as a discipline. | N | |
| 6) | Internalization and dissemination of professional ethical standards. | N | |
| 7) | Demonstration of competence in information technologies, and the ability to use computer and other technologies for purposes related to the pursuit of knowledge in psychology and the broader social sciences. | N | |
| 8) | Skills to communicate the knowledge of psychological science effectively, in a variety of formats, in both Turkish and in English (in English, at least CEFR B2 level). | N | |
| 9) | Recognition, understanding, and respect for the complexity of sociocultural and international diversity. | S | Participation |
| 10) | Recognition for the need for, and the skills to pursue, lifelong learning, inquiry, and self-improvement. | S | HW,Participation |
| 11) | Ability to formulate critical hypotheses based on psychological theory and literature, and design studies to test those hypotheses. | N | |
| 12) | Ability to acquire knowledge independently, and to plan one’s own learning. | S | Exam,HW |
| 13) | Demonstration of advanced competence in the clarity and composition of written work and presentations. | H | Exam,HW |
| Prepared by and Date | SEMRA AĞRALI , September 2019 |
| Course Coordinator | SEMRA AĞRALI |
| Semester | Fall |
| Name of Instructor | Asst. Prof. Dr. MUSTAFA ÇORUH |
| Week | Subject |
| 1) | Introduction to Information Systems |
| 2) | Competitive Environment |
| 3) | Competitive Environment II |
| 4) | E-R Diagrams I |
| 5) | E-R Diagrams II |
| 6) | Introduction to Relational Databases |
| 7) | Relational Databases using MySQL I |
| 8) | Relational Databases using MySQL II |
| 9) | Database Management using SQL I |
| 10) | Database Management using SQL II |
| 11) | Database Management using SQL III |
| 12) | Database Management in the Cloud I |
| 13) | Database Management in the Cloud II |
| 14) | Data Mining for Business Intelligence |
| 15) | Final Exam/Project/Presentation period |
| 16) | Final Exam/Project/Presentation period |
| Required/Recommended Readings | David M. Kroenke; Randall J. Boyle (2016), Using MIS, Pearson. | |||||||||||||||
| Teaching Methods | Lectures/contact hours using “flipped classroom” as an active learning technique | |||||||||||||||
| Homework and Projects | Final Project | |||||||||||||||
| Laboratory Work | none | |||||||||||||||
| Computer Use | Course is given at a computer lab where computers are equipped with MySQL or SQL Server | |||||||||||||||
| Other Activities | none | |||||||||||||||
| Assessment Methods |
|
|||||||||||||||
| Course Administration |
agralis@mef.edu.tr none Instructor’s office: 5th Floor office hours: TBA email address: agralis@mef.edu.tr Rules for attendance: Minimum attendance requirement is 70%. Missing an assignment: Assignment deadlines are always extendable up to 72 hours, with submissions late for (0,24] hours receive 70% of the credit they get, (24,48] hours receive 35% , and (48,72] receive 10%. Missing a project: Project deadlines are always extendable up to 72 hours, with submissions late for (0,24] hours receive 70% of the credit they get, (24,48] hours receive 35% , and (48,72] receive 10%. Missing a final: Faculty regulations. A reminder of proper classroom behavior, code of student conduct: YÖK Regulations Academic dishonesty and plagiarism: YÖK Regulations Disclaimer: The instructor reserves the right, when necessary, to alter the grading policy, change examination dates, and modify the syllabus and course content. Modifications will be announced in class. Students are responsible for the announced changes. |
|||||||||||||||
| Activity | No/Weeks | Hours | Calculation | ||||
| No/Weeks per Semester | Preparing for the Activity | Spent in the Activity Itself | Completing the Activity Requirements | ||||
| Course Hours | 14 | 1 | 3 | 56 | |||
| Project | 3 | 22 | 1 | 69 | |||
| Quiz(zes) | 3 | 2 | 1 | 9 | |||
| Total Workload | 134 | ||||||
| Total Workload/25 | 5.4 | ||||||
| ECTS | 5 | ||||||