Projects·Project·Lesson 59 of 62Pro
Hospital ward: beds and stays
A closing project, using what the course has covered.
What you’ll do
Two weeks of admissions on a small ward. The ward manager needs stay lengths, how many beds were in use on one day, and how the patients were shared between nurses.
The steps
4 steps- 1In F2, work out how many days the patient stayed. Fill it down to F13.
- 2In I3, count the beds in use on the day in I2: patients admitted on or before it and discharged after it.
- 3In I4, find the longest stay.
- 4In I7, count the patients looked after by the nurse in H7. Fill it down to I9.
Project locked
Unlock the other 44 lessons for $49.99
Pro opens every drill, practice set, scenario, project and section review. One payment, yours to keep.