-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathindex.html
195 lines (188 loc) · 19.5 KB
/
index.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Data journalism</title>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="css/bootstrap.min.css" rel="stylesheet">
<link href="css/custom.css" rel="stylesheet">
</head>
<body class="markdown github">
<header class="navbar-inverse navbar-fixed-top">
<div class="container">
<nav role="navigation">
<div class="navbar-header">
<button type="button" class="navbar-toggle" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1">
<span class="sr-only">Toggle navigation</span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
<a href="index.html" class="navbar-brand">J298 Data Journalism</a>
</div> <!-- /.navbar-header -->
<!-- Collect the nav links, forms, and other content for toggling -->
<div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
<ul class="nav navbar-nav">
<li class="dropdown">
<a href="#" class="dropdown-toggle" data-toggle="dropdown">Class notes<b class="caret"></b></a>
<ul class="dropdown-menu">
<li><a href="week1.html">What is data?</a></li>
<li><a href="week2.html">Types of stories</a></li>
<li><a href="week3.html">Working with spreadsheets</a></li>
<li><a href="week4.html">Acquiring, cleaning, and formatting data</a></li>
<li><a href="week5.html">R, RStudio, and the tidyverse</a></li>
<li><a href="week6.html">Data journalism in the tidyverse</a></li>
<li><a href="week7.html">Don't let the data lie to you</a></li>
<li><a href="week8.html">Databases and SQL</a></li>
<li><a href="week9.html">Finding stories using maps</a></li>
<li><a href="week10.html">Maps meet databases</a></li>
<li><a href="week11.html">More PostGIS</a></li>
<li><a href="week12.html">R practice</a></li>
<li><a href="week13.html">PostGIS practice</a></li>
<li><a href="week14.html">More fun with R</a></li>
</ul>
</li>
<li><a href="software.html">Software</a></li>
<li><a href="datasets.html">Data</a></li>
<li><a href="questions.html">If you get stuck</a></li>
<li class="dropdown">
<a href="#" class="dropdown-toggle" data-toggle="dropdown">Email instructors<b class="caret"></b></a>
<ul class="dropdown-menu">
<li><a href="mailto:[email protected]">Peter Aldhous</a></li>
<li><a href="mailto:[email protected]">Amanda Hickman</a></li>
</ul>
</li>
</ul>
</div><!-- /.navbar-collapse -->
</nav>
</div> <!-- /.navbar-header -->
</header>
<div class="container all">
<header class="navbar-inverse navbar-fixed-top">
<div class="container">
<nav role="navigation">
<div class="navbar-header">
<button data-target="#bs-example-navbar-collapse-1" data-toggle="collapse" class="navbar-toggle" type="button">
<span class="sr-only">Toggle navigation</span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
<a class="navbar-brand" href="index.html">J298 Data Journalism</a>
</div>
<div id="bs-example-navbar-collapse-1" class="collapse navbar-collapse">
<ul class="nav navbar-nav">
<li class="dropdown">
<a data-toggle="dropdown" class="dropdown-toggle" href="#">Class notes<b class="caret"></b></a>
<ul class="dropdown-menu">
<li><a href="week1.html">What is data?</a></li>
<li><a href="week2.html">Types of stories</a></li>
<li><a href="week3.html">Working with spreadsheets</a></li>
<li><a href="week4.html">Acquiring, cleaning, and formatting data</a></li>
<li><a href="week5.html">R, RStudio, and the tidyverse</a></li>
<li><a href="week6.html">Data journalism in the tidyverse</a></li>
<li><a href="week7.html">Don't let the data lie to you</a></li>
<li><a href="week8.html">Databases and SQL</a></li>
<li><a href="week9.html">Finding stories using maps</a></li>
<li><a href="week10.html">Maps meet databases</a></li>
<li><a href="week11.html">More PostGIS</a></li>
<li><a href="week12.html">R practice</a></li>
<li><a href="week13.html">PostGIS practice</a></li>
<li><a href="week14.html">More fun with R</a></li>
</ul>
</li>
<li><a href="software.html">Software</a></li>
<li><a href="datasets.html">Data</a></li>
<li><a href="questions.html">If you get stuck</a></li>
<li class="dropdown">
<a data-toggle="dropdown" class="dropdown-toggle" href="#">Email instructors<b class="caret"></b></a>
<ul class="dropdown-menu">
<li><a href="mailto:[email protected]">Peter Aldhous</a></li>
<li><a href="mailto:[email protected]">Amanda Hickman</a></li>
</ul>
</li>
</ul>
</div>
</nav>
</div>
</header>
<div class="container all">
<h1 id="data-journalism,-spring-2018"><a name="data-journalism,-spring-2018" href="#data-journalism,-spring-2018"></a>Data Journalism, Spring 2018</h1><p>This course is for students who want to make finding and reporting stories from data part of their toolkit. It will be useful for anyone interested in investigative journalism, which nowadays is often heavily data-driven, or those keen to use data to provide context and ground-truth for regular beat reporting. You should be comfortable with numbers, and thinking critically and quantitatively. You must be prepared to work with some simple code (in R and SQL), and to get your hands dirty with real-life, messy data!</p><h3 id="weekly-schedule"><a name="weekly-schedule" href="#weekly-schedule"></a>Weekly schedule</h3><p>We will meet in <strong>108/Lower NG</strong> on Thursdays from 6pm - 9pm. Your instructors, <a href="http://www.peteraldhous.com/"><strong>Peter Aldhous</strong></a> and <strong><a href="http://velociraptor.info/">Amanda Hickman</a></strong>, will maintain office hours over Skype. You are encouraged to arrange appointments to discuss your work.</p><ul>
<li><h4 id="**jan.-18:**-[**what-is-data?**](week1.html)"><a name="**jan.-18:**-[**what-is-data?**](week1.html)" href="#**jan.-18:**-[**what-is-data?**](week1.html)"></a><strong>Jan. 18:</strong> <a href="week1.html"><strong>What is data?</strong></a></h4>
<p>Categorical and continuous variables; basic operations for interviewing a dataset; sampling and margins of error; plotting and summarizing distributions; choosing bins for your data; basic newsroom math. (<strong>Peter Aldhous</strong>)</p>
<ul>
<li><strong>Assignment:</strong> File a preliminary pitch for a data-driven story. Also, read stories for discussion in week 2.</li></ul>
</li></ul><ul>
<li><h4 id="**jan.-25:**-[**data-journalism:-types-of-stories**](week2.html)"><a name="**jan.-25:**-[**data-journalism:-types-of-stories**](week2.html)" href="#**jan.-25:**-[**data-journalism:-types-of-stories**](week2.html)"></a><strong>Jan. 25:</strong> <a href="week2.html"><strong>Data journalism: Types of stories</strong></a></h4>
<p>Through a tour of some great examples of data journalism, we’ll get inspiration for our work in this course. (<strong>Peter Aldhous</strong>)</p>
<ul>
<li><strong>Assignment:</strong> Quiz on good practice in data analysis and data journalism.</li></ul>
</li></ul><ul>
<li><h4 id="feb.-1:-[**working-with-spreadsheets**](week3.html)"><a name="feb.-1:-[**working-with-spreadsheets**](week3.html)" href="#feb.-1:-[**working-with-spreadsheets**](week3.html)"></a>Feb. 1: <a href="week3.html"><strong>Working with spreadsheets</strong></a></h4>
<p>Understanding spreadsheet functions and pivot tables is the foundation for the rest of your exploration of data. We’ll learn how to troubleshoot and use spreadsheets. (<strong>Amanda Hickman</strong>)</p>
<ul>
<li><strong>Assignment:</strong> Pivot table assignment.</li></ul>
</li></ul><ul>
<li><h4 id="feb.-8:-[**acquiring,-cleaning,-and-formatting-data**](week4.html)"><a name="feb.-8:-[**acquiring,-cleaning,-and-formatting-data**](week4.html)" href="#feb.-8:-[**acquiring,-cleaning,-and-formatting-data**](week4.html)"></a>Feb. 8: <a href="week4.html"><strong>Acquiring, cleaning, and formatting data</strong></a></h4>
<p>Where and how to find data online. Tips and tricks for downloading unruly data, including browser extensions to extract data from web tables and download from multiple files <em>en masse</em>. (<strong>Peter Aldhous</strong>)</p>
<ul>
<li><strong>Assignment:</strong> Data cleaning exercise.<ul>
<li><strong>Assignment:</strong> Revise your pitch for a data-driven story. <em>Due Feb 24</em></li></ul>
</li></ul>
</li></ul><ul>
<li><h4 id="**feb.-15:**-[**r,-r-studio,-and-the-tidyverse**](week5.html)"><a name="**feb.-15:**-[**r,-r-studio,-and-the-tidyverse**](week5.html)" href="#**feb.-15:**-[**r,-r-studio,-and-the-tidyverse**](week5.html)"></a><strong>Feb. 15:</strong> <a href="week5.html"><strong>R, R Studio, and the tidyverse</strong></a></h4>
<p>Introduction to <a href="https://www.r-project.org/">R</a>, <a href="https://www.rstudio.com/">R Studio</a> and the <a href="https://www.tidyverse.org/">tidyverse</a> packages for data journalism. (<strong>Peter Aldhous</strong>)</p>
<ul>
<li><strong>Assignment:</strong> Exercises to reinforce concepts learned in class.</li></ul>
</li></ul><ul>
<li><h4 id="**feb.-22:**-[**data-journalism-in-the-tidyverse**](week6.html)"><a name="**feb.-22:**-[**data-journalism-in-the-tidyverse**](week6.html)" href="#**feb.-22:**-[**data-journalism-in-the-tidyverse**](week6.html)"></a><strong>Feb. 22:</strong> <a href="week6.html"><strong>Data journalism in the tidyverse</strong></a></h4>
<p>We’ll use tidyverse packages to explore data on opioid prescription under Medicare in California, and related datasets on the doctors involved. (<strong>Peter Aldhous</strong>)</p>
<ul>
<li><strong>Assignment:</strong> Further exercises with the data from class.</li></ul>
</li></ul><ul>
<li><h4 id="**mar.-1:**-[**don't-let-data-lie-to-you**](week7.html)"><a name="**mar.-1:**-[**don't-let-data-lie-to-you**](week7.html)" href="#**mar.-1:**-[**don't-let-data-lie-to-you**](week7.html)"></a><strong>Mar. 1:</strong> <a href="week7.html"><strong>Don’t let data lie to you</strong></a></h4>
<p>Data is as full of lies as people, but somehow we are inclined to believe numbers in ways we we wouldn’t believe sentences. We’ll look at ways that numbers lie to us and people lie to each other with numbers. (<strong>Amanda Hickman</strong>)</p>
<ul>
<li><strong>Assignment:</strong> Submit a reporting and data analysis plan, based on your earlier pitch.</li></ul>
</li></ul><ul>
<li><h4 id="**tuesday-mar.-6:**-[**introduction-to-databases-and-sql**](week8.html)"><a name="**tuesday-mar.-6:**-[**introduction-to-databases-and-sql**](week8.html)" href="#**tuesday-mar.-6:**-[**introduction-to-databases-and-sql**](week8.html)"></a><strong>Tuesday Mar. 6:</strong> <a href="week8.html"><strong>Introduction to databases and SQL</strong></a></h4>
<p>We’ll work <a href="https://www.postgresql.org/">PostgreSQL</a> using SQL, to ask questions of data. Note that this class will meet on a Tuesday. (<strong>Amanda Hickman</strong>)</p>
<ul>
<li><strong>Assignment</strong> Skill reinforcement assignment in PostgreSQL.</li></ul>
</li></ul><ul>
<li><h4 id="**mar.-15:**-[**finding-stories-using-maps**](week9.html)"><a name="**mar.-15:**-[**finding-stories-using-maps**](week9.html)" href="#**mar.-15:**-[**finding-stories-using-maps**](week9.html)"></a><strong>Mar. 15:</strong> <a href="week9.html"><strong>Finding stories using maps</strong></a></h4>
<p><a href="https://qgis.org/en/site/">QGIS</a> is a desktop geographic information system (or GIS) application that we’ll use to view, edit, and analyze geographic data. (<strong>Amanda Hickman</strong>)</p>
<ul>
<li><strong>Assignment</strong> Skill reinforcement assignment in QGIS.</li></ul>
</li></ul><ul>
<li><h4 id="**mar.-22:**-[**maps-meet-databases**](week10.html)"><a name="**mar.-22:**-[**maps-meet-databases**](week10.html)" href="#**mar.-22:**-[**maps-meet-databases**](week10.html)"></a><strong>Mar. 22:</strong> <a href="week10.html"><strong>Maps meet databases</strong></a></h4>
<p><a href="https://postgis.net/">PostGIS</a> adds support for geographic queries and objects to Postgres — it is a powerful tool for geographic analysis, and it plugs right into QGIS. We’ll explore more advanced queries that take advantage of PostGIS’s power. We’ll also discuss the tool or strategy you’d like to tackle in week 12. (<strong>Amanda Hickman</strong>)</p>
<ul>
<li><strong>Assignment</strong> Skill reinforcement assignment in PostGIS.</li></ul>
</li></ul><ul>
<li><h4 id="**mar.-29:**-spring-break----no-class"><a name="**mar.-29:**-spring-break----no-class" href="#**mar.-29:**-spring-break----no-class"></a><strong>Mar. 29:</strong> Spring Break — No class</h4>
</li><li><h4 id="**apr.-5:**-[**going-deeper-with-postgis**](week11.html)"><a name="**apr.-5:**-[**going-deeper-with-postgis**](week11.html)" href="#**apr.-5:**-[**going-deeper-with-postgis**](week11.html)"></a><strong>Apr. 5:</strong> <a href="week11.html"><strong>Going deeper with PostGIS</strong></a></h4>
<p>We’ll keep working on pulling together GIS and databases so everyone has a good handle on the tools we’re using. (<strong>Amanda Hickman</strong>)</p>
<ul>
<li><strong>Assignment</strong> Submit a progress report on your data analysis.</li></ul>
</li></ul><ul>
<li><h4 id="**apr.-12:**-[**r-practice**](week12.html)"><a name="**apr.-12:**-[**r-practice**](week12.html)" href="#**apr.-12:**-[**r-practice**](week12.html)"></a><strong>Apr. 12:</strong> <a href="week12.html"><strong>R practice</strong></a></h4>
<p>After a few weeks working with SQL and maps, we’ll get reacquainted with R. In groups, you will answer questions from data using dplyr code. (<strong>Peter Aldhous</strong>)</p>
</li><li><h4 id="**apr.-19:**-[**postgis-practice**](week13.html)"><a name="**apr.-19:**-[**postgis-practice**](week13.html)" href="#**apr.-19:**-[**postgis-practice**](week13.html)"></a><strong>Apr. 19:</strong> <a href="week13.html"><strong>PostGIS practice</strong></a></h4>
<p>Another practice session to reinforce skills covered previously, working in groups to write PostGIS queries. (<strong>Amanda Hickman</strong>)</p>
</li><li><h4 id="**apr.-26:**-[**more-with-fun-with-r**](week14.html)"><a name="**apr.-26:**-[**more-with-fun-with-r**](week14.html)" href="#**apr.-26:**-[**more-with-fun-with-r**](week14.html)"></a><strong>Apr. 26:</strong> <a href="week14.html"><strong>More with fun with R</strong></a></h4>
<p>Some more useful tricks in R, including loading data from multiple files, making new columns in your data, and pulling data from the US Census API. Plus: When you need step beyond dplyr, and do a statistical analysis. (<strong>Peter Aldhous</strong>)</p>
<ul>
<li><strong>Assignment</strong> Submit your data journalism project.</li></ul>
</li></ul><ul>
<li><h4 id="**may-3:**-project-show-and-tell"><a name="**may-3:**-project-show-and-tell" href="#**may-3:**-project-show-and-tell"></a><strong>May 3:</strong> Project show and tell</h4>
Students present their data journalism projects. (<strong>Peter Aldhous and Amanda Hickman</strong>)</li></ul><h3 id="recommended-reading"><a name="recommended-reading" href="#recommended-reading"></a>Recommended reading</h3><p>Sarah Cohen: <a href="http://store.ire.org/products/numbers-in-the-newsroom-using-math-and-statistics-in-news-second-edition"><em>Numbers in the Newsroom: Using Math and Statistics in News</em></a></p><p>Philip Meyer: <a href="http://www.amazon.com/Precision-Journalism-Reporters-Introduction-Science/dp/0742510883"><em>Precision Journalism: A Reporter’s Introduction to Social Science Methods</em></a></p><h3 id="attendance"><a name="attendance" href="#attendance"></a>Attendance</h3><p>Unexcused absence from two classes will drop you one letter grade; a third unexcused absence will result in an F. Excused absences will be permitted only in extraordinary circumstances. Regardless of the reason for an absence, students will be responsible for any assignments due and for learning material covered in class.</p><h3 id="grading"><a name="grading" href="#grading"></a>Grading</h3><p>Class participation, weekly assignments: <strong>90%</strong><br>Attendance: <strong>10%</strong></p><h3 id="good-manners"><a name="good-manners" href="#good-manners"></a>Good manners</h3><p>Students must turn off the ringers on their cell phones before class begins. Students may not check e-mail, social media sites or other websites during lecture portions of class or while working on class exercises.</p><h3 id="academic-dishonesty-and-plagiarism"><a name="academic-dishonesty-and-plagiarism" href="#academic-dishonesty-and-plagiarism"></a>Academic dishonesty and plagiarism</h3><p>The high academic standard at the University of California, Berkeley, is reflected in each degree that is awarded. As a result, it is up to every student to maintain this high standard by ensuring that all academic work reflects his/her own ideas or properly attributes the ideas to the original sources.</p><p>These are some basic expectations of students with regards to academic integrity:</p><ul>
<li><p>Any work submitted should be your own individual thoughts, and should not have been submitted for credit in another course unless you have prior written permission to re-use it in this course from this instructor.</p>
</li><li><p>All assignments must use “proper attribution,” meaning that you have identified the original source of words or ideas that you reproduce or use in your assignment. This includes drafts and homework assignments!</p>
</li><li><p>If you are unclear about expectations, ask your instructor.</p>
</li></ul><h3 id="disability-accommodations"><a name="disability-accommodations" href="#disability-accommodations"></a>Disability accommodations</h3><p>If you need disability-related accommodations in this class, if you have emergency medical information you wish to share with the instructor, or if you need special arrangements in case the building must be evacuated, please inform the instructors as soon as possible by seeing one of us after class or making an appointment to visit during office hours. If you are not currently listed with DSP (Disabled Students’ Program) but believe that you could benefit from their support, we encourage you to <a href="http://dsp.berkeley.edu/">apply online</a>.</p>
</div> <!-- /.container all -->
<script src="https://code.jquery.com/jquery.min.js"></script>
<script src="js/bootstrap.min.js"></script>
</body>
</html>