Muutke küpsiste eelistusi

Data Skills for Media Professionals: A Basic Guide [Pehme köide]

  • Formaat: Paperback / softback, 224 pages, kõrgus x laius x paksus: 229x152x13 mm, kaal: 295 g
  • Ilmumisaeg: 01-Oct-2019
  • Kirjastus: Wiley-Blackwell
  • ISBN-10: 1119118964
  • ISBN-13: 9781119118961
Teised raamatud teemal:
  • Formaat: Paperback / softback, 224 pages, kõrgus x laius x paksus: 229x152x13 mm, kaal: 295 g
  • Ilmumisaeg: 01-Oct-2019
  • Kirjastus: Wiley-Blackwell
  • ISBN-10: 1119118964
  • ISBN-13: 9781119118961
Teised raamatud teemal:

Teaches the basic, yet all-important, data skills required by today’s media professionals

The authors of Data Skills for Media Professionals have assembled a book that teaches key aspects of data analysis, interactive data visualization and online map-making through an introduction to Google Drive, Google Sheets, and Google My Maps, all free, highly intuitive, platform-agnostic tools available to any reader with a computer and a web connection. Delegating the math and design work to these apps leaves readers free to do the kinds of thinking that media professionals do most often: considering what questions to ask, how to ask them, and how to evaluate and communicate the answers.

Although focused on Google apps, the book draws upon complementary aspects of the free QGIS geographic information system, the free XLMiner Analysis ToolPak Add-on for Google Sheets, and the ubiquitous Microsoft Excel spreadsheet application. Worked examples rely on frequently updated data from the U.S. Bureau of Labor Statistics, the Federal Election Commission, the National Bridge Inventory of structurally deficient bridges, and other federal sources, giving readers the option of immediately applying what they learn to current data they can localize to any area in the United States. The book offers chapters covering: basic data analysis; data visualization; making online maps; Microsoft Excel and pivot tables; matching records with Excel's VLOOKUP function; basic descriptive and inferential statistics; and other functions, tools and techniques. 

  • Serves as an excellent supplemental text for easily adding data skills instruction to courses in beginning or advanced writing and reporting
  • Features computer screen captures that illustrate each step of each procedure
  • Offers downloadable datasets from a companion web page to help students implement the techniques themselves
  • Shows realistic examples that illustrate how to perform each technique and how to use it on the job

Data Skills of Media Professionals is an excellent book for students taking skills courses in the more than 100 ACEJMC-accredited journalism and mass communication programs across the United States. It would also greatly benefit those enrolled in advanced or specialized reporting courses, including courses dedicated solely to teaching data skills.

Preface ix
1 Basic Data Analysis 1(26)
Some Example Data
1(2)
An Introductory Tool: Google Sheets
3(1)
Getting the Data into a Google Sheet
4(5)
Getting a Fixed Copy of the Data
9(2)
Formatting the Data
11(1)
Cleaning the Data
12(1)
Planning your Analysis
13(1)
Filtering
14(3)
Calculating
17(4)
Labeling and Tidying Up
21(1)
Sorting
22(2)
Where's the Save Button?
24(1)
Writing About the Analysis Results
24(2)
Recap
26(1)
References
26(1)
2 Data Visualization 27(16)
Preparing Your Data
28(1)
Making a Column Chart
29(4)
Publishing the Chart to the Web
33(2)
Choosing the Right Type of Chart
35(6)
Recap
41(1)
References
41(2)
3 Making Online Maps 43(42)
Downloading a Shapefile
44(1)
Importing the Shapefile into QGIS
45(2)
Examining the Shapefile and Joining it with the Unemployment Data
47(7)
Customizing and Publishing the Map File with Google My Maps
54(10)
Mapping Specific Points with Latitude and Longitude Coordinates
64(9)
Mapping Specific Points with Addresses
73(4)
Making a Map When You Have no Geolocation Data to Import
77(6)
Recap
83(1)
References
84(1)
4 Microsoft Excel and PivotTables 85(30)
Introducing PivotTables
85(4)
Getting Started: Aggregating Contributions by City
89(3)
Using the PivotTable Tool's Filters Box
92(2)
Using the PivotTable Tool's Columns Box
94(2)
Investigating Relatedness
96(9)
Spotting the Absence of a Relationship
105(2)
Downloading Campaign Finance Data from the Federal Election Commission
107(4)
Excel vs. Google Sheets
111(1)
Recap
112(1)
References
113(2)
5 Matching Records with Excel's VLOOKUP 115(18)
Overview
118(1)
Aggregating each Candidate's Donations by Source
119(3)
Using VLOOKUP
122(5)
Using Filters to Create a Classification Column
127(2)
VLOOKUP Pitfalls
129(2)
Recap
131(1)
References
131(2)
6 Google Sheets and Inferential Statistics 133(38)
Sampling and Assumptions of Inferential Statistics
134(2)
Getting the Data and Installing the XLMiner Google Sheets Add-on
136(2)
Computing and Understanding Basic Inferential Statistics
138(2)
Descriptive Statistics and Confidence Intervals
140(3)
The One-sample T-test
143(5)
The One-sample Chi-square Test
148(4)
Knowing which Test to Use
152(2)
Computing and Understanding Basic Bivariate Statistics
154(1)
Two-sample T-tests
154(4)
Chi-square Analysis of a PivotTable
158(6)
Correlation Between Two Continuous Variables: Regression
164(5)
Recap
169(1)
References
170(1)
7 Other Functions, Tools and Techniques 171(20)
DATE, NOW, and DATEDIF
171(2)
AVERAGE, STDEV, MEDIAN, MIN, MAX
173(2)
RAND
175(1)
LEFT, MID, and RIGHT
175(2)
The Text to Columns Wizard
177(2)
CONCATENATE
179(1)
IF and IFS
180(2)
IFERROR
182(1)
COMBIN and PERMUT
183(1)
Google Forms
184(3)
Comparing Numbers Over Time
187(1)
Adjusting for Inflation
187(1)
Adjusting for Population Changes
188(2)
Recap
190(1)
References
190(1)
Index 191
KEN BLAKE, PHD, is Associate Professor of Journalism and Strategic Media at Middle Tennessee State University. He researches public opinion and teaches undergraduate courses in writing and reporting, as well as a graduate course in empirical media theory.

JASON REINEKE, PHD, is Associate Professor of Journalism and Strategic Media at Middle Tennessee State University. He teaches an undergraduate course in free expression, as well as a graduate course in quantitative research methods, and has published in some of the field's top academic journals.