# 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

- five competitors
- six judges
- three judged events

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

Return to
the UNCA Computer Science home
page