The IRE Resource Center is a major research library containing more than 23,250 investigative stories — both print and broadcast. Add to that more than 3,000 tipsheets from our national conferences on how to cover specific beats or do specific stories and you have a resource that no reporter or editor should be without. These stories and tipsheets are searchable online or by contacting the Resource Center directly (573-882-3364 or rescntr@ire.org) where a researcher can help you pinpoint what you need. Browse or search the tipsheet section of our library below. Logged-in members can view the tipsheets free online:
Search results for "filtering" ...
-
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
-
Practical machine learning: Tips, tricks and real-world examples for machine learning in the newsroom
Learn how to apply machine learning in the newsroom from examples from real-world projects, including building intelligent regular expressions with maximum entropy models; using Bayesian classifiers to filter documents; and linear and logistic regression.
Tags: Machine learning; news reporting; entropy models; filters; linear regression; logistic regression
-
Importing data using the Microsoft Excel Import Wizard
Importing data into Microsoft Excel will enhance your reporting by allowing you to do original, in-depth analysis on a variety of different types of information. It's fortunate that Excel can accommodate multiple data formats so you can do basic or complex sorts, filters, pivot tables and more. In this lesson you’ll learn about different data formats, how to identify a format, which ones are Excel-friendly and how to get them into Excel.
Tags: data; excel; import; text file; comma-separated value; database format; html; access file; pdf
-
Moving from Excell 2003 to Excel 2007: Welcome to the Ribbon
Dowdell discusses the changes between Excel 2003 and Excel 2007. Basic differences in the layout of the programs, and the introduction of the "ribbon" are addressed. "The "Ribbon" is what Microsoft is calling this new interface. It has gotten rid of the menus and added a series of tabs." Dowdell discusses where to find and how to use different fucntions in the 2007 version of Excel.
Tags: Excel 2003; Excel 2007; ribbon; pivot tables; filtering; sort; sorting;
-
Skills and Knowledge Checklist for Excel
This tipsheet lists everything that a journalist would ever need to know in order to use Microsoft Excel. It covers everything from basic terminology to data formatting, data design and data calculation. Wolfe explains the most important and complicated functions, and lists other helpful tricks.
Tags: spreadsheets; calculations; filtering data; formula; worksheet; toolbar.
-
Hunting for Trends in Data Using Microsoft Access
This tipsheet uses a database about hunting accidents to demonstrate some of the basic Access functions. It covers everything from sorting data to crafting queries. The tipsheet offers several practice questions, such as "How many accidents occurred overall on the first day of deer hunting season in 1994?" It then goes on to explain how to write queries that answer these questions.
Tags: Microsoft Access; database analysis; design view; Queries
-
Microsoft Access: Quick Tips
This tipsheet is a good guide to some of the more basic functions of Microsoft Access. It gives easy -to-follow explanations for writing queries that sort, filter and summarize the data. The tipsheet also explains how to join tables.
Tags: databases; query design view; tables; Group By; order by
-
My Favorite (Excel) Friends
This tipsheet goes through many little-known but very neat functions of Microsoft Excel. Sylwester covers everything from changing date displays to sub-totaling, wildcard searches and combining functions.
Tags: Excel; spreadsheets; filtering
-
Tipsheet No: 661
Callahan's handout gives a roadmap to some of the best Web sites for reporters on a deadline. Callahan lists sites for covering everything from the courthouse beat to Congress. Master's handout covers how to use the Internet to get information and how to filter useless information out of your Internet searches. Slone's handout also lists everyday tools on the Internet including tips on how to figure out who is behind a Web site. Audio tape is available for purchase from the IRE Resource Center. Contact us at (573) 882-3364 or rescntr@ire.org.
Tags: 8 pgs.
-
CAR on Beat
Guide defines and explains computer-assisted reporting resources, including listserves, newsgroups, bulletin boards, news filters, forums, databases, gopher sites, and www sites. Includes general information on use requirements, cost, and problems associated with each resource. Audio tape is available for purchase from the IRE Resource Center. Contact us at (573) 882-3364 or rescntr@ire.org
Tags: Electronic Data Internet