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 CensusClick the following link to download the Patient Census data.Patient Census DataBased 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.Daily Floor Census Excel templateSubmit your completed assignment by following the directions linked below.

 
"Looking for a Similar Assignment? Order now and Get 10% Discount! Use Code "Newclient"

If this is not the paper you were searching for, you can order your 100% plagiarism free, professional written paper now!

Order Now Just Browsing

All of our assignments are originally produced, unique, and free of plagiarism.

Free Revisions Plagiarism Free 24x7 Support