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

The exam took place on Monday 18.03.2024 from 14:00 - 16:30 in six rooms in Building 101 of the Faculty of Engineering (HS 026, HS 036, SR 00-010/14, SR 01-009/13, SR 01-016/18, SR 02-016/18). A total of 161 students were registered for the exam (IR: 70, DBIS: 91). A total of 139 students showed up (IR: 65, DBIS: 74).

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 18.03.2024 and Tuesday 19.03.2024. Right after the correction, the points per task and the grade for each student were entered in a file exam-result.txt in the SVN folder of the respective student.

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

The exam inspection will *probably* take place on Thursday, March 21, probably from 14 - 16 h. A confirmation with the exact time and modalities follows.

Here is the distribution of the grades.

95 - 100   1.0   ( 2 times)  **   
90 -  94   1.3   ( 7 times)  *******   
85 -  89   1.7   ( 8 times)  ********   
80 -  84   2.0   (18 times)  ******************   
75 -  79   2.3   (12 times)  ************   
70 -  74   2.7   (16 times)  ****************   
65 -  69   3.0   (19 times)  *******************   
60 -  64   3.3   (14 times)  **************   
55 -  59   3.7   ( 9 times)  *********   
50 -  54   4.0   ( 8 times)  ********   
45 -  49   5.0   (11 times)  ***********   
below 45   5.0   (15 times)  ***************   

Average number of points and standard deviation per task:

A1 : 15.7 ± 4.8
A2 : 12.6 ± 4.0
A3 : 13.8 ± 4.2
A4 : 12.8 ± 4.7
A5 : 10.7 ± 6.0

for A in 1 2 3 4 5; do printf "A%s : %s\n" "$A" "$(cat */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

Statistics for Information Retrieval (70 registrations, 65 showed up)

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

cut -f4 internal/exam/ir_accounts.tsv | while read RZ; do cat $RZ/exam-result.txt; done 2>/dev/null | cut -d"," -f6 | \grep -o '[0-9]\+' | awk '{ bucket = int($1/5) * 5; printf("%d-%d\n", bucket, bucket+4) }' | sort -r | uniq -

A1 : 15.9 ± 4.4
A2 : 12.8 ± 4.0
A3 : 14.7 ± 3.1
A4 : 13.0 ± 4.2
A5 : 11.8 ± 5.4

for A in 1 2 3 4 5; do printf "A%s : %s\n" "$A" "$(cut -f4 internal/exam/ir_accounts.tsv | while read RZ; do cat $RZ/exam-result.txt; done 2>/dev/null | 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

  100 +--------------------------------------------------------------------+   
      |                                                   *                |   
      |  *                                                  *       *      |   
   90 |                                                                    |   
      |         *                                          *               |   
      |     *   *       *                        * *                       |   
   80 |                                                                    |   
      |     *  * *       *       *           *        * *      *           |   
      |       *                                     *                      |   
   70 |                *         *    *                                    |   
      |        **                           *    *                         |   
   60 |   *                             *                                  |   
      |         *                                                          |   
      |                                                                    |   
   50 |              *                                                     |   
      |                                                                    |   
      |*                 *                                                 |   
   40 |                                                                    |   
      |                                                                    |   
      |                                                                    |   
   30 +--------------------------------------------------------------------+   
      0             50           100          150           200           250  

for U in $(cut -f4 internal/exam/ir_accounts.tsv | while read RZ; do if [ -f $RZ/exam-result.txt ]; then echo $RZ; fi; done); do POINTS_EXAM=$(cut -d"," -f6 $U/exam-result.txt | \grep -o "[0-9]\+"); POINTS_EXERCISES=$(\grep ^$U internal/exam/exercise-points.csv | cut -d";" -f5); printf "$POINTS_EXERCISES\t$POINTS_EXAM\n"; done | \grep "\." > exercise-points-and-exam-results.ir.tsv gnuplot -e 'set terminal dumb; set tics scale 0; plot "exercise-points-and-exam-results.dbis.tsv" pt "*" notitle'

Statistics for Databases and Information Systems (91 registrations, 74 showed up)

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

A1 : 15.5 ± 5.1
A2 : 12.4 ± 3.9
A3 : 13.0 ± 4.8
A4 : 12.6 ± 5.1
A5 :  9.6 ± 6.2

  100 +--------------------------------------------------------------------+   
      |                         *        *                                 |   
   90 |                 *           *    *     *                  *        |   
      |                                  *            * **                 |   
   80 |                                 *            * *                   |   
      |   *     *                                         *                |   
   70 |                *                  * *                              |   
      |         *         *                   *        *                   |   
   60 |                                      *     *      *                |   
      |             *                                                      |   
   50 |   **  *  *       *       *                                         |   
      |    **                                                              |   
   40 |                                                                    |   
      |                                                                    |   
   30 |          *                                                         |   
      |                                                                    |   
   20 |                                                                    |   
      |                                                                    |   
   10 |                                                                    |   
      |                                                                    |   
    0 +--------------------------------------------------------------------+   
      0             50           100          150           200           250  

Text on this page before the exam

The written exam will take place on Monday, March 18, 2024, from 2:00 pm to 4:30 pm in building 101 in the following rooms, depending on the initial letters of your last name:

• A - Ha: Room 00-026 (Lecture hall left)

• He - Mi: Room 00-036 (Lecture hall right)

• Mu - Ran: Room 00-010/14 (Ground floor seminar room left)

• Raw - Schuh: Room 01-009/13 (First floor seminar room right)

• Schus - Tha: Room 01-016/18 (First floor seminar room left)

• Tho - Z: Room 02-016/18 (Second floor seminar room right)

The exam begins on time at 2:00 pm. Please make sure to be there at least 15 minutes before the start.

Take a seat at a place where an exam is laid out. You may read the cover sheet and write your name and matriculation number on it, but do not open the exam. Please place your student ID as well as an ID card or passport in front of you on the table.

Also remember that, as announced, you are only allowed to bring a single A4 sheet of paper with content on both sides. No further materials or electronic devices of any kind are allowed.

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.