- Details
- Parent Category: Programming Assignments' Solutions
We Helped With This Excel (VBA) Programming Assignment: Have A Similar One?
| Category | Programming |
|---|---|
| Subject | Excel (VBA) |
| Difficulty | Undergraduate |
| Status | Solved |
| More Info | Excel Vba Homework Help |
Assignment Description
Application 05: Hospital Analysis
Submission:
You should have one macro (.xlsm) file.
***IMPORTANT: Students must use VBA to complete this assignment. No credits will be given otherwise.
Description:
Floor 4, 5 and 6 of Hospital A are reserved for patients who just had an operation. The Excel spreadsheet contains patients’ information and nurses’ assignments at the beginning of a morning shift.
Each floor has 50 rooms (e.g., 401, 402 … 450). There are 5 nurses and 5 assistants stationed on each floor. Each patient has to be administered by at least one nurse and one assistant. A new patient should be assigned a nurse with fewest number of patients. An assistant on the same floor is then paired up with the nurse to care for the new patient.
Tasks:
Write a program that does the following:
1. (10 points) Create a data type for patients’ information (all information shown on sheet “Current Patients”).
2. (10 points) Store information on sheet “Current Patients” using array format and the data type created in part 1.
3. Allow user to:
a) Check-in a new patient
i. (10 points) New patient’s information should be added to sheet “Patients” and the array using dynamic array.
ii. (15 points) Assign nurses and assistants to the new patient. iii. (5 points) Assign a room to the new patient. iv. (5 points) Data entered has to follow the same format shown in sheet
“Current Patients”
b) Check-out a patient
i. (10 points) Delete patient’s record from sheet “Current Patients” and the array.
c) (10 points) See a list of patients currently under a specific Nurse’s or Assistant’s care given their name.
d) (5 points) See which Nurse and Assistant are administering a specific patient, given a patient’s name and DOB.
4. (20 points) The main sub should call at least one function and one sub.
Skills Being Assessed: Using user-defined data types, calling other functions and subs from the main program, loops, arrays and other basic VBA functions.
