Computer Applications

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.

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.

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.

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.

The conditions for admission to assessment and approval in this course unit are those stated in the "Regulamento Académico dos Cursos Técnicos Superiores Profissionais da Escola Superior Agrária de Coimbra do Instituto Politécnico de Coimbra" available at http://www1.esac.pt/alunos/regulamentos.php, particularly regarding minimum attendance requirements in different assessment periods and the minimum final grade required for approval (equal to or greater than 9.50 on a scale of 0 to 20).

Continuous or Periodic Assessment

Mandatory: Students must meet the minimum attendance requirement for practical classes, as stated in the current Academic Regulations.
Three assessment components (each scored from 0 to 20):

Two tests (T1 and T2), each weighted at 45%
In-class Participation (PP), weighted at 10%

Final Grade:
The final grade (on a scale from 0 to 20) is the weighted average of the three assessment components:

0.45 × T1 + 0.45 × T2 + 0.10 × PP, rounded to two decimal places.

The student passes if the weighted average is equal to or greater than 9.50.

Final Exam Assessment (regular and other periods)

Mandatory: Students must meet the minimum attendance requirement for practical classes, as stated in the current Academic Regulations.

The final exam grade is obtained through a practical computer-based exam. The exam is divided into parts corresponding proportionally to the two tests taken during the course (T1 and T2).

Students who did not pass through continuous or periodic assessment may, if they wish, be exempt from one part of the final exam, provided the following conditions are met:
a) The grades of the frequency tests (T1 or T2) taken during the same academic year are equal to or higher than 7.50;
b) Attendance was equal to or greater than 75% of the classes taught.

Assessment scores are only valid for that academic year. It is not possible to reuse a grade obtained (T1 and/or T2) in a previous academic year.

Grade Improvement Exam

The grade in the improvement exam is obtained through a practical computer-based exam, identical to the final exam.
In the improvement exam, previously obtained grades cannot be reused.

NAO