Public University of Navarre



CastellanoEuskara | Academic year: 2018/2019 | Previous academic years:  2019/2020  |  2017/2018  |  2016/2017  |  2015/2016 
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: 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 Science and Engineering.

Up

General proficiencies

CB1, CB2, CB3

CT3, CT5, CT6

Up

Specific proficiencies

CE2

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.

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

Relationship between formative activities and proficiencies

Competence Formative activity
CT3 A-6, A-7
CT5 A-4, A-6, A-7
CT6 A-4
CE2 A-1, A-2, A-4, A-6, A-7, A-8
CB1,CB2,CB3 A-1, A-2, A-4, A-6, A-7, A-8

Up

Languages

English

Up

Evaluation

 

Aspecto   Criterios   Instrumento   Weight 
R1, R2, R3, R4, R5, R6 Understanding of the theoretical and practical contents  Theoretical-practical exam. It includes contents from the individual or group labs. A minimum grade of 50% is required in this exam to pass the subject. Remediable in the the extraordinary evaluation.  48%  
R1, R2, R3, R4, R5, R6 Partipation in classroom activities As registered by the lecturer. This outcome is not remediable in the extraordinary evaluation 7%  
R1, R2, R3, R4, R5, R6 Collaborative applications of theoretical concepts Lab submission under the requirements by the lecturer. This outcome is not remediable in the extraordinary evaluation 30%
R1, R2, R3, R4, R5, R6 Individual work Lab submission under the requirements by the lecturer and, potentially, written exam on their contents. Remediable in the the extraordinary evaluation. 15%

Up

Contents

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.

Up

Agenda

The theoretical contents of the subject are as follows:

  • 1. Programming in Python
    • T1a Operating systems and programming;
    • T1b Data types and used interaction;
    • T1c Alternative control structures in Python;
    • T1d Iterative control structures in Python;
    • T2e Collections in Python;
    • T2f Text management in Python.
  • 2. Spreadsheets
    • T2a Fundamentals on spreadsheets;
    • T2b Advanced functions for spreadsheets;
    • T2c Storing and searching for information;
    • T2d Importing, analyzing and exporting information;
    • T2e Advanced data analysis.
  • 3. Automated information processing
    • T3a File management in Python;
    • T3b Information storage and representation in Python;
    • T3c Automated spreadsheet management in Python.

The practical labs are as follows:

  • 1.- Setting and using a Python environment
  • 2.- User interaction with Python
  • 3.- Alternative control structures in Python
  • 4.- Iterative control structures in Python
  • 5.- Collections in Python
  • 6.- Reading text files in Python
  • 7.- Basic uses spreadheets;
  • 8.- Advanced uses spreadheets;
  • 9.- Searching information in a spreadsheet;
  • 10.- Information import/export with spreadsheets
  • 11.- Professional applications of spreadsheets
  • 12.- Automated file management in Python
  • 13.- Information import/export with Python
  • 14.- Integrating spreadsheets and 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ágina oficial de la Python Foundation (docs.python.org/3/).

Up

Location

Aulario

Up