Google Integrates GapMinder Data Visualization into Spreadsheets

Friday, March 28. 2008

After nearly a year of waiting to see what Google would do with the purchase of Hans Rosling's GapMinder project we've been rewarded! Google has integrated the GapMinder time-series data visualization tools directly into Google Spreadsheets as a 'Gadget'.

The gadget allows you turn turn any time-series data into stunning full motion graphs. The graphs are interactive and can also be easily embedded into your online work as a flash object.

Here's Hans Rosling in action, showing off the GapMinder tool with Carbon Emmission data:





With the addition of GapMinder gadgets in Google spreadsheets, you can now create your own visualizations in a snap. Here's a quick one that I did showing web traffic to the main sections of ForumOne.com over the past year - fun!



Take some time to play with the axis parameter and you can begin to see how powerful this tool is. Many of the organizations that we work with have data as a core piece of their issue analysis and policy work. Exploring this new tool should be a high priority for those that are looking for a flexible and simple way to present that data online in engaging formats.

Posted by Kurt Voelker in Technology at 12:07 | Comments (0) | Trackbacks (0)
Bookmark Google Integrates GapMinder Data Visualization into Spreadsheets  at del.icio.us Digg Google Integrates GapMinder Data Visualization into Spreadsheets Bloglines Google Integrates GapMinder Data Visualization into Spreadsheets Technorati Google Integrates GapMinder Data Visualization into Spreadsheets Fark this: Google Integrates GapMinder Data Visualization into Spreadsheets Bookmark Google Integrates GapMinder Data Visualization into Spreadsheets  at YahooMyWeb Bookmark Google Integrates GapMinder Data Visualization into Spreadsheets  at Furl.net Bookmark Google Integrates GapMinder Data Visualization into Spreadsheets  at reddit.com Bookmark Google Integrates GapMinder Data Visualization into Spreadsheets  at blinklist.com Bookmark Google Integrates GapMinder Data Visualization into Spreadsheets  at Spurl.net Bookmark Google Integrates GapMinder Data Visualization into Spreadsheets  at NewsVine Bookmark Google Integrates GapMinder Data Visualization into Spreadsheets  at Simpy.com Bookmark Google Integrates GapMinder Data Visualization into Spreadsheets  at blogmarks Bookmark Google Integrates GapMinder Data Visualization into Spreadsheets  with wists Bookmark Google Integrates GapMinder Data Visualization into Spreadsheets  at Ma.gnolia.com wong it! Bookmark using any bookmark manager!

Giving Back: Installing Wireless Networks in the Lower 9th Ward

Wednesday, March 19. 2008

Andrew Cohen, myself, and about 10 other volunteers spent the morning installing a wireless network (Cisco provided the equipment) at The St. Bernard Community Center in New Orleans' lower 9th ward. The volunteer effort was organized by Beth Kanter as part of the Nonprofit Technology Network's Day of Service.

It felt great to give back a little, to meet the dedicated folks that are still working hard every day to bring the city back, and to roll up my sleeves and work with some power tools. Thank to Beth Kanter for organizing the day.

Here's some pics that I snapped on my Treo while we were working, and a quick video of our ride to the center:







Technorati Tags:

08NTC



Posted by Kurt Voelker in Technology at 14:46 | Comment (1) | Trackbacks (0)
Bookmark Giving Back: Installing Wireless Networks in the Lower 9th Ward  at del.icio.us Digg Giving Back: Installing Wireless Networks in the Lower 9th Ward Bloglines Giving Back: Installing Wireless Networks in the Lower 9th Ward Technorati Giving Back: Installing Wireless Networks in the Lower 9th Ward Fark this: Giving Back: Installing Wireless Networks in the Lower 9th Ward Bookmark Giving Back: Installing Wireless Networks in the Lower 9th Ward  at YahooMyWeb Bookmark Giving Back: Installing Wireless Networks in the Lower 9th Ward  at Furl.net Bookmark Giving Back: Installing Wireless Networks in the Lower 9th Ward  at reddit.com Bookmark Giving Back: Installing Wireless Networks in the Lower 9th Ward  at blinklist.com Bookmark Giving Back: Installing Wireless Networks in the Lower 9th Ward  at Spurl.net Bookmark Giving Back: Installing Wireless Networks in the Lower 9th Ward  at NewsVine Bookmark Giving Back: Installing Wireless Networks in the Lower 9th Ward  at Simpy.com Bookmark Giving Back: Installing Wireless Networks in the Lower 9th Ward  at blogmarks Bookmark Giving Back: Installing Wireless Networks in the Lower 9th Ward  with wists Bookmark Giving Back: Installing Wireless Networks in the Lower 9th Ward  at Ma.gnolia.com wong it! Bookmark using any bookmark manager!

A Few Tactical First Steps for your 2008 Social Strategy

Thursday, January 17. 2008

If your organization is like most, your communications team is working hard to devise the best way to tap into the massive popularity of the social web to promote your message and move your mission. Before you spend too much time and energy trying to devise a clever FaceBook app that's bound to go viral, here's a few practical tips for easing your organization into the wild new world of Social Media.

  • Set your content free
    Anything you post to the web should be easily sharable. So first, make sure to give your site visitors the opportunity to post your content to Digg, StumbleUpon, Delicious, Newsvine and other social media sharing sites - and seek out niche news sharing sites that cover your sector and include those as well. It's free exposure - and its the first step to spreading your messaging beyond the confines of your own domain.

  • Teach your staff to tag, post, friend, and share
    You may say that your site visitors don't know about those Social Media sites I just listed. Maybe that's true. But it's easy to educate your staff. So let them be the first wave of social evangelists for your content. Here's how: Teach your communications staff and issue experts to create accounts on the social media sites relevant to your sector, you can do that at your next staff meeting in 20 minutes. Now have them click those sharing links you added to your content in step one and you've just turned your staff into social media mavens.

  • Don't be Selfish
    In the world of social media, blatant self promotion is pretty obvious, and so you don't want your staff only sharing your organization's content. They'll gain more credibility, and more friends and followers, if they're sharing news and information of interest and relevance to your sector from any source. Here's how: take advantage of the fact that your staff are passionate about the issues and topics your organization works on. Everyday they see interesting and relevant news and stories all over the web that would be of interest to others like them. In fact, they probably already email them to each other all the time. Train your staff to post to social media sites instead of locking all that great information up in your office email.

So what's in it for your organization? The goal is to give your ideas and messages the ability to be rapidly spread through the networks of millions of real people that are consuming news on recommendations from their friends. By positioning your staff as evangelists, you'll be well on your way to making many new friends. These are friends that are likely to listen, because they trust your staff as smart providers of useful information. And of course, their friends have friends who listen to them too, and so on. So the next time you launch that great campaign, it will have an entirely new channel through which to spread - and it's a channel that's growing as fast, or faster than anything we've seen on the web to date.



Posted by Kurt Voelker at 18:03 | Comments (0) | Trackbacks (0)
Bookmark A Few Tactical First Steps for your 2008 Social Strategy  at del.icio.us Digg A Few Tactical First Steps for your 2008 Social Strategy Bloglines A Few Tactical First Steps for your 2008 Social Strategy Technorati A Few Tactical First Steps for your 2008 Social Strategy Fark this: A Few Tactical First Steps for your 2008 Social Strategy Bookmark A Few Tactical First Steps for your 2008 Social Strategy  at YahooMyWeb Bookmark A Few Tactical First Steps for your 2008 Social Strategy  at Furl.net Bookmark A Few Tactical First Steps for your 2008 Social Strategy  at reddit.com Bookmark A Few Tactical First Steps for your 2008 Social Strategy  at blinklist.com Bookmark A Few Tactical First Steps for your 2008 Social Strategy  at Spurl.net Bookmark A Few Tactical First Steps for your 2008 Social Strategy  at NewsVine Bookmark A Few Tactical First Steps for your 2008 Social Strategy  at Simpy.com Bookmark A Few Tactical First Steps for your 2008 Social Strategy  at blogmarks Bookmark A Few Tactical First Steps for your 2008 Social Strategy  with wists Bookmark A Few Tactical First Steps for your 2008 Social Strategy  at Ma.gnolia.com wong it! Bookmark using any bookmark manager!

Crowd Sourcing, The Network Effect, and Friending - Oh My!

Monday, December 17. 2007

Last week I was invited by the AFL-CIO to talk with about 40 of their affiliated union's communication directors. We had a great discussion about online trends and opportunities for making an impact online. The conversation was focused on four principles that we're seeing have a real positive effect these days:

1. Crowd-Sourcing: What can your crowd do for you?
2. The Network Effect: Making your sites and systems better with user supplied information
3. Everyone's a Pro-sumer: Thinking about multimedia, user generated content, and mobility
4. Put down the Bull Horn: Building interactive relationships in the age of "friending"

The goal was to share a few stories that illustrate these trends and innovations at a high level and to provide tangible tactics and approaches that can be mixed into your own web communications’ strategies. The full presentation audio is available below, enjoy...

SlideShare | View | Upload your own
Posted by Kurt Voelker in Communication, Technology at 10:57 | Comments (0) | Trackbacks (0)
Bookmark Crowd Sourcing, The Network Effect, and Friending - Oh My!  at del.icio.us Digg Crowd Sourcing, The Network Effect, and Friending - Oh My! Bloglines Crowd Sourcing, The Network Effect, and Friending - Oh My! Technorati Crowd Sourcing, The Network Effect, and Friending - Oh My! Fark this: Crowd Sourcing, The Network Effect, and Friending - Oh My! Bookmark Crowd Sourcing, The Network Effect, and Friending - Oh My!  at YahooMyWeb Bookmark Crowd Sourcing, The Network Effect, and Friending - Oh My!  at Furl.net Bookmark Crowd Sourcing, The Network Effect, and Friending - Oh My!  at reddit.com Bookmark Crowd Sourcing, The Network Effect, and Friending - Oh My!  at blinklist.com Bookmark Crowd Sourcing, The Network Effect, and Friending - Oh My!  at Spurl.net Bookmark Crowd Sourcing, The Network Effect, and Friending - Oh My!  at NewsVine Bookmark Crowd Sourcing, The Network Effect, and Friending - Oh My!  at Simpy.com Bookmark Crowd Sourcing, The Network Effect, and Friending - Oh My!  at blogmarks Bookmark Crowd Sourcing, The Network Effect, and Friending - Oh My!  with wists Bookmark Crowd Sourcing, The Network Effect, and Friending - Oh My!  at Ma.gnolia.com wong it! Bookmark using any bookmark manager!

GrantsFire and Foundation Transparency

Wednesday, November 7. 2007

I'm attending the Technology Affinity Group annual conference in San Francisco - a gathering of foundation technology leaders. Here's some live blogging notes on a session about GrantsFire - an edge aggregator of grant information.

What is GrantsFire?

  • a web site: http://www.grantsfire.com
  • a working group
  • a data standard initiative


The Site

  • search for and view awarded grants details


Why GrantsFire?
Comments from the audience:

  • a great source of info for grantseekers
  • info for grantees to see other similar work being done across their sector
  • inform grantmakers to see sector-based investments -> lead to collaboration
  • demonstrate the collective impact of a foundation's investment
  • trend monitoring


Why Do This in the First Place?
The foundatiion center has, for years manually collected and 'munged' grants data from participants - labor intensive and slooow - poor visibility into the real data

How?

  • any foundation publishes their grant data to the web in a standard format
  • register your grant feed with GrantsFire
  • GrantsFire spiders registered sites


Publishing Standards:

  • use standard XHTML tags (HGrant microformant)
  • RSS: use extended RSS format


Some of my thoughts:

  • This is a great initiative to increase transparency and open information sharing.

  • opportunity exists to extend standard to grantee outputs - so that a grantee could tag their outputs to a specific grant - and have grantsfire compile the documents, posts, photos, reports etc - wow

  • amazing to me that leading grant management database vendors don't automatically support this standard and provide the publishing service to their customers
Posted by Kurt Voelker in Collaboration at 14:34 | Comments (0) | Trackbacks (0)
Bookmark GrantsFire and Foundation Transparency  at del.icio.us Digg GrantsFire and Foundation Transparency Bloglines GrantsFire and Foundation Transparency Technorati GrantsFire and Foundation Transparency Fark this: GrantsFire and Foundation Transparency Bookmark GrantsFire and Foundation Transparency  at YahooMyWeb Bookmark GrantsFire and Foundation Transparency  at Furl.net Bookmark GrantsFire and Foundation Transparency  at reddit.com Bookmark GrantsFire and Foundation Transparency  at blinklist.com Bookmark GrantsFire and Foundation Transparency  at Spurl.net Bookmark GrantsFire and Foundation Transparency  at NewsVine Bookmark GrantsFire and Foundation Transparency  at Simpy.com Bookmark GrantsFire and Foundation Transparency  at blogmarks Bookmark GrantsFire and Foundation Transparency  with wists Bookmark GrantsFire and Foundation Transparency  at Ma.gnolia.com wong it! Bookmark using any bookmark manager!

Web Executive Seminar Recap: Internet Technology Investment Planning

Tuesday, September 11. 2007


Back in June we hosted another Web Executive Seminar at the National Press Club. This time we convened four IT leaders to talk about Internet Technology Investment planning for their nonprofit or government organizations.

Our speakers included:

Susi Alger, Information Technology Director at opensecrets.org, (2007 Webby Award Winner)





Kristofer Mathisen, Vice President of Cognitive Technologies, speaking on the Web Content Unit Program Management Office at Office of Comptroller of the Currency, U.S. Department of the Treasury.




Brian Moran, Information Technology Director at the U.S. International Trade Commission



Matt Schuttloffel, Internet Services Director at the National Wildlife Federation


Posted by Kurt Voelker in Technology at 12:02 | Comments (0) | Trackbacks (0)
Bookmark Web Executive Seminar Recap: Internet Technology Investment Planning  at del.icio.us Digg Web Executive Seminar Recap: Internet Technology Investment Planning Bloglines Web Executive Seminar Recap: Internet Technology Investment Planning Technorati Web Executive Seminar Recap: Internet Technology Investment Planning Fark this: Web Executive Seminar Recap: Internet Technology Investment Planning Bookmark Web Executive Seminar Recap: Internet Technology Investment Planning  at YahooMyWeb Bookmark Web Executive Seminar Recap: Internet Technology Investment Planning  at Furl.net Bookmark Web Executive Seminar Recap: Internet Technology Investment Planning  at reddit.com Bookmark Web Executive Seminar Recap: Internet Technology Investment Planning  at blinklist.com Bookmark Web Executive Seminar Recap: Internet Technology Investment Planning  at Spurl.net Bookmark Web Executive Seminar Recap: Internet Technology Investment Planning  at NewsVine Bookmark Web Executive Seminar Recap: Internet Technology Investment Planning  at Simpy.com Bookmark Web Executive Seminar Recap: Internet Technology Investment Planning  at blogmarks Bookmark Web Executive Seminar Recap: Internet Technology Investment Planning  with wists Bookmark Web Executive Seminar Recap: Internet Technology Investment Planning  at Ma.gnolia.com wong it! Bookmark using any bookmark manager!

Gaining Influence Through Open Access

Wednesday, March 15. 2006

A few days ago, Dan Cohen, the Director of Research Projects at the Center for History and New Media at George Mason University, lamented the lack of non-commercial API's:

one of my pet peeves as someone trying to develop software tools for scholars, teachers, and students is the lack of application programming interfaces (APIs) for educational resources.

If your policy or issue-focused organization is like most, you have great data locked away in databases, websites, and reports. You are distributing the information through your traditional communication channels - including the web - but consumers of your information have to come to you to get it, and its only available in formats that you provide. Why not set that data free and let users manipulate and consume it in their own innovative ways?

Empowered by freely available application programming interfaces (APIs), innovative developers can now grab data and tools from multiple sources and combine them to create new and innovative views of the information (check out ChicagoCrime.org for a great example). Commercial organizations are embracing the trend in a big way, and it has spawned a new wave of online applications called mashups.

These commercial organizations have realized that opening their data and tools expands the reach of their services and information well beyond the capacity of thier internal resources - and it lets its information assume new and powerful shapes. However, non-commercial organizations have been slow to embrace the trend, and are noticably under-represented in this current list of over 200 freely available data and service APIs.

There are thousands of motivated innovators out there - set your data free and let them innovate for you.

Technorati tags: nptech, mashups, API, policy
Posted by Kurt Voelker in Technology at 11:52 | Comments (0) | Trackbacks (0)
Bookmark Gaining Influence Through Open Access  at del.icio.us Digg Gaining Influence Through Open Access Bloglines Gaining Influence Through Open Access Technorati Gaining Influence Through Open Access Fark this: Gaining Influence Through Open Access Bookmark Gaining Influence Through Open Access  at YahooMyWeb Bookmark Gaining Influence Through Open Access  at Furl.net Bookmark Gaining Influence Through Open Access  at reddit.com Bookmark Gaining Influence Through Open Access  at blinklist.com Bookmark Gaining Influence Through Open Access  at Spurl.net Bookmark Gaining Influence Through Open Access  at NewsVine Bookmark Gaining Influence Through Open Access  at Simpy.com Bookmark Gaining Influence Through Open Access  at blogmarks Bookmark Gaining Influence Through Open Access  with wists Bookmark Gaining Influence Through Open Access  at Ma.gnolia.com wong it! Bookmark using any bookmark manager!

Ethics and Interactivity: Moderating User Comments

Thursday, January 26. 2006

Last Thursday, the washingtonpost.com turned off the comment feature on their blog. The decision was made after Deborah Howell's editorial about Jack Abramoff directing contributions to democrats brought on a torrent of vitriolic comments from readers.

It begs the question - how should an organization manage the balance between "transparency and openness" and control of their message? Its a question that used to need answering only by online community purveyors. Today, every organization using the web to distribute their message needs to be paying close attention to this debate.

Yesterday, washingtonpost.com editor Jim Brady hosted a live online discussion on this very issue (a timely move toward transparency in the wake of their very closed shut-down of user comments). The panel included blogosphere biggies Jeff Jarvis of Buzz Machine, Jane Hamsher of FireDogLake, Jay Rosen of PressThink, and Glenn Reynolds of InstaPundit

Here's some goodies from the conversation:

On civility:
I love open comments, just as I love free beer, free pizza... But I'm not entitled to them. And those who partake, I think, owe a certain degree of civility to their hosts.

In an age where there's less control, I think that such informal measures matter more, not less.

Glen Reynolds


On the value in being open:
The age of controlled conversation is over. The age of open conversation is here. But that is damned hard for the controllers to get used to. And I don't say that with the pejorative edge it seems to indicate. The journalists thought it was their job -- emphasis on job, responsibility, value -- to control by verifying and judging and so on. If the job, instead, is to enable [emphasis mine], then you have to start exercising new muscles. And it is important to keep in mind that a democracy is better served by the airing of more viewpoints and perspectives. And journalism is better served by the exposing of more news.

Jeff Jarvis




Posted by Kurt Voelker in Collaboration, Communication at 12:32 | Comment (1) | Trackbacks (0)
Bookmark Ethics and Interactivity: Moderating User Comments  at del.icio.us Digg Ethics and Interactivity: Moderating User Comments Bloglines Ethics and Interactivity: Moderating User Comments Technorati Ethics and Interactivity: Moderating User Comments Fark this: Ethics and Interactivity: Moderating User Comments Bookmark Ethics and Interactivity: Moderating User Comments  at YahooMyWeb Bookmark Ethics and Interactivity: Moderating User Comments  at Furl.net Bookmark Ethics and Interactivity: Moderating User Comments  at reddit.com Bookmark Ethics and Interactivity: Moderating User Comments  at blinklist.com Bookmark Ethics and Interactivity: Moderating User Comments  at Spurl.net Bookmark Ethics and Interactivity: Moderating User Comments  at NewsVine Bookmark Ethics and Interactivity: Moderating User Comments  at Simpy.com Bookmark Ethics and Interactivity: Moderating User Comments  at blogmarks Bookmark Ethics and Interactivity: Moderating User Comments  with wists Bookmark Ethics and Interactivity: Moderating User Comments  at Ma.gnolia.com wong it! Bookmark using any bookmark manager!

ProjectSpaces is Getting Noticed

Wednesday, January 4. 2006

A few days ago Pete Cashmore of Mashable paid us a great compliment in this post on Forum One's ProjectSpaces online collaboration tool:


I tried using Basecamp for a project a while back and I found it infuriating - we gave up on it pretty quickly... The 37Signals guys are dedicated to their “less is more” philosophy but for those who crave more features, ProjectSpaces seems like a good option.


We have worked really hard to keep ProjectSpaces both feature-rich and simple at the same time. It's encouraging to see it starting to get noticed!

Posted by Kurt Voelker in Collaboration, Technology at 10:16 | Comments (0) | Trackbacks (0)
Bookmark ProjectSpaces is Getting Noticed  at del.icio.us Digg ProjectSpaces is Getting Noticed Bloglines ProjectSpaces is Getting Noticed Technorati ProjectSpaces is Getting Noticed Fark this: ProjectSpaces is Getting Noticed Bookmark ProjectSpaces is Getting Noticed  at YahooMyWeb Bookmark ProjectSpaces is Getting Noticed  at Furl.net Bookmark ProjectSpaces is Getting Noticed  at reddit.com Bookmark ProjectSpaces is Getting Noticed  at blinklist.com Bookmark ProjectSpaces is Getting Noticed  at Spurl.net Bookmark ProjectSpaces is Getting Noticed  at NewsVine Bookmark ProjectSpaces is Getting Noticed  at Simpy.com Bookmark ProjectSpaces is Getting Noticed  at blogmarks Bookmark ProjectSpaces is Getting Noticed  with wists Bookmark ProjectSpaces is Getting Noticed  at Ma.gnolia.com wong it! Bookmark using any bookmark manager!

More on the Death of Books Debate

Wednesday, November 30. 2005

Jim Cashel recently asked the question Are Books Dead?. This month's FastCompany Magazine features a great conversation between Jeff Jarvis, a blogger at BuzzMachine.com, and John Griffin, President of The National Geographic Society, on that exact question - and there are some fantastic quotes in their brief exchange that have direct relevance to Policy and Issue-focused organizations that today rely heavily on thick research reports and books to distribute their message.

Here's some good ones:


So what are you in 20 years, when the medium no longer matters? In our post-scarcity world, distribution is not king and neither is content. Conversation is the kingdom, and trust is king. Perhaps your value is not just editors or articles but the community around them. Break free of media's shackles and ask: What are you really?...

So take that as advice from the bottom-up: Find ways to aggregate people and capture the wisdom of that crowd.

- Jarvis


technorati tags: ngo, nptech, blogs

Technorati tag: SOTU Bingo
Posted by Kurt Voelker in Strategy at 12:30 | Comments (0) | Trackbacks (0)
Bookmark More on the Death of Books Debate  at del.icio.us Digg More on the Death of Books Debate Bloglines More on the Death of Books Debate Technorati More on the Death of Books Debate Fark this: More on the Death of Books Debate Bookmark More on the Death of Books Debate  at YahooMyWeb Bookmark More on the Death of Books Debate  at Furl.net Bookmark More on the Death of Books Debate  at reddit.com