Some of the more eagle eyed among you may have noticed a logo appearing next to some of our surgery dates denoting them as an “Open Data Surgery”:
Where you see this logo it means that as well as being able to attend a surgery to find support on social media there will also be someone there willing and able to discuss Open Data with you.
But what does this mean?
Open data is essentially all the facts, figures and statistics government and other public sector organisations release that we as citizens have the right to see and use. This can include things such and local authority spending. census information, road accident data, demographic information etc.
Surgery Managers have the option on whether to offer open data support on a event by event basis, depending on the availability and skills of the volunteer surgeons. So, Surgeons if you have the skills to be able to offer this type of support, be sure to let your surgery manger know when you sign up so they can toggle this option on to the sessions you will be able to attend.
Then all you patients need to do it keep your eye out for the logo and introduce yourself to your surgery manager when you arrive to make sure you are paired up with the right person that’s signed up to offer open data support.
As part of the open data project at the Social Media Surgeries we’ve been working with Birmingham Open Spaces Forum (BOSF) to see if we can find a way of using data to help them in their work. BOSF is a network organisation that aims to bring together all the people in Birmingham with an interest in open spaces – so Friends of Parks Groups, allotments, community gardeners etc. There are close to 100 small community groups involved in this wider network.
To help them we first need to know what data related problem they want to solve. We met and explored various possibilites but plumped for a very practical problem – how do they way to collect evidence for how much income the groups generate in their respective areas. This was worked down to 2 simple questions.
How to collect the data
How to display it (and for whom and where)
At this point we’re not using open data, but it’s a good place to start to get a group understanding how to use data, and some of the tools that can be used to visualize and manipulate it.
After some discussion with the group it was decided that best way to collect the information they wanted was through Google Forms.
Google Forms is a free survey tool that does more than just create questionnaires, it allows you to embed videos and photos to illustrate your questions and collaborate with other Google users, but more importantly in this instance it collects responses directly to a spreadsheet so that the data collected can be quickly accessed and used with other tools.
To be able to use Forms you first need Google email (Gmail), which, if you haven’t already got an account, is a 2 minute sign up process here. It is then one of the functions available in Google Drive and building a form is an option under “Create new”.
Once you’ve done that you should end up with a page that looks like this:
Now you can begin to build your survey. There are a number of question types you can choose from, they include, among others, plain text, multiple choice, scale, date and time with the option to make each a “Required question” so that completion is mandatory to complete the form.
Some even have bespoke settings that allow you to make choices based on the answers (i.e. if yes go to Question 5) and advanced settings that will let you refine it further (text must contain ***, number greater *** than etc etc).
As you set each question you can give it a description to give people pointers as to the sort of response you’re after, or if there are options on how to answer.
To add more questions you just need to click add new item and when you think you’re done, click done.
To create the form that’s all you need to do. There are options on the screen to track progress and requiring people to log in to leave responses etc. And you can also add page breaks so only a set amount of questions appear per page, and change the theme to make it look pretty but at it’s simplest your form is complete.
Now you have your form you can share it widely to start collecting responses. Google have also made this easy – you can share it directly from the creation page by clicking “Send form”, view the live form to get a direct link or grab the embed code to put it on your own blog/website (go to File > Embed)
They sent that out this week with 4 weeks to get responses back.
As the responses come in they’ll use the spreadsheet to total up the figures city wide, breakdown the figures by ward and evidence how important the groups are in their neighbourhoods.
They’ll also be able to see a rough breakdown of how each group raises money, and then potentially signpost them to each others dependent on their strengths (bid writing vs fundraising etc).
One note of caution when collecting numbers: you can get carried away. We started here just wanting one simple number – how much money did this groups bring in and where are they. It become tempting to started looking for lots of other information, but staying focussed on a simple achievable and thing probably improves the liklihood that people will help and you will succeed.
Once they’ve completed collecting the data they can then turn some of the responses into a graphic. By using Google Form’s built in “Show summary of responses” option it will automatically generate pie charts and graphs for the relevant sections – which are sometimes easier to to understand than just rows and columns of figures.
Once that data has all been collected there are other things BOSF could do. Maybe the could use the figures to calculate the value of the volunteer hours to the areas that they serve.
Could your community group or charity be more effective if you collected information in different ways, used it better, shared it with the right people? Would it help if you could more easily find information that government has about the places or perhaps the people you are trying to help?
We are experimenting in Birmingham with how we can use the social media surgeries to share not just social media skills with local community groups and charities, but also data skills.
If you want a chat – even to find out what we mean – please click the links below for anyone of the surgeries for the following areas and sign up…
As always we start with you and your group. What are you trying to achieve? What skills and tools do you have at the moment? Can we show you new ideas that could help you achieve more? Can we help you in practical ways use those skills and tools – there and then? Always the same relaxed approach of a social media surgery.
What’s your aim?
Our ultimate aim is to encourage more community groups and local charities to find good uses for Open data. This is numerical information that government shares in public. so we can have a better understanding of the places we live in and the way government works. But we won’t throw you into anything difficult, we’ll start where you are and help you with the numbers and skills that matter to you.
Is there any information online?
As we work with people we’ll learn together how to solve problems. We’ll describe what we’re doing and share it here on the blog. We will also be writing about things that might help you, tools, sites where data is stored, examples from other organisations.
I have no idea what you mean when you say open data!
Sorry – it is jargony. Open government data is when government shares information on the internet that it owns and grants you and I permission to use it (using an open government license) A simple example is local government releasing a monthly list of all spending over £500. You can find the Birmingham one here. But don’t be phased by any of this – we want to help you develop the understanding and skills that might be useful for what you are trying to achieve.