{"product_id":"data-skills-for-media-professionals-isbn-9781119118961","title":"Data Skills for Media Professionals","description":"\u003cp\u003e\u003cb\u003eTeaches the basic, yet all-important, data skills required by today’s media professionals\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eThe authors of \u003ci\u003eData Skills for Media Professionals\u003c\/i\u003e 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.\u003c\/p\u003e \u003cp\u003eAlthough 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. \u003c\/p\u003e \u003cul\u003e \u003cli\u003eServes as an excellent supplemental text for easily adding data skills instruction to courses in beginning or advanced writing and reporting\u003c\/li\u003e \u003cli\u003eFeatures computer screen captures that illustrate each step of each procedure\u003c\/li\u003e \u003cli\u003eOffers downloadable datasets from a companion web page to help students implement the techniques themselves\u003c\/li\u003e \u003cli\u003eShows realistic examples that illustrate how to perform each technique and how to use it on the job\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003e\u003ci\u003eData Skills of Media Professionals\u003c\/i\u003e 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.\u003c\/p\u003e \u003cp\u003ePreface ix\u003c\/p\u003e \u003cp\u003e\u003cb\u003e1 Basic Data Analysis 1\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eSome Example Data 1\u003c\/p\u003e \u003cp\u003eAn Introductory Tool: Google Sheets 3\u003c\/p\u003e \u003cp\u003eGetting the Data into a Google Sheet 4\u003c\/p\u003e \u003cp\u003eGetting a Fixed Copy of the Data 9\u003c\/p\u003e \u003cp\u003eFormatting the Data 11\u003c\/p\u003e \u003cp\u003eCleaning the Data 12\u003c\/p\u003e \u003cp\u003ePlanning your Analysis 13\u003c\/p\u003e \u003cp\u003eFiltering 14\u003c\/p\u003e \u003cp\u003eCalculating 17\u003c\/p\u003e \u003cp\u003eLabeling and Tidying Up 21\u003c\/p\u003e \u003cp\u003eSorting 22\u003c\/p\u003e \u003cp\u003eWhere’s the “Save” Button? 24\u003c\/p\u003e \u003cp\u003eWriting About the Analysis Results 24\u003c\/p\u003e \u003cp\u003eRecap 26\u003c\/p\u003e \u003cp\u003eReferences 26\u003c\/p\u003e \u003cp\u003e\u003cb\u003e2 Data Visualization 27\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003ePreparing Your Data 28\u003c\/p\u003e \u003cp\u003eMaking a Column Chart 29\u003c\/p\u003e \u003cp\u003ePublishing the Chart to the Web 33\u003c\/p\u003e \u003cp\u003eChoosing the Right Type of Chart 35\u003c\/p\u003e \u003cp\u003eRecap 41\u003c\/p\u003e \u003cp\u003eReferences 41\u003c\/p\u003e \u003cp\u003e\u003cb\u003e3 Making Online Maps 43\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eDownloading a Shapefile 44\u003c\/p\u003e \u003cp\u003eImporting the Shapefile into QGIS 45\u003c\/p\u003e \u003cp\u003eExamining the Shapefile and Joining it with the Unemployment Data 47\u003c\/p\u003e \u003cp\u003eCustomizing and Publishing the Map File with Google My Maps 54\u003c\/p\u003e \u003cp\u003eMapping Specific Points with Latitude and Longitude Coordinates 64\u003c\/p\u003e \u003cp\u003eMapping Specific Points with Addresses 73\u003c\/p\u003e \u003cp\u003eMaking a Map When You Have no Geolocation Data to Import 77\u003c\/p\u003e \u003cp\u003eRecap 83\u003c\/p\u003e \u003cp\u003eReferences 84\u003c\/p\u003e \u003cp\u003e\u003cb\u003e4 Microsoft Excel and PivotTables 85\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eIntroducing PivotTables 85\u003c\/p\u003e \u003cp\u003eGetting Started: Aggregating Contributions by City 89\u003c\/p\u003e \u003cp\u003eUsing the PivotTable Tool’s “Filters” Box 92\u003c\/p\u003e \u003cp\u003eUsing the PivotTable Tool’s “Columns” Box 94\u003c\/p\u003e \u003cp\u003eInvestigating Relatedness 96\u003c\/p\u003e \u003cp\u003eSpotting the Absence of a Relationship 105\u003c\/p\u003e \u003cp\u003eDownloading Campaign Finance Data from the Federal Election Commission 107\u003c\/p\u003e \u003cp\u003eExcel vs. Google Sheets 111\u003c\/p\u003e \u003cp\u003eRecap 112\u003c\/p\u003e \u003cp\u003eReferences 113\u003c\/p\u003e \u003cp\u003e\u003cb\u003e5 Matching Records with Excel’s VLOOKUP 115\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eOverview 118\u003c\/p\u003e \u003cp\u003eAggregating each Candidate’s Donations by Source 119\u003c\/p\u003e \u003cp\u003eUsing VLOOKUP 122\u003c\/p\u003e \u003cp\u003eUsing Filters to Create a Classification Column 127\u003c\/p\u003e \u003cp\u003eVLOOKUP Pitfalls 129\u003c\/p\u003e \u003cp\u003eRecap 131\u003c\/p\u003e \u003cp\u003eReferences 131\u003c\/p\u003e \u003cp\u003e\u003cb\u003e6 Google Sheets and Inferential Statistics 133\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eSampling and Assumptions of Inferential Statistics 134\u003c\/p\u003e \u003cp\u003eGetting the Data and Installing the XLMiner Google Sheets Add‐on 136\u003c\/p\u003e \u003cp\u003eComputing and Understanding Basic Inferential Statistics 138\u003c\/p\u003e \u003cp\u003eDescriptive Statistics and Confidence Intervals 140\u003c\/p\u003e \u003cp\u003eThe One‐sample T‐test 143\u003c\/p\u003e \u003cp\u003eThe One‐sample Chi‐square Test 148\u003c\/p\u003e \u003cp\u003eKnowing which Test to Use 152\u003c\/p\u003e \u003cp\u003eComputing and Understanding Basic Bivariate Statistics 154\u003c\/p\u003e \u003cp\u003eTwo‐sample T‐tests 154\u003c\/p\u003e \u003cp\u003eChi‐square Analysis of a PivotTable 158\u003c\/p\u003e \u003cp\u003eCorrelation Between Two Continuous Variables: Regression 164\u003c\/p\u003e \u003cp\u003eRecap 169\u003c\/p\u003e \u003cp\u003eReferences 170\u003c\/p\u003e \u003cp\u003e\u003cb\u003e7 Other Functions, Tools and Techniques 171\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eDATE, NOW, and DATEDIF 171\u003c\/p\u003e \u003cp\u003eAVERAGE, STDEV, MEDIAN, MIN, MAX 173\u003c\/p\u003e \u003cp\u003eRAND 175\u003c\/p\u003e \u003cp\u003eLEFT, MID, and RIGHT 175\u003c\/p\u003e \u003cp\u003eThe “Text to Columns” Wizard 177\u003c\/p\u003e \u003cp\u003eCONCATENATE 179\u003c\/p\u003e \u003cp\u003eIF and IFS 180\u003c\/p\u003e \u003cp\u003eIFERROR 182\u003c\/p\u003e \u003cp\u003eCOMBIN and PERMUT 183\u003c\/p\u003e \u003cp\u003eGoogle Forms 184\u003c\/p\u003e \u003cp\u003eComparing Numbers Over Time 187\u003c\/p\u003e \u003cp\u003eAdjusting for Inflation 187\u003c\/p\u003e \u003cp\u003eAdjusting for Population Changes 188\u003c\/p\u003e \u003cp\u003eRecap 190\u003c\/p\u003e \u003cp\u003eReferences 190\u003c\/p\u003e \u003cp\u003eIndex 191\u003c\/p\u003e  \u003cp\u003e\u003cb\u003eKEN BLAKE, P\u003csmall\u003eH\u003c\/small\u003eD,\u003c\/b\u003e 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. \u003c\/p\u003e\u003cp\u003e\u003cb\u003eJASON REINEKE, P\u003csmall\u003eH\u003c\/small\u003eD,\u003c\/b\u003e 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.   \u003c\/p\u003e\u003cp\u003e\u003cb\u003eTeaches fundamental data skills required by today's media professionals\u003c\/b\u003e \u003c\/p\u003e\u003cp\u003e\u003ci\u003eData Skills for Media Professionals\u003c\/i\u003e 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 consider what questions to ask, how to ask them, and how to evaluate and communicate the answers. \u003c\/p\u003e\u003cp\u003eAlthough 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 Microsoft Excel. Worked examples rely on frequently updated data from the U.S. Bureau of Labor Statistics, the Federal Election Commission, the U.S. Environmental Protection Agency's Toxics Release Inventory, 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 covers 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. \u003c\/p\u003e\u003cul\u003e \u003cli\u003eServes as an excellent supplemental text for easily adding data skills instruction to courses in beginning or advanced writing and reporting\u003c\/li\u003e \u003cli\u003eFeatures computer screen captures that illustrate each step\u003c\/li\u003e \u003cli\u003eOffers downloadable datasets from a companion web page to help students implement the techniques themselves\u003c\/li\u003e \u003cli\u003eShows realistic examples that illustrate how to perform each technique and how to use it on the job\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003e\u003ci\u003eData Skills for Media Professionals\u003c\/i\u003e 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 also benefits those enrolled in advanced or specialized reporting courses, including courses dedicated solely to teaching data skills.\u003c\/p\u003e","brand":"Wiley-Blackwell","offers":[{"title":"Default Title","offer_id":47989026095333,"sku":"NP9781119118961","price":28.5,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1842\/7735\/files\/9781119118961.jpg?v=1761782489","url":"https:\/\/k12savings.com\/es\/products\/data-skills-for-media-professionals-isbn-9781119118961","provider":"K12savings","version":"1.0","type":"link"}