| Course Type | Elective Course |
|---|
| Course Level | Bachelor's Degree |
|---|
| Year of Study | - |
|---|
| Semester | - |
|---|
| ECTS | 5 |
|---|
| Name of Lecturer(s) |
|
| Learning Outcomes |
At the end of this course, the students;
- Can explain the basic concepts of information system.
- Can create the database and its components (table, form, query, report).
- Can write basic queries (select, delete, update, insert) on the database as SQL
- Can design information system prototype
- Can explain basic concepts of production information systems
- Can implement the basic functions of a sample ERP software (warehouse, shift, inventory, BOM definition, MPS-MRP)
|
| Mode of Delivery | Face to face |
|---|
| Prerequisites | No |
|---|
| Recommended Optional Programme Components | None |
|---|
| Course Description | Information management in production systems, Information and knowledge. Design principles in production information systems. E-R models and normalization. Design of relational databases and Access, query design, SQL queries and DDL, DCL, and DML, single and multiple tables. Forms, macros and reports in Access. Visual Basic database programming by using data control. Database programming by using DAO. Database programming by using ADO and Access modules. ASP interface. Applications with MRP, MRPII and ERP. |
|---|
| Course Contents |
| WEEK |
TOPICS |
|
1st Week |
Introduction to information systems: Basic Concepts, Establishment of information systems, tools used in the development of information systems Management of information system projects, management information system, concepts of production information system |
|
2nd Week |
Database Design and Management: Basic concepts, data types, table creation applications in Access and MySQL, Normalization Operations. Form creation applications on Access. |
|
3rd Week |
Database Design and Management: SELECT command and Access and MySQL applications |
|
4th Week |
Database Design and Management: SELECT, INSERT command and Access and MySQL applications |
|
5th Week |
Database Design and Management: DELETE and UPDATE commands and Access and MySQL applications |
|
6th Week |
Database Design and Management: Reports on Access and VB script applications |
|
7th Week |
Database Design and Management: VB script applications on Access |
|
8th Week |
Midterm |
|
9th Week |
Database Design and Management: VB script applications on Access |
|
10th Week |
Database Design and Management: VB script applications on Access |
|
11th Week |
Database Design and Management: VB script applications on Access |
|
12th Week |
Implementation of the sample ERP system: Identification BOM, product route, order, stock-supply policies |
|
13th Week |
Implementation of the sample ERP system: Opening, displaying, reviewing and approving work orders |
|
14th Week |
Implementation of the sample ERP system: Creation of sample databases Implementation of the sample ERP system: Business Intelligence application. |
|
| Recommended or Required Reading | K. C. LAUDON-J. P. LAUDON, Management Information Systems, Prentice Hall, Upper Saddle River 2010.
Access Database Design and Programming (2002), Steven Roman ve Ron Petrusha, O'Reilly and Assc.
|
|---|
| Planned Learning Activities and Teaching Methods |
- Project
- Lecture
- Questions/Answers
- Problem Solving
- Report Preparation
|
|---|
| Assessment Methods and Criteria |
|
Quantity |
Percentage (%) |
| Mid-term |
1 |
35 |
| Practice |
1 |
15 |
| Project |
1 |
10 |
| 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 |
2 |
28 |
| Preparation for Final exam |
1 |
25 |
25 |
| Course hours |
14 |
3 |
42 |
| Preparation for Midterm exam |
1 |
25 |
25 |
| Laboratory (including preparation) |
1 |
4 |
4 |
| Final exam |
1 |
2 |
2 |
| Homework |
1 |
8 |
8 |
| Total Work Load | 136 |
| Total Work Load / 30 (h) | 4.53 |
| ECTS Credit of the Course | 5 |
|
| Language of Instruction | Turkish |
|---|
| Work Placement(s) | No |
|---|
