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 organization. The Health Organization 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 readings will support the development of the Health Organization Workforce Plan. This includes key topics relevant to the development of the workforce plan such as preparing an Environmental Scan, analyzing the organizations 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:
10) Conclusion
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.
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:
Demographic data:
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.
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.
Creating graphs.
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:
http://www.ehow.com/video_4978987_use-subtotals-totals-excel-spreadsheet.html
http://spreadsheets.about.com/od/excelfunctions/qt/autosum.html
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:
You will be assessed according to the following criteria, which are expanded in the Unit Learning Guide under the Rubric section for Assessment 2.
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.
http://spreadsheets.about.com/od/excel101/a/Excel_beg_guide.htm
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.
We value our customers, and so ensure that our papers are 100 percent original. Our Team of professionals does not miss the mark; they ensure that step by step each paper is written uniquely. We never duplicate or work as we compare papers rest assured. We deliver our work a day before time to ensure that you don’t miss your deadlines. It is not only doing the work but delivering it at the right time. We capture the consequences of late remittances. .
We value customer satisfaction here at popularessaywriters.com and make sure that you get the best value for your Money. It happens that sometimes you can pay twice for your order or may want to cancel it, or you feel that it doesn’t meet your requirements; our money back guarantee will give you the opportunity to get back your money. We will also refund 100% of money paid double. In case your paper does not satisfy your requirements , we request that you notify us via writing within 2 days otherwise on the third day we will assume that you have been satisfied. Do all your correspondences through our email address popularessaywriters@gmail.com.
Read moreAt popularessaywriters.com, our professional writers know the consequence plagiarism does for our clients. We have updated software’s such as article checker and copyscape to check for originality of the custom papers before submission of the final paper to the you. Our guarantee to the customer is that we will write 100% original papers for them that are quality, timely and of low cost. We have experienced professional and competent PhD writers who will write quality custom papers for you..
Read more. At popularessaywriters.com, we are proud to provide top-quality Essay writing service to our esteemed customers. We are ready to take up that challenging academic assignment that is giving you sleepless nights and simplify it for you according to your desired requirements. We are willing to revise your paper if it does not meet your requirements. At popularessaywriters.com, we do not compromise with quality; thus, we offer unlimited free revisions until the customer is satisfied with their custom paper. Our unlimited free revision services are provided under the following terms:.. .
Read morePopularessawriters.com knows that client’s information is an essential tool for our company. It means that whatever the client requests from our service is kept strictly confidential. It means that whoever writes for this company understands the terms and conditions hence you should not be worried because you will never see your work somewhere else...
Read moreRest assured that we will always be attentive to your needs and requirements. We belief in the phrase treat your neighbour as you would want them to treat you. We leave nothing to chance and always look forward to a good interaction with each other.. .
Read more