Differences

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

--- playground:soda1 [2015/04/24 14:27] – loleg
+++ playground:soda1 [2015/04/30 21:25] (current) – loleg
@@ Line 1: / Line 1: @@
-====== SoDaCaMp001: The art of spreadsheets ======
+====== SoDaCaMp: The art of spreadsheets ======
+{{ http://soda.camp/images/karate_05.png?120|}}
 Background: [[http://make.opendata.ch/school|in English]], [[http://make.opendata.ch/schule|auf Deutsch]].
-{{ http://soda.camp/images/karate_05.png?120|}}
 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.
-For background information, see **[[http://make.opendata.ch/school|School of Data Switzerland]]**. A first session facilitated by [[http://SoDa.CaMp|SoDa.CaMp]] is planned for **May 1, 2015**. Please contact [[http://utou.ch|Oleg]] to take part.
+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.
-=== Introductions and what is data? ===
-.00 – 11.00
-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 or pictures that come to mind when thinking of numbers/statistics/data. Now sketch or talk about how it makes you feel when someone tries to convince you of something you disagree with using elaborate diagrams and factoids.
-=== Internet breakout #1 ===
-.00 - 11.25
-We will do a short [[https://plus.google.com/hangouts/_/calendar/bGF2cm92c2t5QGdtYWlsLmNvbQ.286mo4diqsce23iq75au2gl010?authuser=0|online Hangout]] and see if anyone wishes to join through the Internet. While this is running, we will collect and post highlights of our introductory exercise in the form of a Simple Data Package.
-=== Data sources & establishing trust ===
-.30 – 12.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 ===
-.00 – 14.00
-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, and ideal learning and practice paths.
-{{ http://soda.camp/images/karate_08.png?120|}}
-=== Internet breakout #2 ===
-.00 - 14.25
-We will do a second short [[https://plus.google.com/hangouts/_/calendar/bGF2cm92c2t5QGdtYWlsLmNvbQ.4f3hkajbfgti41qf338943npv4?authuser=0|online Hangout]] and see if anyone wishes to join through the Internet. While this is running, we will collaborate on cleaning data from an Open Data Portal online.
-=== Spreadsheet geijutsu ===
-.30 – 15.30
+The current plan for the day is here: [[http://j.mp/sodacamp001|SoDaCaMp 001.pdf]]
-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.
+Links and notes on this Etherpad: https://pad.okfn.org/p/6VHvCJVnnP