Save Time & improve Grades
- Questions Asked 122557
- Experts 2535
- Total Answered 96948
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!
Human Resource Management Homework Help Hospital Statistics and Spreadsheet Management This assignment deals with hospital statistics and spreadsheet data management. You will prepare the daily floor census spreadsheet and calculate the daily floor totals. Make sure you pay attention to the "Patients Remaining from Last Report" section on the Patient Census Data sheet. You will need that number to calculate the "Remaining Midnight" number on the Excel spreadsheet. Also, do not forget to calculate the A&D total. The A&D total is the number of patients admitted and then discharged within the same day. This means you will find those patients listed under both the admitting column and the discharge column. A task that is closely related to Utilization Management is tracking how many patients are in the hospital at any given time, which patients are transferred or discharged on a daily basis, and how many others are admitted. The daily census is important for financial reasons, staffing, and tracking trends. Calculating Census Click the following link to download the Patient Census data. Patient Census Data Based on this information, prepare and calculate the daily floor census for the Orthopedic unit using the Daily Floor Census Excel template linked below. Use military time to record entries in chronological order. Note any A & D's (patients admitted and discharged the same day) in the field next to your signature. Once the data is entered you do need to calculate the daily floor totals.
Ask a questionExperts are online