|
|
xi | |
Preface |
|
xiii | |
Features |
|
xv | |
New to This Edition |
|
xvii | |
Acknowledgments |
|
xix | |
|
1 What Data Journalism and Computer-Assisted Reporting Is and Why Journalists Use It |
|
|
1 | (18) |
|
|
2 | (9) |
|
How to Learn: Trial and Error---and Repetition |
|
|
11 | (1) |
|
|
11 | (3) |
|
|
14 | (1) |
|
|
15 | (1) |
|
|
15 | (1) |
|
|
16 | (3) |
|
Part I Learning Computer-Assisted Reporting Skills |
|
|
|
2 Online Resources: Researching and Finding Data on the Internet |
|
|
19 | (24) |
|
|
21 | (2) |
|
Digital Information and Data on the Internet |
|
|
23 | (1) |
|
|
23 | (1) |
|
What Online Resources to Use |
|
|
24 | (1) |
|
Digital Library Researchers and Journalists |
|
|
25 | (1) |
|
|
25 | (1) |
|
Discussion Groups and Social Media |
|
|
25 | (1) |
|
Using Boolean Logic to Search the Internet |
|
|
26 | (1) |
|
|
27 | (2) |
|
Downloading Different Files |
|
|
29 | (8) |
|
|
37 | (2) |
|
|
39 | (1) |
|
|
40 | (1) |
|
|
41 | (2) |
|
3 Gathering and Analyzing Text and Social Media |
|
|
43 | (16) |
|
Social Media for News Gathering and Analysis |
|
|
50 | (6) |
|
|
56 | (1) |
|
Authenticity and Accuracy |
|
|
57 | (1) |
|
|
57 | (1) |
|
|
57 | (1) |
|
|
58 | (1) |
|
4 Spreadsheets, Part 1: Basic Math for Journalists |
|
|
59 | (20) |
|
Becoming Friendly with Numbers |
|
|
60 | (2) |
|
|
62 | (2) |
|
|
64 | (3) |
|
Going from Horizontal to Vertical |
|
|
67 | (2) |
|
Comparing Parts to the Sum |
|
|
69 | (2) |
|
|
71 | (3) |
|
Using Average and Median for Better Accuracy |
|
|
74 | (2) |
|
|
76 | (1) |
|
|
77 | (1) |
|
|
77 | (1) |
|
|
78 | (1) |
|
5 Spreadsheets, Part 2: More Math that Matters |
|
|
79 | (24) |
|
|
80 | (4) |
|
|
84 | (2) |
|
|
86 | (3) |
|
|
89 | (1) |
|
|
90 | (7) |
|
|
97 | (3) |
|
|
100 | (1) |
|
|
100 | (1) |
|
|
101 | (2) |
|
6 Database Managers, Part 1: Searching and Summarizing |
|
|
103 | (20) |
|
|
109 | (3) |
|
|
112 | (1) |
|
|
113 | (1) |
|
|
114 | (1) |
|
|
114 | (2) |
|
Boolean Logic: And, Or, Not |
|
|
116 | (2) |
|
|
118 | (3) |
|
|
121 | (1) |
|
|
121 | (1) |
|
|
122 | (1) |
|
7 Database Managers, Part 2: Matchmaking |
|
|
123 | (12) |
|
Relational Databases Are Everywhere |
|
|
124 | (1) |
|
|
125 | (2) |
|
|
127 | (4) |
|
|
131 | (1) |
|
|
132 | (1) |
|
|
132 | (3) |
|
Part II Using Computer-Assisted Reporting in News Stories |
|
|
|
8 Getting Data Not on the Web: How to Find and Negotiate for Data |
|
|
135 | (14) |
|
|
136 | (3) |
|
|
139 | (1) |
|
|
140 | (2) |
|
Privacy and Security Issues |
|
|
142 | (1) |
|
|
143 | (1) |
|
|
144 | (2) |
|
|
146 | (1) |
|
|
146 | (1) |
|
|
147 | (2) |
|
9 Building Your Own Database: How to Develop Exclusive Sources |
|
|
149 | (12) |
|
|
152 | (1) |
|
Spreadsheet or Database Manager |
|
|
153 | (1) |
|
Using the Database Manager |
|
|
154 | (2) |
|
Creating a Relational Database |
|
|
156 | (2) |
|
|
158 | (1) |
|
|
158 | (1) |
|
|
159 | (2) |
|
10 Dirty Data: How to Fact Check Your Data and Clean It |
|
|
161 | (18) |
|
|
163 | (2) |
|
|
165 | (1) |
|
|
166 | (1) |
|
|
166 | (2) |
|
|
168 | (2) |
|
|
170 | (1) |
|
|
171 | (2) |
|
|
173 | (2) |
|
|
175 | (1) |
|
|
175 | (1) |
|
|
176 | (1) |
|
|
177 | (1) |
|
|
177 | (2) |
|
11 Doing the Data Journalism and Computer-Assisted Reporting Story: How to Report and Write with Data |
|
|
179 | (14) |
|
Pick a Story You Know Can Be Done |
|
|
180 | (1) |
|
Pick a Database You Can Get |
|
|
181 | (1) |
|
|
181 | (1) |
|
|
182 | (1) |
|
|
183 | (1) |
|
Match the Database to Your Knowledge |
|
|
183 | (1) |
|
|
184 | (1) |
|
Keep Up with Other Reporters' Work |
|
|
185 | (1) |
|
Integrate Databases into Your Daily Work |
|
|
185 | (1) |
|
|
186 | (1) |
|
Become Familiar with the Field of Data Programming |
|
|
186 | (1) |
|
|
186 | (1) |
|
|
187 | (1) |
|
Good Reporting and Ethics |
|
|
188 | (1) |
|
Stay Curious, Get Excited |
|
|
188 | (2) |
|
|
190 | (1) |
|
|
190 | (1) |
|
|
191 | (2) |
Appendix A A Short Introduction to Mapping Data |
|
193 | (12) |
Appendix B A Short Introduction to Social Network Analysis |
|
205 | (10) |
Selected Bibliography |
|
215 | (2) |
Websites |
|
217 | (2) |
Sources for Key Examples |
|
219 | (2) |
Glossary |
|
221 | (4) |
Index |
|
225 | |