Management Information Systems

This Course Unit (UC) does not require previous knowledge

Classes will be taught in a theoretical-practical format, in computer rooms.

An interactive expository methodology will be used in the presentation of some fundamental tools and concepts, supported by practical experimentation based on problem solving.
The problem-based learning component will seek to approximate, whenever possible, learning in the classroom to situations experienced in professional practice. Additionally, a collaborative learning strategy (i.e., peer interaction) will be maintained throughout the semester, which will seek to help the presentation of themes of greater complexity and involvement.

In addition to the classes, students are motivated to develop complementary learning, through the resolution of challenges launched throughout the semester.

This curricular unit aims to provide students with instrumental and conceptual skills in the field of spreadsheets that are particularly useful in the context of other curricular units, as well as in the subsequent effective and efficient exercise of their professional activity.
As main objectives in this curricular unit, it is intended that students have:

O1 – a basic understanding of management information technologies and systems, GIS;
O2 – an adequate understanding of the role of GIS in organizations;
O3 – perception of the importance of data processing, in the creation of reports and in the presentation of conclusions.

At the end of the course, students should have developed skills and competences, namely:

C1 – problem solving using spreadsheet applications;
C2 – using advanced features of the spreadsheet;
C3 – data handling and problem solving.

1. Introduction to Information Systems

2. Microsoft Excel spreadsheet
2.1. Familiarization with the work environment
2.2. Basic features
2.3. Some customization elements of the work context

3. The Spreadsheet – Tools for Quantifying and Exploring Data
2.2.1. Introduction to formulas and functions
2.2.2. Math functions
2.2.3. Statistics functions
2.2.4. Using the Analysis Toolpak

4. Excel in Data Analysis and Query and in the Creation of New Information
4.1. Search and reference functions
4.2. logical functions
4.3. Text and information functions
4.4. date and time functions
4.5. financial functions

5. Data visualization and illustration
5.1. Chart selection and data format
5.2. Creating and formatting graphics
5.3. Customization and final presentation

6. Data Structure and Organization – Data Tables
6.1. Sorting of data tables
6.2. Data selection using Data Filters
6.3. Subtotal Evaluation

NAO

Main Bibliography

[1] Luís Silva Rodrigues. Utilização do Excel para Economia & Gestão. FCA – Editora de Informática, 2016. ISBN 978-972-722-775-4.

[2] Maria do Rosário, Matos Bernardo, Pedro Isaías e Mário Carrilho Negas. Excel Aplicado. FCA – Editora Informática, 2013. ISBN 978-972-722-755-6.

[3] Maria Adelaide Carvalho. Exercícios resolvidos com Excel para a Economia e Gestão, 4.ª Edição Atualizada e Aumentada. FCA – Editora Informática, 2012. ISBN 978-972-722-729-7.

[4] Paula Peres. Excel Avançado. Edições. Silabo, 2011. ISBN: 978-972-618-640-3.

Complementary Bibliography

[5] Michael Alexander, Richard Kusleika, John Walkenbach. Microsoft Excel 2019 Bible: The Comprehensive Tutorial Resource. Wiley; 1st edition (October 23, 2018). ISBN 978-1119514787.

[6] Mike Smart. Learn Excel 2016 Expert Skills with The Smart Method: Courseware Tutorial teaching Advanced Techniques. The Smart Method Ltd; 1st edition (March 3, 2016). ISBN 978-1909253094.

[7] Katherine T. Smith, L. Murphy Smith and Lawrence C. Smith. Microsoft Excel for Accounting: The First Course”, Prentice Hall. Prentice Hall; 1st edition (July 15, 2002). ISBN 978-0130085511.

[8] Katherine T. Smith, L. Murphy Smith and Lawrence C. Smith. Microsoft Excel for Accounting: Auditing and Accounting Information Systems. Prentice Hall; 1st edition (August 1, 2002) ISBN 978-0130085528