Homework #7 -- due 5 December, 1996

You can do this homework in any Windows or Unix spreadsheet program. I suggest you use Quattro Pro. It's installed on almost all PC's on the UNCA campus.

The problem

In this assignment you will design a spreadsheet for a competition. The competition involves

For every event, each judge assigns every competitor a rating from 0.0 to 10.0. Assume the scores are given to an "accuracy" of one-tenth. A competitor's score on a particular event is obtained by taking the six ratings of the judges, discarding the highest and lowest ratings, and then adding the remaining four.

For example, if the six scores are 9.8, 9.7, 9.9, 5.3, 7.1, and 9.5, the high and low scores (9.9 and 5.3) are thrown away, and the remaining four are summed to give a total of 9.8+9.7+7.1+9.5, or 36.1.

The competitor's final score is obtained by computing a weighted sum of his/her scores on the three events. The events are weighted so that the second and third events count twice as much as the first. So, if the competitors scores were 36.1, 38.7, and 35.5, his/her final score would be 36.1+2*38.7+2*35.5, or 184.5.

Your mission

Write a spreadsheet that can be used by the official scorers of this competition.

If you just figure out someway to bring all the numbers together, you will not get an A-level score on this homework. A-level scores will only be rewarded to those whose spreadsheets are well-designed works of art.

Return to the CSCI 171 homework index
Return to the CSCI 171 index
Return to Dean Brock's home page
UNCA CSCI logo Return to the UNCA Computer Science home page