4 ms·
I teach data journalism to a class of ~20 students with no teaching assistants and it sounds like my curriculum has some overlap with the author's. I spend the
by danso 11y ago
I teach data journalism to a class of ~20 students with no teaching assistants and it sounds like my curriculum has some overlap with the author's. I spend the first few classes focused on spreadsheets -- including formulas and pivot tables.
After that, I go full on into SQL. This was initially motivated by the fact that SQL is a pretty important skill, and it is one of the most succinct ways to describe the concept of computationally joining two datasets to find interesting insights...which is basically the core of journalism (e.g. a list of names of business owners and a list of names of political campaign contributors)...but I've found it's a great way to teach computing in general. For most of these students who have never programmed, SQL is the first time that they've had to tell a computer exactly what they want. For example, I used to think it was a pain to have to specify every column you want to see with a `SELECT` statement...but this is in perfect contrast with how Excel works. The latter by default shows everything, and this has implications with not just computer performance and dataset size limitations, but in data filtering...that is, you're forced to see all the data columns at once, even if it's far too much to consume. With SQL, it's about knowing exactly what you want to see and telling the computer to do it exactly the way you want.
On the teaching side, this makes things far easier for me. I no longer have to teach a GUI, which is a long series of me saying "Click here...unless you're on PC/on version 2011X/have a window size less than 1024px wide" and writing tedious guides of screenshots. With SQL, I just write SQL. And the exercises can be stated in plain English.
For the exams, I basically made them write out a bunch of queries on real-world datasets which I described in plain English...I gave them the expected results, and so they had to write the queries that got the answers. Very easy to grade and very easy to give them help on (they were take home exams):
Baby name data: http://2015.padjo.org/assignments/midterm-babysteps-sql/ http://2015.padjo.org/assignments/midterm-babysteps-sql/
Medicare data: http://2015.padjo.org/assignments/midterm-wsj-medicare-walkthrough/ http://2015.padjo.org/assignments/midterm-wsj-medicare-walkt...
And to comment on the author's experience with the "stereotype threat", in which students of traditionally minority groups hesitate to speak up because they feel they are being judged by that group, e.g. xkcd #385 http://xkcd.com/385/...this http://xkcd.com/385/...this is definitely a phenomenon. Last year I had a nearly all female class and they had no problems at all speaking up/out at me. In elective programming classes with more males, they generally were more reserved.
- random_rr 11y agoThose baby name questions are pretty neat! Thanks for sharing this.
- tsumnia 11y agoYeah, I think I'm going to steal the dataset for one of my classes!
- danso 11y agoHelp yourself! I find the baby name data a great scenario for teaching data...everyone has a name, everyone has assumptions and opinions about how popular and genderized their names are, and everyone is fascinated by how many/few other American babies share their name. The data is structurally simple -- 4 columns, 5 if you use the state-by-state version -- yet numbers in the hundreds of thousands of rows. Plus, even being so simple, it contains virtually all of the "dirtiness" of real world data.
- psyklic 11y agoThanks! I'm also a big fan of your data journalism Python exercises: https://github.com/compjour/search-script-scrape/ https://github.com/compjour/search-script-scrape/