Information on the retake exam for "Information Retrieval, WS 23/24" and "Databases and Information Systems, WS 23/24"

The retake exam took place on Monday 09.09.2024 from 14:00 - 16:30 in two rooms in Building 101 of the Faculty of Engineering (HS 026 and HS 036). A total of 48 students were registered for the exam (IR: 16, DBIS: 32, as of 05.08.2024). A total of 25 students showed up (IR: 10, DBIS: 15).

Here is the PDF of the exam and here is a version of the exam with solutions (strictly for personal use only, only for checking, unsuitable for learning.

The exam was corrected on Monday 09.09.2024. Right after the correction, the points per task and the grade for each student were entered in a file retake-exam-result.txt in the SVN folder of the respective student, as well as in the HISinOne.

Students have the opportunity to give feedback on the retake exam in the forum.

The exam inspection will take place in an asynchronous fashion in Heike Hägle's office (Room 02-025 in building 51). More on the exam inspection procedure will be shared in a separate post in the forum.

Here is the distribution of the grades.

95 - 100   1.0   
90 -  94   1.3   
85 -  89   1.7   (1 time )  *   
80 -  84   2.0   
75 -  79   2.3   
70 -  74   2.7   
65 -  69   3.0   (3 times)  ***
60 -  64   3.3   (5 times)  *****
55 -  59   3.7   (7 times)  ******* 
50 -  54   4.0   (3 times)  ***
45 -  49   5.0   (1 times)  *
40 -  44   5.0   (3 times)  ***
below 40   5.0   (2 times)  *****

cat */retake-exam-result.txt | cut -d"," -f6 | \grep -o '[0-9]\+' | awk '{ bucket = int($1/5) * 5; printf("%d-%d\n", bucket, bucket+4) }' | sort -r | uniq -c

Average number of points and standard deviation per task:

A1 : 13.4 ± 4.3
A2 : 10.2 ± 3.6
A3 : 13.2 ± 3.4
A4 : 11.4 ± 5.1
A5 :  5.4 ± 4.7

for A in 1 2 3 4 5; do printf "A%s : %s\n" "$A" "$(cat */retake-exam-result.txt | cut -d"," -f$A | cut -d":" -f2 | \grep -o '[0-9]\+' | awk '{x+=$1;y+=$1*$1}END{mean=x/NR; printf "%4.1f ± %.1f\n", mean, sqrt(y/NR-mean^2)}')"; done

Text on this page before the exam

The written retake exam will take place on Monday, September 9, 2024, from 14:00 - 16:30 h (2.5 hours) in building 101 of the Faculty of Engineering, in the two big lecture halls 00-026 and 00-036.

The exam begins on time at 14:00 h. Please make sure to be there at least 15 minutes before that time. We will assign you to one of the two rooms onsite.

Take a seat at a place where an exam is laid out. Before the official start, you can read the cover sheet and fill out your name and matriculation number on the top. You are not allowed to open the exam before 14:00 h of that day. Please place your student ID as well as an ID card or passport in front of you on the table.

You are allowed to bring a single A4 sheet of paper with content on both sides, created by yourself. No further materials or electronic devices of any kind are allowed. See https://daphne.informatik.uni-freiburg.de/ws2324/InformationRetrieval/svn/public/slides/lecture-13.pdf#page=14 .

Leaving early before the end of the exam is not possible. After submitting, please leave the building quietly and only start talking once you are outside.