anchor.diff:  Intro to SQL with Access (part 1);Jaimi Dowdell (IRE and NICAR);Jeffersonian/Knickerbocker;Saturday;9 a.m. - 9:50 a.m.;Structured Query Language, or SQL, is a powerful item to add to your data toolbox. This session will give you an introduction to using SQL to interview, sort, select and summarize your data. While the class is taught in Microsoft Access, this language is widely used and can be taken to other database managers with some minor tweaks.
   Own your own map stack: Open source maps from the ground up;Chris Amico (NPR), Brian Boyer (Chicago Tribune), Matt Stiles (NPR);New York Central;Saturday;9 a.m. - 9:50 a.m.;Life after Google Maps: From TileMill to QGIS, learn about open-source mapping options for displaying and geocoding your data.
   Web scraping without programming;Chris Keller (Madison.com), Michelle Minkoff (The Associated Press);Wabash Cannonball;Saturday;9 a.m. - 9:50 a.m.;We'll walk through some in-depth tutorials of free tools that don't require you to know programming to bring structure to information you find on the Web, including OutwitHub and manipulating the distinct parts of a web page.  We'll cover tasks as simple as grabbing all of the images off the page, and as complex as paging through a searchable database.
  +Getting data into Excel: From PDF to HTML;Matt Wynn (Omaha World-Herald);Wabash Cannonball;Saturday;10 a.m. - 10:50 a.m.;In the real world, your key dataset probably isn't going to come in an easy-to-use package. This hands-on session will cover how to import data into Excel from a variety of formats.
   The ins and outs of internal APIs;Anthony DeBarros (USA TODAY), Christopher Groskopf (PANDA), John Keefe (WNYC Radio), James Wilkerson (The Washington Post);New York Central;Saturday;10 a.m. - 10:50 a.m.;Dozens of public and private groups are opening up treasure troves of data using APIs, which are quickly becoming the new standard for shuffling data around the internet. Learn how easy it can be to get started building them for your own use, and get some tips from power users on how to make use of what's already out there.
  +Navigating the storm: Using data to bolster the traditional weather story;Stephen Stirling (The Star-Ledger);Missouri Pacific;Saturday;10 a.m. - 10:50 a.m.;"Weather stories are a fact of life for reporters across the country. Mountains of useful data, in all sorts of formats, is made readily available by the government and other independent agencies, but rarely used by newsrooms.  Where to find it, how to use it to build interactivity into every day weather stories and how to use data to look beyond your typical ""it rained yesterday"" article."
  +Intro to R;Jacob Fenton (Sunlight Foundation);Grand Hall I;Saturday;10 a.m. - 10:50 a.m.;"Run stats without paying a dime! R is free statistical software that does everything from simple regressions and correlations to beautiful charts, maps and visualizations. We&rsquo;ll focus on importing data, running statistical tests, and looking for hidden relationships between variables."
  +American FactFinder 2;Ron Campbell (The Orange County Register);Grand Hall I;Saturday;10 a.m. - 10:50 a.m.;"Is American FactFinder a fiendish plot or a tool of the devil? Ron Campbell demystifies and defangs the Census Bureau&rsquo;s data finder."
  +Intro to QGIS 2;Michael Corey (Center for Investigative Reporting);Grand Hall II;Saturday;10 a.m. - 10:50 a.m.;
  +Federal stats for local stories;Ron Nixon (The New York Times), Gavin Off (The Charlotte Observer);Frisco/Burlington;Saturday;10 a.m. - 10:50 a.m.;The federal government keeps a treasure trove of data, but knowing where to find what you need can be daunting. This session will help show you the way and give you some ideas of how you can turn federal numbers into stories with local impact.
   Intro to SQL with Access (part 2);Jaimi Dowdell (IRE and NICAR);Jeffersonian/Knickerbocker;Saturday;10 a.m. - 10:50 a.m.;
   Unsession: What we should be teaching the next generation;Steve Doig (Arizona State University);Illinois Central;Saturday;10 a.m. - 10:50 a.m.;Where is the next generation of CAR reporters and news apps developers?  Its clear that the unmet demand for data driven jobs won't slack off any time soon.  What skill set divides current j-school graduates from succeeding in these jobs?  How and where can j-school grads get these skills, and what is being done to ensure future grads will be prepared to dive into future data projects?
  -Federal stats for local stories;Ron Nixon (The New York Times), Gavin Off (The Charlotte Observer);Frisco/Burlington;Saturday;10 a.m. - 10:50 p.m.;The federal government keeps a treasure trove of data, but knowing where to find what you need can be daunting. This session will help show you the way and give you some ideas of how you can turn federal numbers into stories with local impact.
  -Getting data into Excel: From PDF to HTML;Matt Wynn (Omaha World-Herald);Wabash Cannonball;Saturday;10 a.m. - 10:50 a.m.;In the real world, your key dataset probably isn't going to come in an easy-to-use package. This hands-on session will cover how to import data into Excel from a variety of formats.
  -Intro to R;Jacob Fenton (Sunlight Foundation);Grand Hall I;Saturday;10 a.m. - 10:50 a.m.;"Run stats without paying a dime! R is free statistical software that does everything from simple regressions and correlations to beautiful charts, maps and visualizations. We&rsquo;ll focus on importing data, running statistical tests, and looking for hidden relationships between variables."
  -Navigating the storm: Using data to bolster the traditional weather story;Stephen Stirling (The Star-Ledger);Missouri Pacific;Saturday;10 a.m. - 10:50 a.m.;"Weather stories are a fact of life for reporters across the country. Mountains of useful data, in all sorts of formats, is made readily available by the government and other independent agencies, but rarely used by newsrooms.  Where to find it, how to use it to build interactivity into every day weather stories and how to use data to look beyond your typical ""it rained yesterday"" article."
  -American FactFinder 2;Ron Campbell (The Orange County Register);Grand Hall I;Saturday;10 a.m. - 10:50 a.m.;"Is American FactFinder a fiendish plot or a tool of the devil? Ron Campbell demystifies and defangs the Census Bureau&rsquo;s data finder."
  -Intro to QGIS 2;Michael Corey (Center for Investigative Reporting);Grand Hall II;Saturday;10 a.m. - 10:50 a.m.;
  +PowerPivot;Tom Torok (The New York Times);Wabash Cannonball;Saturday;11 a.m. - 11:50 a.m.;The session will cover importing and joining very large data sets as well as pivoting and filtering with slicers using PowerPivot, a free add-in for Excel 2010.
  +Web scraping;Mark Ng (Donald W. Reynolds National Center for Business Journalism);Grand Hall II;Saturday;11 a.m. - 11:50 a.m.;Some of the most useful datasets are on the Web, and while they don't require FOIAs, you might need to do some work to get them into your spreadsheets. In this class, we'll take a look at techniques for mining data from the Web and making it useful.
  +Lockdown - Make sure your information is secure;Jacob Harris (The New York Times), Steve Doig (Arizona State University);Illinois Central;Saturday;11 a.m. - 11:50 a.m.;In an age of increasing electronic surveillance by governments and corporations, journalists owe it to their confidential sources to be extra-careful about keeping their identities and other information absolutely secure. This session will explain how to use tools like anonymous servers, burner cellphones and cryptography programs to keep your data and contacts safe from prying eyes.
  +Dealing with real-time data;Alastair Dant (The Guardian);Missouri Pacific;Saturday;11 a.m. - 11:50 a.m.;Time flows through every news story - online, we zoom from long-running chronologies to minute-by-minute updates. Real-time sources pose problems in both the design and development of digital content. Here are a few ideas about how we can face these challenges.
  +CAR wash 1: How dirty is it?;Jennifer LaFleur (ProPublica);Jeffersonian/Knickerbocker;Saturday;11 a.m. - 11:50 a.m.;
  +"Rapid fire future: Quick talks on what&#39;s on the horizon";Matt Waite (University of Nebraska);New York Central;Saturday;11 a.m. - 11:50 a.m.;Struggling to keep up? Want to know what's on the horizon but not ready for prime time yet? This panel, in short bursts, gives you a taste of tech and ideas on the cusp of becoming tomorrow's tools for journalists. Drones, learning machines, distributed computing and more, all on the horizon and maybe in your newsroom soon.
  +Government CAR for any newsroom;Jim Miller (The Press Enterprise), Mc Nelly Torres (Florida Center for Investigative Reporting);Frisco/Burlington;Saturday;11 a.m. - 11:50 a.m.;Budgets, audits, contracts, businesses, sweet deals and corruption are all part of government coverage. Whether you work in a large newsroom or one-person bureau, we'll show you how to use all the technology available to follow the money and produce quick hits and/or in-depth stories.
  +Census.ire.org;Joe Germuska (Chicago Tribune);Grand Hall I;Saturday;11 a.m. - 11:50 a.m.;
   TileMill;Chris Amico (NPR), Brian Boyer (Chicago Tribune), Matt Stiles (NPR);Grand Hall III;Saturday;11 a.m. - 11:50 a.m.;We'll go from a public dataset and a blank canvas to a working interactive map using TileMill, an open source map design studio. This session will focus on how to use TileMill, how to style your map and how to get it on the web.
  -Lockdown - Make sure your information is secure;Jacob Harris (The New York Times), Steve Doig (Arizona State University);Illinois Central;Saturday;11 a.m. - 11:50 a.m.;In an age of increasing electronic surveillance by governments and corporations, journalists owe it to their confidential sources to be extra-careful about keeping their identities and other information absolutely secure. This session will explain how to use tools like anonymous servers, burner cellphones and cryptography programs to keep your data and contacts safe from prying eyes.
  -"Rapid fire future: Quick talks on what&#39;s on the horizon";Matt Waite (University of Nebraska);New York Central;Saturday;11 a.m. - 11:50 a.m.;Struggling to keep up? Want to know what's on the horizon but not ready for prime time yet? This panel, in short bursts, gives you a taste of tech and ideas on the cusp of becoming tomorrow's tools for journalists. Drones, learning machines, distributed computing and more, all on the horizon and maybe in your newsroom soon.
  -Dealing with real-time data;Alastair Dant (The Guardian);Missouri Pacific;Saturday;11 a.m. - 11:50 a.m.;Time flows through every news story - online, we zoom from long-running chronologies to minute-by-minute updates. Real-time sources pose problems in both the design and development of digital content. Here are a few ideas about how we can face these challenges.
  -PowerPivot;Tom Torok (The New York Times);Wabash Cannonball;Saturday;11 a.m. - 11:50 a.m.;The session will cover importing and joining very large data sets as well as pivoting and filtering with slicers using PowerPivot, a free add-in for Excel 2010.
  -Census.ire.org;Joe Germuska (Chicago Tribune);Grand Hall I;Saturday;11 a.m. - 11:50 a.m.;
  -CAR wash 1: How dirty is it?;Jennifer LaFleur (ProPublica);Jeffersonian/Knickerbocker;Saturday;11 a.m. - 11:50 a.m.;
  -Web scraping;Mark Ng (Donald W. Reynolds National Center for Business Journalism);Grand Hall II;Saturday;11 a.m. - 11:50 a.m.;Some of the most useful datasets are on the Web, and while they don't require FOIAs, you might need to do some work to get them into your spreadsheets. In this class, we'll take a look at techniques for mining data from the Web and making it useful.
  -Government CAR for any newsroom;Jim Miller (The Press Enterprise), Mc Nelly Torres (Florida Center for Investigative Reporting);Frisco/Burlington;Saturday;11 a.m. - 11:50 a.m.;Budgets, audits, contracts, businesses, sweet deals and corruption are all part of government coverage. Whether you work in a large newsroom or one-person bureau, we'll show you how to use all the technology available to follow the money and produce quick hits and/or in-depth stories.
  -Creative uses of web scraping;Dan Nguyen (ProPublica), Julian Todd (Scraperwiki), Aine McGuire (Scraperwiki);New York Central;Saturday;2 p.m. - 2:50 p.m.;Web scraping is more than just copying HTML files onto your computer for later reading. Knowing how to navigate a variety of website types and formats will let you create useful, structured data from complex websites.
  +CAR wash 1 and 2: How dirty is it? and Cleaning;Jennifer LaFleur (ProPublica);Jeffersonian/Knickerbocker;Saturday;2 p.m. - 2:50 p.m.;"As anyone who has dealt with government data knows, it&rsquo;s seldom perfect when we get it. This session&nbsp;will give you some suggestions for integrity-checking your data to find the holes and how to fill them."
  +Integrating CAR into a daily beat;Megan Luther (IRE and NICAR), Kate Martin (Skagit Valley Herald);Frisco/Burlington;Saturday;2 p.m. - 2:50 p.m.;It can be tough to do CAR and meet your daily story quota, but it can be done. We feature organizing tips, ways to improve efficiency and how to negotiate with your editor for CAR time. We also will highlight quick-hit CAR stories and ways to insert CAR nuggets into your daily stories.
  +What we can find out about elections;Aaron Bycoffe (Huffington Post), Derek Willis (The New York Times), Jeremy Dunck (Votizen.com);Illinois Central;Saturday;2 p.m. - 2:50 p.m.;Between microtargeted ads, near real-time disclosure of finances and troves of increasingly available data, the tools of the modern campaigns are much different than they used to be. Journalists need to catch up. This session explores ways to cope with the rapid developments in elections and how to build tools that will help uncover the story.
  +Mini-Boot Camp part 2;Jaimi Dowdell (IRE and NICAR), David Herzog (IRE and NICAR), Jennifer LaFleur (ProPublica), Megan Luther (IRE and NICAR), Ron Nixon (The New York Times), David Donald (Center for Public Integrity);"Grand Hall I&amp;II *pre-registration only";Saturday;2 p.m. - 4:50 p.m.;
  +Creative uses of web scraping;Dan Nguyen (ProPublica), Julian Todd (ScraperWiki), Aine McGuire (ScraperWiki);New York Central;Saturday;2 p.m. - 2:50 p.m.;Web scraping is more than just copying HTML files onto your computer for later reading. Knowing how to navigate a variety of website types and formats will let you create useful, structured data from complex websites.
  +Map graphics for video;Michael Corey (Center for Investigative Reporting);Missouri Pacific;Saturday;2 p.m. - 2:50 p.m.;Learn how to use the wealth of freely available satellite imagery and other GIS materials to make high-quality video graphics on an affordable budget.
   Displaying data geographically with ArcView;Tom Meagher (The Star-Ledger);Wabash Cannonball;Saturday;2 p.m. - 2:50 p.m.;"
   "
  -Mini-Boot Camp part 2;Jaimi Dowdell (IRE and NICAR), David Herzog (IRE and NICAR), Jennifer LaFleur (ProPublica), Megan Luther (IRE and NICAR), Ron Nixon (The New York Times), David Donald (Center for Public Integrity);"Grand Hall I&amp;II *pre-registration only";Saturday;2 p.m. - 4:50 p.m.;
  -What we can find out about elections;Aaron Bycoffe (Huffington Post), Derek Willis (The New York Times), Jeremy Dunck (Votizen.com);Illinois Central;Saturday;2 p.m. - 2:50 p.m.;Between microtargeted ads, near real-time disclosure of finances and troves of increasingly available data, the tools of the modern campaigns are much different than they used to be. Journalists need to catch up. This session explores ways to cope with the rapid developments in elections and how to build tools that will help uncover the story.
  -CAR wash 2: Cleaning;Jennifer LaFleur (ProPublica);Jeffersonian/Knickerbocker;Saturday;2 p.m. - 2:50 p.m.;
  -Map graphics for video;Michael Corey (Center for Investigative Reporting);Missouri Pacific;Saturday;2 p.m. - 2:50 p.m.;Learn how to use the wealth of freely available satellite imagery and other GIS materials to make high-quality video graphics on an affordable budget.
  -Integrating CAR into a daily beat;Megan Luther (IRE and NICAR), Kate Martin (Skagit Valley Herald);Frisco/Burlington;Saturday;2 p.m. - 2:50 p.m.;It can be tough to do CAR and meet your daily story quota, but it can be done. We feature organizing tips, ways to improve efficiency and how to negotiate with your editor for CAR time. We also will highlight quick-hit CAR stories and ways to insert CAR nuggets into your daily stories.
   Importing and selecting data by attribute with ArcView;Janet Roberts (Thomson Reuters);Wabash Cannonball;Saturday;3 p.m. - 3:50 p.m.;"
   "
  +Hidden databases: Mining the private parts of public officials;Ryann Grochowski (Investigative Newsource), Russ Ptacek (KSHB-TV);Frisco/Burlington;Saturday;3 p.m. - 3:50 p.m.;"Tools to identify usernames and e-mail addresses used by politicians and others and how to use that data to track the subject&rsquo;s digital footprint from dating sites, social networks, and even the documents that reveal the &ldquo;private parts&rdquo; of public officials. We'll also look at little-known data sources that reporters can request about their congressmen and women. You'll leave with a list of these data sources, where you can request them, and ideas for stories you can get out of them."
  +Hacking the Census;Paul Overberg (USA TODAY);Missouri Pacific;Saturday;3 p.m. - 4:50 p.m.;
  +Automation and free text;Reg Chua (Thomson Reuters), Jonathan Stray (The Associated Press);New York Central;Saturday;3 p.m. - 3:50 p.m.;Data to text, and text to data. Some types of news stories are really dressed up data, such as financial reports and sports scores, and we'll take a look at the newsrooms and technologies that are already being used to produce these stories automatically. In the other direction, documents like financial disclosures or bulk incident reports contain useful data that can be extracted. Tools for reporting on large volumes of unstructured text are coming along slowly, but much is possible today.
  +Predicting the news: Tell your readers what will happen, before it happens;Mary Jo Webster (St. Paul Pioneer Press), Matt Wynn (Omaha World-Herald), Jeff Larson (ProPublica);Illinois Central;Saturday;3 p.m. - 3:50 p.m.;"We often report on things that have already happened, but statistical techniques can predict events before they occur. See how knowing what will happen &mdash; or what should have happened &mdash; can reveal new kinds of stories."
   Web Inspector;Dan Nguyen (ProPublica);Jeffersonian/Knickerbocker;Saturday;3 p.m. - 3:50 p.m.;Learn how to use the web browser's built-in web inspector to navigate the source details and structure of a webpage. The tool is most often used by web developers to debug and design sites, but it's equally useful for poking around and finding hidden data files
  -Automation and free text;Reg Chua (Thomson Reuters), Jonathan Stray (The Associated Press);New York Central;Saturday;3 p.m. - 3:50 p.m.;Data to text, and text to data. Some types of news stories are really dressed up data, such as financial reports and sports scores, and we'll take a look at the newsrooms and technologies that are already being used to produce these stories automatically. In the other direction, documents like financial disclosures or bulk incident reports contain useful data that can be extracted. Tools for reporting on large volumes of unstructured text are coming along slowly, but much is possible today.
  -Hidden databases: Mining the private parts of public officials;Ryann Grochowski (Investigative Newsource), Russ Ptacek (KSHB-TV);Frisco/Burlington;Saturday;3 p.m. - 3:50 p.m.;"Tools to identify usernames and e-mail addresses used by politicians and others and how to use that data to track the subject&rsquo;s digital footprint from dating sites, social networks, and even the documents that reveal the &ldquo;private parts&rdquo; of public officials. We'll also look at little-known data sources that reporters can request about their congressmen and women. You'll leave with a list of these data sources, where you can request them, and ideas for stories you can get out of them."
  -Predicting the news: Tell your readers what will happen, before it happens;Mary Jo Webster (St. Paul Pioneer Press), Matt Wynn (Omaha World-Herald), Jeff Larson (ProPublica);Illinois Central;Saturday;3 p.m. - 3:50 p.m.;"We often report on things that have already happened, but statistical techniques can predict events before they occur. See how knowing what will happen &mdash; or what should have happened &mdash; can reveal new kinds of stories."
  -Hacking the Census;Paul Overberg (USA TODAY);Missouri Pacific;Saturday;3 p.m. - 4:50 p.m.;
  -Environmental analyses for any newsroom;Elizabeth Lucas (Center for Public Integrity), Kate Golden (Wisconsin Watch);Frisco/Burlington;Saturday;4 p.m. - 4:50 p.m.;"Key federal environmental data sets: how to get them and navigate their endless caveats. Some possibilities for state environmental data &mdash; and what to do when regulators aren't tracking the data you need. Using visualization tools like Tableau Public and Google Fusion Tables to find stories in those messy data. One example we'll use is CPI/NPR's ""Poisoned Places"" 2011 investigation of coal-fired power plants; Lucas led CPI's data analysis for that story, and Golden produced a Wisconsin-specific viz."
  +Geocoding to merge databases with addresses into maps with ArcView;Pam Dempsey (cu-citizenaccess.org);Wabash Cannonball;Saturday;4 p.m. - 4:50 p.m.;"
  +"
   PANDA Project provisioning party;Brian Boyer (Chicago Tribune), Christopher Groskopf (PANDA);Jeffersonian/Knickerbocker;Saturday;4 p.m. - 4:50 p.m.;Take home a present from your trip to St. Louis -- a PANDA for your newsroom! The PANDA Project team will walk you through the easy steps to set up a site on Amazon Web Services.
   When data visualization does the heavy lifting;John Bones (Verdens Gang), Ken Schwencke (Los Angeles Times);New York Central;Saturday;4 p.m. - 4:50 p.m.;
   Getting to yes: Battling data pricetag inflation and other roadblocks;Ryan McNeill (The Dallas Morning News), Mary Jo Webster (St. Paul Pioneer Press);Illinois Central;Saturday;4 p.m. - 4:50 p.m.;What do you do when a government agency wants you to pay hundreds or even thousands of dollars for data? Panelists will offer up tactics for negotiating, examples of common problems that often lead to inflated price tags and some success stories.
  -Geocoding to merge databases with addresses into maps with ArcView;Pam Dempsey (cu-citizenaccess.org);Wabash Cannonball;Saturday;4 p.m. - 4:50 p.m.;"
  -"
  +Environmental analyses for any newsroom;Elizabeth Lucas (Center for Public Integrity), Kate Golden (Wisconsin Watch);Frisco/Burlington;Saturday;4 p.m. - 4:50 p.m.;"Key federal environmental data sets: how to get them and navigate their endless caveats. Some possibilities for state environmental data &mdash; and what to do when regulators aren't tracking the data you need. Using visualization tools like Tableau Public and Google Fusion Tables to find stories in those messy data. One example we'll use is CPI/NPR's ""Poisoned Places"" 2011 investigation of coal-fired power plants; Lucas led CPI's data analysis for that story, and Golden produced a Wisconsin-specific viz."
  +Data U: The databases you need to cover higher ed;Alex Richards (Chronicle of Higher Education), Jennifer Wheeler (The Register-Mail);Illinois Central;Sunday;9 a.m. - 9:50 a.m.;A wealth of information is at your fingertips when it comes to putting colleges in context for your readers. This panel touches on the resources at the national, state and campus level that you need to know about to make it happen.
  +Mining the web for data and stories;Jaimi Dowdell (IRE and NICAR);New York Central;Sunday;9 a.m. - 9:50 a.m.;"The Web is one of the first places we go for information, but so much of it is hidden deep beyond search engines&rsquo; eyes. This session will highlight strategies for finding data that can&rsquo;t be found with a traditional search engine and will point you to the best sites for tracking down local, national and international data."
   Webscraping/data munging hackathon with Python;Jeremy Bowers (The Washington Post), Serdar Tumgoren (The Washington Post);Grand Hall III;Sunday;9 a.m. - 10:50 a.m.;An open session for help on any Python-related subject, from basic install questions to help on work or personal coding projects.
   Mini-Boot Camp part 3;Coulter Jones (IRE and NICAR), Jaimi Dowdell (IRE and NICAR), Jennifer LaFleur (ProPublica);"Grand Hall I&amp;II *pre-registration only";Sunday;9 a.m. - 10:50 a.m.;"
   "
  -Mining the web for data and stories;Jaimi Dowdell (IRE and NICAR);New York Central;Sunday;9 a.m. - 9:50 a.m.;"The Web is one of the first places we go for information, but so much of it is hidden deep beyond search engines&rsquo; eyes. This session will highlight strategies for finding data that can&rsquo;t be found with a traditional search engine and will point you to the best sites for tracking down local, national and international data."
  -Data U: The databases you need to cover higher ed;Alex Richards (Chronicle of Higher Education), Holly Hacker (The Dallas Morning News);Illinois Central;Sunday;9 a.m. - 9:50 a.m.;A wealth of information is at your fingertips when it comes to putting colleges in context for your readers. This panel touches on the resources at the national, state and campus level that you need to know about to make it happen.
  +A day in the life of a News App: An intro to Internet infrastructure;Jeff Larson (ProPublica), Ted Han (DocumentCloud);Illinois Central;Sunday;10 a.m. - 10:50 a.m.;CAR reporters and News Apps developers have many similar skills. But what differences they do have can be illuminated through the lives of web applications. We'll discuss the specifics of how web apps do their thing, and in general about what you need to know about the internet to understand how web apps work.
   Storyboarding your ideas;Sarah Cohen (Duke University), Brant Houston (University of Illinois);New York Central;Sunday;10 a.m. - 10:50 a.m.;Don't leave the CAR conference without a battle plan for putting your new knowledge and skills to work back home. In this freewheeling group session, we'll discuss your story ideas, flesh them out, and develop strategies for doing them amid the daily demands of every newsroom. We'll talk about navigating office politics and help you develop a personal action plan.
  -A day in the life of a News App: An intro to Internet infrastructure;Jeff Larson (ProPublica), Ted Han (DocumentCloud);Illinois Central;Sunday;10 a.m. - 10:50 a.m.;CAR reporters and News Apps developers have many similar skills. But what differences they do have can be illuminated through the lives of web applications. We'll discuss the specifics of how web apps do their thing, and in general about what you need to know about the internet to understand how web apps work.
  
positive.code: Integrating CAR: Story ideas for the whole newsroom;Mark Wert (The Cincinnati Enquirer), Jaimi Dowdell (IRE and NICAR);Frisco/Burlington;Thursday;2 p.m. - 2:50 p.m.;"Data based reporting shouldn't be just a tool for economics, transportation or crime reporters; it can be used in other parts of the room. From features to sports, we&rsquo;ll talk about stories and techniques that can be used throughout the newsroom."
  CSVKit;Anthony DeBarros (USA TODAY), Christopher Groskopf (PANDA);Missouri Pacific;Thursday;2 p.m. - 2:50 p.m.;This suite of Python utilities is a Swiss Army knife for converting and working with comma-delimited text files. This demo will explain ways it can help you, from rearranging and trimming columns to generating stats and SQL statements to make tables.
  Worth doing for money - turning good work into money;Chase Davis (Center for Investigative Reporting), Matt Wynn (Omaha World-Herald);Illinois Central;Thursday;3 p.m. - 3:50 p.m.;"News applications can be so much more than Infographics 2.0. This session will talk about examples about how news apps teams have transformed their work into something more: namely, products &mdash; including some that actually make money. We want this to be a discussion. Come with your thoughts on methods, ethics and ideas."
  CAR on a shoestring;"Kevin Crowe (Investigative Newsource), Patrick Sweet (The Citizens&#39; Voice), Mary Jo Webster (St. Paul Pioneer Press)";New York Central;Thursday;3 p.m. - 3:50 p.m.;How to do CAR stories with limited resources. Panelists will offer tips for winning over your boss, carving time out of your overworked schedule, useful (and cheap!) tools and story ideas that can be done anywhere.
  Health analyses for any newsroom;Charles Ornstein (ProPublica), Jeff Porter (Association of Health Care Journalists);Frisco/Burlington;Thursday;3 p.m. - 3:50 p.m.;"All newsrooms can produce meaningful stories about health care in their own communities with a dose of data. This session will focus on Medicare and Medicaid data you can localize, how to track disciplined doctors in your state, and the care of vulnerable residents in nursing homes. You&rsquo;ll leave with a handout listing online resources to explore and tips for both CAR beginners and longtime data users."
  Data viz in 20 minutes: jQuery DataTables;Christopher Schnaars (USA TODAY);Missouri Pacific;Thursday;3 p.m. - 3:50 p.m.;Use DataTables, an open-source jQuery plug-in, to post sortable datasets online within 20 minutes.
  Data for business investigations;Maurice Tamman (Thomson Reuters), Chris Taggart (OpenCorporates);Frisco/Burlington;Thursday;4 p.m. - 4:50 p.m.;We'll discuss concrete and essential tools for investigating business with data. This session will look at U.S. and global corporate data and navigating your way through the tangled (and incomplete) web with OpenCorporates.
  Get the most out of Google Fusion Tables;Rebecca Shapley (Google);Missouri Pacific;Thursday;4 p.m. - 4:50 p.m.;Google Fusion Tables allows you to easily publish relatively large data sets. Learn how this free tool can help journalists create maps, graphs and timelines, mash-up different data sets and collaborate on data.
  Turning your stories into a tablet/phone app;Daniel Lathrop (The Dallas Morning News), Will Sullivan (Lee Enterprises);New York Central;Thursday;4 p.m. - 4:50 p.m.;As news organizations dabble in new ways of finding revenue and journalists look to tell stories in new ways, what does a CAR story or project look like as a standalone app? We'll explore the emerging world as it relates to native apps, HTML5 apps, eBooks and other  mobile-enabled formats.
  Free tools for Web scraping without programming;Chris Keller (Madison.com), Michelle Minkoff (The Associated Press);Illinois Central;Thursday;4 p.m. - 4:50 p.m.;"Turning wild data on the Web into structured formats that are useful for analysis and presentation can be one of the toughest barriers to data journalism. We'll take a rapid-fire tour of free tools on the Web (which don't require programming) that can help &mdash; some tried and true, some recently in production."
  Introduction to SPSS;Ron Campbell (The Orange County Register);Grand Hall II;Friday;9 a.m. - 9:50 a.m.;Navigate SPSS using descriptive statistics and frequencies. Create basic counts and percentages to help you understand your data. Do crosstabs to show the data in different ways, and statistical tests.
  Year in CAR;Mark Horvit (IRE and NICAR), Megan Luther (IRE and NICAR);Frisco/Burlington;Friday;9 a.m. - 9:50 a.m.;What were the big stories of the year? What were the most creative uses of data analysis? See what your colleagues have been up to and pick up some story ideas at the same time.
  Intro to Google Fusion Tables;Ryan Murphy (Texas Tribune), Matt Stiles (NPR);Grand Hall I;Friday;9 a.m. - 9:50 a.m.;Google Fusion Tables allows you easily to publish relatively large data sets. Learn how to create maps, graphs and timelines, mash-up different data sets and collaborate on data using this free, point-and-click tool.
  
negative.code: Title;Speaker;Place;Day;Time;Description
  "Follow the Money  Tracking Companies&#39; Influence on Politics Free business journalism training before the conference";Ron Nixon (The New York Times), Bill Allison (Sunlight Foundation);New York Central;Wednesday;12:30 p.m. - 5 p.m.;Come to a free Reynolds Center workshop on Wednesday, Feb. 22, the afternoon before the CAR Conference. Bring the name of a company you follow to this workshop and learn how to track its efforts at political influence from two experts: New York Times reporter Ron Nixon and Sunlight Foundation editorial director Bill Allison. They will help you:
  Welcome;Jaimi Dowdell (IRE and NICAR), Mark Horvit (IRE and NICAR), Megan Luther (IRE and NICAR);Frisco/Burlington;Thursday;8:30 a.m. - 8:50 a.m.;"Welcome to the conference! IRE staff will highlight key sessions and events that you won&rsquo;t want to miss while in St. Louis. We&rsquo;ll also give you a brief rundown on some of the resources IRE has to offer."
  "Why learn programming: A reporter&#39;s perspective";"Tommy Kaas (Kaas &amp; Mulvad), Ryan McNeill (The Dallas Morning News)";Illinois Central;Thursday;9 a.m. - 9:50 a.m.;Learn how adding a programming language to your toolbox can make you a better reporter.
  Tableau for Beginners;Daniel Hom (Tableau Public), Ross Perez (Tableau Public);Grand Hall I;Thursday;9 a.m. - 12:30 p.m.;Learn how to create beautiful, interactive data visualizations on short deadlines. No programming required.
  Against All -Spanish- odds;Mar Cabra (International Consortium of Investigative Journalists), David Cabo (Freelance software developer);Missouri Pacific;Thursday;9 a.m. - 9:50 a.m.;"In  Spain, ""lobbying"" is taboo, campaign contributions are a  mystery and transparency an illusion. We have one of the highest  unemployment rates in the world, and in the recent national elections,  the president-to-be refused to answer any questions from the press.  Journalist Mar Cabra and computer developer David Cabo will explain  their tricks to make journalism and accountability work in such aharsh environment. David and Mar will be sharing some of their  recent work, and welcoming the brainstorming of new ways around the system."
  NewsCamp::Text as data;Noah Smith (Carnegie Mellon University);New York Central;Thursday;9 a.m. - 9:50 a.m.;A computational linguist describes key ideas in thinking about text as data that, through statistics, can help us understand the behavior of people and society.  We'll show a range of examples that illustrate tradeoffs in statistical and computational complexity, linguistic sophistication, and weak vs. strong domain assumptions.
  Getting started: Digging deep with data journalism;"Jaimi Dowdell (IRE and NICAR), Momi Peralta Ramos (La Nacion), Rob O&#39;Dell (Arizona Daily Star)";Frisco/Burlington;Thursday;9 a.m. - 9:50 a.m.;"Are you new to data journalism or does this happen to be your first time at a CAR conference? If so, this session will help you get on track to make sure that you get the best experience possible from the 2012 CAR Conference. We&rsquo;ll highlight sessions and give you tips for success during and after the conference."
  NewsCamp::Investigating text in the wild;Sarah Cohen (Duke University);New York Central;Thursday;10 a.m. - 10:50 a.m.;How investigative reporters have found stories buried in text and ways investigators in other industries have mined their documents.
  Free tools for wrangling data;Steve Doig (Arizona State University), Matt Stiles (NPR);Illinois Central;Thursday;10 a.m. - 10:50 a.m.;Before you get to enjoy the thrill of finding that smoking-gun pattern in some data for your big project, you have to deal with the drudgery of acquiring and cleaning up the data. Happily, a well-stocked and expanding toolbox of free services and applications exists to help you scrape data from websites, export it from clunky formats like pdf, and clean up messy, unstandardized variables.
  Bring your mapping dreams to fruition: Tricks to customize basic tools;Michelle Minkoff (The Associated Press);Missouri Pacific;Thursday;10 a.m. - 10:50 a.m.;"In recent years, Web cartographers have seen a nearly unprecedented leap in the tools available to us. But the question remains &mdash; how do we manipulate these tools to tell OUR stories, ripe with data? What can we do to make our maps stand apart from the pack? This session will demo some strategies, with minimal HTML and JavaScript, that anyone can use to bring life to the mapping dreams you have in your head."
  How to track cheating in your local schools;Holly Hacker (The Dallas Morning News), John Perry (Atlanta Journal-Constitution);Frisco/Burlington;Thursday;10 a.m. - 10:50 a.m.;"Erasing to the top &mdash; How to tell if school testing gains are legitimate or too good to be true."
  Social Media Sleuthing: Backgrounding people and companies;Doug Haddix (Kiplinger Program - Ohio State University);Illinois Central;Thursday;11 a.m. - 11:50 a.m.;Tips and techniques for using Twitter, Facebook, LinkedIn and other  social media services to dig deep on individuals and organizations.
  NewsCamp::Jam Sessions;Jacob Perkins (Weotta), Jeremy Bowers (The Washington Post), Chase Davis (Center for Investigative Reporting);Jeffersonian/  Knickerbocker;Thursday;11 a.m. - 5:50 p.m.;
  From your computer to the web: Using Microsoft Cloud and Google Docs;Coulter Jones (IRE and NICAR), Cheryl Phillips (The Seattle Times);Missouri Pacific;Thursday;11 a.m. - 11:50 a.m.;Let your audience search your data. Learn tricks on how newsrooms can use Microsoft Cloud and Google Docs to quickly and easily display dynamic information online without programming.
  NewsCamp::Tools for unstructured text;Chase Davis (Center for Investigative Reporting), Loretta Auvil (National Center for Supercomputing Applications);New York Central;Thursday;11 a.m. - 11:50 a.m.;Reporters are used to working with rows and columns, but some of the best data available comes in the form of unstructured text. This session will give a sense of the tools and techniques critical for working with unstructured data, as well as their applications in the newsroom.
  The art of requesting and negotiating data;David Hunn (St. Louis Post-Dispatch), Jennifer LaFleur (ProPublica);Frisco/Burlington;Thursday;11 a.m. - 11:50 a.m.;"Getting any record can be a challenge, but wrangling data can introduce even more challenges.  We&rsquo;ll give you some tools and tips for getting data out of government agencies."
  NewsCamp::Music Lessons;Sarah Cohen (Duke University), Ted Han (DocumentCloud), Jonathan Stray (The Associated Press);Wabash Cannonball;Thursday;1 p.m. - 4:50 p.m.;
  Tableau for Pros;Daniel Hom (Tableau Public), Ross Perez (Tableau Public);Grand Hall I;Thursday;1:30 p.m. - 5:30 p.m.;Take your data visualization skills to the next level. In this class we'll push Tableau's capabilities further to create more complex visualizations. You'll learn how to:
  Locating the story: The latest in mapping;David Herzog (IRE and NICAR), Ben Welsh (Los Angeles Times);Illinois Central;Thursday;2 p.m. - 2:50 p.m.;See how journalists are using geographic information system (GIS) mapping to plot trends and uncover hidden spatial relationships. Also, learn how open-source and commercial GIS programs compare.
  