Information Technologies

Prerequisites:
Although there is no defined precedence, the student should have basic knowledge of using spreadsheet tools, as well as interpretation ability and structured thinking in problem-solving.

Teaching and learning activities:
Classes will be taught using computers and digital tools in a theoretical-practical regime. A dynamic teaching and learning process will be used, with support for digital tools and based on the “Scrum” and “Flipped Classroom” methodologies (type of “Blended learning”). Student-centered teaching and learning, provision of teaching materials in advance, development of activities and classes almost entirely aimed at applying concepts, with fundamentally interactive dynamics.

Aims
Introduction to Information and Technologies Systems to support management, in the agricultural context.
Introduction to approaches and practices of advanced data analysis and decision support.
Introduction to decision support tools, using spreadsheets.

Learning Outcomes
Instrumental and conceptual capabilities in the field of information systems and technologies to support management.
Knowledge acquisition about the current and the major information technologies, as well as their application.
Critical analysis capabilities on information systems and technologies to support management in the agricultural context.
Strengthen the skills in the use of spreadsheets, as a decision support tool.
Consolidation of knowledge and practices in the area of advanced data analysis.

Syllabus:
1. Introduction to Information Systems and Technologies
2. Information Systems and Organizations
3. Information Systems in Agriculture
4. The Microsoft Excel Spreadsheet as a decision support tool
4.1. Databases
4.2. Dynamic tables and charts
4.3. Dashboards and Scorecards
5. The concept Data Warehouse
5.1. Multidimensional modeling
5.2. Implementation of a DW
6. Excel PowerPivot

NAO

1. Francisco Esteves e Pedro Anunciação (2021) “Sistemas de Informação – Paradigma e soluções para a gestão”, Plátano Editora (ebook)
2. Robert Bosco (2013) “PowerPivot for Advanced Reporting and Dashboards”, Packt Publishing
3. Dora Melo (2024) Documentos Teóricos e Práticos de Apoio às Aulas, Politécnico de Coimbra, Coimbra Business School | ISCAC
4. Yanai López (2013) “Sistemas de Informação para Gestão”, Escolar Editora
5. Sérgio Sousa (2010) “Tecnologias de Informação – O que são? Para que servem?” – 6ª Ed., FCA Editora de Informática
6. Maribel Yasmina Santos & Isabel Ramos (2010) “Business Intelligence – Tecnologias da Informação na Gestão de Conhecimento”, 2.ª Edição Atualizada e Aumentada, FCA Editora de Informática
7. Ron Person (2014) “Balanced Scorecards and Operational Dashboards with Microsoft Excel”, 2nd Ed., John Wiley & Sons, Inc.
8. Michael Alexander & John Walkenbach (2013) “Microsoft Excel Dashboards and Reports”, 1st Ed., John Wiley & Sons, Inc.