Week 5 Assessment

An infection control nurse has data showing the percentage breakdown of hospital-acquired infections by type (CAUTI 35%, CLABSI 25%, SSI 20%, VAP 15%, C. diff 5%). She wants a single chart that shows each type's proportion of the whole. Which chart type is most appropriate?

A pharmacy manager has a spreadsheet with 3,000 medication records. Column D contains the status of each medication: "Active," "Discontinued," or "Recalled." She needs a quick count of how many medications have been discontinued. Which formula should she use?

A hospital quality director wants one chart that shows monthly patient satisfaction scores as a line and monthly complaint counts as bars. What is the primary advantage of using a combination chart for this?

A health information management intern is reviewing a hospital's patient database and notices that two different patients—Maria Garcia (DOB 03/15/1985) and Maria Garcia (DOB 11/22/1990)—were accidentally merged into a single record under MRN 10045678. Lab results, medications, and allergy information from both patients are now combined. Which database integrity principle was violated, and what is the MOST serious patient safety risk?

A physician at Hospital A needs to view lab results for a patient who was originally tested at Hospital B. Both hospitals participate in a Health Information Exchange (HIE). The physician's EHR sends a request to the HIE, which retrieves the results from Hospital B's system in real time. What type of HIE exchange is this?

A hospital HIPAA officer is designing access controls for the new EHR system. She wants to ensure that a billing clerk can see insurance information but not clinical notes, while a nurse can see clinical notes but not billing details. Which access control model follows the HIPAA "minimum necessary" principle?

A charge nurse has a patient assignment sheet in one workbook and a separate "NurseRoster" table in another workbook that maps Nurse_ID to certification level. She needs a formula in cell B2 that looks up the Nurse_ID in A2 against the NurseRoster table and returns the matching Cert_Level, or "No Match" if the ID is not found. Which formula is correct?

A hospital administrator creates a PivotTable from 10,000 patient discharge records. She drags "Discharge Month" to Rows, "Total Charges" to Values, and wants to view data for only Q4 (October, November, December) without deleting any rows. Where should she drag "Discharge Quarter" to enable this filtering?

A hospital database administrator discovers that when she deletes a physician's record from the Providers table, all 2,400 patient appointment records linked to that physician through a foreign key are automatically deleted too. The appointments data is permanently lost. What design flaw caused this problem, and what should have been configured instead?

A rural clinic's laboratory processes blood samples and manually re-enters results into the EHR by printing the LIS report and typing values into each patient's chart. Last month, a transcription error caused a patient's potassium level to read 3.5 mEq/L (normal) instead of the actual result of 8.5 mEq/L (critically high), delaying emergency treatment. Which system integration failure is the ROOT CAUSE of this error?