Human Research Information Systems (HRIS) Report

Human Research Information Systems (HRIS) Report

Provide a subheading comprehensive related to you topic in this sentence

Student Name: XXX

Student ID: XXXX

Subject name and number: BUSM3080 Health Services Management

Submission date: DD/MM/YYYY

Word Count: 1,500 words

Glossary of AbbreviationsGlossary of TermsTable of Contents

TOC o "1-3" h z u Glossary of Abbreviations PAGEREF _Toc174383298 h iGlossary of Terms PAGEREF _Toc174383299 h i1. Introduction PAGEREF _Toc174383300 h 12. Findings PAGEREF _Toc174383301 h 22.1 Subheading (create a subheading if needed, if you need more, copy and paste this heading) PAGEREF _Toc174383302 h 23. Discussion PAGEREF _Toc174383303 h 33.1 Subheading (create a subheading if needed, if you need more, copy and paste this heading) PAGEREF _Toc174383304 h 34. Conclusion PAGEREF _Toc174383305 h 45. References PAGEREF _Toc174383306 h 5

1. Introduction*Provide a comprehensive title to your headings and subheadings

Definition what is a healthcare workforce, why it is important in health management (100 words),

why is important for health managers to forecast the workforce (100 words),

introduce the settings (from the data) (150 words)

explain what specific issue you will be looking at (term this as a question) (50 -75 words)

400 words

2. Findings2.1 Subheading (create a subheading if needed, if you need more, copy and paste this heading) Provide a comprehensive title to your headings and subheadings

Introduce the two to three items you will be discussing with your findings (400 words in total)

Use new paragraphs for each of the items you discover through your analysis (you can use tables and/or graphs bar charts or lines)

(no referencing)

3. Discussion

3.1 Subheading (create a subheading if needed, if you need more, copy and paste this heading) Provide a comprehensive title to your headings and subheadings - remove instruction before submitting

*Explain what you found above and how you will overcome the issues, with evidence-based strategies and approaches using journal articles - 500 words (remove this before submitting the assessment) - remove instruction before submitting

4. Conclusion*Summarise what was found in each of the sections (no referencing) in 200 words (remove this before submitting the assessment) - remove instruction before submitting

5. References

*8 or more references for a 1,500-word assessment (remove this before submitting the assessment) - remove instruction before submitting

Tutorial Workshop Instructions and Assignment 1 2024

Introduction

The NSW Ministry of Health has provided a de-identified data set at unit record level from the payroll of one acute hospital which is classified as an acute metropolitan hospital Peer Group 5. The data set has been provided on the understanding that the University of Western Sydney will undertake to strictly preserve the confidentiality of the data and that the University is subject to the:

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 be required to return the pivot table file with the data set on the USB stick at the end of the computer lab without taking a copy, and to abide by the confidentiality agreement in place.

Location

Online Mondays 1300 1500 (1 pm 3 pm)

Assignment 1

Purpose: As outlined in the Learning Guide, the purpose of the assignment is to give students an operational understanding of Human Research Information Systems (HRIS) content based on the data extract. The reporting of findings will result in the development of analytical skills in review, presentation and interpretation of workforce data.

Task: The assignment has been scaffolded to include the following requirements:

Review of video on the use of Microsoft Excel prior to the tutorial.

Attend the tutorial to assist students in the use of Microsoft Excel and pivot tables to develop the capability to analyse the data set provided in the tutorial. The outline of the data set and data extracts will be provided at the tutorial and explained to students so that they can undertake background research on the workforce categories to be analysed as well as the key data items such as gender, age, workforce category, service area etc.

Attendance in the tutorials.

Preparation of management report in report format (see WSU Writing and Presentation Style Guide).

Background Reading: The most relevant background reading is Topic 4 and Topic 5 in Module 2 of the Study Guide and also Module 4, as this topic introduces Human Resource Information Systems (HRIS). Students can undertake any additional reading on the acute hospital workforce including reports published by the Australian Institute of Health & Welfare (AIHW).

Data Source and Data Items

Pivot table: The pivot table to be interrogated is a payroll extract of the following data items:

Source: NSW Ministry of Health Human Resources Information System, 2016

The data file was created by the Workforce Planning and Performance Unit of the Workforce Planning and Development Branch of the NSW Ministry of Health.

The data is selected from an acute public hospital in metropolitan Sydney which is classified as A3 Ungrouped acute tertiary referral. The link is as follows:

https://www.google.com/search?q=metropolitan+Sydney+A3+%E2%80%93+Ungrouped+acute+%E2%80%93+tertiary+referral.&sca_esv=626fabf78ea21382&rlz=1C1GCEU_en-GBAU1092AU1093&ei=UjWwZp74JN2n2roP5J-byQ8&ved=0ahUKEwie6Y7N49yHAxXdk1YBHeTPJvkQ4dUDCBA&uact=5&oq=metropolitan+Sydney+A3+%E2%80%93+Ungrouped+acute+%E2%80%93+tertiary+referral.&gs_lp=Egxnd3Mtd2l6LXNlcnAiQW1ldHJvcG9saXRhbiBTeWRuZXkgQTMg4oCTIFVuZ3JvdXBlZCBhY3V0ZSDigJMgdGVydGlhcnkgcmVmZXJyYWwuSABQAFgAcAB4AZABAJgBAKABAKoBALgBA8gBAPgBAZgCAKACAJgDAJIHAKAHAA&sclient=gws-wiz-serp#:~:text=NSW%20Hospital%20Peer%20Groups%202016A further data item has been created from the data set called Cost Centre 2 which adds together like service and organisational clusters. The best way to do this is to understand the organisational structure of the facility and do the groupings on that basis. However, this may not be consistent with the way you want to do your workforce planning at an organisational level. Therefore the data is clustered based on relevant service groupings called service areas.

In order to show the data items and layout in the Pivot Table Fields, click on any of the active cells in the pivot spreadsheet (computer lab).

The two main counts 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.

Data Items:

There are differing data components including:

Demographic data:

This includes age and gender data items

Employment status:

Workforce characteristics and classification:

This includes length of service, award group and award

Services descriptors or service areas.

This includes cost centres provided in the original file and grouped cost centres.

Tutorial instructions

Load the file with the data and this instruction file which is on the memory stick and pass it onto the next student.

Load your own memory stick into the computer. You can copy the instruction file and the data file which is also on vUWS onto your stick. Remember that the data file (even without the unit record data) is confidential.

We are going to go through the data items and discuss the implications for your specific analysis of the data set.

You will do the extracts from the actual pivot table at the computer lab workshop in week 3 -4 .

Assignment 1 questions

Describe the attributes of the total workforce using the data provided in the tutorial. Use graphs and tables to support your analysis. Remember to source all material correctly.

Select two of the service areas (derived from grouped cost centres). Explain the reason for your selection.

Analyse in detail the characteristics of each of those two service areas and then compare them to the total workforce of the hospital. Present your analysis using graphs, tables and explanatory text.

Identify the human resources challenges the hospital is facing based on the data analysis.

Based on the analysis and issues identification, describe your recommended strategies for addressing the human resources management challenges the hospital is facing.

Hints: Use attachments to provide your data analysis (tables and graphs) so that the content of the management report focuses on critical analysis of the data and the challenges and strategies to address the challenges.

Tutorial

Load the file with the pivot table which is on the memory stick and pass it onto the next student.

Load your own memory stick into the computer and create an Excel file to cut and paste material from the pivot table. Do not copy the data file as it is confidential and this was a requirement of providing the data file to the University. Create an Excel file on your computer saved on your memory stick and call it:

Student Number_Initials_BUSM3080 Assignment 1 2024

Spreadsheet called pivot There is already a pivot set up in the file. If you want to recreate one yourself, highlight the data from the extract spreadsheet from cell A1 to H1248 go to the Insert Menu and choose insert PivotTable. The pivot options show and choose OK. The pivot table is created in another worksheet. The Field List should be showing on the right-hand side, but if it is not click on the active cells to the left and the Field List will appear.

Creating Values if you have created a new pivot click on the data item called in the Field List and then drag and drop the item into the area called Values at the bottom of the spreadsheet.

You should now be seeing an item called Employee ID in that square. You should also be seeing a heading with Count of Employee ID and the number 1247 in the active cells area to the left.

Now do the same for FTE in the Field List and you should be seeing Sum of FTE and the number 817.43 in the active cells area to the left. If you see Count of FTE drop down the arrow on the right, choose Value Field Settings and then choose Sum.

The pivot table is now ready to use. You can practice setting up the pivot by selecting a data item and dragging it into the area called Row labels and/or Column Labels.

Creating cross-tabulations.

Create the cross-tabulations you want to create for your selected service areas and copy them onto the file with a separate spreadsheet for each cross-tabulation. You can name each spreadsheet by double-clicking on the Sheet 1 etc label. Each pivot table should show the Count of Employer ID and Sum of FTE as the Values. You select paste and then Paste Values. Place the cursor in the top left-hand corner before you paste.

Creating graphs.

In the pivot table, 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 choose 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 you create.

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 one. 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 Autosum function. The link is as follows:

TBA

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.

To complete the assignment:

Write up the tables and graphs as an attachment to the report and then in the report use all headings and provide key findings.