Health Organisation(Any one) Workforce Plan (Please select any one health organisation/ hospital in NSW)
Note; All the points below should be covered in this assignment.
Graph, data and table should be attached.
Length: 2000 words. (NOTE: Executive Summary, References and Appendices are not included in the word count)
The purpose of the assignment is to prepare a workforce plan for one health organisation. The Health Organisation Workforce Plan will have
to include all of the relevant sections of a Workforce Plan as outlined in the readings links. The Workforce Plan needs to include
recommendations on strategies to address key workforce issues.
The assignment will be scaffolded so that readingswill support the development of the Health Organisation Workforce Plan. This includes
key topics relevant to the development of the workforce plan such as preparing an Environmental Scan, analysing the organisation’s
workforce data set, identifying critical issues and developing strategies to address the issues identified.
You will need to gain the permission of the Chief Executive Officer (or other relevant person such as Workforce Planning or Human
Resources Manager) to carry out the project, including requesting a data set. This action is essential for you to gain access to the
people and information that you require to successfully complete the project.
The process will include the following steps:
1) Prepare a Table of Contents for the HealthOrganisation Workforce Plan using report format.
2) Executive summary.
3) Draft the Introduction for the Workforce Plan.
4) Prepare the external Environmental Scan for the plan using relevant NSW, other States and Territories and national health
workforce references including policy and planning documents. Determine if there is a relevant Workforce Plan for public sector health
services developed by the Local Health District (NSW), Hospital and Health Services (Queensland) and relevant networks in other States and
Territories. If you work in the private sector, this type of documentation will still be helpful.
5) Prepare the internal Environmental Scan by:
a. Gathering information on the organisation’s organisational structure,
b. Describing the structures and processes of the organisation’s approach to workforce planning and management, including whether the
organisation has a current Workforce Plan, or Strategic, Business or Operational Plans which refer to workforce planning initiatives and
c. Identifying the extent to which the organisation currently analyses its own current and future workforce supply and requirements,
including preparation of a workforce profile.
6) Provide a profile of the organisation’s workforce if data are available. Undertake the data analysis required to support the
workforce plan if data are available in order to develop a workforce profile using tables and graphs and supporting explanatory text. See
the section below on the proposed data set. If data are not available, describe the workforce profile and use interviews and external
sources to identify workforce characteristics, trends, levels of shortage and workforce issues.
7) Based on data analysis and/or interviews with key staff and relevant information from the Environmental Scan, determine whether
supply is currently adequate to meet the service demand by workforce category.
8) Based on the previous steps and relevant literature, identify critical issues to be addressed in the workforce plan.Analyse the
strengths and weaknesses of the organisation’s present and future workforce planning strategies.
9) Recommend key strategies to address the critical issues in each of the areas of workforce planning and development, including:
• Recruitment and retention;
• Organisational performance management strategies related to the workforce;
• Utilisation of capability frameworks for identifying and developing skills levels of the workforce;
• Applying skills-mix and workforce redesign strategies to the health workforce;
• Education and training strategies addressing workforce development; and
• Strategies for developing workforce efficiency and productivity.
Data Sources, Data Items and Data Analysis for Workforce Profile
Any request for data should make it very clear that the University will undertake to strictly preserve the confidentiality of the data and
that the University only provides access to the assignments by the Unit Co-ordinator and Subject Lecturer.
In addition, the data is not to be released for any other purpose or used by any other party including research, publications and third
parties. Therefore students will also be required to abide by a confidentiality agreement, and small cell sizes under 5 will not be
reported in the assignment.
Data Source and Data Items
It is recommended that the organisation be requested to provide a data set. The most useful extract is from a payroll data set, and you
will need to request an Excel file with a pivot table of the extracted data. The data can be extracted for one payroll period, and
November 2015 would be a good time to source the data as it is usually representative of the data over a calendar year.
Please request the following data items:
The two main workforce counts to be included in the data set are:
FTE (Full Time Equivalent) includes productive, non-productive and overtime hours. FTE is calculated based on an award working week and
hours contributing to allocated days off are considered when taken. Most awards are 38 hours per week including junior medical officers
and nurses. Senior Medical Officers such as Staff Specialists are 40 hours per week.
Headcount (based on a count of the records in the extract spreadsheet and using Employee ID as the unique count.
The Data Items to be included in the data set are:
There are differing data components including:
This includes age and gender data items
Workforce characteristics and classification:
This includes length of service, award group and award
Services descriptors or service areas.
This includes cost centres and grouped cost centres or “service areas”.
The excel file provided to students who are analysing the NSW Ministry of Health data set can be provided to staff at the organisation
(Information Officer or Payroll Officer) to show how the data has been grouped. The ID number needs to be de-identified and is just for
the purposes of showing the number of records.
The following table is a list of the data items and their groupings which need to be requested.
Source: NSW Ministry of Health Human Resources Information System, 2015
The original data file was created by the Workforce Planning and Performance Unit of the Workforce Planning and Development Branch of the
NSW Ministry of Health, and if required I can provide a copy of the data file provided by the Ministry.
Create a further data item from the original data set called “Service Area” which adds together “like” service and organisational
clusters. The Excel data file shows these groupings for an acute hospital.
The best way to do this is to understand the organisational structure of the facility and do the groupings on that basis. However to
develop data sets using clinical streams you may need to move away from organisational lines of responsibility.
Data analysis and presentation
Follow the format of the extracted data in the Excel file to extract your own data.
The following sections provide some material on how to develop graphs and manipulate the data provided. This will be covered in the
Webinars as well.
• In the excel file in the relevant worksheet, create the cross tabulations that you want to graph. Highlight the data to be
graphed. Create a graph. Double click within the graph. Choose the Design you want to graph and the Quick Layout function to create labels
for your graph.
• Double click on the legend and choose the option for Bottom.The graph should be completed.
• Now create a Word file, click on the graph, right click and chose Copy and paste into the Word file. Then enter Graph 1 as a
heading above the graph and give the graph a title.
• Repeat the process with each table and graph you use in the workforce plan.
Managing small cell sizes
When data is cross-tabulated it often results in small cell sizes. No data should be reported in a table or graph with a value of less
than five. Therefore data needs to be added to the nearest data range or data ranges changed to add data together.
The grouping of data uses the Autosumfunction. A link is as follows:
Copy and paste the total table so that you have another version to work with. However, you need to create empty cells to sum into so:
• Highlight the cells where you want the sum to appear.
• Click on Insert in the home menu and insert cells. Then use Autosum to add the numbers.
• Then copy and paste the totals you have created.
• Then delete the original data and create a new label.
You will be assessed according to the following criteria, which are expanded in the Unit Learning Guide under the Rubric section for
• Academic writing skills, use of report format and APA.
• Ability to introduce the topic and findings in a well summarised Executive Summary.
• Understanding of the process of the development of a health workforce plan.
• Preparation of an Environmental Scan,
• Capacity to analyse workforce profile data including the use of charts and tables to support the analysis and presentation.
• Critical analysis and synthesis of the relevant literature to support issues identification and strategies development.
Provide your answers based on the recommended readings in Modules 3 to 5 and other references that you find (see the Rubric for details on
additional readings).Review the video on the use of excel.
Write up most of the tables and graphs as an attachment to the report and then in the report use all headings linked to your data analysis
and provide key findings.
Services Areas FTE by Award Group
Allied Health Corporate Services & Hospital Support Hotel Services Maintenance & Trades Medical Nursing Other Prof. & Para
Professionals & Support Staff Other Staff Scientific & Technical Clinical Support Staff
Allied Health 15.94 2 3.95 2.46 2.08
Womens and Childrens inpatient services 0.95 7.58 50.86
Emergency and Urgent Care Services 11.48 33.96 59.7 1
Critical Care Services 0.74 5.47 17.07
Medical and Palliative Care Services 1 7.6 31.51 134.4 0.6
Geriatric and Rehabilitation Services 3 18.81 19.57 2
Medical & Surgical – Nursing 1 34.77
Anaesthetics, Surgical and Operating Theatre Services 10.58 25.12 95.65 6 8.68
Clinical Support Services 35.56 4.57 1.16 1.01 0.84 1
Ambulatory Care Services 0.21 1.14 0.01 17.96
Management Services 10.67 4.72 14.82
Management/administration support services 25.59 2 0.62
Non clinical support services 18.61 51.59 3.08 6.74
Grand Total 55.71 94.93 51.59 3.08 128.34 451.76 17.04 0.62 14.36
What is the data telling you?
Improve the layout of these tables