Tasks | Early Adolescence | Sporting League Tables

Tasks - Early Adolescence

Sporting League Tables   by Richard Grey, Curriculum Council

Phase of Development:   Early Adolescence

Learning Area/s:	Mathematics, Health & Physical Education
Strand/s	Substrand/s
Chance & Data	Collect & Organise Data Summarise & represent Data Interpret data
Working Mathematically	Mathematical Strategies Apply and verify
Algebra	Understand symbols
Number	Calculate Understand operations
Brief Description:	Students place results of a sporting competition such as football, netball, hockey or basketball in a spreadsheet. These are often found on the Internet.
Expected Outcomes:	Tabulate data and assign a score for a win, loss or draw. Calculate ratio of points for to points against Check and verify that the sum of columns is correct Understands symbolic representation of database formula.
Learning Activities/ Experience:	Create a spreadsheet to keep the record of a sporting fixture. A score for a win, loss and draw must be allocated. Express the ratio of points or goals for the team to points or goals scored against the team as a percentage using appropriate spreadsheet formula. Use the total columns to check and validate that the data entry is correct. No. A B C D   E   E   F   1 Team Win Loss Draw  Pts  for Pts against % 2               3               4               5               6 Total             Use the data to rank the teams.