Class IT for Human Resources Management

Today Information Systems play a fundamental role in Organizations. That is why it is fundamental that all have the knowledge to enable them to use the Systems in order to realize their full potential. The area of Business Sciences in general and Human Resources Management in particular, is one of those that most need to understand how Information Systems can be used not only for efficiency gains but also for the creation and maintenance of competitive advantages.

This UC intends to equip students with the skills that enable them to use Information Systems to their full potential, as well as to understand what types of systems should be used for each solution, and to be able to participate in their selection and management.

Great emphasis will be placed on the practical use of Office productivity tools, in particular in mastering spreadsheet capabilities.

1 - Introduction to IS / IT - Information Systems and Technologies

• General Concepts and IS evolution (PC, Spreadsheet; Networks / Internet)
• Information Systems and Technologies
• Information in organizations
• Integrated Management Systems
• The future of Information Systems (IoT, AI, Cloud Computing)

2 - Database Management Systems

• Database Design

3 - ERP - Enterprise Resource Planning

• ERP notions
• Logistics and Treasury, HR and Accounting
• HR management 

4 - Other Enterprise Systems

• SCM - Supply Chain Management
• CRM - Customer Relationship Management

5 - Word Processor

• Document Formatting: Styles, Images, Tables
• Document Automation: Indexes, Citations, and Bibliography
• Object insertion and document linking 

6 - Spreadsheet

• Introduction to Ms-Excel
• Relative and Absolute Addresses
• Formula and Function Manipulation
• Cell Formatting
• Using Lists, Sorting, and Aggregations 
• Handling several sheets
• Graphics Formatting
• PivotTables

Coordination with the teachers of other CUs (Statistics and HR Analytics) in order to use practical classes to solve their exercises, thus boosting students' awareness of the use of IT tools in applied contexts.
Creation of an ERP demo of a Human Resources Management environment.
Presentation of videos and games related to Organisational and Human Resources Information Systems .
Active methodology - students are encouraged to research on topics related to Organisational Information Systems / HRM and to prepare presentations to the class with the results of the research.

• Frye, Curtis - Microsoft Excel 2016 Passo a Passo. Edição em Português. Brasil. Bookman, 2016. ISBN 9788582603956.
• Kavanagh, Michael J., Johnson, Richard - Human Resource Information Systems. Fourth Edition (International Student Edition). SAGE Publications Inc; 2017. ISBN 978-1506386539.
• Sousa, Sérgio, Sousa, Maria José - Soluções Informáticas na Gestão de Recursos Humanos. Reimpressão: abril 2003. Lisboa. FCA. 1998. ISBN: 9789727223633