Public University of Navarre



CastellanoEuskara | Academic year: 2019/2020 | Previous academic years:  2016/2017  |  2015/2016 
Bachelor's degree in Agricultural, Food and Rural Environment Engineering at the Universidad Pública de Navarra
Course code: 501103 Subject title: COMPUTER SCIENCE
Credits: 6 Type of subject: Basic Year: 1 Period: 1º S
Department: Estadística, Informática y Matemáticas
Lecturers
LOPEZ MOLINA, CARLOS (Resp)

Partes de este texto:

 

Module/Subject matter

COMPUTER SCIENCE

Up

Descriptors

Basic knowledge about the use and programming of computers, operative systems, databases and programs, with applications to Engineering.

Up

General proficiencies

  • CB1: Students are able to demonstrate they have acquired knowledge and understanding in a field of study based on the basic foundations gained within their general secondary education together with the support of advanced textbooks and aspects of the latest advances in the field.
  • CB2: Students can apply their knowledge to a job or vocation in a professional manner and have the competences which are generally shown through the elaboration and defence of arguments and problem solving in their field of study.
  • CT4: Ability to search and use the information, rules and regulations relative to the field of action.

 

Up

Specific proficiencies

  • CG2: Adequate knowledge of the physical problems, technologies, equipment, and water and energy supply systems, the limits imposed by budgetary factors and building regulations, the relationships between installations and/or buildings with farms, agro-food industries and spaces related to gardening and landscaping with their social and environmental surroundings, as well as the need to relate those surroundings from that environment with human needs and environmental protection.
  • CE3: Basic knowledge of the use and programming of computers, operating systems, databases and computer programmes with engineering applications.

Up

Learning outcomes

R1- Comprender el concepto de sistema operativo y ser capaz de trabajar con los más comunes en el ámbito de la ingeniería.
R2- Conocer herramientas de edición y ejecución de programas.
R3- Ser capaz de propone y desarrollar soluciones algorítmicas para problemas bien definidos.

R4- Utilizar diferentes estructuras de control y de datos para desarrollar programas. Validar y estudiar la calidad de los algoritmos propuestos.

R5- Utilizar herramientas ofimáticas para la importación, gestión, visualización y exportación de información.

R6- Integrar el uso de ficheros, hojas de cálculo y programas personalizados para gestionar información en el ámbito de la ingeniería.

 

RESULTADOS APRENDIZAJE ENAEE:
ENAEE-3: Un conocimiento adecuado de su rama de ingeniería que incluya algún conocimiento a la vanguardia de su campo.

Up

Methodology

Methodology-Activities Classroom tuition Off-site classes
A-1 Theoretical lessons 29 15
A-2 Practical lessons 28 30
A-3 Seminar 1  
A-4 Personal work   15
A-5 Reading    
A-6 Personal study   24
A-7 Exams 5  
A-8 Individual tuition    3
...    
Total 63 87

Up

Relationship between formative activities and proficiencies

Competence Formative activity
CB1 A-2, A-3
CB2 A-2
CG2 A-1, A-2, A-4, A-6, A-7, A-8
CE3 A-1, A-2, A-4, A-6, A-7, A-8
CT4 A-2, A-4

Up

Languages

English

Up

Evaluation

 

Aspect   Criteria   Tool   Weight  
R1, R2, R3, R4, R5, R6 Comprehension of the theoretical and practical contents   Theoretical-practical exam. It is a must to get 5 over 10 in this exam to pass. Remediable in the the extraordinary evaluation.   40%
ER1, R2, R3, R4, R5, R6 Partipation in classroom activities Short exams during the lessons. This part is not remediable in the extraordinary evaluation.   5%
R1, R2, R3, R4, R5, R6 Application to practical problems of the theoretical concepts Practical exam and/or works. Remediable in the the extraordinary evaluation. 10%  
R1, R2, R3, R4, R5, R6 Individual work   45%

Up

Contents

Uso y diseño de hojas de cálculo. Importación y exportación de información en diferentes formatos. Manejo de herramientas nativas de hojas de cálculo para la depuración, análisis y visualización de información.
Rol de las aplicaciones en informática moderna. Creación de aplicaciones, ejecución de las mismas. Comprensión de los fundamentos de programación en términos de tipos de datos y estructuras de control. Diseño de soluciones algorítmicas para problemas bien definidos en el ámbito de la ingeniería.
Integración de programas personalizados con aplicaciones existentes. Gestión automática de grandes volúmenes de información. Interacción con sistemas operativos.

Up

Agenda

The theoretical side of the subject develops as follows:

  • Part 1. Programming with Python
    • T1a Introduction to operating systems and programming;
    • T1b Data types and basic interaction with users;
    • T1c Alternative programming structures;
    • T1d Collections;
    • T1e Iterative programming structures;
    • T1f Text management with Python
    • T1g Functions
    • T1h Text file reading and writing
  • Part 2. Spreadsheets
    • T2a Fundamentals of spreadsheets;
    • T2b Advanced functions for spreadsheets;
    • T2c Information search and retrieval with spreadsheets;
  • Part 3. Automatic information processing
    • T3a Management of data with Python;
    • T3b Management of spreadsheets with Python.

The practical side of the subject develops as follows:

  • Part 1. Programming with Python
    • 1. Executing Python scripts;
    • 2. Interaction with users and basic information management;
    • 3. Alternative programming structures;
    • 4. Collections;
    • 5. Iterative programming structures;
    • 6. Text management in Python;
  • Part 2. Spreadsheets
    • 7. Basic spreadsheets;
    • 8. Advanced functions for spreadsheets;
    • 9. Information search and retrieval with spreadsheets;
    • 10. Importing and exporting information from/to spreadsheets;
  • Part 3. Automatic information processing
    • 11. File reading with Python;
    • 12. Integration of spreadsheets with Python.

 

Up

Bibliography

Acceda a la bibliografía que su profesor ha solicitado a la Biblioteca.


 

  • C. Valdés-Miranda Cros, Manual imprescindible de Excel 2013, Anaya Multimedia;
  • Apache Foundation, The OpenOffice Calc Reference (Official), accesible on-line en la página oficial de LibreOffice (help.libreoffice.org/Main_Page);
  • E. Bahit, Curso: Python para Principiantes, accesible en el repositorio de SafeCreative (www.safecreative.org);
  • A. Marzal, Introducción a la programación en Python, accesible on-line en la Colección Sapientia de la Universidad Jaume I (www.sapientia.uji.es).
  • The Python Foundation, The Python Language Reference (Official), accesible on-line en la páginaoficial de la Python Foundation (docs.python.org/3.5/reference/).

 

Up

Location

Aulario

Up