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