Exercise 3: Olympics

The Charting Olympics: Charting The Olympics

The Exercise- The Charting Olympics: Charting The Olympics

[Let’s pretend] I am the editor of the official magazine for the Olympic Games in Tokyo 2021. I am looking to recruit a team of talented designers to work on the visualisations for this publication. Working in teams of 3, I wanted you to come up with a variety of different charts ideas to represent some provided data about the Olympics.

Research and preparation (recommended 30 mins)

1. Spend time familiarising yourself with the worksheets of data in the file ‘OlympicsData.xlsx’ (or if you prefer Google Sheets use the redirect ‘OlympicsData(GSheet).html’).

2. Note down (in written language) different ideas for potential analysis of this data that you think you could explore with the data provided. If you have ideas that would require further data (eg. country populations) that you could reasonably imagine obtaining, that is ok.

Sketching and publishing (recommended 75 mins)

3. Using pens/paper or digital apps, sketch as many different charts as you can imagine. You do not need to plot real data, use the data to inspire your ideas. Just make each chart as clear as possible what would be plotted (eg. so on the x-axis, you would have YEARS, and on the y-axis COUNTRY)

4. Using Miro, publish your collection of sketches, organising themaround the CHRTS taxonomy. Teams are encouraged to come up with as many distinct ideas as possible, with extra credit for particularly unique chart recipes OR particularly interesting topics of analysis!

Our ideas

Ik vond het wel fijn om m'n ideeën die we via de video call zouden voorleggen aan elkaar, eerst uit te schrijven. Dit document is hier te bekijken, en is ook onderaan deze pagina te vinden.

Na een kort individueel brainstormmoment hebben we ieder onze voorstellen voorgelegd aan elkaar en dit brainstormen samen voortgezet.

Research and preparation

Games

Sport	Event	Gender	Athlete(s)	Country	Medal	Result	TimeInSeconds
2016	Athletics	10000m	Men	Mohamed Farah	GBR	Gold	27:05.17	1625,17
2016	Athletics	10000m	Men	Paul Kipngetich Tanui	KEN	Silver	27:05.64	1625,64
2016	Athletics	10000m	Men	Tamirat Tola	ETH	Bronze	27:06.26	1626,26
2016	Athletics	10000m	Women	Almaz Ayana	ETH	Gold	29:17.45	1757,45
2016	Athletics	10000m	Women	Vivian Jepkemoi Cheruiyot	KEN	Silver	29:32.53	1772,53

[Let’s pretend] I am the editor of the official magazine for the Olympic Games in Tokyo 2021. I am looking to recruit a team of talented designers to work on the visualisations for this publication. Working in teams of 3, I wanted you to come up with a variety of different charts ideas to represent some provided data about the Olympics.

Research and preparation (recommended 30 mins) 1. Spend time familiarising yourself with the worksheets of data in the file ‘OlympicsData.xlsx’ (or if you prefer Google Sheets use the redirect ‘OlympicsData(GSheet).html’). 2. Note down (in written language) different ideas for potential analysis of this data that you think you could explore with the data provided. If you have ideas that would require further data (eg. country populations) that you could reasonably imagine obtaining, that is ok.

Variabele 1	Variabele 2	Variabele 3	CHRTS
Land	Winnaars met goud		Spatial
Medaillesoorten	Aantal		Categorical
Vrouwen vs mannen	Aantal	Aantal gouden medailles

Visualiseer:

• Wereldkaart, en kleur een land goud in als ze goud hebben gewonnen

• Wereldkaart, en hetzelfde maar dan voor alledrie de medaillesoorten (indien een land alledrie heeft gehaald, dan met diagonale strepen goud/zilver/brons aangeven

• Pie chart: hoeveel % van alle soorten gewonnen medailles door vrouwen

• Pie chart: hoeveel % van alle soorten gewonnen medailles door mannen

• Pie chart: verdeling totale aantal gouden medailles man-vrouw

• Bar chart: per profession, het aantal medailles

• Line chart: het totale aantal medailles per jaar

• Iteratie: twee lines in deze chart; een mannelijk, een vrouwelijk