Estudia
- Artes y humanidades
- Ciencias
- Ciencias de la salud
- Ciencias sociales y jurídicas
-
Ingeniería y arquitectura
- Doble Grado en Ingeniería Civil e Ingeniería de los Recursos Mineros y Energéticos
- Doble Grado en Ingeniería en Tecnologías y Servicios de Telecomunicación / Grado en Ciencia e Ingeniería de Datos
- Doble Grado en Ingeniería Informática del Software / Grado en Matemáticas
- Doble Grado en Ingeniería Informática en Tecnologías de la Información / Grado en Ciencia e Ingeniería de Datos
- Grado en Ciencia e Ingeniería de Datos
- Grado en Ingeniería Civil
- Grado en Ingeniería de los Recursos Mineros y Energéticos
- Grado en Ingeniería de Organización Industrial
- Grado en Ingeniería de Tecnologías Industriales
- Grado en Ingeniería de Tecnologías Mineras
- Grado en Ingeniería Eléctrica
- Bachelor´s Degree in Industrial Electronics and Automatics Engineering
- Grado en Ingeniería en Geomática
- Grado en Ingeniería en Tecnologías y Servicios de Telecomunicación
- Grado en Ingeniería Forestal y del Medio Natural
- Grado en Ingeniería Forestal y del Medio Natural (En extinción)
- Grado en Ingeniería Informática del Software
- Grado en Ingeniería Informática en Tecnologías de la Información
- Grado en Ingeniería Mecánica
- Grado en Ingeniería Química
- Grado en Ingeniería Química Industrial
- Grado en Marina
- Grado en Náutica y Transporte Marítimo
- Información, acceso y becas
Fundamentos de Informática
- Prácticas de Laboratorio (28 Hours)
- Tutorías Grupales (2 Hours)
- Clases Expositivas (28 Hours)
The subject "Fundamentos de Informática" belongs to the "Basic Training" module and to the subject "Computer Science". For this reason, this subject includes part of the basic knowledge competencies that the student has to develop in relation to computing, specifically, it covers those that refer to basic knowledge about the use and programming of computers, operating systems, databases and computer programs with applications in engineering. It also includes the following transversal skills such as the ability to abstract, problem-solving skill and creativity.
After the framing of the subject, both in computer science itself and in the other disciplines of the degree, introductions will be carried out to the fields that make up the titles of its four main topics of the program: software and hardware components, operating systems, programming and databases, with a greater incidence in programming that will be specified in a versatile general-purpose programming language for any branch of engineering. The subject has a marked practical nature for the student to learn by interacting with the computer, a tool that will be essential both throughout their undergraduate studies and in professional life.
As it is a subject of basic competencies, it does not require any prior specific knowledge that has not been developed in the student's previous training stages; However, it is considered that the student is minimally familiar as a common user with the computer, and all the added knowledge and skills that he possesses will result in greater benefit and less effort in the subject.
The competences that will be developed in this subject, understood within the framework of an introductory and brief subject, are the following ones:
For the Bachelor's Degree in Civil Engineering:
General and basic competences:
- CB1: The students must demonstrate knowledge and understanding in an area of study that starts from the base of general secondary education, and is usually at a level that, although supported by advanced textbooks, also includes some aspects that imply insights from the cutting edge of your field of study.
- CB2: The students must know how to apply their knowledge to their work or vocation in a professional way and have the skills that are usually demonstrated through the development and defense of arguments and problem solving within their area of study.
- CB3. The students must have the ability to gather and interpret relevant data (usually within their area of study) to make judgments that include reflection on relevant issues of a social, scientific or ethical nature.
- CB4 The students can transmit information, ideas, problems and solutions to both a specialized and non-specialized audience.
- CB5 The students have developed those learning skills necessary to undertake further studies with a high degree of autonomy.
- CG02: Understanding of the multiple technical and legal constraints that arise in the construction of public works, as well as the ability to use proven methods and accredited technologies to achieve the greatest efficiency in construction while taking care of the environment and the protection of the safety and health of workers and users of public works.
- CG07: Ability to carry out studies and design surface or groundwater catchments in its context.
Specific competences:
- CB03: Basic knowledge on the use and programming of computers, operating systems, databases and computer programs with application in engineering.
These competences are specified in the following learning outcomes:
- 1RA38: Recognizing computer science within engineering disciplines.
- 1RA39: Knowing the fundamentals of the binary system to understand the representation of information in computers.
- 1RA40: Identifying the hardware components in a computer system as well as their interconnection in networks, and understand their basic operation.
- 1RA41: Distinguishing the main peripherals used in a computer system, specifically in the context of engineering
- 1RA42: Classifying the different types of software used in a computer system.
- 1RA43: Identifying and classifying different types of computer systems and their use context.
- 1RA44: Knowing the main functions performed by an operating system.
- 1RA45: Analyzing what services the operating system provides to programs and end users.
- 1RA46: Identifying the main operating systems used in professional engineering environments and using their main services in a basic level.
- 1RA47: Knowing the main functions performed by a database management system.
- 1RA48: Designing data models for simple problems.
- 1RA49: Using basic expressions to query and modify information stored in a database.
- 1RA50: Identifying some database management systems used in professional engineering environments.
- 1RA51: Identifying the main application programs used in professional engineering environments.
- 1RA52: Understanding the concept of algorithm and the abstraction process of a problem in programming environments.
- 1RA53: Identifying the development process of a software in a Software Engineering context.
- 1RA54: Recognizing the elementary data structures provided by a structured programming language.
- 1RA55: Handling the elementary control structures of a structured programming language.
- 1RA56: Abstracting operations.
- 1RA57: Designing small applications to solve elementary problems in collaborative work environments.
For the Bachelor's Degree in Mining & Energy Resources Engineering:
General and basic competences:
- CG01: Scientific-technical skills for the exercise of the profession of Technical Mining Engineer and knowledge of the functions of consulting, analysis, design, calculation, project, construction, maintenance, conservation and exploitation..
Specific competences:
- CE03: Basic knowledge on the use and programming of computers, operating systems, databases and computer programs with application in engineering.
These competences are specified in the following learning outcomes:
- 1RA38: Recognizing computer science within engineering disciplines.
- 1RA39: Knowing the fundamentals of the binary system to understand the representation of information in computers.
- 1RA40: Identifying the hardware components in a computer system as well as their interconnection in networks, and understand their basic operation.
- 1RA41: Distinguishing the main peripherals used in a computer system, specifically in the context of engineering
- 1RA42: Classifying the different types of software used in a computer system.
- 1RA43: Identifying and classifying different types of computer systems and their use context.
- 1RA44: Knowing the main functions performed by an operating system.
- 1RA45: Analyzing what services the operating system provides to programs and end users.
- 1RA46: Identifying the main operating systems used in professional engineering environments and using their main services in a basic level.
- 1RA47: Knowing the main functions performed by a database management system.
- 1RA48: Designing data models for simple problems.
- 1RA49: Using basic expressions to query and modify information stored in a database.
- 1RA50: Identifying some database management systems used in professional engineering environments.
- 1RA51: Identifying the main application programs used in professional engineering environments.
- 1RA52: Understanding the concept of algorithm and the abstraction process of a problem in programming environments.
- 1RA53: Identifying the development process of a software in a Software Engineering context.
- 1RA54: Recognizing the elementary data structures provided by a structured programming language.
- 1RA55: Handling the elementary control structures of a structured programming language.
- 1RA56: Abstracting operations.
- 1RA57: Designing small applications to solve elementary problems in collaborative work environments.
For the Bachelor's Degree in Forestry and Sustainable Natural Resources Management:
General and basic competences:
- CG01 - Ability to understand the basics of biological, chemical, physical, mathematical resources, and representation systems needed for the development of a professional activity, as well as to identify the different biotic and physical elements of the forest environment and renewable natural elements susceptible to protection, conservation, and applications in the forest environment.
- CG14 - Ability to understand, interpret, and adopt scientific advances in the forestry field, to develop and transfer technology, and to work in a multilingual and multidisciplinary context.
- CB1 – Students must demonstrate knowledge and understanding in an area of study that builds on the foundation of general secondary education, and is often at a level that, while supported by advanced textbooks, also includes some aspects that involve knowledge from the forefront of their field of study.
- CB2 - Students must know how to apply their knowledge to their work or vocation in a professional way and have the skills that are usually demonstrated through the development and defense of arguments and problem solving within their area of study.
Specific competences:
- CE03: Basic knowledge on the use and programming of computers, operating systems, databases and computer programs with application in engineering.
These competences are specified in the following learning outcomes:
- MB-RA24: Recognizing computer science within engineering disciplines.
- MB-RA25: Knowing the fundamentals of the binary system to understand the representation of information in computers.
- MB-RA26: Identifying the hardware components in a computer system as well as their interconnection in networks, and understand their basic operation.
- MB-RA27: Distinguishing the main peripherals used in a computer system, specifically in the context of engineering
- MB-RA28: Classifying the different types of software used in a computer system.
- MB-RA29: Identifying and classifying different types of computer systems and their use context.
- MB-RA30: Knowing the main functions performed by an operating system.
- MB-RA31: Analyzing what services the operating system provides to programs and end users.
- MB-RA32: Identifying the main operating systems used in professional engineering environments and using their main services in a basic level.
- MB-RA33: Knowing the main functions performed by a database management system.
- MB-RA34: Designing data models for simple problems.
- MB-RA35: Using basic expressions to query and modify information stored in a database.
- MB-RA36: Identifying some database management systems used in professional engineering environments.
- MB-RA37: Identifying the main application programs used in professional engineering environments.
- MB-RA38: Understanding the concept of algorithm and the abstraction process of a problem in programming environments.
- MB-RA39: Identifying the development process of a software in a Software Engineering context.
- MB-RA40: Recognizing the elementary data structures provided by a structured programming language.
- MB-RA41: Handling the elementary control structures of a structured programming language.
- MB-RA42: Abstracting operations.
- MB-RA43: Designing small applications to solve elementary problems in collaborative work environments.
For the Bachelor's Degree in Geomatic Engineering:
General and basic competences:
- CG01 – Designing and developing geomatic and topographic projects.
- CB1 – Students must demonstrate knowledge and understanding in an area of study that builds on the foundation of general secondary education, and is often at a level that, while supported by advanced textbooks, also includes some aspects that involve knowledge from the forefront of their field of study.
- CB2 - Students must know how to apply their knowledge to their work or vocation in a professional way and have the skills that are usually demonstrated through the development and defense of arguments and problem solving within their area of study.
- The students must have the ability to gather and interpret relevant data (usually within their area of study) to make judgments that include reasoning on relevant issues of a social, scientific, or ethical nature.
Specific competences:
- CE03: Basic knowledge on the use and programming of computers, operating systems, databases and computer programs with application in engineering.
These competences are specified in the following learning outcomes:
- M1RA29: Recognizing computer science within engineering disciplines.
- M1RA30: Knowing the fundamentals of the binary system to understand the representation of information in computers.
- M1RA31: Identifying the hardware components in a computer system as well as their interconnection in networks, and understand their basic operation.
- M1RA32: Distinguishing the main peripherals used in a computer system, specifically in the context of engineering
- M1RA33: Classifying the different types of software used in a computer system.
- M1RA34: Identifying and classifying different types of computer systems and their use context.
- M1RA35: Knowing the main functions performed by an operating system.
- M1RA36: Analyzing what services the operating system provides to programs and end users.
- M1RA37: Identifying the main operating systems used in professional engineering environments and using their main services in a basic level.
- M1RA38: Knowing the main functions performed by a database management system.
- M1RA39: Designing data models for simple problems.
- M1RA40: Using basic expressions to query and modify information stored in a database.
- M1RA41: Identifying some database management systems used in professional engineering environments.
- M1RA42: Identifying the main application programs used in professional engineering environments.
- M1RA43: Understanding the concept of algorithm and the abstraction process of a problem in programming environments.
- M1RA44: Identifying the development process of a software in a Software Engineering context.
- M1RA45: Recognizing the elementary data structures provided by a structured programming language.
- M1RA46: Handling the elementary control structures of a structured programming language.
- M1RA47: Abstracting operations.
- M1RA48: Designing small applications to solve elementary problems in collaborative work environments.
For the Bachelor's Degree in Mining Engineering Technologies:
Basic and general competences:
CG1 – Sinthesis and análisis skills.
CG2 – Organization and planification skills.
CG3 – Oral and written communication in a native language.
CG5 – Computer science knowledge related to the area of study.
CG6 – Information management skills.
CG7 – Problem resolution.
CG8 – Decission making.
CG9 – Team work.
CG10 – Skills to work in interdisciplinary teams.
CG11 – Personal relations skills.
CG12 – Critical thinking.
CG13 – Ethical comitment.
CG14 – Autonomous learning.
CG15 – Adaptation to new situation and diverse contexts.
CG16 – Motivation for quality.
CG17 - Awareness on environmental and sustainability issues.
CG18 – Motivation for heatl and safety issues.
CG19 – Managing skills.
CG20 – Ability to handle new information and communication technologies.
CG21 - Ability to relate the knowledge of the different specialties in the area of study.
CG22 - Initiative and entrepreneurial spirit.
CG23 – Creativity.
CG24 – Ability to manage in an optimal manner the available time and resources.
Specific competence:
- CE03: Basic knowledge on the use and programming of computers, operating systems, databases and computer programs with application in engineering.
These competences are specified in the following learning outcomes:
- RA05.01 - Recognizing computer science within engineering disciplines (CG1, CG2, CG3, CG5, CG6, CG7, CG8, CG9, CG11, CG12, CG13, CG14, CG15, CG16, CG17, CG18, CG19, CG21, CG22, CG23, CG24, CE3).
- RA05.02 - Knowing the fundamentals of the binary system to understand the representation of information in computers (CG1, CG2, CG3, CG5, CG6, CG7, CG8, CG9, CG11, CG12, CG13, CG14, CG15, CG16, CG17, CG18, CG19, CG21, CG22, CG23, CG24, CE3).
- RA05.03 - Identifying the hardware components in a computer system as well as their interconnection in networks, and understand their basic operation (CG1, CG2, CG3, CG5, CG6, CG7, CG8, CG9, CG11, CG12, CG13, CG14, CG15, CG16, CG17, CG18, CG19, CG21,
CG22, CG23, CG24, CE3).
- RA05.04 - Distinguishing the main peripherals used in a computer system, specifically in the context of engineering (CG1, CG2, CG3, CG5, CG6, CG7, CG8, CG9, CG11, CG12, CG13, CG14, CG15, CG16, CG17, CG18, CG19, CG21, CG22, CG23, CG24, CE3).
- RA05.05 - Classifying the different types of software used in a computer system (CG1, CG2, CG3, CG5, CG6, CG7, CG8, CG9, CG11, CG12, CG13, CG14, CG15, CG16, CG17, CG18, CG19, CG21, CG22, CG23, CG24, CE3).
- RA05.06 - Identifying and classifying different types of computer systems and their use context (CG1, CG2, CG3, CG5, CG6, CG7, CG8, CG9, CG11, CG12, CG13, CG14, CG15, CG16, CG17, CG18, CG19, CG21, CG22, CG23, CG24, CE3).
- RA05.07 - Knowing the main functions performed by an operating system (CG1, CG2, CG3, CG5, CG6, CG7, CG8, CG9, CG11, CG12, CG13, CG14, CG15, CG16, CG17, CG18, CG19, CG21, CG22, CG23, CG24, CE3).
- RA05.08 - Analyzing what services the operating system provides to programs and end users (CG1, CG2, CG3, CG5, CG6, CG7, CG8, CG9, CG11, CG12, CG13, CG14, CG15, CG16, CG17, CG18, CG19, CG21, CG22, CG23, CG24, CE3).
- RA05.09 - Identifying the main operating systems used in professional engineering environments and using their main services in a basic level (CG1, CG2, CG3, CG5, CG6, CG7, CG8, CG9, CG11, CG12, CG13, CG14, CG15, CG16, CG17, CG18, CG19, CG21, CG22, CG23, CG24, CE3).
- RA05.10 - Knowing the main functions performed by a database management system (CG1, CG2, CG3, CG5, CG6, CG7, CG8, CG9, CG11, CG12, CG13, CG14, CG15, CG16, CG17, CG18, CG19, CG21, CG22, CG23, CG24, CE3).
- RA05.11 - Designing data models for simple problems (CG1, CG2, CG3, CG5, CG6, CG7, CG8, CG9, CG11, CG12, CG13, CG14, CG15, CG16, CG17, CG18, CG19, CG21, CG22, CG23, CG24, CE3).
- RA05.12 - Using basic expressions to query and modify information stored in a database (CG1, CG2, CG3, CG5, CG6, CG7, CG8, CG9, CG11, CG12, CG13, CG14, CG15, CG16, CG17, CG18, CG19, CG21, CG22, CG23, CG24, CE3).
- RA05.13 - Identifying some database management systems used in professional engineering environments (CG1, CG2, CG3, CG5, CG6, CG7, CG8, CG9, CG11, CG12, CG13, CG14, CG15, CG16, CG17, CG18, CG19, CG21, CG22, CG23, CG24, CE3).
- RA05.14 - Identifying the main application programs used in professional engineering environments (CG1, CG2, CG3, CG5, CG6, CG7, CG8, CG9, CG11, CG12, CG13, CG14, CG15, CG16, CG17, CG18, CG19, CG20, CG21, CG22, CG23, CG24, CE3).
- RA05.15 - Understanding the concept of algorithm and the abstraction process of a problem in programming environments (CG1, CG2, CG3, CG5, CG6, CG7, CG8, CG9, CG11, CG12, CG13, CG14, CG15, CG16, CG17, CG18, CG19, CG21, CG22, CG23, CG24, CE3).
- RA05.16 - Identifying the development process of a software in a Software Engineering context (CG1, CG2, CG3, CG5, CG6, CG7, CG8, CG9, CG11, CG12, CG13, CG14, CG15, CG16, CG17, CG18, CG19, CG21, CG22, CG23, CG24, CE3).
- RA05.17 - Recognizing the elementary data structures provided by a structured programming language (CG1, CG2, CG3, CG5, CG6, CG7, CG8, CG9, CG11, CG12, CG13, CG14, CG15, CG16, CG17, CG18, CG19, CG21, CG22, CG23, CG24, CE3).
- RA05.18 - Handling the elementary control structures of a structured programming language (CG1, CG2, CG3, CG5, CG6, CG7, CG8, CG9, CG11, CG12, CG13, CG14, CG15, CG16, CG17, CG18, CG19, CG21, CG22, CG23, CG24, CE3).
- RA05.19 - Abstracting operations (CG1, CG2, CG3, CG5, CG6, CG7, CG8, CG9, CG11, CG12, CG13, CG14, CG15, CG16, CG17, CG18, CG19, CG21, CG22, CG23, CG24, CE3).
- RA05.20 - Designing small applications to solve elementary problems in collaborative work environments (CG1, CG2, CG3, CG5, CG6, CG7, CG8, CG9, CG10, CG11, CG12, CG13, CG14, CG15, CG16, CG17, CG18, CG19, CG20, CG21, CG22, CG23, CG24, CE3).
The breakdown into topics and sections of the subjects covered by this subject is as follows:
- General vision of computer science and its application in the context of this engineering .
- How computers systems represent information.
- Hardware and software components of a computer system.
- Structure a computer and general workflow.
- Peripheral devices.
- System interconnection.
- Software types.
- Computer system types and contexts of application.
- Operating systems used in professional engineering environments.
- Introduction to programming.
- Development of small software applications.
- Introduction to databases.
- Data Base Management Systems used in professional engineering environments.
Generic description of the laboratory practices corresponding to each theoretical topic:
- Introduction to the tools in the laboratory (1h).
- The spreadsheet as a tool ( (3h).
- Design, implementation, and exploitation of a database (6h).
- Programming (18h).
Those contents are structured using the following organization:
UNIT I: Introduction.
- Topic 1: Introduction to computer science: information representation and basic elements of a computer.
UNIT II: Data bases.
- Topic 2: Introduction to databases: systems, entity-relationship model, and relational model.
UNIT III: Programming:
- Topic 3: Introduction to programming: concept of program, control structures, and Python programming language.
UNIT IV: Computer’s workflow:
- Topic 4: Hardware y software.
- Topic 5: Operating systems.
The student's face-to-face activities will consist of attending lectures, laboratory practices and group tutorials. In the lectures, the teacher will alternate the presentation of the theoretical contents of the subject with the realization of examples and exercises on them, encouraging as much as possible the participation of the students in solving problems, collaborating with their classmates in small groups. On the contrary, the laboratory practices will be individual, to ensure the acquisition of basic practical skills by each student.
The group tutorials will be dedicated to the sharing by the students of the doubts and difficulties that have arisen during the learning process. Academic tutoring will take place at the time established for this purpose by each professor, and can be contacted through the professor's email.
The lecture activities will consist of the study of the theoretical matter, the realization of the exercises and problems that the professor proposes or publishes through the Virtual Campus.
The course requires a total of 150 hours between the student's face-to-face and non-face work.
The estimated breakdown of the work by subject is as follows (every two hours of theory and practice classes correspond to one week)
IN-CLASS WORK | OUT OF CLASS WORK | ||||||||
SUBJECT | Horas totales | Lectures | Laboratory | Group tutoring | Evaluation sessions | Total | Group Work | Independent Work | Total |
INT | 10 | 2 | 4 | 6 | 4 | 4 | |||
HSW | 17 | 3 | 3 | 14 | 14 | ||||
OS | 17 | 3 | 3 |
| 14 | 14 | |||
DB | 28 | 5 | 6 | 11 | 17 | 17 | |||
Py | 74 | 15 | 18 | 33 | 41 | 41 | |||
- | 4 | 2 | 2 | 4 | |||||
Total | 150 | 28 | 28 | 2 | 2 | 60 | 20 | 70 | 90 |
The summary by work modalities is shown below:
MODALITY | Horas | % | Totales | |
In-class | Lectures | 28 | 18.7 | 60 |
Laboratory | 28 | 18.7 | ||
Group Tutoring | 2 | 1.3 | ||
Evaluation Sessions | 2 | 1.3 | ||
Out of class | Group Work | 20 | 13.3 | 90 |
Independent Work | 70 | 46 | ||
Total | 150 | 150 |
1. Ordinary call
Two different evaluation models will be distinguished during the ordinary call: CONTINUOUS EVALUATION and NON-CONTINUOS EVALUATION.
IMPORTANT: Those students attending to 50% or more of the evaluation activities proposed in CONTINUOUS EVALUATION will not be able to attend to the exams proposed in NON-CONTINUOUS EVALUATION.
CONTINUOUS EVALUATION
The final mark in this call will be calculated using the following elements: theory exam, laboratory exam, laboratory tests, laboratory deliverable, and oral exposition.
- Theory exam mark (T). This mark will be calculated using the mark of one or several tests scheduled during the theory classes. The mark of such tests will account for 40% of the final score. Every test used to calculate the theory mark (T) will have the same relative weight to obtain a final score. Type of evaluation: SE1 of the “Memoria Verificada”.
- Laboratory tests (cP). The student will be asked to perform some tests about the tools used to operate with spreadsheets and databases. Those tests will be performed during the laboratory sessions. Two tests will be proposed, each one of them will account for 15% of the final score. The combination of both tests accounts for 30% of the final score. Type of evaluation: SE3 of the “Memoria Verificada”.
- Laboratory exam (eP). The student will be asked to solve one or several programming exams using the computer. These exams will account for 15% of the final score. Type of evaluation: SE1 of the “Memoria Verificada”.
- Laboratory deliverable (tP). The student will be asked to submit a programming script in the Virtual Campus according to some instructions given by the laboratory teachers. Such task will account for 15% of the final score. Type of evaluation: SE2 of the “Memoria Verificada”.
- Oral exposition (O). The students will be organized in teams and each team will be asked to perform an oral exposition. This work will account for 10% of the final score. Type of evaluation: SE2 of the “Memoria Verificada”.
Every evaluation item will be qualified with a numerical score between 0 and 10. However, when we add the weights described in the previous list, we obtain an accumulated weight of 110% and, therefore, the possibility of getting a final mark of 11. The final mark in this subject will not be higher than 10 in any case. In case that a student obtains partial scores high enough so its combination using the formula proposed result in a mark higher than 10, that mark will be reduced to 10. The rest of the score will be used to decide which students get the maximum qualification “Matrícula de Honor” in case there are too many candidates able to obtain such score.
Tu sum up, the formula to calculate the final numerical mark will be the following one:
MARK = 0.4 · T + 0.3 · cP + 0.15 · eP + 0.15 · tP + 0.10 · O,
Just in case MARK is not higher than 10. Otherwhise, MARK will be reduced to 10.
To pass this subject in the ordinary call, two extra conditions must be met by the student:
- The student must attend to at least 70% of the laboratory hours.
- The student must obtain a score of at least 4 in the following evaluation items:
- Theory mark (T).
- Laboratoy tests (cP).
- Combined score of the programming section ( (eP + tP)/2).
In case one or more of those conditions are not met, the student will not be able to pass this subject in the ordinary call. In case the student, fails to meet such conditions but her weighted numerical score is higher than 5, then the student will get a final qualification of “4.5 – Suspenso” in the ordinary call.
To obtain any qualification in the ordinary call using this evaluation model, the student must attend to at least 50% of the evaluation events. Otherwise, it will be considered that the student cannot be evaluated using the CONTINUOUS EVALUATION model.
NON-CONTINUOUS EVALUATION
Those students that did not have obtained a qualification using the CONTINUOUS EVALUATION model will still be able to pass this subject during the ordinary call by attending to some exams whose nature is similar to the ones described for the CONTINUOUS EVALUATION model. Such exams will be performed during January’s official call. In such case, the final mark will be calculated using the following elements:
- Theory exam (fT): 40%.
- Laboratory exam about spreadsheets and databases (fP1): 30%.
- Laboratory exam about programming (fP2): 30%.
The final mark will be calculated using the following formula:
MARK = 0.4 · fT + 0.3 · fP1, + 0.3 · fP2
In addition, to pass the subject the student must obtain a score of at least 4 at each exam. In case this condition is not met but the student obtains a numerical mark of 5 or higher using the previous formula, then the student will get a final qualification of “4.5 – Suspenso” in the ordinary call.
2. Extraordinary call
The evaluation items and formula to obtain a final mark during the extraordinary call are the same as the ones described for the model NON-CONTINUOUS EVALUATION of the ordinary call. However, some exceptions will be considered to calculate a final score.
- In case the student had already obtained a score of 5 or higher in any of the items used to compute the final mark in a previous call (of the current academic year), then that partial score will be kept and the student will not have to pass the exam of such part of the subject again. This situation can happen in three different items used to compute the final mark.
- Theory passed (T in CONTINUOUS EVALUATION or fT in the rest of cases). This score will be used as fT to calculate the final mark.
- Laboratory tests passed (cP in CONTINUOUS o fP1 in the rest of cases). This score will be used as fP1 to calculate the final mark.
- Programming passed (combined score of eP y tP in CONTINUOUS EVALUATION, or fP2 in the rest of cases). This score will be used as fP2 to calculate the final mark.
- If, during CONTINUOUS EVALUATION, the students obtained a score of 5 of higher in the oral exposition (O), then the formula used to calculate the final mark in this call will be the following one:
MARK = 0.36 · fT + 0.27 · fP1, + 0.27 · fP2 + 0.1 · O
This new formula will only be used in case that it helps the student, i.e., if using the O score with the formula results in a better mark compared with the formula that only uses fT, fP1, and fP2. If this is not the case, then O will not be used to calculate the final mark.
3. Differentiated evaluation
Students with differentiated evaluation will get a mark that combines a theory exam (eT) and a practical exam (eP). This practical exam will include a separated mark for programming skills (bP) and spreadsheet and database related skills (bHB). These marks will have an identical importance to obtain a general mark for the practical exam: each partial mark will account for 50% of the practical exam (eP). The final mark for the subject will be obtained using the following formula:
MARK = 0.5 · eT + 0.25 * bP + 0.25 bHB
In addition, in order to pass the subject, it will be necessary to obtain a mark of at least 5 in both the theory exam (eT) and the practical exam (eP, computed as the average between bP and bHB).
This mechanism of differentiated evaluation could be replaced by a different one adapted to a each student, in light of what is stated at "artículo 7 del Reglamento de evaluación" from University of Oviedo.
The materials posted in the Virtual Campus are considered enough to completely fulfill every learning goal defined in this guide.
The following bibliography list proposes complementary materials to go deeper into the concepts described in this subject:
Data bases:
- (ESP) Fundamentos de Diseño de Bases de Datos. Quinta Edición. A. Silberschatz, H.F. Korth, S. Sudarshan. McGraw-Hill, 2006 (libro de texto).
- (ESP) Fundamentos de Bases de Datos. A. Silberschatz, H.F. Korth, S. Sudarshan. McGraw-Hill, 4ª, 5ª, 6ª edición, 2006-2014 (libro de texto, versión ampliada).
- (ENG) Database System Concepts. 4th, 5th, 6th, or 7th edition. A. Silberschatz, H.F. Korth, S. Sudarshan. McGraw-Hill, 2001-2019 (textbook).
Operating Systems:
- (ESP) Sistemas Operativos. Una visión aplicada.; J. Carretero, F. García, P. de Miguel, F. Pérez, 2ª edición (2007). McGraw Hill.
- (ESP) Fundamentos de Sistemas Operativos; A. Silberschatz, P.B. Galvin, G. Gagne; 7ª edición (2005). McGraw Hill.
- (ENG) Operating Systems: Three Easy Pieces; Arpaci-Dusseau, Remzi H. Arpaci-Dusseau y Arpaci-Dussea, Andrea C. (2015). Disponible en http://pages.cs.wisc.edu/~remzi/OSTEP/
Programming:
- (ENG) Python Programming: An Introduction to Computer Science; J. Zelle; 2nd Edition. Franklin, Beedle Associates Inc., 2010
- (ENG) Python in a Nutshell ; A. Martelli; Second Edition. O’Reilly Media, 2006.
- (ESP) Python 3 - Los fundamentos del lenguaje; S. Chazellet; CNI, tercera edición, 2020.
The software used during this subject is described in the following list:
- Spreadsheets: Preferably, Microsoft Excel.
- Databases: Microsoft Access.
- Python software development: Pycharm (JetBrains) or, alternatively, PyScripter.
At the release time of this guide, every software proposed is free to use or can be used with a free license that can be obtained using the student’s University credentials. We recommend every student to install the software mentioned in their personal computers.