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: | |||||
| FERNANDEZ FERNANDEZ, FCO. JAVIER [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 (3 hours)
Basic informatics
Operative systems
Elementary use of Internet
2. Programming (14 hours)
Types of simple data
Basic commands
Control structures
Types od structured data
3. Spreadsheet (6 hours)
Elementary operations
Formulae and functions
Graphics
4. Databases (6 hours)
Relations and tables
Queries
Creation and design
5. Project management (1 hour)
Practical contents
- Windows ad Miaulario operative systems (2 hours)
- Pascal programming environment (2 hours)
- Alternative control structures (2 hours)
- Iterative control structures (4 hours)
- Data structures (8 hours)
- Excel files management. Graphics (2 hours)
- Absolute and relative references. Mathematical and logical functions (2 hours)
- Searching functions and statistics (2 hours)
- Creation of a database with Access (3 hours)
- Queries in a database (2 hours)
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).