Information Management

Recommended Prerequisites

Basic knowledge of Microsoft Excel.

Teaching Methods

Classes will comprise an oral presentation of the conceptual framework from the teacher, after which students will carry out computational exercises using the selected applications (Excel and Access) and develop a group project under teacher supervision. 

Learning Outcomes

By the end of the term, students, should be able to:

- Differentiate between data and information

- Identify and characterize the main types of organizational information systems

- Understand the concept of Business Intelligence, as well as the main steps and components of a Business Intelligence process/system

- Distinguish between transactional processing and analytical processing, and their different implications

- Understand and be able to apply the Relational Model basic principles

- Recognize the potential of  Microsoft Excel e Microsoft Access as data management and information production tools (self-service Business Intelligence)

- Plan and implement a simple management information system (Business Intelligence) using the select tools.

Work Placement(s)

No

Syllabus

1. Conceptual framework

 1.1. Data and Information

 1.2.  Main Enterprise Information System types

 1.3. Business Intelligence

2. Transactional processing  versus Analytical processing

3. Relational Model fundamentals

4. Microsoft Excel versus Microsoft Access: specificities and complementarities

 4.1. Importing and preparing data

 4.2. Data processing

 4.3. Visualization and reporting

5. Practical project development.

Head Lecturer(s)

Víctor Manuel dos Reis Raposo

Assessment Methods

Assessment
Mini Tests: 25.0%
Project: 75.0%

Bibliography

Information technology for management: transforming organizations in the digital economy. Efraim Turban [et al.]. 6th ed.. John Wiley & Sons, 2008. [BP 330.341 INF].

 

Excel 2013 bible. John Walkenbach, John Wiley & Sons, 2013. [BP 519.6 WAL]

 

Access 2013 bible. Michael Alexander and Dick Kusleika, John Wiley & Sons, 2013. [BP 519.6 ALE].