This assignment is to take your data from Homework #4 & #5 and upload it to google. You will need a google account (Gmail, Drive, Blogger or other). Any account should work. Once yoiu have one google account, you can add other services.
Google fusion tables are on Google Drive. If you do not have a google account, sign up for free, for google drive.
Below is a video on Google Drive and how it works
What is Google Fusion Tables?
It allows you to visualize data in a map format instead of a table or chart format.
You can upload excel data with locational information (Lat/Long, addresses, city and etc.). Once you upload this spreadsheet, you can map each row (record or transaction) to google map. It allows you to show your data in a map format. Google will map each row. Once mapped, you can use the informational data about each row (the columns) to highlight what is important.
For example, your data has addresses. You can map each address and show them on a google map. The you can change to color of each dot based on other information in the spreadsheet, like sales price.
See an example here.
From Menu click Visualize:Map
Here is a youtube tutorial example
http://www.youtube.com/watch?v=pLL2EDXfaXQ
Youtube Video about using buckets to colorize your data
We will work on this in class on Monday Oct 22, 2012. I will be available for a one-on-one on Wednesday Oct 24, 2012 from 9:25 am to 1:25pm on Skype (username: osistrunk3) or join.me.
There will be no formal class on Wed Oct 24, 2014. So use that time to work on your homework.
This homework assignment was very interesting. I never used google fusion tables and therefore was amazed at how many things it enables you to do like geocode your data into a map and actually see where everything is. This is also my first time using google drive which allows you to upload almost any document or spreadsheet in the cloud. I think that learning these tools would be very beneficial to me in the near future.
ReplyDelete