Information Package / Course Catalogue
| Law | |||||
| Bachelor | Length of the Programme: 4 | Number of Credits: 240 | TR-NQF-HE: Level 6 | QF-EHEA: First Cycle | EQF: Level 6 |
ECTS Course Information Package
| 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 | ||||||
| Co-requisites | None | ||||||
| Expected Prior Knowledge | 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 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) The ability to recognize and apply basic principles and theories of law, legal methodology, and interpretation methods. | |||||||
| 2) The ability to follow, evaluate, interpret and apply the current developments and legislative amendments. | |||||||
| 3) The ability to locate and use legal resources; to follow and evaluate current legislative amendments, legal science, and court decisions. | |||||||
| 4) The ability to internalize social, scientific and ethical values while evaluating legal information. | |||||||
| 5) The ability to recognize, examine and resolve legal issues with respect to general principles of law, de lege feranda and de lege lata; to take into consideration both national and international aspects of law; and to acknowledge the importance of personal conviction while making decisions. | |||||||
| 6) The ability to critically analyze legal disputes, legislation, court decisions and different views in the legal science; to form his/her own opinions; to detect legal lacuna and suggest alternative solutions. | |||||||
| 7) The ability to understand issues regarding different fields of law; to characterize and propose solutions to complex issues arising from legal practice. | |||||||
| 8) The ability to participate in and organize legal projects and activities as a socially responsible individual; to put his/her legal knowledge and skill to use efficiently (in the public or private sector). | |||||||
| 9) The ability to use a foreign language at least on a B2 Level on the European Language Portfolio, to follow legal developments and communicate with colleagues in that language; to use computer software and information and communication technologies necessary in the law field at an Advanced Level of the European Computer Driving License. | |||||||
| 10) Adoption of a positive approach to the concept of lifelong learning. | |||||||
| 11) The ability to understand the development, evolution, and problems of the society and to contribute to the solution of these problems by legal methods. | |||||||
| 12) The ability to understand the structure, organization, and functioning of law on the national and international level; to contribute to the development thereof. |
Relation to Program Outcomes and Competences
| N None | S Supportive | H Highly Related |
| Program Outcomes and Competences | Level | Assessed by | |
| 1) | The ability to recognize and apply basic principles and theories of law, legal methodology, and interpretation methods. | S | |
| 2) | The ability to follow, evaluate, interpret and apply the current developments and legislative amendments. | N | |
| 3) | The ability to locate and use legal resources; to follow and evaluate current legislative amendments, legal science, and court decisions. | N | |
| 4) | The ability to internalize social, scientific and ethical values while evaluating legal information. | S | |
| 5) | The ability to recognize, examine and resolve legal issues with respect to general principles of law, de lege feranda and de lege lata; to take into consideration both national and international aspects of law; and to acknowledge the importance of personal conviction while making decisions. | N | |
| 6) | The ability to critically analyze legal disputes, legislation, court decisions and different views in the legal science; to form his/her own opinions; to detect legal lacuna and suggest alternative solutions. | N | |
| 7) | The ability to understand issues regarding different fields of law; to characterize and propose solutions to complex issues arising from legal practice. | N | |
| 8) | The ability to participate in and organize legal projects and activities as a socially responsible individual; to put his/her legal knowledge and skill to use efficiently (in the public or private sector). | N | |
| 9) | The ability to use a foreign language at least on a B2 Level on the European Language Portfolio, to follow legal developments and communicate with colleagues in that language; to use computer software and information and communication technologies necessary in the law field at an Advanced Level of the European Computer Driving License. | S | |
| 10) | Adoption of a positive approach to the concept of lifelong learning. | H | |
| 11) | The ability to understand the development, evolution, and problems of the society and to contribute to the solution of these problems by legal methods. | N | |
| 12) | The ability to understand the structure, organization, and functioning of law on the national and international level; to contribute to the development thereof. | N |
| Prepared by and Date | SEMRA AĞRALI , September 2019 |
| Course Coordinator | SEMRA AĞRALI |
| Semester | Fall |
| Name of Instructor | Asst. Prof. Dr. UTKU KOÇ |
Course Contents
| 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. |
|||||||||||||||
ECTS Student Workload Estimation
| 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 | ||||||