Introduction to data analysis in Excel

Code:

IADE01

Acronym:

IADE

Keywords
Classification	Keyword
CNAEF	Engineering and related techniques

Instance: 2022/2023 - 2S (of 08-03-2023 to 31-07-2023)

Active?	Yes
Responsible unit:	Department of Industrial Engineering and Management
Course/CS Responsible:	Introduction to data analysis in Excel

Cycles of Study/Courses

Acronym	No. of Students	Study Plan	Curricular Years	Credits UCN	Credits ECTS	Contact hours	Total Time
CTIADE	6	Syllabus	1	-	1,5	12	40,5
L.BIO	14	Syllabus	2	-	1,5	12	40,5
L.EA	50	Syllabus	1	-	1,5	12	40,5
L.EC	236	Syllabus	1	-	1,5	12	40,5
L.EEC	60	Syllabus	2	-	1,5	12	40,5
L.EGI	120	Syllabus	1	-	1,5	12	40,5
L.EM	59	Syllabus	2	-	1,5	12	40,5
L.EMAT	49	Syllabus	1	-	1,5	12	40,5
L.EMG	0	Plano de estudos oficial a partir de 2008/09	2	-	1,5	12	40,5
L.EQ	10	Syllabus	2	-	1,5	12	40,5

Teaching language

Portuguese

Objectives

In this training in transversal skills, students are expected to acquire skills in the use of Spreadsheets, in particular MS Excel, for solving management problems and analyzing large volumes of data, namely using data series available in Pordata, INE and others.

Learning outcomes and competences

It is intended that students achieve the following goals:
● Use of Spreadsheets.
● Understanding the essential concepts of data analysis and management.
● Solving problems involving a large volume of data, namely using data series available at Pordata, INE and others.

Working method

B-learning

Program

In this transversal skills training, students are expected to acquire transversal skills in the use of Spreadsheets, in particular MS Excel, for solving management problems and data analysis. The program, structured into five sequential modules, provides for the approach of the following topics:

● Use of spreadsheets (MS-Excel).

● Types of information (numeric values, formulas and text).

● Relative and absolute references.

● Definition and use of functions.

● Creation of graphics. Conditional Formatting.

● Filters.

● Pivot tables.

Mandatory literature

Site oficial do Excel da Microsoft; Site oficial do Excel da Microsoft
Adelaide Carvalho, FCA; Exercícios Resolvidos Excel para Economia & Gestão

Teaching methods and learning activities

This training was developed to work in the distance learning modality, so it will essentially work in asynchronous self-learning mode with consultation of videos and documents on different topics, as well as access to bibliographical references and various links, exercises and online quizzes. The interaction between professors/students will be ensured daily through forums.

Evaluation Type

Distributed evaluation with final exam

Assessment Components

Designation	Weight (%)
Teste	100,00
Total:	100,00

Amount of time allocated to each course unit

Designation	Time (hours)
Estudo autónomo	28,50
Trabalho escrito	12,00
Total:	40,50

Eligibility for exams

rating greater than 85% on the transition test

Calculation formula of final grade

• Assessment methods will be based on two components:




• a distributed component, in the form of answers to questions (quizzes) in moodle; students will be admitted to phases “n+1”, if they have obtained a grade higher than 85% in the transition test “n -> n+1”.


• One component of the final exam, in person, lasting 1 hour in a computer room at FEUP.




• Formula for calculating final grade = 100% exam

Special assessment (TE, DA, ...)

Obtaining approval for this CT in a special season exam requires approval in the following two components:

- Distributed component (if not performed during the semester), which may be replaced by the completion of the "Final Quiz" in Moodle (with the respective approval) in the 15 days prior to the exam date;

- Final exam component, to be carried out through a in class test, lasting 1:30h in a computer room at FEUP. Only those who have previously passed the distributed component of the CT have access to the final exam.