Assessment

Continous Assessment Activities

Title	Weighting	Hours	ECTS	Learning Outcomes
Autonomous SQL query resolution	10	2	0.08	KM15, SM17
E-R design problems evaluation	20	1.5	0.06	CM17, CM18
Practical exam	20	2	0.08	KM15, SM17
Technical report	20	0.5	0.02	CM17, CM18, KM15, SM16, SM17
Theory exam	30	2	0.08	CM17, CM18

EVALUATION CRITERIA

The evaluation of the course consists of 5 parts: theory evaluation, evaluation of E-R design problems, writing a technical report, evaluation of practices and autonomous resolution of SQL queries.

• E-R DESIGN PROBLEMS EVALUATION and THEORY EVALUATION (Nota_Probl and Nota_Teoria). There will be two written individual exams, with a weight of 20% and 30% in the final grade respectively. The first will be conducted approximately in the middle of the semester and will evaluate the basic concepts and skills acquired for the design of a database (E-R model). The second test will be held at the end of the semester and will evaluate the theoretical concepts of the entire course.
• PRACTICAL WORK EVALUATION (Nota_Pract). The evaluation of practical work (with a 20% weight) will be carried out by means of a series of SQL queries in the last practical session where the student will be able to check his mark at the end of the test. The format will be the same as in the autonomous learning module.
• WRITTEN INDIVIDUAL TESTS (Nota_PEI): The above three grades will be averaged to calculate the written individual tests mark:
  
  Nota_PEI = (0.3 * Nota_Teoria + 0.2 * Nota_Probl + 0.2 * Nota_Pract) / 0.7
  
  
• AUTONOMOUS WORK (Nota_InfTec and Nota_AutoAval). It will be divided into two blocks: technical report (20%) and autonomous SQL query resolution (10%). To score in the first one, the students need to write a technical report consisting of 4 parts (corresponding to the 4 phases of DB design: requirements, E-R diagram, logical table model and implementation/test dataset. The document must be delivered in the previously defined format and that must allow a correct reading and interpretation of the diagrams. If a diagram cannot be read clearly for reasons of resolution or quality, this part of the report will be failed, as well as those that depend on it since they cannot be evaluated. The technical report will be delivered in two parts, in the middle and end of the semester. The final grade of the technical report will be calculated from both notes (note1 and note2) as follows: Nota_IT_ = max [(note1 + note2) / 2; 0.7 * note2]. The autonomous SQL queries resolution (auxiliary practical work) will be carried out outside the regular lessons’ timetable through an autonomous online learning module. This module will be open after each practice and will be available until the next practice. The grade will be proportional to the number of questions answered throughout the course and their difficulty.

The final grade (Nota_Final) will be the weighted average of the grades in each part (see table of evaluation activities) and will be calculated as follows:

Nota_Final = 0.2 * Nota_Pract + 0.2 * Nota_InfTec + 0.1 * Nota_AutoAval + 0.2 * Nota_Probl + 0.3 * Nota_Teoria

A necessary condition for this calculation is that each of the components should have a mark greater than zero, and the average mark obtained in the written individual tests (Note PEI) should be equal or greater than 4.5.

You must have a Final Grade equal or greater than 5 to pass the course. A student is considered "Non-evaluated" only if he or she has not done any of the assessment activities.

RE-EVALUATION CRITERIA

Students who have not passed the course after applying the above assessment criteria will be eligible for the re-evaluation only if they fall in one of the following categories:

(A) Meet the conditions for the calculation of the final grade, but the total score obtained is equal to or greater than 3.5 and less than 5; (Nota_PEI ≥ 4,5 but with 3.5 ≥ Nota_Final < 5)

(B) Have obtained a score of less than 4.5 in the written individual tests, but if the final grade was calculated as described above, itwould be equal or higher than 5; (Nota_PEI < 4,5 but with Nota_Final ≥ 5)

In this re-evaluation exam, which will be written and will be carried out the last week of the semester, students will be evaluated again in all the content of the course (Nota_Reeval). The final grade of the course will be obtained by averaging the mark of the reevaluation (Nota_Reeval) and the written individual tests (Nota_PEI). In case this average is greater than or equal to 5, the final grade (Nota_Final) of the course will be "pass" (a 5).

In the case of not being eligible for reevaluation, the final grade will be the minimum between the written individual tests (Nota_PEI) and 4.5.

SINGLE ASSESSMENT MODALITY

Students who have chosen the single assessment modality will take a test consisting of three parts:

• Part (A): theoretical questions that will include the entire syllabus of the course.
• Part (B): design problems (including all design and normalization phases), relational algebra search problems and questions related to the autonomous work (Technical Report).
• Part (C): SQL search problems (to be done on a computer).

The final grade will be the weighted average of the three previous activities, where part (A) will account for 40% of the grade, part (B) 40% and part (C) 20%.

If the final mark does not reach a 5, there will be another opportunity to pass the course through a recovery exam that will be held on the date indicated by the degree coordination committee. In this test it will be possible to resit the parts corresponding to theory and problems (parts A and B). Part C is not recoverable.
In case of obtaining a grade equal to or greater than a five in the recovery exam, the final grade for the subject will be a "pass" (a 5).

OTHER IMPORTANT INFORMATION

• REGISTRATION IN CARONTE: Students should register inCaronte (http://caronte.uab.cat) at the beginning of the course, since coursework materials, practical assignments and final marks are published there. To register in Caronte it is necessary to enter personal data and a photo card in JPG format. This information will remain strictly private and will be destroyed once the course has finished.
• CONVALIDATIONS: There will be no special treatment for students who repeat the course.
• HONOUR GRADE: Students who have more than 9 in the final mark will have an honour grade (MH) up to the limit of 5% of those enrolled, according to UAB regulations. In the case of having more than 5% of the students over 9, MH will be awarded tothose who have the highestmarks.
• PLAGIARISM: Without prejudice to other disciplinary measures that may be considered appropriate, the irregularities committed by any student that can lead to a variation in the markings of an evaluation act will lead to a grade of zero. Therefore, copying, plagiarizing, cheating, copying, etc. in any of the assessment activities it will imply a suspension and result in a zero mark. Assessment activities qualified in this way and by this procedurewill not be recoverable. If it is necessary topass any of these assessment activities to pass the subject, this subject will be suspended directly, without opportunity to recover it in the same course. In the case of the Technical Report, all the groups involved will be punished with zero (0), regardless of the authorship of the work.

 Calendar of evaluation activities

The dates of the evaluation activities (midterm exams, exercises in the classroom, assignments, ...) will be announced well in advance during the semester.

The date of the final exam is scheduled in the assessment calendar of the Faculty.

"The dates of evaluation activities cannot be modified, unless there is an exceptional and duly justified reason why an evaluation activity cannotbe carried out. In this case, the degree coordinator will contact both the teaching staff and the affected student, and a new date will be scheduled within the same academic period to make up for the missed evaluation activity." Section 1 of Article 115. Calendar of evaluation activities (Academic Regulations UAB).

Grade revision process

After all grading activities have ended, students will be informed of the date and way in which the course grades will be published. Students will be also be informed of the procedure, place, date and time of grade revision following University regulations.

Retake Process

"To be eligible to participate in the retake process, it is required for students to have been previouslybeen evaluated for at least two thirds of the total evaluation activities of the subject." Section 3 of Article 112 ter. The recovery (UAB Academic Regulations). Additionally, it is required that the student to have achieved an average grade of the subject between 3.5 and 4.9.

The date of the retake exam will be posted in the calendar of evaluation activities of the Faculty. Students who take this exam and pass, will get a grade of 5 for the subject. If the student does not pass the retake, the grade will remain unchanged, and hence, student will fail the course.

Irregularities in evaluation activities

In spite of other disciplinary measures deemed appropriate, and in accordance with current academic regulations, "in the case that the student makes any irregularity that could lead to a significant variation in the grade of an evaluation activity, it will be graded with a 0, regardless of the disciplinary process that can be instructed. In case of various irregularities occur in the evaluation of the same subject, the final grade of this subject will be 0". Section 10 of Article 116. Results of the evaluation. (UAB Academic Regulations).

Final note: The proposed evaluation activities may undergo some changes according to the restrictions imposed by the health authorities on on-campus courses.