Cursos / 1º Ciclo / Faculty of Economy and Business Management :: Economics
SISTEMAS DE INFORMAÇÃO EM GESTÃO - 2018/2019
2º curricular year
Semestralidade: 1st semester
Leading Teacher: Mestre Jorge Almeida
Assistant Professor: Mestre Jorge Almeida
Class type and School hours
Orientação Tutorial : 1 Horas
Teórico-prática : 2 Horas
This Course unit aims to provide students with Information Technology skills in particular in solving problems in the area of economics and management using spreadsheets, Information Systems models and relational databases. This Course unit aims also to provide students with an understanding of the role of Information Systems in organizations.
It is intended that students achieve the following objectives:
Be able to solve problems in the area of economics and management with spreadsheets.
Acquire skills in conceptual modeling of Information Systems.
Know how to create, implement and use relational databases.
Learn how to use information and communication technology (ICT).
Understand the role of Information Systems (IS) in organizations.
Skills to be acquired
Solve management problems with spreadsheets.
Develop conceptual models of Information Systems.
Create, implement and use relational databases.
Know the role of Information Systems (IS) in organizations.
Classes are theoretical and practical. All the classrooms are equipped with computers where keynotes and computer applications are presented. Students can individually, on their computers, follow the presentations and solve the proposed exercises.
Use of spreadsheets (MS Excel). Conditional Formatting. Filters. PivotTables. Building models to solve problems in the area of economics. Designing models of Information Systems.
The relational model. Concepts of normalization and primary key. Foreign keys and referential integrity. Construction of class models in UML.
MS-Access. Tables, forms, queries and reports.
Evolution of IT / IS in organizations.
The role and importance of the IS. Transaction Processing Systems (TPS), Management Information Systems (MIS), Decision-Support Systems (DSS) and Executive Support Systems (ESS). Information Architecture. Planning Information Systems. ERP - Enterprise Resource Planning, CRM - Customer Relationship Management, SCM - Supply Chain Management. Data processing, data analysis and reporting (OLAP, Data Warehouses, Datamining). Business Intelligence. Knowledge management. Business and electronic commerce.
Evaluation is based on continuous assessment, including attendance, participation, tests (2), as well as final exam.
Video projector for presenting applications, fundamental concepts and examples. Students should solve exercises using classroom computers.
|Author||Ken Laudon, Jane P. Laudon|
|Title||Management information systems|
|Editor||Pearson Prentice Hall|
|Title||Domine a 110% Access 2010|
|Author||Maria José Sousa|
|Title||Domine a 110% Excel 2010|
|Title||Exercícios Resolvidos Excel para Economia & Gestão|