Scenario
It is nearly the end of the season and, with just two matches remaining, the person responsible for producing the tables has resigned. You have been asked to take over and have been supplied with a table. This needs some information to be added to it so that you can produce a current table of positions and then, when the last two match results are known, a final table has to be produced.
[link to this data]
2A Develop the table with formulae and add new scores P3 P4
Transfer the league table data to a spreadsheet and complete the match entries with these two results:
Castle Abbey beat Mer City 7 – 3
Ferton Town beat Mer City 5 – 2
Add formulae to the sheet to calculate Goal difference and add a new column Points (3 for a win, 2 for score draw, 1 for a no-score draw)
2B Present the information attractively with suitable data types and format P5 P6
Using a separate sheet, enhance the presentation of the table with your choice of layout, colours, fonts, borders and alignment. Include a new column to display the Position of each team (1st to 8th).
On a separate sheet, create a charts to display (i) each team, their Position and total Points and (ii) each team and their Goals For and Goals Against in accurate and effective ways.
2C Add new features M1 D2
Prepare a new blank table for the next year's results. These are to be entered by staff on a separate sheet which needs to be included in the file. Formulae should be included as appropriate in the table so that results entered on the results grid are automatically entered in the league table and Points totals revised.
Add a feature that will enable the order of the table to be reset as required to show the teams in descending order of Points.
[sample working form and table]
2A Develop the table with formulae and add new scores P3 P4
Transfer the league table data to a spreadsheet and complete the match entries with these two results:
Castle Abbey beat Mer City 7 – 3
Ferton Town beat Mer City 5 – 2
Add formulae to the sheet to calculate Goal difference and add a new column Points (3 for a win, 2 for score draw, 1 for a no-score draw)
2B Present the information attractively with suitable data types and format P5 P6
Using a separate sheet, enhance the presentation of the table with your choice of layout, colours, fonts, borders and alignment. Include a new column to display the Position of each team (1st to 8th).
On a separate sheet, create a charts to display (i) each team, their Position and total Points and (ii) each team and their Goals For and Goals Against in accurate and effective ways.
2C Add new features M1 D2
Prepare a new blank table for the next year's results. These are to be entered by staff on a separate sheet which needs to be included in the file. Formulae should be included as appropriate in the table so that results entered on the results grid are automatically entered in the league table and Points totals revised.
Add a feature that will enable the order of the table to be reset as required to show the teams in descending order of Points.
 |
| sample form for recording results |
[sample working form and table]
No comments:
Post a Comment