Code: | ESG0028 | Acronym: | SII |
Keywords | |
---|---|
Classification | Keyword |
OFICIAL | Interaction and Multimedia |
OFICIAL | Engineering |
Active? | Yes |
Responsible unit: | Department of Industrial Engineering and Management |
Course/CS Responsible: | Master in Services Engineering and Management |
Acronym | No. of Students | Study Plan | Curricular Years | Credits UCN | Credits ECTS | Contact hours | Total Time |
---|---|---|---|---|---|---|---|
MESG | 15 | Syllabus since 2007/08 | 1 | - | 6 | 56 | 162 |
Prepare students for designing information systems appropriate to user needs and objectives of organizations, considering the short, medium and long term. So they should be able to prepare conceptual models of information, in particular classes of objects and relational models, develop conceptual models of user interaction, apply software engineering methodology, and use relational database management systems.
Students should be able to (i) analyze a problem of information management, (ii) propose and test a conceptual model, (iii) build and test a prototype database and user interfaces, including searches and reports. This prototype can be for personal use, but it is not suitable for groups of people. Students learn to negotiate the development of robust enterprise systems.
Algebra.
Basic enterprise Management concepts.
Basic personal computing skills.
1. DESIGN OF INFORMATION SYSTEMS: Introduction to the processes of analysis and modelling of systems and organisations; Introduction to the design of an information system.
2. USER INTERFACE MODELING: Introduction; Introduction to specification and prototyping tools; Recommendations, principles and rules for interface design; Main models of interface: menus, forms, dialogue boxes and direct manipulation; Problems with user interaction modelling.
3. CONCEPTUAL MODELING OF CLASSES: static modelling of classes of objects (UML); classes, attributes and methods; associations and simple aggregations; generalisations and inheritance; Mapping between class model and relational model.
4. DATABASE DESIGN: Introduction to DBMS - Database Management Systems; SQL language; RelacionalAlgebra and Calculus; Database normalisation.
5. CONCLUSIONS AND REFERENCES.
MAIN BIBLIOGRAPHY: Documentation prepared by lecturers (lecture notes in Portuguese and presentations from classes in English) in the course Web page (SiFEUP/SIGARRA).
OTHER BIBLIOGRAPHY (selected chapters to be indicated by the lecturers on the indicated themes):
DESIGN OF INFORMATION SYSTEMS: Barry W. Boehm: Software Engineering Economics, Prentice Hall 1981.
USER INTERFACE MODELING: Yvonne Rogers, Helen Sharp, Jenny Preece: Interaction Design: Beyond Human - Computer Interaction, John Wiley & Sons 2011.
CONCEPTUAL MODELING OF CLASSES: Michael R. Blaha, William J. Premerlani: Object-Oriented Modeling and Design for Database Applications, Prentice Hall 1998.
DATABASE DESIGN and CONCEPTUAL MODELING OF CLASSES: Abraham Silberschatz, Henry F. Korth, S. Sudarshan: Database System Concepts, McGraw-Hill 1997.
DATABASE DESIGN: C. J. Date: An Introduction to Database Systems (6th Edition), Addison Wesley 1995.
CRITICAL SUCCESS FACTORS: John F. Rockart: Chief Executives Define their own Data Needs, Harvard Business Review, 2, 1979.
PROCESS MODELLING: Geary A. Rummler, Alan P. Brache: Improving Performance: How to Manage the White Space on the Organization Chart, Jossey-Bass 1990
This course is based on the following complementary activities that involve lecturing, learning, and associated assessment of acquired knowledge and competences:
A1. THEORETICAL NOTIONS: The theoretical concepts taught during theoretical classes should be learnt by study activities and conceptualisation.
A2. THEORETICAL-PRACTICAL CASES: Students should study test cases and solutions presented by lecturers in classes, and practice with new problems.
A3. DBMS TOOL: After the presentation of the software tool (MS Access) students should autonomously use and explore it.
A4. INFORMATION SYSTEM PROTOTYPE: Students have to design and develop an IS prototype. This project will be supervised by the lecturers during classes. Note: Student groups will be composed based on a questionnaire with behavioural questions aiming at creating homogenous groups.
Designation | Weight (%) |
---|---|
Defesa pública de dissertação, de relatório de projeto ou estágio, ou de tese | 5,00 |
Exame | 45,00 |
Teste | 10,00 |
Trabalho escrito | 15,00 |
Trabalho laboratorial | 25,00 |
Total: | 100,00 |
Designation | Time (hours) |
---|---|
Elaboração de projeto | 20,00 |
Elaboração de relatório/dissertação/tese | 16,00 |
Estudo autónomo | 60,00 |
Frequência das aulas | 56,00 |
Trabalho de investigação | 10,00 |
Total: | 162,00 |
Students have to reach a minimum mark to be admitted to exams (See General Evaluation Rules of FEUP).
All written examinations are closed book exercises. The most important formulas will be provided to students if required. It will also be taken into the account in the assessment the presentation, correctness and quality of the Portuguese or English language used.
The group project mark done in a previous academic year will be considered only if the cross-evaluation by the rest of the group is over 2.5 values in 5.
The final mark will be calculated based on the grades achieved on the mini-test Access (10% of the Final Mark), on the Final Exam (45% of the final mark) and on the group assignment (45% of the Final Mark).
P1. Mini-test Access: 10%
P2. Final Exam : 45% (Note: A minimum mark of 6.5 out of 20 is required in this component for successful completion of this course.
P3 Group assignment
P3.1 Report: 15%
P3.2 Assignment: 25%
P3.3- Assignment presentation: 5%
Each group makes a 10 minute presentation. The lecturers may choose which student will make the presentation and may ask questions to each group member individually (this allows a distinct evaluation of each group member in this evaluation component).
At the end of the group project assignment, each student has to assess each of his group colleagues using a cross evaluation system available on: http://paginas.fe.up.pt/~sibd/aval (SiFEUP/SIGARRA username and password). This cross-evaluation may change the individual mark of a student in the group project negatively or positively as follows: [-2, -1, 0, 1] (when compared to the global group mark before cross-evaluation).
Students who do not answer the survey used to set the profile for the creation of the projects groups within the prescribed deadline will have a penalty of 25% on the group work mark.
Students who do not perform the cross-evaluation within the prescribed deadline will have a penalty of 25% on the group work mark and the corresponding cross-evaluation will be filled with the default value.
At the time of appeal exam: the marks obtained in group work and in the MS Access mini-test will keep the same weight.
Not applicable.
Not applicable.
Students may also improve their marks in the P2 or P3 components in the following academic year.
The group project mark done in a previous academic year will be considered only if the cross-evaluation by the rest of the group is over 2.5 values in 5.
The members of the groups will be selected by the lecturers. This selection will be based on a questionnaire, which will work as way of defining each students’ profile in a group. Each member of the group will have the chance to assess the performance of the peer members, by a system of crossed assessment.