summer camp

Recent posts

Google Fusion Maps with Joe Wertz

StateImpact Oklahoma’s Joe Wertz, mapping wizard, shows us how to create an interactive map using Google Fusion Maps and some raw data in this quick and simple tutorial.

Here is the data that you can use, if you’d like to try this at home.

(Don’t be alarmed! The audio doesn’t kick in until about ten seconds in.)

Creating a Legend

Of special note, around minute 31 (31:00), Joe walks us through creating a legend for your map. To do that (in the new and improved version):

  1. In the map view, click on the little arrow on top of the “Map of…” tab and navigate down to “change map styles.
  2. Whether you are dealing with points or polygons, make sure that your bucket ranges are exactly as you’d like them to appear in your legend.
  3. Click on “automatic legend” (your last option on the list to the left).
  4. Create a title for your legend.
  5. Decide where you’d like your legend to appear (typically in the bottom right-hand corner,  unless your map makes a different corner preferable).
  6. Hit “Save.”

Embedding an Iframe Into Your Site

At minute 32 (32:35), Joe shows us how to embed an iframe with your map and legend right into your site.

  1. Click on Share (in the upper right-hand corner) and publish it to the web. You’ll see your current sharing settings listed towards the top. If it doesn’t say “Public” hit the blue “Change” and select “Public on the web.” Continue reading

Summer Camp: Excel Basics with Molly Bloom

Let StateImpact Reporter Molly Bloom lead  you through some basics of using Excel, including: 
  • Importing data from txt and csv files!
  • Sorting and filtering data!
  • and Creating easy and super-powerful pivot tables for data analysis and organization!

To experiment with the files used in this video:
  1. Report Card data: Go here and click on File –> Download as –> Microsoft Excel.
  2. Enrollment data is here.
  3. School levy data is here

Summer Camp: FOIA Tips with Ida Lieszkovsky

Check out our FOI star Ida Lieszkovsky’s quick primer on strategies for getting the documents you want from government agencies.

The webinar includes:

  • A review of the importance of knowing your FOIA laws and legal precedents. “I’ve found it important not just to review the Ohio guidelines, but to also review the successes and failures of public records requests in the state, since they can often help me anticipate how people will react and I can taylor my request with that in mind,” says Ida. Continue reading

Summer Camp: John O’Connor’s Social Media Secrets

We recently persuaded John O’Connor, StateImpact Florida education reporter and social media extraordinaire, to share some of his tips and tricks with us. He put together a list of key take-aways, below, for those of you who weren’t able to join us.

  • Not all social media is equal. Take advantage of the strengths of different sites. Twitter is what’s happening now. It’s great for publishing and promotion, but also a good way to find sources, activists and trends. Use Facebook to share things that might spark a conversation. LinkedIn is great for finding people who worked or work for specific companies or organizations.
  • Twitter is the most useful social media service, but it needs to be tamed. Use TweetDeck, HootSuite or a similar tool to bend it to your will.
  • Remember that social media is a conversation. You have to engage with others to get the most out of it.
  • Use social media to tell stories. People love to live-tweet events. Compile those tweets with Storify, but be a journalist and organize and add context to tell a story.