Classes are over















NEXT CLASS

Semester Over
It was Fun and I hope
you learned something
in this class. Review this blog in 2033
and see if we were right.


Tuesday, April 2, 2013

Wednesday April 3, 2013 - Google Maps and Google Fusion Tables

This Homework #6 is due Sunday April 7, 2013 at midnight. There is no exam this time. Once you finish your Google fusion table, save it and then share it with me at osistrunk@gmail.com. Make sure you either make it public or available for viewing by me. Your grade will be based on how well your map looks and the coloring of the location dots based on sales price, city or date.

This assignment is to take your data from the this excel file, which has data used in Homework #4 & #5 and upload it to Google.

You will need a Google account (Gmail, Drive, Blogger or other). Any account should work. Once you 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 



                                                  https://www.youtube.com/watch?v=mpOmuG3HfPo

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.





 Here is a Youtube tutorial example 




 Youtube Video about using buckets to colorize your data



We will work on this in class on Wednesday April 3, 2013.

I will be available for a one-on-one on Skype (username: osistrunk3) or join.me. Just text me (4045090533) to set an appointment.

No comments:

Post a Comment