Discipline details

Course details

Recommended Prior Knowledge

-
Objectives

Learning objectives:
-Understand the importance of Spreadsheets for the organization.
-Understand the importance of databases in defining organizational strategies.
-Know and use the functionalities of Spreadsheets.
-Know and use the functionalities of Databases.
-Develop database management applications that include spreadsheet functionalities.
Teaching/learning methodology:
- Expository process -Active process with the aim of learning through individual exploration of specific software.
-Use of simulation to put the student at the center of the teaching/learning process.
-Real-world approaches to bring theoretical and practical teaching closer to the demands of the job market.
The theoretical component will use a combination of expository (concepts) and interrogative methods, while the practical component will use the participatory method and the resolution of exercises.
Teaching Methods

The methods to be used include: ?Expository processes Active processes with the aim of verifying: Learning by discovery through individual exploration of specific software; Learning through research underlying the realization of research tasks in a specific field. Use of simulation to put the student at the center of the teaching/learning process. Real-world approaches to bring theoretical and practical teaching closer to the demands of the job market. In the theoretical components, a combination of expository (concepts) and interrogative methods will be used. The practical components will use the participatory method and exercise solving.
Internship(s)

Não
Syllabus

0. CONTEXT Background Information Systems Information and Communication Technologies Sustainable Development Goals
1. SPREADSHEET Introduction Formulas Functions Charts Pivot Tables
2. DATABASES Data Files Data Access Methods Database Management Systems Database Models The Relational Model
3. DATA STRUCTURE Requirements analysis and specification Conceptual, logical and physical design Relational Database Management Systems Referential integrity
4. DATA MANIPULATION Creating tables Definition of data types Creating/defining keys Establishing relationships between tables Creating and using forms
5. DATA PRESENTATION Creating queries Defining search criteria Using operators Creating and formatting reports
6. INTEGRATIONS Creating and using macros Linking macros to command buttons Building presentation menus Integrating Excel into Access
Content Explanation

The course presents the potential of spreadsheets and databases to support the activities of human resources technicians. It is considered that the use of Spreadsheets and Databases can be of particular interest to enhance decision-making and the acquisition of competitive advantages by organizations. Considering the following as fundamental -Understand the importance of Information Systems and Information and Communication Technologies in an organizational context. -Knowing and using spreadsheets. -Knowing and using databases. -Know how to use software with spreadsheet and database management functions to improve organizational performance. In this way, providing systematized information and databases capable of storing the information needed for organizational decision-making is the challenge of IS/ICT contributing to the Sustainable Development Goals.
Methodology Explanation

Macro skills:: -Critical analysis skills; -Individual, interpersonal and group effectiveness; Problem-solving; -Creativity. Basic skills: -Understand the requirements underlying the use of spreadsheets in an organizational context; -Understand the information requirements for database management in an organizational context; -Define the relevant information to solve the problem; -Ability to develop database management applications to improve organizational performance. Professional skills: Ability to develop functionality within the scope of spreadsheets and applications, including usability concerns, to enable the use of databases in decision-making and the acquisition of competitive advantages.
Responsible Lecturer(s)

-
Bibliography

Essencial: •Martins, A. (2021). Excel Aplicado à Gestão, 5ª edição, Edições Sílabo, ISBN 978-989-561-042-6.
•Gouveia, F., (2021) Base de Dados - Fundamentos e Aplicações, 2ª edição, FCA – Editora de Informática. ISBN: 978-972-722-901-7.
•Reis, L. Cagica, L., Silveira, C., Russo, N., & Marques A. (2021). Inovação e Sustentabilidade em Tecnologias de Informação e Comunicação, Edições Silabo, ISBN 978-989-561-146-1.
•Date, C.J. (2020). An Introduction to Database Systems, 8th Edition, Addison Wesley Publishing Company.

Complementar: •Winston, W. (2019). Microsoft Excel 2019: Data Analysis and Business Modeling, 6th Edition, Pearson Education, USA., ISBN 978-150-930-588-9.
•Martins, A. & Alturas, B. (2023). Aprenda Excel com Casos Práticos, 2ª edição, Edições Sílabo, ISBN 978-989-561-236-9.
•Monk, E. Brady, J., & Mendelsohn, E. (2017). Problem-Solving Cases in Microsoft Access And Excel, 15th Edition, Course Technology, Cengage Learning, Boston, USA., ISBN 978-133-710-133-2.