Back to Functional Skills Maths Entry Level 3 Home

Functional Skills: Tables

Entry Level 3City & GuildsEdexcelNCFEOpen Awards

Functional Skills: Tables Revision

Tables

Tables are similar to Lists, though they allow us to see various pieces of data at once. Think of a Table as multiple Lists stacked together, allowing us to make comparative statements about each entry (i.e. each person, product in a shop, etc.).

Entry Level 3EdexcelCity & GuildsNCFEOpen Awards

How to Read a Table

We want to set two different variables on our table. One of these is our entry, and the other is our group of topics (or, our set of individual Lists).

We’ll set our entries as the rows, and the group of topics as the columns.

In the overlapping section, we want to input our data.

So, for example, let’s say we want to know what Chloe’s favourite drink is:

Following the correct row and column to find their overlap, we can see that Chloe’s favourite drink is Orange Juice.

Entry Level 3EdexcelCity & GuildsNCFEOpen Awards

Follow Our Socials

Social BG
Facebook

Follow our Facebook for community support

Social BG

Follow our Instagram & TikTok for revision help

Our Facebook page can put you in touch with other students of your course for revision and community support. Alternatively, you can find us on Instagram or TikTok where we're always sharing revision tips for all our courses.

Follow our socials for revision tips and community support

  • facebook
  • instagram
  • tiktok
Entry Level 3EdexcelCity & GuildsNCFEOpen Awards

Example

The table below considers all Premier League players, their footedness and their usual position.

Find the totals for each column and each row, and use these to deduce the total number of players.

[3 marks]

Goalkeepers: 12 + 1 + 45 = 58

Defenders: 56 + 25 + 74 = 155

Midfielders: 22 + 67 + 49 = 138

Forwards: 25 + 50 + 34 = 109

 

Left footed: 12 + 56 + 22 + 25 = 115

Both: 1 + 25 + 67 + 50 = 143

Right footed: 45 + 74 + 49 + 34 = 202

 

Total: 58 + 155 + 138 + 109 = 460

alternatively,

Total: 115 + 143 + 202 = 460

Entry Level 3EdexcelCity & GuildsNCFEOpen Awards

Functional Skills: Tables Example Questions

a) Favourite Sport – Football: Alexander and David

 

b) Favourite Drink – Not Cola: Chloe and David

a) Medium hot chocolate: £2.50

Medium cup of tea: £1.50

Small cup of tea: £1.00

Large coffee: £3.00

Total: £2.50 + £1.50 + £1.00 + £3.00 = £8.00 paid

 

b) £10 - £8 = £2 change

a) Their enjoyment is highest (10/10) if they go to Monaco.

 

b) Amsterdam: £300 + £700 + £500 = £1500

Barcelona: £350 + £750 + £400 = £1500

Monaco: £450 + £1200 + £800 = £2450

Prague: £600 + £800 + £200 = £1600

Rome: £550 + £750 + £450 = £1750

Amsterdam and Barcelona are the cheapest options. They should go to Amsterdam, as this has the higher enjoyment of the two.

Functional Skills: Tables Worksheet and Example Questions

Site Logo

Tables EL3

Entry Level 3NewOfficial PFS