Bioecology-2021. Score Calculation

This page reflects a Google document where data on scores earned by students during the bioecology course in 2021 are collected. Seminar grades are assigned by Hennadii Leonidovych Honcharov. For tests, the number of correct answers, the percentage of correct answers, and the score based on that percentage are calculated. After the table of results for each student, distributions by number of correct answers and the correspondence between the number of correct answers and the score obtained are provided. Please note: at the bottom of the window through which you see the results page, there is a scrollbar that allows you to shift the visible portion of the results page left or right. If you are curious about how the test score is calculated, here is an explanation. Let us denote: Pers — the percentage of correct answers for a given student; Weigth — the number of points that can be earned for the test; Max — the maximum percentage of correct answers in the course (achieved by the student with the best test result); Min — the percentage of correct answers for which the minimum satisfactory grade is awarded, i.e. half the points of the Weigth value. The value of Min is set by the instructor depending on the distribution of correct-answer percentages among all students who took the test. Those who scored below Min receive less than half of the possible number of points. The test score is calculated as follows: =IF(Pers=Max;Weigth;IF(Pers>=Min;ROUNDDOWN(Max/2+(Weigth/2+1)*(%-Min)/(Max-Min));ROUNDDOWN(Max/2*Pers/Min))) The formula above is analogous to Excel or Calc formulas, except that instead of cell addresses the labels defined above are used. Work out how the function IF(condition;action_if_condition_is_true;action_if_condition_is_false) works!