====== LEARN - RAINFORESTS ====== **This project** will show you how to create your own **Google Motion Chart** to investigate and display how Amazon rainforest deforestation has changed over time. === Amazon Deforestation Data 2004-2014: === The Amazon is the largest rainforest in the world. It covers roughly 40% of the South American continent and is in part of eight countries. Tropical “rainforests grow in more than 50 countries but about half of the total is in just three: Brazil with 33%, and Zaire and Indonesia with 10% each,” and 57% of total is in Latin America. (National Wildlife Federation – Educator’s Guide) More background information can be found at these sites: * Global Forest Watch - [[http://www.globalforestwatch.org/country/BRA|Brazil]] * Global Forest Watch - [[http://www.globalforestwatch.org/country/IDN ====== Introduction To Motion Charts: ====== **Charts** are visual displays that are designed to make it easier for people to understand quantities and the relationships between things. Google Apps includes [[https://developers.google.com/chart/interactive/docs/gallery| a large collection of modern mathematical processing and charting tools]]. A [[https://support.google.com/docs/answer/1047434?hl=en&ref_topic=30240|Motion Chart]] is a special kind of 'dynamic' chart that displays and compares up to five data sets and tracks them over the course of time: {{ youtube>jbkSRLYSojo?640x360 |Data Visualisation }} === Video 1. Example Data Visualisation Using Motion Charts (what is possible): === * **IF UNABLE TO ACCESS YOUTUBE VIDEO (requires Flash):[[http://viewpure.com/jbkSRLYSojo|CLICK ON THIS LINK]]** ====== Create Your Own Deforestation Motion Chart: ====== === PART 1. Create your own 'sheet' using the example data: === - Download the file {{:rainforests:your-name-amazon.csv|your-name-amazon.csv (3.5kB)}} to your local workstation (or, if you prefer, download the {{:rainforests:your-name-amazon-old.csv|older, simpler version}} of rainforests csv). - Using the information supplied by your teacher, re-name that file. - Using the information supplied by your teacher, upload your newly named file into the correct folder in your Google drive. - Go to your Google drive, right-click on the newly uploaded file and select 'Open with' -> 'Google Sheets' - You should now have a new spreadsheet showing data imported from your file. - Check the columns: The ''Timestamp'' data MUST be in column 'B' [[https://support.google.com/docs/answer/1047434?hl=en|in second column]] (column ''B''). In case of problems, the column layout and format is the most likely culprit. Here is an example of column entries for your example spreadsheet(s): {{:rainforests:rainforest-chart-06.jpg?640 |New version spreadsheet}} === New version of spreadsheet with pre-set bubble sizes & colours === SPREADSHEET SETUP NOTE: You may have to [[https://support.google.com/docs/answer/56470?hl=en&vid=1-635750424063628354-10960929562633227548|set the column format]] for the 'Timestamp' column and [[https://support.google.com/docs/answer/58515?hl=en|configure your spreadsheet]] for Australian 'timezone' and 'locale' (the timezone and locale are USA by default). ---- {{:rainforests:rainforest-chart-01.jpg?640 |Old version spreadsheet}} === Old version of spreadsheet - manually set bubble sizes & colours === ---- **Figure 1. Google Sheet showing Timestamp & Deforestation data for {{:rainforests:your-name-amazon.csv|your-name-amazon.csv (3.5kB)}}** === PART 2. Create your 'chart' using the 'sheet' that you created (above): ====== - From the sheet menu, click on: ''Insert -> Chart'' (see Fig 2). - From the 'Chart Editor' menu, scroll down and click on the ''Motion Chart'' icon. The icon and bubbles will first appear grey (see Fig 3). When you click on the icon, then the bubbles will be coloured). - Click on the blue **[Insert]** button (bottom left-hand corner of the motion chart screen), to save the chart into it's own sheet (see Fig 4 & Fig 5). - See [[:howtos:google:motion-charts#how-to-display-data-experiment-with-motion-chart-display-settings|How to display data & experiment with motion chart display settings]] for more detail. ---- === Screen-shots of 'sheet' and 'chart' (motion-chart) setup: === Click on any image to zoom it to full size: |{{rainforests:rainforest-chart-02.jpg?320|Fig 2}}|{{:rainforests:rainforest-chart-03.jpg?320|Fig 3}}| ^Fig 2: Select 'Insert' -> 'Chart' ^Fig 3: Select 'Motion chart' icon, then click 'Insert'^ ---- |{{:learn:rainforests:rainforest-chart-04.jpg?320|Fig 4}}|{{:rainforests:rainforest-chart-05.jpg?320|Fig 5}}| ^Fig 4: Click on 'Move to own sheet' ^Fig 5: Click on triangle (Play) button at bottom left! ^ Your motion chart should now appear as **'Chart 1'** at the bottom of your sheet. - Click on the 'Chart 1' tab to open your chart. - Choose your own 'Color' and 'Size' settings and play your chart (see 'MORE DETAIL' below). ---- * **VIEW MOTION CHART: [[https://docs.google.com/spreadsheets/d/1NqTfDlEjsKXM2WDzbwsE0YW7H5PskOV1kpXZHWR6Q6w/edit?usp=sharing|Click here to view the live demo (if problem, use Chrome)!]]** * **MORE FUN: [[:howtos:google:motion-charts#how-to-display-data-experiment-with-motion-chart-display-settings|How to display data & experiment with motion-chart display settings]]** * **MORE DETAIL: [[:howtos:google:motion-charts|How to create and customise Google motion charts]]** * **TEACHER RESOURCES: [[:learn:rainforests:home|Resources for teachers]] ** * **THIS PAGE: [[:learn:rainforests:home|Rainforests motion chart: this page!]]** ---- ====== Download A Forest (or Other) Data Set From The Internet: ====== Find and download a wide range of data sets, visit [[http://datahub.io/dataset|this site]] http://datahub.io/dataset and search for 'forest' (for example): {{:rainforests:datahub-io.jpg|Download Data}} ** Example screen grab of datahub.io [[http://datahub.io/dataset?q=forest&sort=score+desc%2C+metadata_modified+desc|search results:]]** Look for an item that has [CSV] or [XLS] that you can click on to download data - clicking on the [CSV] or [XLS] button will take you to a page where you can preview and/or download that data. For [[http://datahub.io/dataset/utc-urban-tree-report-virginia-beach-virginia-2010-05-18|some locations]] it is possible to separately download and then combine two or three data files of the same type. ---- ====== About The Example Data: ====== A real example - [[https://www.youtube.com/watch?v=6eh4EqVCXLk|how satellite data can be used]] * Our Data Source: [[http://www.obt.inpe.br/prodes/index.php|Amazon Deforestation 2004-2014]] - [[http://www.obt.inpe.br/prodes/index.php|Note:]] This 'official' data and includes legally cleared land only. * Sheet 1. {{:rainforests:amazon-no-totals-2004-2014.csv|Amazon Deforestation 2004-2014}} * Sheet 2. {{:rainforests:amazon-with-totals-2004-2014.csv|Amazon Deforestation 2004-2014 (inc. totals)}} * Source for data used in motion chart: http://www.obt.inpe.br/prodes/index.php * Summary of Amazon Forest Loss: http://rainforests.mongabay.com/amazon/deforestation_calculations.html * Other DataSets: http://data.globalforestwatch.org/datasets?q=countryIDN|Indonesia]] *