ISLA IPGT 27872

Computer Applications for Management

• ApresentaçãoPresentation

  The Management IT Applications course develops skills in using spreadsheets and Power BI to organise, process, analyse and visualise data to support management and decision-making. It covers cell editing and formatting, operators, formulas, mathematical and logical functions, lookup and reference functions, and worksheet setup and printing. Advanced topics include pivot tables and charts, slicers, data grouping, timelines and dashboards. The Power BI component covers data import and transformation, data modelling, DAX, visualisation and the use of Power BI Service. These topics support the development of practical solutions for analysing and presenting management information.
• 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. Trabalho individual / grupo (40%)
  2. Teste final prático com exercícios de Excel e Power BI (60%)
  
  Avaliação por exame:
  Os alunos que reprovarem na avaliação continuam a ter duas épocas de exame (normal e de recurso).
  Qualquer que seja a época de avaliação, considera-se que o aluno obteve aprovação na UC se tiver nota final superior ou igual a 9,5 valores.