Data Agent Team 4 collaborative Etherpad

This text pad is synchronized as you type, so that everyone viewing this page sees the same text. This allows you to collaborate seamlessly on documents!
Thanks for working together with your peers!

MISSION 1 Google Hangout Rendezvous
Date: Sunday Apr. 28 1:30 PM UTC/GMT 9:30 AM Eastern Daylight Time
Next Meeting: Sunday May. 5, 1:30 PM UTC/GMT 9:30 AM Eastern Dayllight Time
Agenda: 
  1. Assign meeting roles (facilitator, note-taker, timekeeper...)
  2. Intros and hellos
    1. logistics, meeting times etc
    2. Skills inventory
    3. Learning goals
  3. Dataset: Create a list of all of your potential questions you’d like to explore with this data
    1. Respond with a “+1” to other’s ideas you might also like to explore.
    2. Cluster into 2 or 3 groups based on the number of +1 votes and similarity of questions. You’ll be answering the same question together, but working on your own analysis individually.
    3. Ask: Do you have all the data you need to answer these questions? You are welcome to scour the web for more open data, Agents.
    4. Next Step 1: You’ll receive instructions on how to clean your data in an upcoming missive. (MISSION 2)
  4. Toolset: questions or concerns
    1. Doodle
    2. Google+
    3. Etherpad
    4. Badges.p2pu.org
  5. Review action items and calendar assignments


Attendees:
Facilitator:
Notetakers:
TImekeeper:

Jimena, dxtr

Meeting Notes:
Potential questions We’d like to explore with this data 

Who is the worst polluter? +1
Why are Virgin Island and Gibraltar outliers in terms of per capita emissions +1
Do we have all the data we need? No. Check Google's public dataand other sources to look for possible parameters to correlate.

Action Items and who's responsible:

Jimena: Create Googe event for next Sunday's Meeting
Jimena: create Google fusion tutorial
Jimena: will post data visualisation tools and URLs
dx & Jimena: go through cleaning tutorial http://bit.ly/ttc-cleaning


GOOGLE FUSION TABLES (steps)
1. Go to google and type "fusion tables"
2. Choose "Fusion tables", clicking "create a table"
3. Updload your xls table (clean it before a little bit, so you don´t have blank spaces, incorrect formats in cells, etc). I did it as I explain here: https://docs.google.com/document/d/18Myv1mjiCC-Fe_f1CKDsPJclku9OrusxkQDN7oN-k74/edit?usp=sharing
4. Go to the Map of Location tab (you  need to have a column with names of countries or regions in your data)
5. Play with the options of the Tools tab  (window layout and map styles) to change the symbols on the map. Be aware about some cartography rules to symbolize data!
Here I put the website with the clean data about World Co2 emissions:  https://www.google.com/fusiontables/data?docid=1MtH2OzRZyIAPwNH6mu3fzFXLxrDRkT6KXEUrznc#map:id=3
And here there is an example of using these kind of data in a nice visualization: http://carbon.to/

Still don´t know how to visualize series of data (it seems that here you can only visualize one serie-one year- of data). But you can do it in "Google Public Data".


SOME DATA VISUALIZATION TOOLS I KNOW (Jimena)

Hope you like it. I will put more when I have more time!

CLEANING DATA (Jimena´s conclusions)
I put here all my conclusions and how I cleant the dataset: https://docs.google.com/document/d/18Myv1mjiCC-Fe_f1CKDsPJclku9OrusxkQDN7oN-k74/edit?usp=sharing
And here is the Excel file cleant: https://docs.google.com/file/d/0B2CqcEtA2rTPNm93VTJ6ZTF1WUE/edit?usp=sharing
______________________________

Here is the dataset: http://bit.ly/CO2_data
Background source: http://www.eia.gov/cfapps/ipdbproject/IEDIndex3.cfm. 
For further briefing: http://www.guardian.co.uk/global-development/2013/apr/17/land-grabs-europe-big-business-farming
Original brief available at http://schoolofdata.org/datamooc/ 
Emergency reinforcement:  <missioncontrol@p2pu.org>

Pre-mission Action Items:

______________________________

Data Agent Team 4 Intros/bios

Dexter X: Montreal-based environmental justice and human rights activist, with a background in direct action, civil disobedience, documentary television, experimental film and community radio. 
Jimena Martinez Ramos: I am from Spain, I lived in The Netherlands for a year and in January I moved to St. John's, NL. I am a Geomatics Engineer and now I am pursuing my PhD at Memorial University of Newfoundland, my topic is related to Volunteered Geographic Information and Semantics.
I like to play with data (especially geodata) for telling stories, and I love documentary photography and films.
Here they are my personal website [1] and my photo web [2].[1] http://jimena.snappages.com/ [2] http://jimenamartine.wix.com/photo
Jonathan Bechtel: I own a health supplement company and have always had a head for numbers.  I'm excited about taking this course because I believe it will empower me to answer important questions about my own business as well as further enhance my tech/data skills.....a competency I'm always looking to improve upon.I love economics, running/fitness, and of course, meeting new people :)
Adam Collado: I'm a Computer Tech/Technical Coordinator/Data Specialist/Jack-Of-All-Trades at a small High School in Brooklyn, NY in America. I studied Economics in College and developed a love for finding the ways we (as individuals, groups, and communities) use our resources. I'm especially interested in the field of behavioral economics. I've taken a bunch of P2PU courses, as well as other free online course-ware sites, so I have a pretty deep interest in the concept of online education experiences. I received an email about Data Explorer Missions via the P2PU mailing list and thought it sounded fun to try! Can't wait to collaborate with the rest of the group and learn a bit more about our current task!
Borja Nicolas (Nico): I am from Spain too! (Small world, huh?) I am a journalism student but I am also taking lessons at codeacademy. I am currently working at DisneyWorld, Orlando and I want to improve my data skills. I can not wait to work with you! :)
Maria Rosa Gamarra: I work as regional expert within knowledge management/sustainable management fields in Latin America.  My background is from Infomation Management and now I´m working hardly within Database Management to support large project, mainly in cooperation for development field. I´m so excited with this new activity and hopefully I will contribute effectively there
Erich Smith (E for short): I am a program manager with a local educational non-profit in Philadelphia, Pa.
I have a deep interest in Data mining, un-covering the underling determinate(s) of data trends/predictions, and how data can predict general-to-specfic impacts.  The process which all this happens is why joined the mission, our shared thoughts will lead to new insights and understandings. 

_________________________________