Differences

This shows you the differences between two versions of the page.

--- playground:soda1 [2015/04/21 12:38] – created loleg
+++ playground:soda1 [2015/04/30 21:25] (current) – loleg
@@ Line 1: / Line 1: @@
-====== SodaCamp 001: The art of spreadsheets ======
+====== SoDaCaMp: The art of spreadsheets ======
 {{ http://soda.camp/images/karate_05.png?120|}}
-This afternoon workshop is a condensed version of the [[http://schoolofdata.org/2015/01/05/two-day-data-training-in-macedonia/|Macedonian sessions]] run by the School of Data. The intent is to familiarise ourselves with the basic "hammer" of data wrangling: the humble spreadsheet. At the same time we will bend the rules a little and show some creative things you can do with a bunch of cells. For background information, see [[http://make.opendata.ch/school|School of Data Switzerland]] and [[http://soda.camp|Soda.Camp]].
+Background: [[http://make.opendata.ch/school|in English]], [[http://make.opendata.ch/schule|auf Deutsch]].
-=== Introductions and what is data? ===
+This workshop is a condensed version of the [[http://schoolofdata.org/2015/01/05/two-day-data-training-in-macedonia/|Macedonian sessions]] run by the [[http://schoolofdata.org|School of Data]]. The intent is to familiarise ourselves with the basic "hammer" of data wrangling: the humble spreadsheet, and for those already comfortable in Calc, Excel or Tableau, to talk about optimal ways of exploring and communicating data with them. At the same time we will bend the rules a little and make creative use of the calculation engines in our spreadsheet.
-.00 – 13.15
+A first session facilitated by [[http://SoDa.CaMp|SoDa.CaMp]] is planned for **May 1, 2015**, please contact [[user:loleg]] to take part in person in Bern, as we have space limited to 10 participants. We will also run two virtual Hangouts at [[https://plus.google.com/hangouts/_/calendar/bGF2cm92c2t5QGdtYWlsLmNvbQ.286mo4diqsce23iq75au2gl010?authuser=0|11.00 - 11.25]] and [[https://plus.google.com/hangouts/_/calendar/bGF2cm92c2t5QGdtYWlsLmNvbQ.4f3hkajbfgti41qf338943npv4?authuser=0|14.00 - 14.25]], which are also limited to 10 virtual paricipants.
-Short introduction round, talk about what we aim to accomplish, basic concepts of machine-readable data. Warm-up exercise: open up a spreadsheet and in 3 minutes fill it with words that come to mind when thinking of numbers/statistics/data. Now sketch on paper how it makes you feel when someone tries to convince you of something you don't want to hear with these kinds of things.
+The current plan for the day is here: [[http://j.mp/sodacamp001|SoDaCaMp 001.pdf]]
-=== Data sources & establishing trust ===
+Links and notes on this Etherpad: https://pad.okfn.org/p/6VHvCJVnnP
-.15 – 14.30
-Overview of data portals and other sources, tips on how to search for data effectively, intro to [[http://datahub.io]] and other open data sites. Where to find/borrow/scrape data, get help finding data, create your own data, use random data. How to ensure data quality and trustworthiness, verify sources, good (as in legal and respectful) practices in working with data. The ethics of data art and creative license. If any of these are sticky points, we will spend more time.
-=== Spreadsheet-fu ===
-.45 – 15.30
-After a short break, we will learn how to manage a table using commands like SUMIF and VLOOKUP, explore data better using pivot tables and talk about where to learn more advanced techniques. We will then prepare tables for printing, Web sites, and visualisations using tools like D3 and Tableau. We will discuss what mastery of spreadsheets entails?
-{{ http://soda.camp/images/karate_08.png?120|}}
-=== Spreadsheet geijutsu ===
-.30 – 16.30
-We will end the workshop by making art right in the same place where we were doing data analysis minutes before. Or feel free to continue practicing your spreadsheet-fu, as each participant prefers. We can talk about the notion of generative art, the many styles of interacting and working with data, and some of the different ways symbolic information is perceived and interpreted by the brain.