Embedded Files
Submit ONE Google sheet with different sheets exploring the data sets linked below. Some example visualizations are below - yours don't have to (and shouldn't) be the same - explore for yourselves. I recommend leaving the Decimal Mark data until last, as it requires the most data processing work.
In the Australian population example, I chose to represent population as the size of the dot and the percentage change of population as red-to-green)
- Australian State Population Data: abs.gov.au/ausstats/abs@.nsf/mf/3101.0
- Represent both the population and growth rate on one visualization of Australia
- There is a little data cleaning you need to do here!
- World Country Population & Area: worldometers.info/geography/alphabetical-list-of-countries/ (copy into notepad first!)
- Make a visualization that clearly shows the distribution of population around the world
- Getting the colour distribution correct on you map is the trick here
- Decimal Marks across the World: wikipedia.org/wiki/Decimal_mark (Use the data extracted from Wikipedia below)
- Visualize which countries use decimal points and which use decimal point and which use a decimal comma
- Translating the lists into useful numerical data is the trick here
Australian State Population (size) and changes in population (colour) - 2017 version
World Population Density
# Data from https://en.wikipedia.org/wiki/Decimal_mark#Hindu.E2.80.93Arabic_numeral_system# Date retrieved 2017-10-17# Countries that use Hindu-Arabic numerals and a Decimal Point AustraliaBangladeshBotswanaBritish West IndiesBruneiCambodiaCanadaChinaMacauDominican RepublicEgyptEl SalvadorGhanaGhanaGuatemalaHondurasIndiaIrelandIsraelJapanJordanKenyaKorea, NorthKorea, SouthLebanonLuxembourgMalaysiaMaldivesMaltaMexicoMyanmarNepalNew ZealandNicaraguaNigeriaPakistanPalestinePanamaPhilippinesPuerto RicoSingaporeSri LankaSwitzerlandTaiwanTanzaniaThailandUgandaUnited KingdomUnited StatesZimbabwe# Countries that use Hindu-Arabic numerals and a Decimal CommaAlbaniaAlgeriaAndorraAngolaArgentinaArmeniaAustriaAzerbaijanBelarusBelgiumBoliviaBosnia and HerzegovinaBrazilBulgariaCameroonCanadaChileColombiaCosta RicaCroatiaCubaCyprusCzech RepublicDenmarkEast TimorEcuadorEstoniaFaroesFinlandFranceGermanyGeorgiaGreeceGreenlandHungaryIcelandIndonesiaItalyKazakhstanKosovoKyrgyzstanLatviaLebanonLithuaniaLuxembourgMacauMacedoniaMoldovaMongoliaMoroccoMozambiqueNamibiaThe NetherlandsNorwayParaguayPeruPolandPortugalRomaniaRussiaSerbiaSlovakiaSloveniaSouth AfricaSpainSwedenSwitzerlandTunisiaTurkeyUkraineUruguayUzbekistanVenezuelaVietnam 
Decimal Points Points and Commas: Bright Green = Both, Light Green = Point, Light Red = Comma, Dark Red = Missing Data
Not the best design choices!!
CF Same map on Wikipedia (retrieved 2019)
Blue = Full stop/Period (.)Green = Comma (,) Blue-Green = Both or Apostrophe (')Red = Momayyez (٫) (Arabic decimal separator)Gray = Data Not Available
Report abuse