Introduction to data analysis in Excel
Keywords |
Classification |
Keyword |
CNAEF |
Engineering and related techniques |
Instance: 2024/2025 - 1S (of 07-10-2024 to 09-01-2025)
Cycles of Study/Courses
Acronym |
No. of Students |
Study Plan |
Curricular Years |
Credits UCN |
Credits ECTS |
Contact hours |
Total Time |
CTIADE |
1 |
Syllabus |
1 |
- |
1,5 |
12 |
40,5 |
L.AERO |
0 |
Syllabus |
3 |
- |
1,5 |
12 |
40,5 |
L.BIO |
18 |
Syllabus |
3 |
- |
1,5 |
12 |
40,5 |
L.EA |
9 |
Syllabus |
2 |
- |
1,5 |
12 |
40,5 |
L.EC |
62 |
Syllabus |
2 |
- |
1,5 |
12 |
40,5 |
L.EEC |
214 |
Syllabus |
2 |
- |
1,5 |
12 |
40,5 |
L.EGI |
11 |
Syllabus |
2 |
- |
1,5 |
12 |
40,5 |
L.EIC |
171 |
Syllabus |
2 |
- |
1,5 |
12 |
40,5 |
3 |
L.EM |
45 |
Syllabus |
3 |
- |
1,5 |
12 |
40,5 |
L.EMAT |
3 |
Syllabus |
3 |
- |
1,5 |
12 |
40,5 |
L.EMG |
6 |
Plano de estudos oficial a partir de 2008/09 |
2 |
- |
1,5 |
12 |
40,5 |
3 |
Teaching Staff - Responsibilities
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.