Assessment

Continous Assessment Activities

Title	Weighting	Hours	ECTS	Learning Outcomes
E-R design problems evaluation	20	1.5	0.06	CM19, KM26, SM22
Practical work evaluation	20	2	0.08	CM19, KM26, SM22
Resolution of SQL queries	10	2	0.08	SM22
Technical report	20	0.5	0.02	CM19, KM26, SM22
Theory evaluation	30	2	0.08	CM19, KM26, SM22

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, it would 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 in the last week of the semester, the student will be evaluated again in all the contents of the course. To pass the re-evaluation, a grade greater than or equal to 5 must be obtained. In that case, the final grade of the course will be "approved" (a 5).

In the case of not complying with the conditions to pass the course, the final grade will be the minimum between the written individual tests (Nota_PEI) and 4.5.

 

OTHER IMPORTANT INFORMATION

 

• REGISTRATION IN CARONTE: Students should register in Caronte (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.
• HONOR REGISTRATIONS: Students who have more than 9 in the final mark will have an honor matriculation (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 to those who have the highest marks.
• 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 procedure will not be recoverable. If it is necessary to pass anyof 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.
• SINGLE ASSESSMENT MODALITY: This course does not offer a single assessament modality

 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 cannot be 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 participatein the retake process, it is required for students to have been previously been 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).