Sistemas de Informação

There is no recommended background knowledge.

Theoretical and expository classes (through multimedia support) of the various syllabus, complemented with dialogued expository classes. Tutorial guidance classes with tool exploration and implementation of small projects.

Develop the capacity of analysis and planning and monitoring the development of information systems in enterprises. At the end of the course, students should acquire knowledge related to the basic concepts of information systems, their constitution and types and perceive the issues related to decision-making. Capacity for planning and monitoring the different alternatives for the construction of an information system. It is also developed the ability to proceed to the initial specification of an organization’s information system, the development of its entity-relationship model, the physical model, and the development of a support database.

Theoretical Component
1 – Introduction to Information Systems. 1.1 – The Information System concept. 1.2 – The dimensions of an Information System. 1.3 – A business perspective on Information Systems. 1.4 – A socio-technological approach to Information Systems.
2 – e-Business. 2.1 – Business Processes and Information Systems. 2.2 – Information Systems for different management groups. 2.3 – Information Systems to interconnect the enterprise. 2.4 – Other tools.
3 – Corporate Information Systems. 3.1 – ERP – Enterprise Resource Planning. 3.2 – SCM – Supply Chain Management. 3.3 – CRM – Customer Relationship Management.
4 – How to develop an Information System. 4.1 – Development of an Information System and organizational change. 4.2 – The main phases of the development process of an Information System. 4.3 – The main methodologies for the modelling and design of an Information System. 4.4 – Methods for the development of an Information System.

Tutorial Guidance
1. Introduction to modeling relational databases a.The. Relational Model b.Entity- Relationship Model c.Candidate keys d.Primary keys e.Foreign keys f.Standardization rules
2. SQL a.SQL basics b.Junction c.SQL functions d.Sorting and Grouping e. Subqueries f.Table Management g.Integrity Restrictions
3. Data Manipulation.

Assessment Methods

Theoretical Component (ten points)

Two term tests during the semester (replacing the normal-period exam):

• First term test: in the eighth week of the semester - 3.5 points.
• Second term test: in the second-to-last week of the semester - 6.5 points.

The term tests cover the content taught in the theoretical classes.

In each of the two term tests (theoretical component), a mark of 25% or higher must be obtained. A student who does not obtain a mark of 25% or higher in each of the term tests fails the normal-period assessment (but may take the resit exam or any other period regulated for this purpose in this academic year).

Or by exam (ten points) - in any of the various exam periods scheduled for this academic year for the course unit. The exams cover the content taught in the theoretical classes.

In any of the scheduled exams (theoretical component), a mark of 25% or higher must be obtained. A student who, in any exam taken, does not obtain a mark of 25% or higher in the theoretical component fails that exam.

Practical Component (ten points)

By continuous assessment:

• Two points - during the semester, in four classes selected by the instructor, students who are present in class may submit, at the end of the class, the set of exercises proposed by the instructor to be solved in that class.
• Eight points - practical test (closed book).

In each of the parts of the practical component, a mark of 25% or higher must be obtained. A student who does not obtain a mark of 25% or higher in each of the parts fails the normal-period assessment for the course unit (but may take the resit exam or any other period regulated for this purpose in this academic year).

By exam - assessment of the practical component in the resit exam, or in another extraordinary period regulated for this purpose in this academic year, is carried out through a written test. A student who does not obtain a mark of 25% or higher in this assessment of the practical component fails the exam.

Note: additional oral examinations, in both the theoretical and practical components, may be used as an additional assessment tool whenever deemed necessary to clarify doubts or address situations considered suspicious of fraud having occurred in the assessment process.

The final grade results from the sum of the mark obtained in the theoretical component (0 to 10 points) and the mark obtained in the practical component (0 to 10 points), with each component corresponding to 50% of the final grade. A student passes the course unit if they obtain a final grade equal to or higher than 9.5 points (on a 0-20 scale), provided the minimum requirements are met in each of the components.

Class Attendance

Attendance in theoretical classes is recorded for statistical purposes.

Attendance in practical classes is mandatory, and during the semester only three absences from practical classes are permitted. A student who exceeds this limit of absences from practical classes fails the course unit, without access to any of the assessment periods scheduled for this academic year for the course unit.

Conditions for Grade Improvement

Theoretical Component. The grade obtained through the term tests or the one obtained in the normal-period exam may be changed, through a written test, in the resit period (or another extraordinary period regulated for this purpose). A student who does not obtain a mark of 25% or higher in this assessment of the theoretical component fails the exam.

Practical Component. The grade obtained through continuous assessment may be changed, through a written test, in the resit period (or another extraordinary period regulated for this purpose). A student who does not obtain a mark of 25% or higher in this assessment of the practical component fails the exam.

NAO