Wednesday, October 22, 2014

Mapping Nobel Prize Winning Women

After the recent passing of author Doris Lessing (1919-2013) I became curious how many women have received the Nobel Prize since 1901. Not that many I have come to discover. Of the 851 individual Laureates, 45 have been women, or roughly 5%. According to NobelPrize.org, 25 organizations have been awarded the Nobel Prize, as well. Examples of organizations include Bangladesh's Grameen Bank (2006), Medecins Sans Frontieres (Doctors Without Borders, 1999), Amnesty International (1977), and the United Nations Children's Fund (UNICEF, 1965).

The connection between education for women and girls and economic progress and development is clear. Investments in education for women and girls in developing and underdeveloped countries results in positive economic and social progress. Around the world, from the United States to Africa and Southwest Asia, investment in education, and especially STEM education, improves wages, improves health care, reduces child mortality, and increases political action and commitment.

My hopes are the map may help inspire people to improve the recognition of the contributions of women throughout all segments of global society. 


Click "Legend" to open the map's legend. The pins are color-coded by the Nobel award, green for chemistry, red for physics, silver for economics, and so forth. Click on a pin and the information for a particular Nobel winner will appear. When the window opens, scroll to the bottom. I added a link to the winner's entry on NobelPrize.org and used a link to their Wikipedia.org entry for a picture, if one was available. I assigned the colors, by the way. The interactive map above was created from a simple spreadsheet.

The spreadsheet is very simple to create. A little forethought must be given to how the data is organized. As I tell my students, you don't have to be an expert in the topic, but you do have to understand how to organize information. In this case, I mapped the winners by their place of birth. However, in many cases, the winners did not their award in their home country. Before and during World War Two, a mass exodus of people from Western, Central, and Eastern Europe occurred in advance of Nazi Germany influence. In some cases, the location does not note the place of birth but the country of residence at the time of the award. This special circumstance might make for an interesting lesson plan for middle or high school students, by the way. Both men and women Nobel Prize awards for the 1940's exhibited considerably disruption due to the war.


As the above spreadsheet illustrates, nothing fancy is going on. Year, Winner's Name, City, Country, Prize Category, etc. A couple of special notes; for the data to be mapped, some information about location must be provided. Now, I have provided "city" and "country." I could use a technique called "geocoding," but this process comes at a real cost. Some processes included with ArcGIS Online come with a real dollar amount attached and cost real money. Geocoding is one of those processes. I opted not to charge geocoding against our account and elected to use geographic coordinates instead. Thus, the "x" and "y" are latitude and longitude. The ArcGIS Online dashboard comes equipped to handle data attached to geographic coordinates at no cost to the user. The upload process is also smart enough to identify geographic coordinates in a spreadsheet in the event an unsophisticated user provided unusual field headings, like "peanut_butter" and "jelly." The data within the record is often enough to offset unfortunate headings.

There are two columns missing from the above graphic. The first missing field is "image_LNK." This is a reserved field name. Use this field to provide a link to an online image. The field must contain the fully qualified URL to the image. The second missing field is "wiki_LINK." This field contains the URL to pertinent Wikipedia page. I believe adding other custom fields is possible, though I have not explored this potential. To provide better coverage, below is the rest of the spreadsheet.


This is not a precise tutorial for putting data online. The process is not more involved than what I have described, though. ArcGIS Online maps can be shared with selected Murray State people or Murray State groups, or can even be made public. And, as you have see above, can even be embedded in a website.

The same potential for building map applications similar to the two maps I have posted exists for kids in kindergarten through high school in Kentucky. Sponsored by the Kentucky Geographic Alliance, all K-12 schools in Kentucky have at their disposal ArcGIS Online for Education. Check out connected.esri.com for complete details.

For more information about ESRI's ArcGIS Online for Education at Murray State contact Michael Busby at the Mid-America Remote sensing Center (MARC.)

Dr Robin Zhang Keeps Up with Geoscience Graduates

In the 2013-2014 academic year Murray State University charged individual departments with keeping track of graduates. Figuring out geographic distributions, mapping geography, is something geographers tend to be pretty good at. In the Department of Geosciences, Dr. Robin Zhang took on the task of mapping where Geosciences graduates end up soon after graduation.

Using ArcGIS Online, a free mapping application provided by ESRI courtesy of MSU/MARC, Dr. Zhang decided to give the mapping application a shot. Below, is the GIS-based mapping application created by Dr. Zhang illustrating the distribution of Geosciences graduates.


Interactive maps like the one above are pretty easy to create. To create one of these interactive maps, an ESRI Global Account is required. These accounts are free, created simply by visiting ESRI.com and filling out a short form. An account can also be created by the local ESRI Site License Administrator, Michael Busby. An invitation to join the Murray State University ArcGIS Online community is also necessary. Again, this request goes to the local ESRI Site License Administrator, or can be handled during the ESRI account request.

The account provides access to ESRI's ArcGIS Online for Education. The next bit of the puzzle is managing the data. In Dr. Zhang's map app, her data were the locations of Geosciences alumni - people. People will gainful employment are typically tied to an employer's address, a building. The building can be located in a number of ways, but most commonly with an address or a set of coordinates. By clicking on one of the colored dots, information on a person is revealed, including the longitude and latitude (x and y) of the employer's location. To put a point on a globe one needs a coordinate, a longitude and latitude. With that important element in a spreadsheet, each row in a spreadsheet then becomes a mappable record.

In essence, one really only needs a spreadsheet replete with information, tied in some way to a place on the Earth. Then, an interactive map is born. In my next post, I will demonstrate my interactive map and provide an example of my spreadsheet.


GitHub Student Developer Pack

GitHub recently released a suite of software, programming resources, cloud development tools, and other development resources specifically for students.

The Education branch of GitHub has partnered with several providers to offer students a nice bundle of free services, software, and opportunities to begin app and service development.

For complete information, click here.

To be eligible, you must be a student aged 13+ and enrolled in a degree or diploma granting course of study. All one needs is a school-issued email address, valid student identification card, or other official proof of enrollment.

To get access to the pack, GitHub will need to verify your student status. Sign up using the form and GitHub will send you an email once you've been verified.

GitHub Education is also a great STEM resource for crowdsourcing programming, for software development, for learning to code, for improving code, and for all sorts of activities related to software development.