Public University of Navarre



CastellanoEuskara | Academic year: 2023/2024
Double degree in Agrifood Engineering and Rural Environment and Innovation of Food Processes and Products from Navarre Public University at the Universidad Pública de Navarra
Course code: 510102 Subject title: COMPUTER SCIENCE
Credits: 6 Type of subject: Mandatory Year: 1 Period: 1º S
Department:
Lecturers:
PEREZ GOYA, UNAI (Resp)   [Mentoring ] MURU TORRES, IÑIGO   [Mentoring ]

Partes de este texto:

 

Module/Subject matter

COMPUTER SCIENCE

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

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 To use the most common operating systems.
R2 To know the edition, compilation and execution tools to develop programs.
R3 To use the different control and data structures to develop programs. To validate the developed programs.
R4 To design simple databases and make queries.

R5. To design and develop algorithmic solutions to well-defined problems.

R6. To integrate the use of files, spreadsheets and tailor-made script to manage information in a professional, engineering application.

 

LEARNING OUTCOME
ENAEE-3: An adequate knowledge of your engineering branch that includes some knowledge at the forefront of your field.

Up

Methodology

Methods- Activity In-class time (hours) Off-class time (hours)
A-1 Theoretical lessons 29 15
A-2 Practical lessons 28 30
A-3 Seminars 0  
A-4 Personal work   15
A-5 Reading    
A-6 Personal study   25
A-7 Exams 5  
A-8 In-office assistance    3
Total 62 88

Up

Evaluation

 

Learning
outcome
Assessment
activity
Weight (%) It allows
test resit
Minimum
required grade
R1, R2, R3, R4, R5, R6 Theoretical-practical exams. It includes contents from the individual or group labs. 48%  Yes 5
R1, R2, R3, R4, R5, R6 As registered by the lecturer. 7%   Yes  
R1, R2, R3, R4, R5, R6 Lab submission under the requirements by the lecturer. 30% Yes  
R1, R2, R3, R4, R5, R6 Lab submission under the requirements by the lecturer and, potentially, written exam on their contents. 15% Yes  

If the student did not get the minimum grade to weigh in any of the activities, the grade of the subject would be 4.9 out of 10 at most (fail). 

Up

Agenda

The theoretical side of the subject develops as follows:

  • Part 1. Programming with Python
    • Introduction to computers and programming;
    • Python environment, variables and variable scope;
    • Types and basic interaction with users;
    • Programming structures: functions, indentation and encapsulation;
    • Collections;
    • Alternative programming structures;
    • Iterative programming structures;
    • Text management;
  • Part 2. Spreadsheets
    • Advanced functions for spreadsheets;
    • Information search and retrieval with spreadsheets;
  • Part 3. Automatic information processing
    • Management of data with Python;
    • 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. Group project: Automatic information processing

 

Up

Bibliography

Access the bibliography that your professor has requested from the Library.


 

  • Shaw, Z. A. (2013). Learn Python the hard way: A very simple introduction to the terrifyingly beautiful world of computers and code. Addison-Wesley.
  • Lee, K. D., Lee, K. D., & Steve Hubbard, S. H. (2015). Data Structures and Algorithms with Python. Springer.
  • Barry, P., & Griffiths, D. (2009). Head First Programming: A Learner's Guide to Programming Using the Python Language. " O'Reilly Media, Inc.".
  • Luciano, R. (2015). Fluent Python: Clear, Concise, and Effective Programming.
  • 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.6/reference/).
  • 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);

 

Up

Languages

English

Up

Location

Aulario

Up