Subject: Informatics and Data Analysis

Scientific Area:

Scientific, Cultural, Social and Ethical Formation

Workload:

80 Hours

Number of ECTS:

7,5 ECTS

Language:

Portuguese

Overall objectives:

1 - Providing students with basic knowledge of exploratory data analysis, so that they may read or consult studies using statistics, prepare information and carry out studies in their future professional activities.
2 - Providing students with computer skills that will be useful to them in the elaboration of academic papers and in their future professional activities.
3 - Use a word processing application (Microsoft Word) to create various types of documents, change the presentation of existing documents and to use the application to produce web pages and as a tool for mailing.
4 - Create good public presentations using the Microsoft PowerPoint.
5 - Use a spreadsheet (Microsoft Excel) as a tool to calculate, to work with data and to create charts, providing the basis for moving to advanced use.
6 - Create databases using Access and to be able to manipulate data in tables, queries and forms, allowing to work effectively with data.

Syllabus:

1 - Computers and data analysis. Measures of location, of spread and shape. Graphical representation for univariate and for bivariate data.
2 - Text formatting. Creating Tables. Inserting numbered lists and brands. Inserting pictures into documents. Associating hyperlinks. Defining and using styles. Table of contents. Creating documents to be used in Web pages.
3 - Structure of a presentation. Browsing a presentation. Placing objects, text boxes, tables and charts. Inserting SmartArt and diagrams, clip art, images and photo album. Inserting video and áudio. Creating Links. Creating a PowerPoint Show file (*.ppsx). Publishing on the Web. Creating manual notes for the presenter.
4 - Structure of a worksheet. Using functions. Using relative references, absolute, and mixed. Managing multiple sheets. Adding and Formating Graphics. Data Processing. Dynamic reports (Pivot Tables).
5 - Understanding databases. Structure of an Access database and its objects.

Literature/Sources:

Aczel, A. D. , 1995 , Statistics - Concepts and Applications , Irwin
Anderson, D.R., Sweeney, D.J., Williams, T.A. , 2002 , Estatística Aplicada à Administração e à Economia , Pioneira: Thomson Learning
Bernardo, M.R., Negas, M.C., Isaías, P. , 2013 , Excel Aplicado , FCA
Carvalho, M.A. , 2007 , Exercícios Resolvidos com Excel para Economia & Gestão - 4.ª Edição Atualizada e Aumentada , FCA
Hoaglin, D., Mosteller, F., Tukey, J. , 1992 , Análise Exploratória de Dados, Técnicas Robustas , Edições Salamandra
Lambert, J., Frye, C. , 2015 , Microsoft Office 2016 Step by Step , Microsoft Press, US
Marques, C.P., Costa, N. , 2013 , Fundamental do Word 2013 , FCA
Levie, R. , 2008 , Advanced Excel for Scientific Data Analysis , Oxford University Press
Marques, C.P., Costa, N. , 2013 , Fundamental do Excel 2013 , FCA
Silvestre, A. , 2007 , Análise de Dados e Estatística Descritiva , Escolar Editora
Morgan, G.A., Leech, N.L., Gloeckner, G.W., Barrett, K.C. , 2011 , IBM SPSS for Introductory Statistics - Use and Interpretation , Routledge
Moroney, M.J. , 1990 , Facts from Figures , FCA
Murteira, B. J. F. , 1999 , Estatística Descritiva, Análise Exploratória de Dados , McGraw-Hill
Pereira, A. , 2006 , SPSS - Guia Prático de Utilização , Edições Sílabo
Neves, J. , 2010 , Fundamental do Access 2010 , FCA
Pestana, D.D., Velosa, S.F. , 2010 , Introdução à Probabilidade e à Estatística , Fundação Calouste Gulbenkian
Sousa, M.J., Carocinho, N. , 2010 , Fundamental do PowerPoint 2010 , FCA
Triola, M.F., Franklin, L.A. , 1995 , Business Statistics , Addison-Wesley Publishing Company
Zar, J.H. , 1999 , Biostatistical Analysis , Prentice Hall International
Murteira, B. J. F. et al. , 2002 , Introdução à Estatística , McGraw-Hill

Assesssment methods and criteria:

Classification Type: Quantitativa (0-20)

Evaluation Methodology:
Classes will include some theoretical stages, where an introduction or revising of the various contents will be done. A more practical approach will be chosen in which students will have to use the computer to solve the exercises / problems proposed. There will be two practical evaluations: a test of exploratory data analysis with SPSS, which will have a 50% weight in the final assessment, and one practical test about Word, PowerPoint, Excel and Access, which will have50 % weight in the final assessment of the course.