Cursos / 1º Ciclo / / Faculty of Economy and Business Management :: Business Management
SISTEMAS DE INFORMAÇÃO EM GESTÃO - 2018/2019
2º curricular year
Semestralidade: 1st semester
ECTS: 6
Teachers
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
Teaching Language
Portuguese
Main Aims/Objectives
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.
Specific Aims/Objectives
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.
Teaching Procedures
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.
Programme
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 Type
Evaluation is based on continuous assessment, including attendance, participation, tests (2), as well as final exam.
Teaching Resources
Video projector for presenting applications, fundamental concepts and examples. Students should solve exercises using classroom computers.
Sustainability Objectives
Keywords
Spreadsheets Models
Relational Databases
Information Systems
Main Bibliography
Author | Ken Laudon, Jane P. Laudon |
---|---|
Title | Management information systems |
Edition | 13 |
Editor | Pearson Prentice Hall |
Year | 2014 |
Author | Sérgio Sousa |
Title | Domine a 110% Access 2010 |
Place | Lisboa |
Editor | FCA |
Year | 2010 |
Author | Maria José Sousa |
Title | Domine a 110% Excel 2010 |
Place | Lisboa |
Editor | FCA |
Year | 2010 |
Complementary Bibliography
Author | Adelaide Carvalho |
---|---|
Title | Exercícios Resolvidos Excel para Economia & Gestão |
Author | Paul Beynon-Davies |
Title | Information systems |