Universidad Pública de Navarra - Nafarroako Univertsitate Publikoa
Public University of Navarre
| 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: | |||||
| PEREZ GOYA, UNAI (Resp) [Mentoring ] | FERRERO JAURRIETA, MIKEL [Mentoring ] | ||||
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.
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
| 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 |
Evaluation
| Learning outcome |
Assessment activity |
Weight (%) | It allows test resit |
Minimum required grade |
|---|---|---|---|---|
| R1, R2, R3, R4, R5, R6 | Theoretical-practical exam. It includes contents from the individual or group labs. | 58 | 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).
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
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);