Resource Center

Tipsheets

Browse more 4,000 tipsheets from our national conferences and Watchdog Workshops on how to cover specific beats, conduct a great interview and learn countless tips on where to find the information you need.

Logged-in members can download any tipsheet, for free. Contact the Resource Center 573-882-3364  or rescntr@ire.org for questions.



Search results for "data formatting" ...

  • Finding and Analyzing Data on FEC.gov

    The Federal Election Commission offers several flavors of campaign finance data. You can view an individual report in PDF or HTML format, look at charts and maps summarizing campaign finance data or search for specific contributions and expenditures. You also can download datasets ranging from the raw text data for an individual report to a summary file containing all individualcontributions made during the two-year election cycle.

    Tags: elections; campaign; candidates

    By Chris Schnaars

    2015

  • Mapping 2: Manipulating and editing geographic data with QGIS

    "In this class we'll explore some useful QGIS data processing functions, including joining tables of data to existing shapefiles, simplifying geographic features so that online maps will render quickly, and how to save data in formats commonly used for web mapping. We'll also learn how to edit geographic data, and how to process data consisting of hundreds or thousands of closely spaced or overlapping points to give a more meaninful summary display." Check out the rest of Peter's tipsheet that's attached.

    Tags: None

    By Peter Aldhous

    2014

  • Campaign Finance I: Mining FEC data

    USA Today's Chris Schnaars delves into what's up with campaign finance data from the FEC. His tipsheets and presentation go over the basics of the data and explain how to read the files and look at them in spreadsheet format.

    Tags: campaign finance; senate; FEC

    By Chris Schnaars

    2014

  • Getting Started with Excel

    Helena Bengtsson's Tipsheet shows beginners how to use Excel. Bengtsson covers everything from entering data, moving around the program, changing column/row width, copying, numbering and sorting columns/rows to entering final calculations and formatting.

    Tags: Excel; tipsheet; data; calculations; formatting

    By Helena Bengtsson

    2014

  • Make Dirty Data Shine with OpenRefine

    Frederick Kaimann, data reporter and developer for the Star-Ledger of New Jersey walks shows you how to use OpenRefine, a program that allows you to clean, manipulate and import data.

    Tags: GREL; OpenRefine; Data; Geocoding; formatting

    By Frederick Kaimann

    2014

  • Tableau Public for Beginners

    Beginning training guide with basic Tableau chart types, maps, formatting and dashboard actions. The handout includes a step-by-step guide of building the 'Baby Names viz' presented at the 2014 CAR Conference. Link to tipsheet: http://www.tableausoftware.com/public/blog/2014/02/nicar-training-part-i-beginner-2342

    Tags: tableau; data set; formatting; maps; dashboard; trend

    By Jewel Loree

    2014

  • Mapping 2: Manipulating geographical data with QGIS

    In addition to displaying geographic data, QGIS is a powerful tool for processing data for use by other mapping applications. If you want to make online maps, using tools including TileMile and Leaflet, for instance, QGIS can help get your data into the right shape. In this class, we'll explore some useful QGIS data processing functions, including joining tables of data to existing shapeflies, simplifying geographic features so that online maps will render quickly, and how to save data in formats commonly used for web mapping. We'll also learn how to edit geographic data, and how to process data consisting of hundreds or thousands of closely spaced or overlapping points to give a more meaning summary display.

    Tags: geographical data; qgis;

    By Peter Aldhous

    2014

  • DANGER!! Look out for dirty data

    IRE training direct, Jaimi Dowdell, gives some ways you can look for problems in data and bulletproof your work in the process.

    Tags: data; cleaning; functions; excel; formatting; filtering

    By Jaimi Dowdell

    2013

  • By Angela Galloway, Jack Gillum, David Jackson, Jennifer LaFleur

    2013

  • Excel 1

    Start learning basic calculation and sorting with Microsoft Excel. Learn how to format your data, rank and sort numbers and filter information.

    Tags: Microsoft Excel; software; calculation; sorting; formatting; filtering; data: CAR

    By Linda Johnson

    2013