Sunday, 25 September 2016

Quibans 39: Injured Cyclists

This Quibans is particularly useful when you are working on (revising?) percentages, particularly undoing a percentage change.

From the Cambridge News:
Cyclists injured on Cambridgeshire's roads falls in last year
Shock new figures show more than one cyclist a day was injured on Cambridgeshire's roads last year - but numbers are falling.
Data from the Department for Transport has revealed 444 cyclists were involved in road accidents last year across the county - of which 74 were seriously injured and three fatally.  This is a drop of 6.3 per cent when compared with the ### in 2014, four of which were fatal.
Cambridge also saw a decrease of 4.3 per cent with 221 cyclist injured in 2015.
Noel Kavanagh, Cambridgeshire county councillor and the council's cycling champion, said “These figures are hugely encouraging in light of the fact that there's a large increase in the number of people cycling.”
Elsewhere across the county, there were 44 people injured in South Cambridgeshire last year, a 17 per cent drop and 15 in East Cambridgeshire, a decrease of 28.6 per cent.  But Huntingdonshire saw injuries go up by 15 per cent with 46 cyclists injured on the roads.
Nationally, the number of cyclist injured on the roads as a whole is falling too with ### in 2015, down by 11.5 per cent compared with the 21,287 in 2014.

The first step is to work out the blanked out numbers.  (Answers given below)

Then we could calculate other things, such as the percentage of injuries in Cambridgeshire that take place in the city of Cambridge, the number that were injured in 2014 in different parts of the county, and what percentage of the cyclist injuries across the country occurred in Cambs.

.
.
.
.
.
.
.
.
.
.
.

The first missing number is 474.  If students wrongly add on 6.3% then they won’t get the right answer.  This should lead them to think again.

With the second number, even if they do the right calculation they won’t get the given number of 18,845 because of rounding issues.  This is a nice prompt for them to then work out what the actual percentage is (closer to 11.47%).

Source:

Friday, 23 September 2016

Quibans 38: Skittles

This Quibans is taken from several sources, including BBC News and the Washington Post.

It is likely many students will have heard about this tweet by Donald Trump’s son:



If you want some of the political reaction to this then you can follow the links below (under ‘sources’).

The BBC article included this:



Here are some figures:
  • Each year, the risk to an American of being killed by a refugee in a terror attack is 1 in 3.64 billion.
  • The manufacturers of Skittles make 200 million of them each day.
  • An ordinary size packet of Skittles contains 54 sweets and 231 Calories (12% of the RDA).
  • An Olympic swimming pool doesn't have a shallow end (!). It has length 50m, width 25m and depth 3m.

What can we work out?

Q1) How much more likely are you to die from choking on food than in a refugee-instigated terror attack?
Q2)  If we want to follow up on the analogy, when there are three poisoned Skittles, how many Skittles are there altogether?
Q3)  What is the total volume of these Skittles?
Q4)  Wikipedia:  "An Olympic-size swimming pool is used as a colloquial unit of volume, to make approximate comparisons to similarly sized objects or volumes."  How many swimming pools do we need to hold the Skittles?
Q5)  How many days will it take to make this many Skittles?
Q6)  How many packets is this?  How many days of calories?
Much of this (and some more probability work too) is covered in the excellent Washington Post article by Philip Bump (link below).  It might be good to ask students to read that article after using this Quibans.

Sources:


Sunday, 4 September 2016

Quibans 37: Say 'Please'

Here are excerpts from two articles in the Daily Telegraph, published about three years apart.
Polite customers offered cheaper coffee by Spanish café owner
3 SEPTEMBER 2016
Disenchanted by rude customers, a café owner on Spain’s Costa Brava has introduced a novel incentive to encourage good manners by charging clients according to how polite they are.
A terse demand for “un café” will see guests charged five Euros (£4.20) for a cup of coffee by Marisel Valencia Madrid, the owner of the Restaurant Blau Grifeu in Llança.
Adding please - or por favor - brings the price down to €3.50 (£2.94). Somebody who tries that bit harder and greets the server with a friendly “Buenos días” will only be charged €1.30 (£1.09).
I put a sign in the window with the price system and it has made all the difference. People are now super polite in all matters and it has really improved daily life,” she said.
“Yesterday some children even told their parents to say please, so it’s working!” she added.



French cafe charges rude customers more

11 DECEMBER 2013

A wine bar and bistro in Nice has apparently grown so fed up of rude customers that it's started penalising impoliteness. Ask for "a coffee" in La Petite Syrah, and it costs you €7 (£5.90). Ask for "a coffee please," and the price drops to €4.25 (£3.60). But enter the place crying "Bonjour, a coffee please," - perhaps also embracing everyone within reach- and the cup will cost you what it costs generally in Nice: €1.40 (£1.20).



What can we do with this? [NB: answers/workings are included with the questions below.]

1) We could, clearly, work out the exchange rate. Is it the same exchange rate in both articles?

The first article gives us £1 is approximately €1.19. The second article has three different values (to 2dp) being used.

7 ÷ 5.90 = 1.186441

4.25 ÷ 3.60 = 1.180556

1.40 ÷ 1.20 = 1.166667

The last of these is rather different – and £1.18 would be a more accurate price for that version. The French article seems to have rounded all of the conversions off to the nearest 10p, whereas the Spanish article gave them to the nearest penny.

It is perhaps interesting that the exchange rate from three years ago is very similar to what it is now.

2) Are there any surprises/errors in the articles?

The photograph says that “Adding please - or por favor - brings the price down to €3.50 (£2.94)”, whereas the photograph of the menu shows that this should be €3.

3) How much should this be in sterling (pounds)?

We can use the exchange rate we worked out earlier to get £2.52

4) A ‘very polite’ coffee in Spain has a very similar price to one in France, whereas a ‘rude’ coffee is much more expensive in France. How can we quantify this?

The rude coffee is 40% more expensive in France, the polite coffee is 21% more expensive and the very polite coffee is 8% more expensive.

Alternatively, the rude coffee is 29% cheaper in Spain, the polite coffee is 18% cheaper and the very polite coffee is 7% cheaper.

5) How do these prices compare to the big coffee chains?

The 'London Toolkit' blog has the prices of coffees in the major chains:



You certainly can't get a coffee for £1.20 !

This Quibans could be extended further by carrying out some research into the different varieties of coffee listed here. Are the sizes the same in all three shops? Are the prices the same across England?

Sources:
http://www.telegraph.co.uk/news/2016/09/02/polite-customers-offered-cheaper-coffee-by-spanish-caf-owner/
http://www.telegraph.co.uk/travel/news/French-cafe-charges-rude-customers-more/
https://www.londontoolkit.com/blog/eats/coffee-shop-chains-in-london/ 

Sunday, 28 August 2016

Quibans 36: School exclusions for assault

This is a lightly rewritten article from the Cambridge News website:

Primary school exclusions on the rise for 'violent behaviour'
More primary school pupils in Cambridgeshire are being excluded from school for violent behaviour, it has emerged.  The figures are especially pronounced amongst primary school pupils, with exclusions for violent behaviour towards adults and other pupils rising.
A spokesman for Cambridgeshire County Council said: “Schools are usually very safe places for pupils and serious incidents of violence against pupils or staff are rare.”
The spokesman said that, while the number of exclusions for violent behaviour had gone up, this may be down to […].
Pupil assaults on an adult
2011/12:  118 primary and 65 secondary
2012/13:  146 primary and 49 secondary
2013/14:  189 primary and 72 secondary
2014/15:  201 primary and 76 secondary
2015/16:  319 primary and 66 secondary
Attacks on other pupils
2011/12:  64 primary and 319 secondary
2012/13:  104 primary and 271 secondary
2013/14:  127 primary and 273 secondary
2014/15:  110 primary and 242 secondary
2015/16:  162 primary and 276 secondary


Possible ways to use this:
First of all, are the claims in the article reasonable ones?
1)  Are “exclusions on the rise”?
2)  Are “serious incidents of violence against pupils or staff rare”?
3)  What else do the figures tell us?
4)  What is wrong with the line: “Pupil assaults on an adult”?
5)  What reasons might the spokesman have given for the rise in exclusions?


Possible ways to approach these questions:
1)  The first of these could be explored by drawing a graph.  What sort of graph might be useful?
Here is the data (in Excel):



And here are some of the graphs I got Excel to draw.  It would be good to ask students to comment on the usefulness of each method of data presentation.








Here are my thoughts about each one:
Line graph:
This is clear.  It shows how the data changes over time.  The lines are not particularly relevant (halfway along a line has no meaning) but this helps our eye to see the pattern.

Stacked column:
These are often used in the media but I think they are unhelpful because the only one it is easy to compare over time is the lowest one.  Is the top part of each bar getting bigger or not?  It is difficult to tell!

3D pie chart:
Only shows the data for one aspect (the number of primary assaults on an adult (so we would need three other graphs).  It shows how the proportion of assaults has changed over the years, but takes the whole pie as being worth all of the assaults on adults over those five years.  The 3D nature of the graph is not helpful …

Clustered column:
This shows all of the data clearly.  If you join up the top of each bar of the same colour you roughly get the line graph.  You can see clearly which ones are going up and which are going down, how much they are doing so and also the relative proportion of assaults in the two age-groups.

Scatter:
Very similar to the line graph (the x-axis wouldn’t behave as I wanted it to!) but without the lines to guide the eye.

100% stacked column:
Like the pie chart, this shows proportion rather than numbers but in a less useful way than the pie chart.  It doesn’t help us to see whether the number of assaults has changed, just how they are distributed.

Those graphs that are useful do seem to show an increase.  (This could be expanded on further.)

2)  To know whether assaults are rare we probably need to know how many school-children there are in Cambridgeshire.  This is ripe for Fermi estimation!  I will assume that the population of the UK is about 70 million and that there are about 50 counties.  Cambridge is clearly not as big as London and other large cities, so I guess that Cambridgeshire has about 1% of the population of the country as a whole.  There are more younger people than older people, so I will estimate that about a fifth of the population are of school age.  70 million x 1% divided by 5 = 140,000 pupils.  (Google suggests the actual number is close to 80,000 pupils, which puts my estimate in the right order of magnitude.  There are likely to be lots of other ways to estimate this.)
There were 823 exclusions for assault in total in the most recent year.  Comparing this to 80,000 pupils who should be attending school for 190 days each year and we get 54 assaults per million school days.  This seems rare to me.

3)  The data also shows us that there are more primary assaults on teachers, whereas at secondary school they are more likely to be on other pupils.

4)  We don’t know how many assaults actually take place because the figures given are for the number of exclusions from school for assault.  Less serious assaults may not be punished in this way, different schools might respond differently, etc.

5)  Here are the full reasons given by the spokesman:
The spokesman said that, while the number of exclusions for violent behaviour had gone up, this may be down to an increase in the number of pupils attending schools, meaning the proportion of exclusions was actually going down.  He added: "Primary schools appear to have reported increases in incidents and this is a matter of concern. However, this may be as a result of better recording of incidents, a change in pupil behaviour, an increase in pupil numbers or a change in teaching practices and expectations."


Source: http://www.cambridge-news.co.uk/primary-school-exclusions-on-the-rise-for-violent-behaiour/story-29658900-detail/story.html

Saturday, 30 July 2016

Quibans 35: Copper coins

From the Daily Telegraph:

Disgruntled parent pays £60 school attendance fine for taking child on holiday in pennies

After taking his son out of school for a holiday, this man received a £60 fine from local authorities.

Rather than take the easy route, he changed £60 in cash into 1 and 2 pence pieces and proceeded to pour them over the reception desk of the local council office.


This story gives some quick and interesting Quibans opportunities.  Here are some ideas:
1) If he used 4,724 coins, how many 1p coins and how many 2p coins were there?
2) What is the smallest number of coins he could have used?
3) What is the biggest number of coins he could have used?
4) If we know the number of coins, how can we easily work out how many were 1p or 2p?
5) Is it possible to carry £60 worth of 1 and 2 pence pieces?
6) What was the weight of the coins?
7) If the coins were stacked up, how high would the stack be?

Answers and other information:
1) I prefer to answer questions 2, 3 and 4 first and then come back to this one.  I think it is still worth asking this question first, though.  
2) 3000 x 2p = 6000 pence.  It says that 1p coins were used too, so presumably 3001 is the smallest number of coins that could have been used.  (2999 x 2p and 2 x 1p)
3) 6000 x 1p = 6000 pence.  2p coins were used so 5999 coins is the biggest (5998 x 1p and 1 x 2p)
4)  There must be at least 3000 coins (that would be all 2 pence pieces).  Then, every time we change a 2p into two 1p coins we get an extra coin.  
Start with the number of coins and subtract 3000 from it.  This excess is the number of 2p coins that have been changed into 1p coins.  We need to double that number to find the number of 1p coins and subtract it from 3000 to find the number of 2p coins.  Not easy to get your head around (but it is possible to simplify this if you use algebra).
1) 4724 - 3000 = 1724.  This is the number of 2p coins that have been changed into 1p coins.
That leaves 3000 - 1724 = 1276 coins that are 2p.
1724 x 2 = 3448, which gives us 3448 1p coins.  Check that the number of coins adds up to 4724 and that the value makes £60.
5) It feels like it probably will.  60 pound coins would be fine, as would 120 50p coins.  Probably won't be good for your trouser pockets, though.  The source for the article (see below) includes a video of him emptying out the coins. 
6) This is rather neat.  A 1p coin weighs 3.56g and a 2p coin is double that, at 7.12g.  It doesn't matter how the coins are distributed between 1p and 2p - the weight will always be 6000 x 3.56g = 21.36kg
7) This is less straightforward for two reasons.  A 1p coin is either 1.52mm or 1.65mm thick (depending on the date and the composition of the metal used) and a 2p coin is either 1.85mm or 2.03mm thick.  The weights are in the ratio 1:2, so the thicknesses are not.  This means that two 1p coins are thicker than one 2p coin.  
If we assume there are the same number of 2p coins as 1p coins (this could be another question!) then there are 2000 1p coins and 2000 2p coins.  Using 1.9mm and 1.6mm as the thickness of each coin that would give a height of 7 metres.  Good luck with building that!


Source:

Sunday, 10 July 2016

Quibans 34: It's May v Leadsom

May v Leadsom to be next prime minister

From the BBC:

Theresa May and Andrea Leadsom will battle it out to become the next leader of the Conservative Party after Michael Gove was eliminated from the contest.
After the second MPs' ballot, Home Secretary Mrs May finished with 199 votes, Energy Minister Mrs Leadsom 84 and Mr Gove, the justice secretary, 46.
Conservative members will now decide the winning candidate, with the result due on 9 September.
The winner will become the UK's second female prime minister.




Possible questions:
1)            What percentage of the vote did each of them get?
2)            Let’s imagine that Michael Gove came second.  How many of Theresa May’s supporters would have needed to switch to Gove for that to happen?
3)            Let’s imagine that Michael Gove came second.  How many of Andrea Leadsom’s supporters would have needed to switch to Gove for that to happen?
4)            What is the biggest number of votes you could get and still come last?


Source:





Friday, 24 June 2016

Quibans 33: EU Referendum

My Yr 12 class arrived this morning asking whether we would be doing a Quibans based on the Referendum result.  Here is what we did.

They knew that the country had voted as follows:
Leave – 52%
Remain – 48%
They told me the turnout was 72%
I had looked up the total number of people who voted and wrote that up:  33,551,983.

The questions they decided on were:
  1. How many people voted Leave/Remain?
  2. What proportion of the population of the UK voted?
  3. How many eligible voters didn’t vote?

Instead of them giving me answers verbally, we set up a spreadsheet on the board and they came up in turn to do some typing.  This allowed us to talk about how to structure this sort of thing on Excel, and what they should type.  It also helped us explore the difference between typing the number 52 and treating it as a percentage (dividing by 100 when we used it) and typing 52%, which Excel treats as the decimal 0.52

After that I gave them figures for South Cambs (where my school is):
Leave – 39.8%
Remain – 60.2%
93,189 people voted.

They worked out the number who voted to remain/leave:


They pointed out that these can’t be exact because you can’t have 0.78 of a vote.  I then told them the actual figures (shown above). 

First they worked out the accurate percentages, and found that they had been correctly rounded to 1dp here.  This then led to the use of the upper and lower bounds to determine how many people might have voted each way.

Clearly, if the figures for South Cambs ended up being approximate because of rounding issues, then the national figures might also be approximate, so we worked out upper and lower bounds for those.

Finally, I gave them the numbers for Cambridge, where 57,799 voted and 73.8% said ‘remain’ and we worked out upper and lower bounds for that.

So: we did lots of good percentages work (including inverse percentage to calculate the total number of eligible voters), used spreadsheets, considered upper and lower bounds.  Lots of interesting things.

At the very end of the lesson one student was interested in whether the margin of victory was big or not.  Is 52% to 48% a 4% difference, or is it a 2% difference?  Or should you look at the raw figures (1.3 million is a big difference).

Here are some of the links we used:


Quibans 111: How much energy and water do our AI tools really use?

Here is how I used the article below from the Times.  Before showing the article, I started with this information and these questions: Mic...