Your sports master has a problem with tallying results for sporting events within the school, in particular, the athletics. The master would like to be able to tally the results of placegetters of each event. Point scores are 3 for 1st, 2 for 2nd and 1 for 3rd. After tallying results the master would then like to sort and summarise the results to produce the following information:
- scores for each gender age group by House
- overall scores for each category (i.e. track or field by House)
- overall scores for each House
- a listing of results for each House sorted in age group then gender
- a listing of first placegetters for selection into the interschool athletics team.
In solving this problem you should follow these stages.
Collecting the data
Plan the columns that will be required in the results table to give the required information.
Defining the solution
Design the table – in what order will you put the columns?
Implementing
Enter the data, proofreading and editing as required. Sort and subtotal as necessary. Filter the tally to display appropriate listings.
Evaluating, collaborating and managing
Evaluate the results of your listings. Are they conveying the information required? Could they be improved?