Subject: Informatics and Data Analysis
Scientific Area:
Mathematics
Workload:
80 Hours
Number of ECTS:
6 ECTS
Language:
Portuguese
Overall objectives:
1 - To provide students with basic knowledge of exploratory data analysis, enabling them to read or consult studies that use statistics, prepare information or conduct studies in their future professional activity.
2 - To provide students with computer skills that will be useful in carrying out academic work and in their future professional activities.
3 - To apply a statistical software (e.g., SPSS, Stata, R, Python libraries) for performing descriptive statistical analysis, data manipulation, and graphical visualizations.
4 - To utilize a spreadsheet software (e.g., Microsoft Excel, Apple Numbers) for data entry, basic calculations, and preliminary data analysis.
5 - To utilize a word processing software (e.g., Microsoft Word, Apple Pages, LaTeX) for creating and editing scientific report texts.
6 - To design slides for presenting technical and scientific content using a presentation software (e.g., Microsoft PowerPoint, Keynote, LaTeX).
Syllabus:
1 - Descriptive Statistics with Statistical Software.
1.1 - Introduction to Descriptive Statistics.
1.2 - Introduction to a Statistical Software (e.g SPSS, Stata, R, Python libraries).
1.3 - Frequency Distributions. Data Exploration and Summarization. Basic Data Visualization.
2 - Data Management and Analysis with Spreadsheet Software.
2.1 - Introduction to a Spreadsheet Software (e.g., Microsoft Excel, Apple Numbers).
2.2 - Cell Formating and Manipulation.
2.3 - Formulas and Functions.
2.4 - Relative, Absolute, and Mixed References.
2.5 - Tables and Graphs.
3 - Scientific Report Writing with Word Processing Software.
3.1 - Introduction to a Word Processing Software (e.g., Microsoft Word, Apple Pages, LaTeX).
3.2 - Text Formatting.
3.3 - Entering Data, Tables, Graphics, and Equations.
3.4 - Indexes, Citations, and References.
4 - Presenting Scientific Findings with Presentation Software.
4.1 - Introduction to a Presentation Software (e.g., Microsoft PowerPoint, Keynote, Beamer).
4.2 - Designing Slides for Technical Content.
4.3 - Entering Tables, Graphics, and Equations.
Literature/Sources:
A. M. Abreu , 2022 , R. Um Mundo por Descobrir , Lisbon International Press
A. Afonso, C. Nunes , 2011 , Estatística e Probabilidades - Aplicações e Soluções em SPSS , Escolar Editora
P. Bruce, A. Bruce, P. Gedeck , 2020 , Practical Statistics for Data Scientists: 50+ Essential Concepts Using R and Python , O'Reilly
P. Dalgaard , 2008 , Introductory Statistics with R , Springer
L. C. Hamilton , 2009 , Statistics with Stata , Cengage Learning
S. Kottwitz , 2021 , LaTeX Beginner's Guide , Packt Publishing
J. Lambert , 2023 , Microsoft Office Step By Step (Office 2021 And Microsoft 365) , Pearson Education (US)
J. Lambert , 2023 , Word Step By Step (Office 2021 And Microsoft 365) , Pearson Education (US)
J. Marôco , 2014 , Análise Estatística com o SPSS Statistics , Report Number
M. Mendes, J. A. Almeida , 2005 , Preparação de Textos Científicos Usando LaTeX , Edições Sílabo
L. S. Rodrigues , 2011 , Utilização do Excel 2010 para a Economia & Gestão , FCA- Editora de Informática
A. C. Pedrosa, S. M. A. Gama , 2016 , Introdução Computacional à Probabilidade e Estatística com Excel , Porto Editora
M. Pereira, H. Piairo , 2012 , Introdução à Estatística - Em R e SPSS , Chiado Books
D. D. Pestana, S. F. Velosa , 2010 , Introdução à Probabilidade e à Estatística , Fundação Calouste Gulbenkian
M. H. Pestana, J. N. Gageiro , 2000 , Análise de Dados para Ciências Sociais: a Complementaridade do SPSS , Sílabo
C. R. Shabab, M. Barrow , 2024 , Statistics for Economics, Accounting and Business Studies , Pearson
M. D. Ugarte, A. F. Militino, A. T. Arnholt , 2016 , Probability and Statistics with R , CRC Press
Assesssment methods and criteria:
Classification Type: Quantitativa (0-20)
Evaluation Methodology:
Teaching Methodologies: Classes includes lectures to introduce fundamental statistical concepts and the software tools to be used, followed by hands-on lab sessions where students solve the proposed exercises/problems. Assessment Methodologies : The assessment is made by means of one of the two following sets of evaluation elements (to be determined by the professor responsible for the course at the beginning of the semester): (i) Two practical tests, each weighing 50%; (ii) One practical test and two assignments. The practical test (50%) is on Descriptive Statistics using statistical and spreadsheet software, and the assignments (50%) involve the use of spreadsheet, word processing, and presentation software.