Key messages

  • Analyse workforce survey data to identify attitudes about the allied health assistant workforce.
  • Complete the workforce survey data report.

By analysing workforce survey data, we can identify organisational attitudes and culture relating to the allied health assistant (AHA) workforce.

Workforce survey data will identify:

  • the survey response rate (providing an indication of staff engagement in the Victorian Assistant Workforce Model)
  • job satisfaction of AHAs and AHPs relative to skill level, length of employment within the organisation, discipline, program or team
  • the confidence of AHPs in delegating to the current AHA workforce
  • the confidence of AHPs in the skills of the current AHA workforce
  • trends in current use of AHAs by AHPs
  • attitudes of staff in relation to the current and future AHA workforce
  • perceived gaps in AHA availability, competency, and training and development needs
  • identification of potential new and/or re-designed AHA roles
  • qualitative data that can contribute to the development of the quantification survey.

Conducting data analysis

Data can be grouped and analysed in an Excel spreadsheet in a way that is relevant to the organisation and project scope.

Filtering data

Filtering data helps to narrow the focus of the worksheet, allowing you to view only the information you need [1].

To analyse the workforce survey data:

  • filter data from the survey in discrete teams, services or disciplines to identify themes specific to this population. For example, filter the data by team to analyse the data from inpatient orthopaedic team
  • compare data between populations and examine data patterns across the organisation
  • identify findings relevant to organisational priorities and key stakeholders. For example, analyse data by discipline to report findings to discipline managers, or analyse data by service to report findings to service managers.

Hints

  • To ensure respondents to the workforce survey cannot be identified, group responses together when analysing results. For example if there are three staff in the speech therapy department, include the results from those respondents in the results of a larger department to ensure all results have a group of no less than 10.

Reporting workforce survey data

Report data by discipline, program team/service, or individual organisational sites depending on the organisation’s project scope.

Provide reports to key stakeholders according to their needs. For example, aggregate data may be relevant for the steering committee, while data by discipline may be most meaningful to the AHP and AHA workforce.

Consideration should be given to how workforce survey results are best represented in visual and written formats. See the downloads section for further guidance in reporting workforce survey data.

Activity outputs

  • Workforce survey data report (for inclusion in final report).

References

1. GCFLearnFree.org 2013, ‘Excel 2013 filtering data’, viewed 19 March 2015