Public University of Navarre

CastellanoEuskara | Academic year: 2017/2018 | Previous academic years:  2016/2017  |  2015/2016  |  2014/2015  |  2013/2014 
Bachelor's degree in Innovation on Food Processes and Products at the Universidad Pública de Navarra
Course code: 502102 Subject title: COMPUTER SCIENCE
Credits: 6 Type of subject: Basic Year: 1 Period: 1º S
Department: Mathematics and Computer Engineering
LOPEZ MOLINA, CARLOS (Resp)   [Mentoring ]

Partes de este texto:


Module/Subject matter




Introduction: Physical and logical structure of a computer. Operative systems. Introduction to programming. Data types, control structures and modularity. Programs for applications: speadsheet, project management, basical use of Internet.



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


General proficiencies

CB1, CB2, CB3


Specific proficiencies

CT3, CT5, CT6, CE2


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.



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 3  
A-8 Individual tuition    3
Total 63 87



Aspect   Criteria   Tool   Weight  
R1, R2, R3, R4, R5, R6 Understanding of the theoretical and practical contents   Theoretical-practical exam. It is a must to reach 5/10 in this exam to pass the subject. Remediable in the the extraordinary evaluation.   40%
ER1, R2, R3, R4, R5, R6 Partipation in classroom activities Short exams and tests during the lessons. This aspect is not remediable in the extraordinary evaluation.   5%
R1, R2, R3, R4, R5, R6 Collaborative applications of theoretical concepts Evaluation of the group outcome to speficic tasks. All members of a group might have heterogeneous, upon lecturer's decision. Not remediable in the the extraordinary evaluation. 10%  
R1, R2, R3, R4, R5, R6 Individual work  Evaluation of individually submitted work. This aspect is remediable in the extraordinary evaluation. 45%



1. Spreadsheets

  • T1a Fundamentals on spreadsheets;
  • T1b Advanced functions for spreadsheets;
  • T1c Storing and searching for information;
  • T1d Importing, analyzing and exporting information;
  • T1e Advanced data analysis.

2. Programming in Python

  • T2a Operating systems and programming;
  • T2b Data types and used interaction;
  • T2c Alternative control structures in Python;
  • T2d Iterative control structures in Python;
  • T2e Collections in Python;
  • T2f Text management in Python.

3. Automated information processing

  • T3a File management in Python;
  • T3b Information storage and representation in Python;
  • T3c Automated spreadsheet management in Python.
  • The practical contents in the subject are:
  • 1.- Basic uses spreadheets;
  • 2.- Advanced uses spreadheets;
  • 3.- Searching information in a spreadsheet;
  • 4.- Information import/export with spreadsheets
  • 5.- Professional applications of spreadsheets
  • 6.- Setting and using a Python environment
  • 7.- User interaction with Python
  • 8.- Alternative control structures in Python
  • 9.- Iterative control structures in Python
  • 10.- Collections in Python
  • 11.- Reading files in Python
  • 12.- Automated file management in Python
  • 13.- Information import/export with Python
  • 14.- Integrating spreadsheets and Python



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


  • 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 (;
  • E. Bahit, Curso: Python para Principiantes, accesible en el repositorio de SafeCreative (;
  • A. Marzal, Introducción a la programación en Python, accesible on-line en la Colección Sapientia de la Universidad Jaume I (
  • The Python Foundation, The Python Language Reference (Official), accesible on-line en la página oficial de la Python Foundation (