Before we start the lesson, typing practice is a nice way to settle ourselves down. Have a 10 minute practice.
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
Open a blank spreadsheet and create the football league table as shown below.
You will need to use borders and 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