xls, 332 KB
xls, 332 KB
A fantasy football spread sheet for World Cup 2014. Can be run by the teacher - or with older children by them using a spread sheet programme. Choose your teams and have a class Fantasy World Cup... Great fun. #excel
Creative Commons "Attribution"

Reviews

4.8

Something went wrong, please try again later.

rossmc88

7 years ago
5

Hi there. Planning on doing something like this for my school this summer term. Wondered if this was adaptable for this year's World Cup, and if so, how? Thanks!

smell the glove

10 years ago
5

Ace resource this - all abilities in upper KS2 able to access it and pick a team within the budget. They have loved following their progress so far.

Azzurro

10 years ago
5

Thanks very much for this. I've got 12 classes of juniors + staff taking part, with some willing children to enter the teams.

kramshaw

10 years ago
5

Will use format, thank you for the brain work.

bopthehonest

10 years ago
4

Thanks for a great resource but I think I’ve found an error in the formula. I’ve changed the formula in my spreadsheet so that each team will score 5 points for winning every match including the final and 10 bonus points for reaching the additional rounds after the group stages. We will enter the number of goals after normal time. A team that is in the knockout rounds might be drawing 1-1 at the end of normal time but then might go on to win 3-2 after extra time or 6-5 after a penalty shoot-out. We will enter the result as w,1,1. This is my formula: =SUM(COUNTIF($E4:$AC4,"w")*win+COUNTIF($E4:$AC4,"d")*draw)+(F4+J4+N4+R4+V4+Z4+AD4)*gf+(G4+K4+O4+S4+W4+AA4+AE4)*ga+(H4+L4+P4+T4+X4+AB4+AF4)*red+COUNTIF(Q4:AC4,"w")*nextround+COUNTIF(Q4:AC4,"l")*nextround Thanks for updating the spreadsheet with all of teams. The children at my school loved this four years ago and I’m sure it will be just as popular this year too. Oh, just one final point the winner’s certificate refers to South Africa 2010 rather than Brazil 2014. Great resource, many thanks! ?

Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.