Public University of Navarre



Academic year: 2023/2024 | Previous academic years:  2022/2023  |  2021/2022  |  2020/2021  |  2019/2020 
Bachelor's degree in Industrial Engineering at the Universidad Pública de Navarra
Course code: 252103 Subject title: COMPUTER SCIENCE
Credits: 6 Type of subject: Basic Year: 1 Period: 1º S
Department: Estadística, Informática y Matemáticas
Lecturers:
GUERRA ERREA, CARLOS (Resp)   [Mentoring ] INDURAIN IBERO, ALFONSO   [Mentoring ]
PALOMINO ECHEVERRIA, SARA   [Mentoring ]

Partes de este texto:

 

Module/Subject matter

Module: Basic Formation

Matter: Computing

Up

General proficiencies

  • CG3. Knowledge on basic and technological matters, abilitating to learn new methods and theories, as well as providing versatility to face unknown situations.
  • CG4. Ability to solve problems with initiative, decision making, creativity, critical reasoning, as well a to be able to communicate and transmit knowledge, abilities and skills in the field of Industrial Engineering in the three specific technologies, namely Mechanics, Electricity and Electronics.

Up

Specific proficiencies

  • CFB3. Having basic skills on using and programming computers, operating systems, databases and software with direct application on engineering.

Up

Learning outcomes

R1. To identify the different components of both the logical and physical system of the computer.

R2. To understand the functionality of an operating system as a manager of the physical system of the computer.

R3. To handle the most common operating systems.

R4. To use the edition, compilation and execution tools to develop programs.

R5. To use the different control structures to develop programs.

R6. To use the different data structures to develop programs.

R7. To perform tests to validate the developed programs.

R8. To design a simple database.

R9. To develop queries to extract information from databases.

R10. To use a spreadsheet.

R11. To know informatics tools to plan engineering projects.

R12. To understand the WWW paradigm.

Up

Methodology

Methodology-Activities Classroom tuition Off-site classes
A-1 Theoretical lessons 30  
A-2 Practical lessons 30  
A-3 Individual tuition 2  
A-4 Exams 4  
A-5 Personal work   84
Total 66 84

Up

Relationship between formative activities and proficiencies/learning outcomes

Competence Formative activity
CG3 A-2, A-3, A-5
CG4 A-2, A-3, A-5
CFB3 A-1, A-2, A-3, A-4, A-5

Up

Languages

English.

Up

Evaluation

 

Learning
outcome
Assessment
activity
Weight (%) It allows
test resit
Minimum
required grade
R5, R6, R7, R8, R9, R10, R11 Theoretical-practical exam 50 YES 5
R5, R6, R7, R8, R9, R10 Short exams during the  lessons 20 YES  
R1, R2, R3, R4, R5, R6, R8, R9, R10, R12 Practical exam/test and/or evaluation of practical works 30 NO  

 

The resit will consist of a new theoretical-practical exam that will recover the first and second assesment activities. The final mark for those students who do not obtain 5 (over 10) in the recovery exam will be the one obtained in this exam (over 10). That is, this mark will not be weighted with that of the third part.

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

Theoretical contents
1. Introduction
   Basic informatics
   Operative systems
2. Programming

 Algorithms
   Types of simple data and variables
   Basic commands
   Control structures
   Types of structured data: Sequences
   Functions
3. Spreadsheet
   Elementary operations
   Formulae and functions
   Graphics
4. Databases
   Relations and tables
   Queries
   Creation and design

 

Practical contents

  • Python programming environment
  • Alternative control structures
  • Iterative control structures
  • Data structures
  • Functions
  • Excel files management. Absolute and relative references. Graphics
  • Functions
  • Searching functions and statistics
  • Creation of a database with Access
  • Queries in a database

Up

Bibliography

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


  • A. Marzal, Introducción a la programación con Python 3, 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.5/reference/).
  • F. Charte, Excel 2013, Anaya (2013).
  • F. Charte, Access 2013, Anaya (2013).

Up

Location

Arrosadia Campus

http://www.unavarra.es/ets-industrialesytelecos/estudios/grado/grado-en-ingenieria-en-tecnologias-industriales/horarios?submenu=yes

Up