Study programme competencies |
Code
|
Study programme competences / results
|
A7 |
CE7 - Interpretar los datos obtenidos mediante medidas experimentales y simulaciones, incluyendo el uso de herramientas informáticas, identificar su significado y relacionarlos con las teorías químicas, físicas o biológicas apropiadas. |
A10 |
CE10 - Comprender la legislación en el ámbito del conocimiento y la aplicación de la Nanociencia y Nanotecnología. Aplicar principios éticos en este marco. |
B2 |
CB2 - Que los estudiantes sepan aplicar sus conocimientos a su trabajo o vocación de una forma profesional y posean las competencias que suelen demostrarse por medio de la elaboración y defensa de argumentos y la resolución de problemas dentro de su área de estudio |
B3 |
CB3 - Que los estudiantes tengan la capacidad de reunir e interpretar datos relevantes (normalmente dentro de su área de estudio) para emitir juicios que incluyan una reflexión sobre temas relevantes de índole social, científica o ética |
B4 |
CB4 - Que los estudiantes puedan transmitir información, ideas, problemas y soluciones a un público tanto especializado como no especializado |
B5 |
CB5 - Que los estudiantes hayan desarrollado aquellas habilidades de aprendizaje necesarias para emprender estudios posteriores con un alto grado de autonomía |
B6 |
CG1 - Aprender a aprender |
B7 |
CG2 - Resolver problemas de forma efectiva. |
B10 |
CG5 - Trabajar de forma colaborativa. |
B11 |
CG6 - Comportarse con ética y responsabilidad social como ciudadano/a y como profesional. |
B12 |
CG7 - Comunicarse de manera efectiva en un entorno de trabajo. |
C1 |
CT1 - Expresarse correctamente, tanto de forma oral coma escrita, en las lenguas oficiales de la comunidad autónoma |
C2 |
CT2 - Dominar la expresión y la comprensión de forma oral y escrita de un idioma extranjero |
C3 |
CT3 - Utilizar las herramientas básicas de las tecnologías de la información y las comunicaciones (TIC) necesarias para el ejercicio de su profesión y para el aprendizaje a lo largo de su vida |
C5 |
CT5 - Entender la importancia de la cultura emprendedora y conocer los medios al alcance de las personas emprendedoras |
C7 |
CT7 - Desarrollar la capacidad de trabajar en equipos interdisciplinares o transdisciplinares, para ofrecer propuestas que contribuyan a un desarrollo sostenible ambiental, económico, político y social. |
C8 |
CT8 - Valorar la importancia que tiene la investigación, la innovación y el desarrollo tecnológico en el avance socioeconómico y cultural de la sociedad |
C9 |
CT9 - Tener la capacidad de gestionar tiempos y recursos: desarrollar planes, priorizar actividades, identificar las críticas, establecer plazos y cumplirlos |
Learning aims |
Learning outcomes |
Study programme competences / results |
To understand the fundamental aspects of computer science |
|
B4 B5 B6 B10 B11 B12
|
C1 C2 C3 C5 C8
|
To know the basic architecture and operation of a computer |
|
B2 B5 B6
|
C3 C8
|
To know how information is represented internally in a computer |
A10
|
B6
|
C1 C2 C5 C8
|
To learn the fundamentals of operating systems and databases. |
A7 A10
|
B2 B3 B7 B10 B11 B12
|
C1 C2 C3 C7 C9
|
To learn and understand the fundamentals of different programming paradigms |
A7
|
B2 B5 B6 B7 B10 B11 B12
|
C3
|
Contents |
Topic |
Sub-topic |
1. Operating systems |
- File Systems
- Command line
- Users, profiles and access types |
2. Introduction to programming |
- What is a programming language
- Data types and operators
- Control statements
- Functions and procedures
- Use of libraries
- Good programming habits |
3. Relational databases |
- Relational model
- Entity-relational model
- The SQL language |
4. Networks |
- Introduction and layer model
- Link and network layer configuration |
Planning |
Methodologies / tests |
Competencies / Results |
Teaching hours (in-person & virtual) |
Student’s personal work hours |
Total hours |
ICT practicals |
A7 B2 B6 B7 C3 C7 C8 C9 |
12 |
34 |
46 |
Seminar |
A7 B2 B6 B7 C3 C8 |
8 |
8 |
16 |
Mixed objective/subjective test |
A7 B2 B3 B4 B6 B7 B11 C3 C6 C9 |
2 |
0 |
2 |
Guest lecture / keynote speech |
A7 A10 B2 B3 B4 B5 B6 B7 B10 B11 B12 C1 C2 C3 C5 C6 C8 |
28 |
56 |
84 |
|
Personalized attention |
|
2 |
0 |
2 |
|
(*)The information in the planning table is for guidance only and does not take into account the heterogeneity of the students. |
Methodologies |
Methodologies |
Description |
ICT practicals |
In the practical sessions the student will perform tasks such as operating system management, coding programs in Python language and database design and management. The instructions for each assignment will be provided sufficiently in advance so that students can make the best use of their time. It is the teacher's mission to supervise the code generated by the student to resolve doubts, correct bad programming styles, and correct errors. |
Seminar |
In the seminar sessions, exercises and practices will be carried out to detect the students' gaps of knowledge in the subject taught until that moment, and give the necessary explanations and/or references to amend them. |
Mixed objective/subjective test |
In the evaluation period, a test of theoretical knowledge and practical problem solving will be carried out to evaluate the student's acquisition of the competencies. |
Guest lecture / keynote speech |
In the theory sessions, the teacher describes the objectives and contents of the subject, in order to give a particular vision of the topic to be treated and relate it to others within the subject. Then the corresponding topic is developed through a master session, using the technical tools available, emphasizing specific issues in which the student must deepen their self-learning. The objective is for students to acquire the necessary computer skills to adequately develop their academic and professional lives. Python will be used as the coding language. |
Personalized attention |
Methodologies
|
Seminar |
ICT practicals |
|
Description |
In the lecture sessions as well as in the practical laboratories and in the seminar sessions, personalized attention will be given to the student, at different levels according to the type of class, detecting the level of assimilation and understanding of the topics explained and the required practices to be implemented.
The seminar sessions are where the student can be more easily reached to know the gaps in their knowledge and indicate how to cover them.
Any doubts and questions will be resolved during class hours or in the hours established as tutorials for each professor. |
|
Assessment |
Methodologies
|
Competencies / Results |
Description
|
Qualification
|
Seminar |
A7 B2 B6 B7 C3 C8 |
The seminar hours will have mechanisms to evaluate the student's progress. This evaluation will be reflected in 10% of the final grade. |
10 |
ICT practicals |
A7 B2 B6 B7 C3 C7 C8 C9 |
Throughout the course there will be three ICT practical works, amounting to a maximum value of 40% of the final grade. |
40 |
Mixed objective/subjective test |
A7 B2 B3 B4 B6 B7 B11 C3 C6 C9 |
The final exam will consist of theoretical questions and several exercises to put into practice the acquired competences.
The final exam will have a maximum value of 50% of the final grade. |
50 |
|
Assessment comments |
To pass the subject, the student must obtain a minimum grade of 5 out of 10 in the result of combining the grades of the evaluable activities. In addition, the student must obtain a minimum grade of 4.5 out of 10 points in the mixed test. If this minimum grade is not reached, the grade for the subject will correspond to the grade for the mixed test.
Attendance to practical classes and seminars is mandatory to pass the course.
A / a student will be considered presented / a in a call if he takes the evaluation test of any practice, if he appears to any evaluable seminar or if he appears to the mixed test.
Second chance and subsequent calls On the second opportunity, the grade obtained in practices and seminars is maintained. Students who take this second opportunity must take the mixed test. Optionally, they may re-take the practical evaluation tests on the second opportunity, with the grade obtained on said second opportunity being the one that prevails, regardless of whether it is higher or lower than that achieved on the first opportunity. If you do not take the evaluation test of any of the practices, the grade obtained at the first opportunity will be maintained.
In case of failing the subject, if a mark equal to or greater than 5 has been obtained in the joint qualification of the practices, a grade of pass (5) may be saved for the subsequent course in the practices section if the student so wishes. want. Students who take advantage of this possibility will be exempted from attending practical classes. The internship grade will not be saved for more than one academic year. The grade from the seminars will not be saved for later courses, and the student must carry out the activities corresponding to this section again.
Enrollment with academic waiver For students enrolled with academic exemption, the obligation to attend practical classes and seminars is eliminated. They must deliver the practices on the established dates or look for a date as close as possible. It is the responsibility of these students to inform the teacher of her circumstance.
|
Sources of information |
Basic
|
Alan Beaulieu (2009). Learning SQL (2ª Edición). O'Reilly
A. Silberschatz; H. Korth; S. Sudarshan (2019). Database System Concepts (7a edición). McGraw Hill
Luis Joyanes Aguilar (2011). Fundamentos de programación: algoritmos, estructuras de datos y objetos. Madrid
Raúl González Duque (). Python para todos. http://edge.launchpad.net/improve-python-spanish-doc/0.4/0.4.0/+download/Python%20para%20todos.pdf
James F. Kurose, Keith W. Ross (2008). Redes de computadores: un enfoque descendente basado en Internet. Addison Wesley |
|
Complementary
|
Mark Lutz (2013). Learning Python, Fifth Edition. O'Reilly Media, Inc
Jesús J. García Molina, Francisco J. Montoya Dato, José L. Fernández Alemán, Ma José Majado Rosales (2005). Una introducción a la programación: un enfoque algorítmico. Thomson |
|
Recommendations |
Subjects that it is recommended to have taken before |
|
Subjects that are recommended to be taken simultaneously |
|
Subjects that continue the syllabus |
|
Other comments |
Office hours Office hours are considered an important part of the development of the course. They are oriented in such a way that the students have and/or can consult different questions such as: 1. Problems in the development of the assignments. 2. Ways of approaching/organizing the assignments. 3. Resolution of doubts about theoretical issues. Students will be asked to request appointments with the responsible professors for video calls via Teams or face-to-face meetings within the tutoring schedules of the faculty established in espazos.udc.es.
Other recommendations: Read: Read the topic to be covered before attending the theoretical sessions, this is very important! Attend: Pay attention in class, do not simply sit in the classroom. Understand: Understand what you are told in the theory sessions and, if not, ask questions. Ask: Ask questions if you do not understand, do not remain with doubts. Study: Study after the sessions, to retain what is understood. Practice: Do many exercises, both those suggested and others on your own, both on paper and on the computer. Gender perspective: as stated in the transversal competences of the degree (C4), the development of a critical, open and respectful citizenship with diversity in our society will be encouraged, highlighting the equal rights of students without discrimination for reasons of gender or sexual condition. Inclusive language will be used in the material and in the development of the sessions. Work will be done to identify and modify prejudices and sexist attitudes and the environment will be influenced to modify them and promote values of respect and equality. Green Campus Faculty of Sciences Program: to help achieve a sustainable immediate environment and comply with point 6 of the "Environmental Declaration of the Faculty of Sciences (2020)", the documentary work carried out in this matter will be requested in virtual format and computer support. If done on paper, plastics will not be used, double-sided printing will be done, recycled paper will be used and drafts will be avoided.
|
|