ISLA IPGT 27872

Computer Applications for Management

• ApresentaçãoPresentation

  Scope: The course focuses on the use of computer-based tools for data analysis and processing to support management. It centres on Microsoft Excel spreadsheets and the Microsoft Power BI business intelligence platform, including their integrated artificial intelligence features.   Area of Application: These skills are applied to transforming organisational data into useful information for decision-making. Specifically, they include data collection, organisation and transformation; calculation of indicators; development of interactive reports and dashboards; and visual communication of results.   Areas of Intervention: In the context of HR management, the course prepares students to manage employee databases; process and analyse remuneration and benefits; calculate and monitor HR indicators (absenteeism, staff turnover, headcount, personnel costs, training and performance); prepare management reports; and develop dashboards to support decision-making.
• ProgramaProgramme

  Syllabus Content Spreadsheets - Introduction Selecting, entering, editing and working with cells Spreadsheets and basic operators Formatting, formulas and functions Mathematical functions Logical functions Lookup and reference functions Outputs - spreadsheet setup and printing Spreadsheets - Advanced Using PivotTables and PivotCharts Using slicers, grouping and timelines Creating dashboards Power BI Brief introduction to Power BI Data import and transformation Data modelling DAX language Data visualisation Power BI Service
• ObjectivosObjectives

  By the end of this module, students should have achieved the following learning outcomes: LO1.: To be proficient in the most commonly used statistical procedures, tables, techniques and machine learning systems, utilising not only the most basic functions but also the AI features available in Excel, as well as other AI systems external to the programme LO2.: Carry out data analysis, adding value to the information used in business decision-making. LO3.: Identify underlying patterns and extract useful information from the large volume of heterogeneous data found within organisations; LO4.: Extract relevant information and produce reports and dashboards to support informed decision-making, using pivot tables in Excel and Power BI.
• BibliografiaBibliography

  Newman, J. (2021) The Microsoft Office 365 Handbook - Everything You Need To Know About Microsoft Office 365 Jelen, B. (2019). Microsoft Excel 2019 Inside Out. Microsoft Press. Frye, C. (2018). Microsoft Excel Functions & Formulas (Wordware Applications Library). Jones & Bartlett Learning. Russo, A., Ferrari, M., & Webb, A. (2018). Analyzing Data with Power BI and Power Pivot for Excel. Microsoft Press. Schreiber, M., & Alexander, M. (2019). Office 365 for IT Pros (2020 Edition): The comprehensive guide to Microsoft's Cloud Office System. Practical 365. Ferrari, M., Russo, A., & Webb, A. (2019). The Definitive Guide to DAX: Business Intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel. Microsoft Press. Ferrari, M., Russo, A., & Webb, A. (2020). Analyzing Data with Power BI and Power Pivot for Excel (2019 Edition). Microsoft Press.  
• MetodologiaMethodology

  The group project follows a project-based learning approach: throughout the semester, students develop a data analysis project applied to human resources management, culminating in a final dashboard in Excel and Power BI. Classes use realistic and anonymised HR datasets (e.g. absenteeism, staff turnover, remuneration and training), helping students connect the tools with real-world professional challenges.   A flipped classroom approach is used selectively: introductory materials (videos and guides) are made available on Moodle before the class, while face-to-face sessions focus on practical exercises and problem-solving. Students explore the AI features integrated into Excel and Power BI critically, always verifying the results obtained. Continuous formative feedback is also provided on the exercises and on intermediate versions of the group project.
• LínguaLanguage

  Português
• TipoType

  Semestral
• ECTS

  6
• NaturezaNature

  Mandatory
• EstágioInternship

  Não
• AvaliaçãoEvaluation

  Avaliação contínua:
  1. Trabalhos de grupo (50%)
  2. Teste final prático com exercícios de Excel e Power BI (50%)
  
  Avaliação por exame:
  Os alunos que reprovarem na avaliacao continua possuem duas epocas de exame (normal e de recurso).
  Qualquer que seja a epoca de avaliacao, considera-se que o aluno obteve aprovacao a UC se tiver nota final superior
  ou igual a 9,5 valores.