The formula function DROPAVERAGE is an easier and better alternative to drop scores
In this example we will work with 6 columns, each holding the score of a quiz. Our final result will be shown as a percent but we will drop the two lowest scores first.
This is the sample data we will work with.
The 6 Quiz columns have the same Grade type, in our example 'From 0 to 10'.
The result we would obtain if we took all 6 columns into account would look like this.
We have added a new column, its editor 'Calculation - addition' and Grade type 'From 0 to 100'.
If you are not familiar with calculations, you will find here a step-by-step on configuring this addition
And this will be the result after dropping the 2 lowest scores
Adding our first condition. Showing the highest value from our Quizzes
We will now add 4 new columns, one for each of the scores we need to take into account in the final result.
The columns must have the 'Calculation - condition'editor and we will configure the same Grade type of our Quiz columns. In our case 'From 0 to 10'.
This will be the result, a column showing the highest score amongst those 6 quizzes.
Adding our 2nd,3rd and 4th condition
You can now copy that column to create the rest of conditions. The main point is to choose the right position in the option 'Pick max value at position'.
The 2nd condition will pick the 2nd highest score (position 2)
The 3rd condition will pick the 3rd highest score (position 3)
and 4th condition will pick the 4th highest score (position 4)
Once configured, the 4 conditions will look like this
Adding our final calculation and hiding the condition columns
Now that our Conditions 1 to 4 are on screen we are able to add the 'Calculation - addition' that will calculate the final result.
Add a new column, 'Calculation - addition' as its editor , 'From 0 to 100' as its grade type and select the 4 conditions and 'Show its result as a percent'.
We will now hide those Condition 1 to 4 columns: Tap and hold on its header > Hide
And this will be our final result
Sample template to import into your iDoceo
If you would like to test this sample tap on this template below from your iPad and 'Open in' iDoceo.
Password is '12345'