| Course Type | Elective Course |
|---|
| Course Level | Master's Degree With Thesis |
|---|
| Year of Study | - |
|---|
| Semester | - |
|---|
| ECTS | 10 |
|---|
| Name of Lecturer(s) |
|
| Learning Outcomes |
At the end of this course, the students;
- Gain an ability to apply the basic principles of database management system.
- Gain an ability to design a data entry and database processes to meet desired needs within realistic.
- Explain the decision support systems, ofice automation systems and networks for engineering applicationsLO9. An ability to interrelate the work study and the productivity.
|
| Mode of Delivery | Face to face |
|---|
| Prerequisites | No |
|---|
| Recommended Optional Programme Components | None |
|---|
| Course Description | Introduction to information systems, transaction/data processing, database design, database management systems, computer based information systems, management information systems, decision support systems, office automation systems, executive support systems, communication and network systems, e-trade, structural query language (SQL). |
|---|
| Course Contents |
| WEEK |
TOPICS |
|
1st Week |
Basic Concepts, Introduction to Information Systems, Data, Databases, Tables: Data types, table creation applications in Access and MySQL. |
|
2nd Week |
Normalization Operations. ER Diagrams |
|
3rd Week |
Queries: Introduction to SQL, the SELECT command, and applications in Access and MSSQL |
|
4th Week |
Queries, SELECT, INSERT commands, and applications in Access and MSSQL |
|
5th Week |
Queries, DELETE, and UPDATE commands, and applications in Access and MSSQL |
|
6th Week |
MSSQL Programming: IF, CASE, WHILE, and PROCEDURE, and Report Creation Applications |
|
7th Week |
Midterm |
|
8th Week |
VBA Programming: Data Access Objects |
|
9th Week |
VBA Programming: Data Access Objects |
|
10th Week |
VBA Programming: Data Access Objects |
|
11th Week |
VBA Programming: Data Access Objects |
|
12th Week |
Multi-Criteria Decision Models and MOORA Application |
|
13th Week |
Project Presentation |
|
14th Week |
Project Presentation |
|
| Recommended or Required Reading | K. C. LAUDON-J. P. LAUDON, Management Information Systems, Prentice Hall, Upper Saddle River 2010.
Gökçen H., (2002) Yönetim Bilgi Sistemleri, Epi Yayıncılık |
|---|
| Planned Learning Activities and Teaching Methods |
- Lecture
- Questions/Answers
- Problem Solving
- Practice
- Presentation
|
|---|
| Assessment Methods and Criteria |
|
Quantity |
Percentage (%) |
| Mid-term |
1 |
30 |
| Project |
1 |
30 |
| Total(%) |
|
60 |
| Contribution of In-term Studies to Overall Grade(%) |
|
60 |
| Contribution of Final Examination to Overall Grade(%) |
|
40 |
| Total(%) |
|
100 |
|
| ECTS Allocated Based on Student Workload |
| Activities |
Quantity |
Duration (Hour) |
Total Workload (Hour) |
| Midterm exam |
1 |
2 |
2 |
| Preparation for Quiz |
|
|
|
| Individual or group work |
14 |
14 |
196 |
| Preparation for Final exam |
1 |
25 |
25 |
| Course hours |
14 |
3 |
42 |
| Preparation for Midterm exam |
1 |
25 |
25 |
| Laboratory (including preparation) |
|
|
|
| Final exam |
1 |
2 |
2 |
| Homework |
1 |
14 |
14 |
| Total Work Load | 306 |
| Total Work Load / 30 (h) | 10.2 |
| ECTS Credit of the Course | 10 |
|
| Language of Instruction | Turkish |
|---|
| Work Placement(s) | No |
|---|
