Title: Introduction to Map Making with Excel
Course: MappingwithExcel > Section: Mapping with Excel

Bonus Module: Map Making with Excel

Introduction

In today's highly mobile and connected society more and more of our daily life utilizes maps and map apps, like Google Maps.  We are becoming highly dependent upon maps and geospatial information about location to get around and make decisions, like where to shop, where to eat, how to get there.  Now, we can combine the power of Excel spreadsheets with online mapping websites, such as Google Maps.  In this brief exercise we will demonstrate how to use the Internet to find geolocation data (data that contains addresses), download it to Excel, copy & paste it to an online geospatial processing website, and create our own instant Internet Map.  When you're done, you will have a Google map that looks like this image:

Step 1: Get the Excel Data

For this exercise we will first search the Internet for data on the location of colleges in California.  We would like to find all of the University of California campus locations around that state.  Fortunately, the State of California provides this information in a convenient website for free.  For this exercise you will select the fields shown in this PDF file: California Colleges Mailing List.pdf: Click this image to launch the website.  Return here when you're done.

If all else fails, here's the Excel data.UCCampusAddresses.csv

Step 2: Copy CSV Data From Excel into Windows Clipboard

Now that we've got the data, we are ready to copy it to the Windows Clipboard and paste into the website for geoprocessing.  Select the rows and columns to copy from Excel:

Step 3: Paste the CSV Data into the Batchgeo Website for Processing

Now you have the data in the Windows Clipboard, lets open the Map Making website and paste the data into the window as shown by this image:

Step 4: Perform Geoprocessing to Covert CVS Data into Geolocation Information

Next press the MAP NOW green button and watch as the BatchGeo website crunches your Excel data using geocoding and builds you instant Google Map!

Step 5: Save Your Map

Now you are ready to save and share you map with the world!  Press the SAVE & CONTINUE green button and enter your information as shown here:

Step 6: Copy & Paste Map URL

Lastly, you will see your personalized Google Map, with the location of the University of California campuses mapped. You can click on any of the red push pens to see detailed data on that campus that came from your Excel spreadsheet.  Copy and paste the URL of your map into the Canvas Assignment to receive your BONUS CREDIT!

Here's an example of My Map made using these instructions.

Bonus Credit Procedure

This bonus module is brought to you by the National Information, Security & Geospatial Technology Consortium, DOL TAACCCT federal grant.  To receive the bonus credit, we ask you to provide us with some student tracking data that will allow us to report the impact on your learning to our funding agency, the Department of Labor.  This information is kept in strict confidence and any identifying information is kept under lock & key by the college.  We do not share your data with any companies and use the information to document our grant efforts solely.  Please follow these voluntary steps:

1. It is imperative that you as a participant in this technology education program participate by completing the electronic intake form for Del Mar College, NISGTC and the DOL. The link to the electronic form is posted below. Please complete the form in its entirety and then you must SUBMIT the Electronic Document. The data compiled is protected in our DMC institutional advancement data base for analysis. If you have already completed this electronic form, please do not complete 2nd time. If this is your first NISGTC Intro to Computers course, this may very well be your first attempt at completing the electronic form. Please complete the form, the data is vital to securing additional funding as well as improving the program for the campus, the students and the community at large. The electronic form should only take you 10 minutes to complete. If you have any questions please contact your instructor or our NISGTC office (John Nelson 698-1478, and Julie Ettenger 698-1475) http://dmc122011.delmar.edu/cgi-bin/IRESurvey/rws5.pl?FORM=NISGTS_IntakeForm_SP13
2. Complete the following document, sign and return to your instructor as either: a) paper document, b) PDF attachment to email, c) a picture image of the document, or d) a fax to 361.698.1479: ConfidentialityAgreement09072013.pdf