Management Support Information Technologies and Systems

There are none.

No classes will occur in this curricular unit.

After attending this course, it is expected that each student knows how to

• Search, process and communicate information through new information and communication technologies;
• Efficiently use (create, edit, save and print files from) different IT tools autonomously;
• Solve different types of problems, namely data analysis and processing, on the computer;
• Use spreadsheets to automate calculations and procedures;
• Design a database in the relational model;
• Create and use a relational database in Access;
• Create an Access database keeping the integrity rules;
• Perform queries of different types in an Access database;
• Define the basic concepts of an Information System;
• Recognize the technologies used in Information Systems;
• List the potential of Information Systems;
• Assess the needs of a company in terms of Information System;
• Identify the role of information technologies in the information management of a company;
• Identify characteristics of specific types of information systems and their potential in organizational information management.

1. Text Processing (Word)
a. Editing, correction and formatting of texts
b. Page setup
c. Creating tables
d. Insertion of objects: images, graphics,…
e. Advanced functions: document printing, document template creation, task automation (automatic text correction, automatic title configuration and numbering, indexes)

2. Multimedia Presentation Utility (Powerpoint)
a. Inserting and editing the template document
b. Inserting and formatting text
c. Text, Drawing and Graphics Tools
d. Effects (transitions and animations)

3. Spreadsheet (Excel)
a. Cell editing
b. Cell formatting
c. Formulas and functions (mathematics, date and time, query and reference, text and information)
d. Lists and series
e. Charts

4. Database Management System (Access)
a. Database Models
b. Access Applications
– Database creation
– Construction of efficient tables and their relationships
– Creation of selection queries and action queries (deletion, insertion and update)
– Creation of Forms and Reports
c. Linking Access to other tools: linking to Word and Excel, importing / exporting data

5. Introduction to Information Systems
a. Data, information and knowledge
b. Information System Concept
c. Organizations and systems

6. Information Systems as Support to the Decision-Making Process
a. The needs of information systems and influences on the business process
b. Technologies associated with Information Systems

7. Some Types of Information Systems to Support Organizations
a. Database Management Systems
b. Electronic Data Exchange (EDE)
c. Enterprise Resource Planning (ERP)
d. Customer Relationship Management (CRM)

• - Test - 100.0%

• - (Contents 1 to 4) 4 works + 4 4 tests (4x20%) - 80.0%
• - (Remaining contents) 1 work - 20.0%

NAO

Alturas, B. (2013). Introdução aos sistemas de informação organizacionais (1ª edição). Edições Sílabo.

Carvalho, A. (2008). Programação com excel para economia & gestão. FCA.

Carvalho, A. (2012). Exercícios resolvidos com excel para economia & gestão. FCA.

Martins, A. (2020). Excel aplicado à gestão: Exemplos resolvidos. Sílabo.

McGrath, M. (2019). Access in easy steps. In easy steps limited.

Sousa, S. & Sousa, M. (2014). Microsoft office 2010 para todos nós. FCA.

Wilson, K. (2020). Using excel 2019: The step-by-step guide. Elluminet Press.

Wilson, K. (2020). Using word 2019: The step-by-step guide. Elluminet Press.