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: | |||||
| LOPEZ MOLINA, CARLOS [Mentoring ] | |||||
Contents
Introduction: physical and logical structure of a computer. Operating systems.
Introduction to programming: data types, control structures and modularity.
Application programs: spreadsheets, databases, project planning, basic uses of Internet.
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.
Learning outcomes
- To use the most common operating systems.
- To know the edition, compilation and execution tools to develop programs.
- To use the different control and data structures to develop programs. To validate the developed programs.
- To design simple databases and make queries.
- To use a spreadsheet.
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. Remediable in the the extraordinary evaluation.
|
50% |
|
Evaluation of competences CT7, CG2, CE3 |
Partipation in classroom activities |
Short exams during the lessons. This part is not remediable in the extraordinary evaluation.
|
20% |
|
Evaluation of competences |
Application to practical problems of the theoretical concepts |
Practical exam and/or works. Remediable in the the extraordinary evaluation. |
30%
|
Agenda
Theoretical contents:
1. Introduction.
Basic computing.
Operating systems.
Basic uses of Internet.
2. Programming.
Simple data types.
Basic instructions.
Control structures.
Structured data types.
3. Spreadsheet.
Basic Operations.
Formulas and Functions.
Graphics.
4. Database.
Tables and relationships.
Queries.
Creation and design.
5. Project Management.
Practical contents:
Windows operating system and MiAulario-NireIkasgelategia.
Pascal programming environment.
Alternative control structures.
Repetitive control structures.
Data structures.
File management in Excel. Charting.
Absolute and relative references. Mathematical and logical functions.
Search functions and statistics.
Creation of a database with Access.
Database queries.
Project management.
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).