Base Knowledge
The student acquires knowledge to perform statistical analysis, build tables / graphs and apply other techniques / tools of statistical inference within the scope of other curricular units.
Teaching Methodologies
In order to achieve the objectives of the UC and confer the competences provided to the student, the learning process is based on case studies, accompanied by a set of instructions and statistical / computer tools that lead the student to analyze each case and draw conclusions. ; in the execution of practical works of application of theoretical concepts; in the bibliographic research necessary to complement the information obtained in class.
Classes will be theoretical-practical. An expository methodology will be used to present the theoretical concepts that will be exemplified with concrete situations in reality. The exhibition will be made using “power point” presentations.
Microsoft Excel, Word and Power Point.
Learning Results
Develop the ability to use computer tools for word processing, data processing and calculation, image processing, preparation of multimedia presentations in Power Point. Develop the ability to use computer tools for word processing, data processing and calculation, image processing, preparation of Excel multimedia presentations. Develop skills in the field of statistics, providing students with an integrated view of descriptive statistics to be applied to situations in the agri–food context. Analyze and interpret the data obtained and present the results in order to summarize the information and facilitate decision making. Use the Excel spreadsheet for the descriptive statistical study of a data set and for the study of the association between two variables. Develop personal skills in terms of structuring logical thinking and reasoning.
Program
Introduction to computer science
Hardware and software. Operation systems. Examples of computer applications for common tasks. Collaborative work tools.
Copyright. Types of licenses. Computer security. Ergonomics.
Data organization in a frequency table and its graphical representation. Use of Microsoft Excel to obtain frequency tables. Pivot tables. Formula programming.
Graphical representation of data. Use of Microsoft Excel in graphs creation.
Location measures, non-central trend measures, dispersion measures and asymmetry and flattening measures. Use of Microsoft Excel to obtain descriptive statistics.
Notions and applications of a presentation manager. PowerPoint.
Word processing. Using Microsoft Word.
Image treatment and editing.
Spreadsheet: functions and procedures; data treatment: basic notions of descriptive statistics; central tendency and dispersion measures. Graphic representation.
Simple linear regression model. Dispersion diagram. Pearson’s correlation coefficient and determination coefficient. Minimums squares method. Use of Microsoft Excel in the construction of the regression line.
Publication and presence on the Internet.
Curricular Unit Teachers
Internship(s)
NAO
Bibliography
Sousa, MJ (2011). Domine a 110% – Excel 2010. FCA – Editora Informática (9789727227068) ECDL Foundation (2006). Módulos AM3, AM4, AM6, The European Computer Driving Licence Foundation Ltd. (disponível em http://www.ecdl.pt/PT/CERTECDL/CERTIECDL/Pages/CertificacoesECDL.aspx 2013 09 13)
Jesus, C (2011). Exercícios de Word 2010 & 2007. FCA – Editora Informática (9789727226726) Amaral, P (2006). O essencial sobre…O Computador. Porto Editora (9789720451224) Vaz, I (2012). Word 2010: Domine a 110%. FCA – Editora de Informática (9789727227181)
Harvey, G (2011). Excel 2010 Para Totós. Porto Editora (9789720452368) Marques, PC (2011). Exercícios de Powerpoint 2010 & 2007. FCA – Editora Informática (9789727227167)
Janert, PK (2010). Gnuplot in action: understanding data with graphs, Manning. Oakland, JS (2003). Statistical Process Control, 5th ed., Butterworth Heinemann
Pinto, Mário Paulo; 2011. Microsoft Word 2010. Edições Centro Atlântico (9789896151102)
Marques, PC (2011). Exercícios de Excel 2010. FCA – Editora Informática (9789727226788) Microsoft (2013). Formação do Office. Microsoft Corporation (disponível em http://office.microsoft.com/pt-pt/support/formacao-FX010056500.aspx em 2013.09.12).
ECDL Foundation (2006). Módulos AM3, AM4, AM6, The European Computer Driving Licence Foundation Ltd. (disponível em http://www.ecdl.pt/PT/CERTECDL/CERTIECDL/Pages/CertificacoesECDL.aspx 2013 09 13)