Assessment

EVALUATION CRITERIA

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

• INDIVIDUAL PARTIAL EXAMS OF THEORY AND PROBLEMS (Nota_Teoria_Probl). There will be two individual written exams (the Nota_Teoria_Probl grade will be the average of these two grades, with a total weight of 40% in the final grade). The first exam will take place in the middle of the semester and the second exam will take place at the end of the semester during the exam period.
• EVALUATION OF INDIVIDUAL PRACTICAL EXERCISES (Nota_Pract). The evaluation of the practical exercises (with a weight of 30%) will be done by means of a series of SQL queries in the last practical session, where the student will be able to obtain his/her grade at the end of the exam. The format of these will be the same as in the self-learning module.
• INDIVIDUAL WRITTEN TESTS (Nota_PEI): The two previous grades will be averaged to calculate the grade of the individual written tests as follows:

                 Nota_PEI = (0,4*Nota_Teoria_Probl + 0,3*Nota_Pract) / 0,7

• 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,4 * Nota_Teoria_Probl + 0,3 * Nota_Pract + 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 Theory and Problem Exam (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_PEI ≥ 4 but with 3.5 ≤ Nota_Final <5)

(B) They have obtained a grade lower than 5 in the set of individual written tests, but if the weights described above were applied, the final grade of the subject would be equal to or higher than 5; (Nota_PEI <4 but with Nota_Final ≥ 5)

In this re-evaluation test, which will be written and will be 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 re-evaluation, a grade equal to or higher than 5 must be obtained. In case of approval, the final mark of the subject will be “approved” (a 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_PEI) 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 students that 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.

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).