Base Knowledge
In order to a,chieve the objectives of the U.C and confer the componences provided to the student, the learning process is based on cases 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 reseearch necessary to complement the information obtained in class.
The exhibition will be made using Microsof Excel, Word and Power Point, and Google Docs.
Teaching Methodologies
Classes will be theoretical-practical. An expository methodology will be used for the presentation of theoretical concepts that will be exemplified with concrete situations of reality. The exhibition will be made using “Power Point” presentations.
Several sheets will be made available on the contents taught, resolved in classes and other supplementary information for resolution at home.
Learning Results
A. Understand the composition and functioning of the computer
A.1. Identify hardware and various types of software.
A.2. Recognize and use common computer functions.
B. Apply good usage practices
B.1. Understand legal aspects, personal safety, and ergonomics associated with computer use.
B.2. Appropriately apply different types of copyright to documents.
C. Select and use computer applications
C.1. Identify suitable programs for performing common tasks.
D. Produce different types of documents
D.1. Use a word processor for simple and also technical-scientific documents.
D.2. Create forms and other types of documents and share them.
E. Manage and analyze data in spreadsheets
E.1. Create tables and analyze data.
E.2. Apply intermediate-level standard functions.
E.3. Build charts appropriate to the nature and purpose of the data.
F. Create effective presentations
F.1. Use presentation software to create presentations, handouts, or posters.
F.2. Apply graphic and content criteria to improve communication effectiveness.
Program
1. Introduction to Informatics.
2. Hardware and software. Operating systems. Examples of computer applications for common tasks.
3. Copyright. Types of licenses. Computer security. Ergonomics.
4. Notions and presentation manager applications.
5. Organization of data in a frequency table and respective graphical representation. Use of Microsoft Excel to obtain frequency tables. Pivot tables. Formula programming.
6. Graphical representation of data. Using Microsoft Excel to build charts.
7. Notions and applications of a presentation manager. Power Point.
8. Word processing. Using Microsoft Word.
9. The Google Docs and its use for group work.
Curricular Unit Teachers
Elisabete Dinora Caldas de FreitasInternship(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)