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:
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……………………….

Need Help Writing an Essay?

Tell us about your assignment and we will find the best writer for your project

Write My Essay For Me

Buy high-quality essays online from our team of professional assignment writers. Every paper we deliver is original and crafted from scratch. Our expertise covers a wide range of assignments, regardless of their difficulty or academic level. From concise essays to extensive research papers, dissertations/theses, and coursework, we handle projects of all sizes.



Share your love