-
Univariate Queries (Basic Skills)
- 1:68 Weekly session register. Total number in activities
- 1:92 How many people are using online resources?
- 1:8a Have childhood obesity rates decreased in our borough? (*rephrased from 1:8 Have we been able to reduce childhood obesity?)
-
Data required
-
Quantitative
- Aggregates, Frequencies
- Percentages
-
Qualitative
- Categorical data i.e type
-
"Found" Data
- Maps, Postcodes
-
Outcome: Description
-
How many of x?
- i.e 35% of teenagers in the borough attend our youth club
-
What kind of x?
- i.e Both BAME and white british teenagers attend our youth club
-
Where can x be found?
- i.e our members live at x, y and z postcodes across the borough
-
Bivariate Queries (Intermediate Skills)
- 1:4 There is a lack of diversity amongst the young people who are willing to participate and engage
- 1:62 People are not using the online resources as much as the paper resources
-
Data required
-
Quantitative
-
Numerical data sets
- Primary:CRM/Internal systems (i.e SimplyConnect), internal records including spreadsheets (Excel), surveys (i.e Survey Monkey, Google Forms)
- Secondary: IMD, ONS, London Data Store
- Outcome: Association between and/or comparison of two different variables.
- Changes in X bring about changes in Y
- i.e as the number of BAME volunteers has decreased, there has also been a decrease in the overall number of volunteers taking part in our scheme
- X is greater than Y
- i.e the majority of our users (90%) prefer online resources to paper resources (10%).
- Hypothesis Testing (*ADVANCED)
- Regression analysis and chi-squared testing to predict trends and/or test the "strength" of existing associations
- i.e 1:63 Enquiries on Universal Credit will increase at greater rate as migration continues and widens
-
Multivariate and/or Mixed Methods Queries (Advanced Skills)
-
1:87 Who is the average user of our services?
-
Quantitative (The Profile)
- Online Survey/Questionnaire
- Method 1A (Basic)
- Distribute an online questionnaire with built in analysis tool via the mailing list to ascertain demographics of users i.e Google Forms
- Method 1B (Intermediate)
- Incorporate attitudinal scales and verbatim feedback boxes to ascertain user's attitudes/opinions towards the organisation
- Internal Records i.e spreadsheets including user information
- Method 2A
- 1) Comparative Analysis for each demographic variable i.e 45% of our users are women, 55% are men.
- 2) Use these findings to generate a summary table and graphics i.e bargraphs, pie charts
- Method 2B (*Advanced)
- 1) For each demographic variable i.e gender, age, race/ethnicity, sexuality, income, compare distribution and if possible, calculate an average
- 2) Plot averages to create the demographic profile of a service user
-
Qualitative (The Story)
- Method 3A:
- Ask users to fill out an online feedback form with a view to gather client testimonies (anonymity optional)
- Method 3B:
- Look at quantitative user profiles and...
- Sample testimonies (from online feedback form) to reflect diversity of participants (see quant method 2A)
- Sample and/or seek out testimonies from users in the database who match the average user profile (method 2B)
- Method 4A :
- Use discretion to ask your users about their stories! If anyone has got an interesting story/testimony, invite them to conduct a short interview and/or fill out a feedback form.
-
Administrative/"Found" Data
- The Profile (Admin)
- If postcode data is available, use a mapping tool to see where your users are based across the borough to help build a user profile
- The Story (Found)
- Social media for testimonies, reviews, any feedback left via email , thank you cards etc to help illustrate your organisations' story
- Outcome: In-depth understanding of who users are (and what some of them think about the organisation)
- This approach can also be used in isolation