Spreadsheets World Cup Tables

Do Now!

Before we start the lesson, typing practice is a nice way to settle ourselves down. Have a 10 minute practice.

Click here to play Monkeytype

In this lesson, you will open a blank spreadsheet and create the football league table as shown below

What is a spreadsheet?

I like to this of a spreadsheet, as a very large piece of paper, where we can make lots of calculations.

There appears to be lots of boxes. These boxes are known as cells.

Each cell has a cell reference.

The cell reference is the column letter followed by the row number. The cell reference for the green cell above is B3.

Learning Objective : Create a set of World Cup based on current standings

Use borders and shading to format the table

Use formula to work out goal difference, games played and points won

Open a blank spreadsheet (MS Excel or Google Sheets) and create a football league table based on the one below

Current World Cup Standings

Open a blank spreadsheet and create the football league table as shown below.

You will need to use borders and shading

Using borders

Using Shading

You should use formula to work out;

  • Games played (Won+Drawn+Lost)
  • Goal difference (Goals Scored – Goals Against)
  • Points ((Games Won * 3) + (Games Drawn + 1)) Remember to use the correct brackets

Do not work them out manually. Use the formula as shown above.

Change the games won, drawn and lost and see what happens to the points total

Change the goals scored and goals against and see what happens to the goal difference.

If you have finished, you can do another table. This one includes England.

You can add the table to the same sheet

If you have finished, you can add more tables

Current World Cup Standings

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Blog at WordPress.com.

Up ↑

%d bloggers like this: