Treatment and representation of qualitative information - Intermediate II

Code:

TRIII01

Acronym:

TRII2

Keywords
Classification	Keyword
CNAEF	Humanities

Instance: 2024/2025 - SP (of 28-03-2025 to 28-03-2025)

Active?	Yes
Responsible unit:	Department of Geography
Course/CS Responsible:	PRR - Treatment and representation of qualitative information- Intermediate II

Cycles of Study/Courses

Acronym	No. of Students	Study Plan	Curricular Years	Credits UCN	Credits ECTS	Contact hours	Total Time
PRRTRII2	12	study plan	1	-	1	7	27

Teaching language

Portuguese

Objectives

1. Deepen knowledge:
  a. Understand the different types of graphics and learn how to create 2D and 3D graphics.
  b. Use recommended charts and new chart functionalities, including Sparkline charts.

2. Develop competences:
   a. Apply conditional formatting to highlight important data.
  b. Using filters to manage and analyse data.

3. Apply knowledge:
  a. Customise spreadsheets to improve data presentation and analysis.
  b. Create effective graphics for data visualisation.

Learning outcomes and competences

At the end of this course, participants should be able to:
- Demonstrate proficiency in creating any spreadsheet;
- Create, format, and interpret a chart;
- Produce and format customized reports.

Working method

Presencial

Program

1. Charts:
- Types of charts, creation of 2D and 3D charts;
- Recommended charts;
- Formatting;
- New chart features and types;
- Sparkline charts.

2. Spreadsheet Customization:
- Conditional formatting;
- Filters.

Mandatory literature

Alexander, A., Kusleika, R., and Walkenbach, J.; Excel 2019 Bible - The Comprhensive Tutorial Resource, Indiana: John Wiley & Sons, Inc, 2019
Martins, A., and Alturas, B. ; Aprenda Excel com Casos Práticos, 1ª edição, Lisboa: edições Sílabo, 2022
Martins, António ; Excel Aplicado à Gestão, 4ª Edição, Lisboa: Edições Sílabo, 2017
Curto, J., Dias, D. and Vieira, D. ; Excel para Economia e Gestão, 4ª Edição, Lisboa: Edições Sílabo, 2023
Peres, P.; Excel Avançado. 3ª edição, Lisboa: Edições Sílabo, 2011

Teaching methods and learning activities

The training methodologies are as follows: expository, interrogative, and active. The entire training process will have a project-based learning (PBL) approach.
Given the practical and participatory nature of the training, assessment is continuous and includes exercises to apply knowledge in autonomous work.

Evaluation Type

Distributed evaluation without final exam

Assessment Components

Designation	Weight (%)
Participação presencial	20,00
Trabalho prático ou de projeto	80,00
Total:	100,00

Amount of time allocated to each course unit

Designation	Time (hours)
Estudo autónomo	20,00
Frequência das aulas	7,00
Total:	27,00

Eligibility for exams

75% attendance.

Calculation formula of final grade

The formula for calculating the final grade is as follows:
Final grade = (0.80*Practical Work) + (0.2*Participation in classroom sessions).

Observations

Programa de Formação Multidisciplinar da U.Porto - Impulso Jovens STEAM e Impulso Adultos - cofinanciado pelos fundos do programa «Next Generation EU» do Plano de Recuperação e Resiliência (PRR)