MIS Spring 2015: Monday March 22, 2015 - Class #17 - Excel HW #6

GOOGLE FUSION TABLES

Other than tables and charts, another good way to present data is with maps. To use maps in a presentation, the data needs locational information (for example, state, zipcode, lat/long, street name and/or street numbers).

For this assignment you will need to find some data with locational variables, so fusion tables can geocode each record. Remember each row is a record and each column is a data field. Make sure the data you get has a few numbers-based data fields (example:building size, sales price, land acreage and/or year building was built).

Assignment: Remember to use screencast-o-matic to record the steps below.
1) Use the excel file from the last two Excel HW assignments. Use the one you already downloaded. The version in the cloud might have been altered from my using it last class.
2) Cut the number of rows from 8,000+ to about 200.
3) 200 will make Google geocoding finish sooner
4) Create the concontenate column (see video below) remember Monday's class
5) Use Save-as to make sure this file is saved as an excel file (.xls)
6) Upload into Google Fusion Tables
7) Map records
8) Change style (see video below)
9) Add Legend to map (see video below)

This Homework #6 is due Sunday March 29, 2015 at midnight.

There is no Classmarker exam.

Once you finish your Google fusion table, upload your created video and complete the form below, to submit your homework.

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.

I will be available for a one-on-one on Skype (username: osistrunk3).
Join.me can be used so I can look at your PC screen from my PC screen
Just text me (4045090533) to set an appointment.
Do not wait until the last minute.

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