Demonstrating Value Blog

October 9, 2013

Love it or hate it, spreadsheets are the number one data tracking tool in many community-based organizations. Unless you are, or have a spreadsheet geek on staff, most of us mainly learn enough to get by - perhaps a few functions, the basics of doing formulas, possibly graphs.  For most people, entering and tracking data in  spreadsheets is easy, but analyzing can be painful.  Here is my wisdom learned from decades of spreadsheeting to make your spreadsheet going a bit easier.

 

Pretend you're somebody else. The seemingly inconsequential spreadsheet file that you’ve started may end up being a key file that is added on to, and used for years by multiple people, long after you’ve left the organization.   Take the extra five minutes to imagine you are somebody else looking at it...

October 8, 2013

In past posts you may have followed our research project with the BC Association of Farmers’ Markets to develop a Farmers’ Market Impact Toolkit.This toolkit was piloted with 9 farmers markets in the summer of 2012 in British Columbia (Canada) and a final version of the toolkit is posted here on our website.

 

Here are just some of the insights into the important value of farmers’ markets in local communities based on the six markets that completed surveys with their stakeholders. This represents 117 customers, 84 vendors, 5 market managers and 18 external stakeholders.

 

While these data are not  a statistically validated sample that can be used to extrapolate findings to farmers’ markets generally, ...

October 8, 2013

Tracking impact measurement in social enterprises can come out of the basic process and system development that should naturally occur in any business.  I recently advanced this notion in my presentation at the Social Enterprise World Forum last week, and have been thinking more about how this should be done. Here are some ideas.

 

Below  is a typical diagram of typical systems and processes that are developed in an enterprise (I nabbed this from Google images the night before the presentation).  I added in additional features that are  unique to social enterprise in blue (not all apply to all enterprise, but many to most).  Note that the blue text doesn't float, but is quite rooted in processes that are part of any business, and the subject of process development.  Since process and system development is intrinsically linked with tracking, you automatically have the basis for impact tracking too!  Most softwares solutions include great data tracking features...

August 9, 2013

I recently spoke with Michelle Strutzenberger, of Axiom News, about the state and future direction of impact measurement in anticipation of my participation in the panel  'Measuring and Demonstrating Impact'  at the Social Enterprise World Forum taking place in Calgary October 2-4. It was a great opportunity to reflect about my experience in the last six years of working in this area, and to articulate where I see this work evolving. The story will be published as part enpCanada stories, the news service for Enterprising Non-profits Canada.

 

Here are my reflections to Michelle's questions:


1. What’s the commitment you hold that brings you to be involved...

August 9, 2013

"There are known knowns; there are things we know that we know. There are known unknowns; that is to say, there are things that we now know we don't know. But there are also unknown unknowns - there are things we do not know we don't know."

 

-Former US of Defense, Donald Rumsfeld

 

This infamous quote left some people befuddled, others impressed.  While this quote emerged from the context of linking the government of Iraq with weapons of mass destruction, uncertainty (everything but the known knowns) pervades the  world of evaluation, social impact assessment and performance measurement.  Still, we acknowledge it in a fairly limited way, and dealing with it explicitly is...

August 9, 2013

I came across this nifty tool when I attended the 6th ANSER conference in Victoria, June 6, 2013. The Community Capital Tool is a decision support and assessment tool, based on the community capital framework, that is designed to facilitate and ground community discussion about integrated planning and monitoring.

 

At the conference, Gretchen Hernandez, Sean Markey, Alfredo Seoane  and Alberto Mollinedo described the tool and its application in Bolivia.
 

The community capital framework stems from the work of Cornelia and Jan Flora who advanced that communities that were successful in supporting healthy sustainable community and economic development paid attention to seven types of capita - natural, cultural, human, social, political, financial and built – and how they interacted and built on one another....

May 29, 2013

Are you about to engage in strategic or business planning in your organization?  Planning  offers a great point to think about what has and hasn’t worked in the past, how you create value (for community, within your business and organization), how you can create even more value, and ways to measure your success moving forward. Demonstrating Value can complement planning activities in a number of ways. 

 

The first way is to help you focus on the big picture, and to ensure that you bring in different perspectives into your planning.   Demonstrating Value tools are build around a holistic picture captured in this lens:

While this lens was developed to think about measurement, it can useful for framing your planning conversations:

 

An Organizational Sustainability Perspective – Are you developing the processes, systems and...

April 26, 2013

If you're in the business of green building or promoting sustainable building and communities, check out our new guide that has recently been added to Demonstrating Value's Resource Library.  In it you'll find guidance on approaches to monitoring and assessing the mission-related impacts of green building and community design, which may be relevant for social enterprises (and programs) that seek to:

  • Create awareness about the environmental, social and economical advantages of green buildings, and provide practical information on how to build green;
  • Promote new urbanism approaches to reduce sprawl in suburban developments;
  • Develop (pilot) projects that showcase green building practices;
  • Provide incentives to retrofit existing buildings to be more energy and water efficient.

Rather than present a list of indicators, we present different methodologies for assessing impact that can be applied to different types of...

April 23, 2013

When CBC’s Fifth Estate program launched Rate my Hospital last week, I couldn't help but immediately look up the grade of my hospital across the street.  I felt smug that Eagle Ridge wasn't one of the Lower Mainland's batch of terribly ranked hospitals.  But should I really sleep better?  For the ranking, grades were assigned to 240 acute-care hospitals across Canada based on expert-informed method using five publicly available indicators. The site also allows visitors to rate hospitals in 5 categories - respect, communication, timeliness, cleanliness and whether they would recommend it.

Based on many of the reactions of the powers-that-be in...

April 2, 2013

It’s not all about the games.  The advent of smart phones and tablets can simplify the collection and analysis of data, as well as powerfully capture narrative, in ways we only could imagine until recently.  The number of apps available grows daily and it can be hard to know what is even possible to do.  I've provided a list of a few apps below to showcase the range of what apps can do in this area. Check app libraries and the internet for more.  In choosing your own apps, look for functions such as whether and how you can export data. (I recently lost all my data in a goal setting app, when the version was updated).

 

GoalScape:  Track goals and reporting

Fluid Surveys: Take surveys on the move

...

Pages