Assessment

Continous Assessment Activities

Title	Weighting	Hours	ECTS	Learning Outcomes
Individual exams of Theory, Problems and Practicum (re-evaluation)	70%	4	0.16	11, 12, 6, 2, 3, 4, 10, 5, 7
Individual partial exams of theory, exercicies i practicum	70%	4	0.16	11, 12, 6, 2, 3, 4, 10, 5, 7
SQL on-line Query Module	10%	2.2	0.09	10, 7, 9
Technical Report of a Use Case	20%	3.8	0.15	1, 12, 6, 10, 9, 8

EVALUATION CRITERIA

The evaluation of the course consists of 3 parts that contains: theory evaluation, problems evaluation, the writing of a technical report, practical work evaluation and autonomous resolution of SQL queries.

• INDIVIDUAL PARTIAL EXAMS OF THEORY, PROBLEMS and PRACTICES. There will be two individual written exams (Nota_Parcial1 35%, Nota_Partial2 35%, with a total weight of 70% in the final grade). The first test (for theory and problems) will be done approximately halfway through the semester and the second test (for theory, problems and practicals) will be done at the end of the semester during the exam period in the IT classrooms.

• AUTONOMOUS WORK (Nota_InfTec and Nota_AutoAval). It will be divided into two blocks: Technical report of a case-of-use (with a weight of 20%) and resolution of autonomous queries in the SQL Query Module (with a weight of 10%). To score in the first, a technical report must be submitted consisting of 4 parts corresponding to the 4 design phases of a DB: requirements, ER diagram, logical table model and implementation / test set. The document must be delivered in a previously defined format and must be suitable for 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 because it cannot be evaluated. The technical report will be delivered in two parts, a first delivery in the middle of the semester and a second delivery at the end of the semester. The final grade of the technical report (with a weight of 20%) will be calculated from the two grades (grade 1 and grade 2) as follows:
             Nota_InfTec = max [(grade1 + grade2) / 2; 0.7 * note2].
  The Nota_AutoAval (with a weight of 10%) is obtained from the autonomous resolution of SQL queries (care practices) that will take place outside the class schedule. They consist of several SQL query modules available in Charon that are open for certain periods of time specified in the module itself. The grade will be proportional to the number of questions answered throughout the course and their difficulty.
• FINAL GRADE: The final grade of the course (Notal_Final) will be the weighted average of the grades in each part (see table of assessment activities) and will be calculated as follows:

                   Nota_Final =0.35 * Nota_Parcial1 + 0.35 * Nota_Parcial2 +  0,2 * Nota_InfTec + 0,1 * Nota_AutoAval

It will be a necessary condition to carry out this calculation that each of the components has a score higher than zero, and that the average mark obtained in the individual written tests (PEI mark) is equal to or higher than 4. The student who does not meet these conditions shall apply the reassessment criteria detailed below.

• CONTINUOUS EVALUATION: The process of continuous evaluation includes these activities: Technical Report of a Use Case (supervised group activity), SQL Queries Module (supervised individual activity) and Parcial Exams (recoverable synthesis test)

You must have a Nota_Final equal to or greater than 5 to pass the course. A student is considered “non-assessable” only if he or she has not completed any assessment activity.

RE-EVALUATION CRITERIA

Students who have failed the subject applying the above criteria and who are in one of the following two situations will be eligible for the re-evaluation process:

(A) Meet the conditions to be able to calculate the Nota_Final, but the total grade obtained is equal to or greater than 3.5 and less than 5; (Nota_Parcial1,2 ≥  3 però amb 3,5 ≤ Nota_Final < 5)

(B) They obtained a grade lower than 3 in partial1 and/or partial2, but if the weightings described above were applied, the final grade for the subject would be equal to or higher than 5; (Partial_Grade1 and/or Partial_Grade2 < 3 but with Final_Grade ≥ 5)

In this re-evaluation test, which will be written and carried out within the last week of the semester, the students will be re-evaluated for the partials that have not passed the conditions. To pass the re-evaluation, a grade equal to or higher than 5 must be obtained for the part being evaluated. In case of retaking and passing the corresponding partials, the final mark for each partial will be 5 and the final mark of the subject will be the maximum between [formula Nota_final, 5].

In the case of not fulfilling the conditions to pass the subject, the final grade will be the minimum between the individual written tests (Nota_Final) and a 4.5.

OTHER IMPORTANT INFORMATION

• REGISTRATION IN CARONTE: It is mandatory to register in Caronte (http://caronte.uab.cat) at the beginning of the course, as the class materials, tasks and grades will be published there. To register in Caronte, you must enter your personal details and a passport-type photo in JPG format. This information will be strictly private and will be destroyed once the course is over.
• VALIDATIONS: There is no special treatment for students who repeat the course.
• RE-EVALUATION OF PRACTICAL WORK: Practical work will not be re-evaluated aside from the rest of the content. However, the re-evaluation exam will contain written SQL exercises similar to those in the SQL Query Module.
• • HONORS: Students who have a final grade of 9 or higher may have an honours degree (“Matrícula de Honor” or MH) up to the limit of 5% of registered students, in accordance with UAB regulations. If there are more than 5% of students with grades above 9, those with the highest grades will have an MH.
• COPY / PLAGIARISM: Without prejudice to other appropriate disciplinary measures, irregularities committed by studentsthat may lead to an unlawful change of the grade will result in a zero (0) mark. Therefore, copying, plagiarizing, deceiving, allowing others to copy, and so on in any of the evaluation activities will result in a failure with a mark of zero (0). Assessment activities qualified in this way and described in this procedure will not be recoverable. If it is necessary to pass any of these assessment activities to pass the course, the course will be failed directly, without the possibility of re-evaluation it in the same course. In the case of the technical report, all the groups involved will be graded with a zero (0), regardless of the authorship of the work.

These regulations include, among others:

• the total or partial copy of a practice, report, or any other assessment activity.
• allow others to copy.
• present group work not done entirely by group members.
• present as their own materials prepared by a third party, even if they are translations or adaptations, e.g., work containing non-original elements.
• possess communication devices (such as mobile phones, smart watches, etc.) accessible during individual theoretical or practical assessment (exams).

CALENDAR OF EVALUATION ACTIVITIES

The dates of the different evaluation activities (in-person exercises, assignments, etc.) will be announced well in advance during the semester.

The dates of the midterm exams, final exams and re-evaluations will be shown in the official faculty exam schedule.

"The schedule of assessment tests may not be modified unless there is an exceptional reason, and it is duly justified for the purpose of an assessment. In this case, those responsible for the grades, after consulting the teachers and students affected, will propose a new program within the corresponding academic period." Section 1 of article 115. Calendar of evaluation activities (UAB Academic Regulations)

QUALIFICATION REVIEW PROCEDURE

The dates of continuous evaluation and delivery of works will be published in Caronte and may be subject to scheduling changes to adaptation to possible incidents. Caronte will always inform about these changes as it is understood that this is the usual platform for information exchange between teachers and students.

For each assessment activity, a place, date, and time of grade revision will be indicated where the student will be able to challenge the marks obtained in the activity with the teacher. In this context, students may argue to change the marks, and such claims will be evaluated by the responsible teacher. If the student does not come to this review, the activity will not be reviewed later.

RE-EVALUATION PROCESS

"To participate in the re-evaluation process, students must have been previously assessed in a set of activities that represent a minimum of two-thirds of the total grade of the subject or module." Article 3 of Article 112b. Recovery (UAB academic regulations). To be able to re-evaluate, the student must have obtained an average grade of the course between 3.5 and 4.9.

The date of this re-evaluation exam will be scheduled in the faculty exam calendar. The student who is present and passes it, will obtain a grade of 5.

UNIQUE ASSESSMENT

• Theory, problems and practicals exam (Nota_AUnica): a single written theory, problems and practicals exam on the computer for all the subjects of the subject with a maximum duration of 4 hours. This exam will be held on the same day as the second term in the end-of-semester exam period.

                Anecessary condition to carry out this calculation that each of the components has a score equal to or higher than 4. The student who does not meet these conditions must apply the reassessment criteria detailed below.

• RECOVERY: students who have obtained a grade of less than 5 and equal to or greater than 3.5 in Nota_AUnica (3.5 ≤ Nota_AUnica < 5) may be admitted to the recovery process. In this re-evaluation test, which will be written and carried out within the last week of the semester, the student will be re-evaluated in all the contents of the subject. To pass the reassessment, a grade equal to or higher than 5 must be obtained. In case of approval, the final grade of the subject will be "passed" (a 5). In the case of breaching the conditions to pass the subject, the minimum between the individual tests (Nota_AUnica) and a 4.5 will be placed on the file.

• Review of the final grade: The review of the final grade follows the same procedure as for the continuous assessment.

IRREGULARITIES IN EVALUATION ACTS

Notwithstanding other disciplinary measures deemed appropriate, and in accordance with current academic regulations, "in the event that the student commits any irregularity that may lead to a significant variation in the grade of an assessment act, this act will be graded with zero, regardless of any other disciplinary process that may be instructed. If there are several irregularities in the assessment of the same subject, the final grade of the subject will be zero." Article 10 of Article 116. Results of the evaluation. (UAB Academic Regulations).