Universidad Pública de Navarra - Nafarroako Univertsitate Publikoa
Public University of Navarre
| Course code: 501103 | Subject title: COMPUTER SCIENCE | ||||
| Credits: 6 | Type of subject: Basic | Year: 1 | Period: 1º S | ||
| Department: Automatics and Computing | |||||
| Lecturers: | |||||
| PATERNAIN DALLO, DANIEL [Mentoring ] | LOPEZ MOLINA, CARLOS [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.
Descriptors
Basic knowledge about the use and programming of computers, operative systems, databases and programs, with applications to Engineering.
Methodology
|
Methodology-Activities |
Classroom tuition |
Off-site classes |
|
A-1 Theoretical lessons |
30 |
15 |
|
A-2 Practical lessons |
29 |
10 |
|
A-3 Seminar |
1 |
|
|
A-4 Personal work |
|
33 |
|
A-5 Reading |
|
|
|
A-6 Personal study |
|
26 |
|
A-7 Exams |
4 |
|
|
A-8 Individual tuition |
|
2 |
|
... |
|
|
|
Total |
64 |
86 |
Evaluation
|
Aspect
|
Criteria
|
Tool
|
Weight
|
|
Evaluation of competences CT7, CG2, CE3 |
Comprehension of the theoretical and practical contents
|
Theoretical-practical exam. It is a must to get 5 over 10 in this exam to pass. In the extraordinary evaluation, the theoretical-practical exam will allow to pass the whole subject (100%)
|
50% |
|
Evaluation of competences CT7, CG2, CE3 |
Partipation in classroom activities |
Short exams during the theoretical lessons.
|
20% |
|
Evaluation of competences |
Application to practical problems of the theoretical concepts |
Practical exam and works. |
30%
|
Agenda
Theoretical contents
1. Introduction
Basic informatics
Operative systems
Elementary use of Internet
2. Programming
Types of simple data
Basic commands
Control structures
Types of structured data
Procedures and functions
3. Spreadsheet
Elementary operations
Formulae and functions
Graphics
4. Databases
Relations and tables
Queries
Creation and design
5. Project management
Practical contents
1. Windows ad Miaulario operative systems
2. Pascal programming environment
3. Alternative control structures
4. Iterative control structures
5. Data structures
6. Procedures and functions
7. Excel files management. Absolute and relative references. Graphics
8. Functions
9. Searching functions and statistics
10. Creation of a database with Access
11. Queries in a database
Bibliography
Access the bibliography that your professor has requested from the Library.
- Joyanes, L., Programación en Pascal (4º edición), Mc Graw Hill (2006)
- Valdés-Miranda, C., Excel 2010, Anaya (2010)
- Casas, J., Access 2010, Anaya (2010).